{"id":"https://openalex.org/W38641591","doi":"https://doi.org/10.1007/978-1-4302-2510-2_11","title":"Common Reporting Problems","display_name":"Common Reporting Problems","alternate_titles":[],"publication_year":2009,"publication_date":"2009-01-01","ids":{"openalex":"https://openalex.org/W38641591","doi":"https://doi.org/10.1007/978-1-4302-2510-2_11","mag":"38641591"},"language":"en","primary_location":{"id":"doi:10.1007/978-1-4302-2510-2_11","doi":"https://doi.org/10.1007/978-1-4302-2510-2_11","is_oa":false,"landing_page_url":"https://doi.org/10.1007/978-1-4302-2510-2_11","pdf_url":null,"source":{"id":"https://openalex.org/S4306462844","display_name":"Apress eBooks","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"ebook platform"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Oracle SQL Recipes","raw_type":"book-chapter"},"parent_works":[{"id":"https://openalex.org/W2499292213","display_name":"Oracle SQL Recipes","relationship":"volume"}],"lineage":["https://openalex.org/W38641591","https://openalex.org/W2499292213"],"child_works_count":0,"type":"book-chapter","is_traditional":true,"indexed_in":["crossref"],"open_access":{"is_oa":false,"oa_status":"closed","oa_url":null,"any_repository_has_fulltext":false},"authorships":[{"author_position":"first","author":{"id":null,"display_name":"Grant Allen","orcid":null,"observed_orcids":[]},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Grant Allen","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]},{"author_position":"middle","author":{"id":"https://openalex.org/A5073027003","display_name":"Bob Bryla","orcid":null,"observed_orcids":[]},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Bob Bryla","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]},{"author_position":"last","author":{"id":"https://openalex.org/A5111441310","display_name":"Darl Kuhn","orcid":null,"observed_orcids":[]},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Darl Kuhn","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]}],"institutions":[],"countries_distinct_count":0,"institutions_distinct_count":0,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":0.0,"has_fulltext":false,"cited_by_count":0,"citation_normalized_percentile":{"value":0.0,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":null,"biblio":{"volume":null,"issue":null,"first_page":"263","last_page":"285"},"is_retracted":false,"is_pulled":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11891","display_name":"Big Data and Business Intelligence","score":0.43549999594688416,"subfield":{"id":"https://openalex.org/subfields/1404","display_name":"Management Information Systems"},"field":{"id":"https://openalex.org/fields/14","display_name":"Business, Management and Accounting"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}},"topics":[{"id":"https://openalex.org/T11891","display_name":"Big Data and Business Intelligence","score":0.43549999594688416,"subfield":{"id":"https://openalex.org/subfields/1404","display_name":"Management Information Systems"},"field":{"id":"https://openalex.org/fields/14","display_name":"Business, Management and Accounting"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}},{"id":"https://openalex.org/T10799","display_name":"Data Visualization and Analytics","score":0.1720000058412552,"subfield":{"id":"https://openalex.org/subfields/1704","display_name":"Computer Graphics and Computer-Aided Design"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T13681","display_name":"Engineering and Information Technology","score":0.11800000071525574,"subfield":{"id":"https://openalex.org/subfields/1712","display_name":"Software"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/report-writing","display_name":"report writing","score":0.6269999742507935},{"id":"https://openalex.org/keywords/database-reporting","display_name":"database reporting","score":0.4390000104904175},{"id":"https://openalex.org/keywords/report-presentation","display_name":"report presentation","score":0.4359999895095825},{"id":"https://openalex.org/keywords/spreadsheet-conversion","display_name":"spreadsheet conversion","score":0.4020000100135803},{"id":"https://openalex.org/keywords/data-presentation","display_name":"data presentation","score":0.3199999928474426}],"concepts":[{"id":"https://openalex.org/C2988876627","wikidata":"https://www.wikidata.org/wiki/Q11266","display_name":"Power point","level":2,"score":0.746161699295044},{"id":"https://openalex.org/C2777601897","wikidata":"https://www.wikidata.org/wiki/Q3409113","display_name":"Presentation (obstetrics)","level":2,"score":0.722110390663147},{"id":"https://openalex.org/C2779955035","wikidata":"https://www.wikidata.org/wiki/Q4686785","display_name":"Advice (programming)","level":2,"score":0.6603368520736694},{"id":"https://openalex.org/C28719098","wikidata":"https://www.wikidata.org/wiki/Q44946","display_name":"Point (geometry)","level":2,"score":0.5936081409454346},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.4752656817436218},{"id":"https://openalex.org/C136764020","wikidata":"https://www.wikidata.org/wiki/Q466","display_name":"World Wide Web","level":1,"score":0.4481941759586334},{"id":"https://openalex.org/C108827166","wikidata":"https://www.wikidata.org/wiki/Q175975","display_name":"Internet privacy","level":1,"score":0.3777211010456085},{"id":"https://openalex.org/C38652104","wikidata":"https://www.wikidata.org/wiki/Q3510521","display_name":"Computer security","level":1,"score":0.37550005316734314},{"id":"https://openalex.org/C15744967","wikidata":"https://www.wikidata.org/wiki/Q9418","display_name":"Psychology","level":0,"score":0.15036222338676453},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.07072365283966064},{"id":"https://openalex.org/C71924100","wikidata":"https://www.wikidata.org/wiki/Q11190","display_name":"Medicine","level":0,"score":0.05894318222999573},{"id":"https://openalex.org/C145420912","wikidata":"https://www.wikidata.org/wiki/Q853077","display_name":"Mathematics education","level":1,"score":0.05312839150428772},{"id":"https://openalex.org/C126838900","wikidata":"https://www.wikidata.org/wiki/Q77604","display_name":"Radiology","level":1,"score":0.0},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.0},{"id":"https://openalex.org/C2524010","wikidata":"https://www.wikidata.org/wiki/Q8087","display_name":"Geometry","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1007/978-1-4302-2510-2_11","doi":"https://doi.org/10.1007/978-1-4302-2510-2_11","is_oa":false,"landing_page_url":"https://doi.org/10.1007/978-1-4302-2510-2_11","pdf_url":null,"source":{"id":"https://openalex.org/S4306462844","display_name":"Apress eBooks","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"ebook platform"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Oracle SQL Recipes","raw_type":"book-chapter"}],"best_oa_location":null,"sustainable_development_goals":[],"study_designs":[],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":0,"referenced_works":[],"related_works":["https://openalex.org/W4235980854","https://openalex.org/W4243567395","https://openalex.org/W314002859","https://openalex.org/W4239797741","https://openalex.org/W4253635657","https://openalex.org/W4241277215","https://openalex.org/W4232754874","https://openalex.org/W2390871166","https://openalex.org/W4240103618","https://openalex.org/W1044817580"],"abstract_inverted_index":{"As":[0],"a":[1,78],"SQL":[2],"developer,":[3],"DBA,":[4],"or":[5,22,80],"power":[6],"user,":[7],"at":[8,66],"some":[9],"point":[10],"you\u2019ll":[11,28,47],"have":[12],"to":[13,16,31,77,92],"write":[14],"reports":[15,40],"share":[17],"with":[18,52],"colleagues,":[19],"management,":[20],"clients,":[21],"other":[23],"companies.":[24],"If":[25],"you\u2019re":[26],"lucky,":[27],"be":[29,50,75,115],"able":[30],"concentrate":[32],"on":[33],"the":[34,59,67,87,105,112,118],"logic":[35],"and":[36,43,102,111],"presentation":[37],"of":[38],"your":[39],"in":[41],"peace":[42],"quiet.":[44],"Unfortunately,":[45],"however,":[46],"almost":[48],"certainly":[49],"confronted":[51],"\u201cshoulder":[53],"surfing\u201d":[54],"report":[55],"critics.":[56],"You":[57],"know":[58],"kind:":[60],"they":[61],"stand":[62],"behind":[63],"you,":[64],"gesticulating":[65],"screen,":[68],"offering":[69],"helpful":[70],"advice":[71],"like":[72,86],"\u201cThat":[73],"should":[74],"converted":[76],"spreadsheet.\u201d":[79],"\u201cCan":[81],"you":[82],"make":[83],"it":[84],"look":[85],"old":[88],"report?":[89],"It\u2019s":[90],"easier":[91],"read":[93],"that":[94],"way.\u201d":[95],"These":[96],"keywords":[97,113],"were":[98],"added":[99],"by":[100,104],"machine":[101],"not":[103],"authors.":[106],"This":[107],"process":[108],"is":[109],"experimental":[110],"may":[114],"updated":[116],"as":[117],"learning":[119],"algorithm":[120],"improves.":[121]},"cited_by_api_url":"https://api.openalex.org/works?filter=cites:W38641591","counts_by_year":[],"updated_date":"2026-11-14T11:04:58.165337","created_date":"2016-06-24T00:00:00"}
