Page 1 of 1
Missing information from Reports
Posted: Wed Jun 09, 2004 9:12 am
by Paul_Woodward
Hello,____Version: R&R 10.1.3.0 - SQL Edition____I^m supporting a set of reports that i have successfully built and tested for a client. They are built on an Oracle 9.2.0.4 datbase platform. The reports are based on views, which pull medical information together with the personnel information. ____The problem is when the report is run onsite, it does not display any personnel information, only the attendance dates, etc. ____However, when the report is run against a "mock" database on my workstation, it all appears correct.____Querying the database through Access or Excel shows that the view contains the information on the client DB.____I have asked the client DBA to check to see if all is well with the views.____Has anyone seen this before?????____Many thanks____Paul
=> Missing information from Reports
Posted: Thu Jun 10, 2004 8:19 am
by kfleming
Is it all of the information from a specific table that is missing or is it only specific fields?____Kathleen__R&R Support
==> RE: Missing info from Reports
Posted: Thu Jun 10, 2004 9:53 am
by Paul_Woodward
Only specific fields are not showing the data.____The view contains the data when you view through Access or Excel, and the DBA says that all views are VALID status.
===> RE: Missing info from Reports
Posted: Thu Jun 10, 2004 12:59 pm
by kfleming
What data type are the missing fields?____Kathleen__R&R Support
===> RE: Missing info from Reports
Posted: Fri Jun 11, 2004 11:27 am
by anna_(Guest)
[updated:LAST EDITED ON Jun-15-04 AT 04:13 AM (EST) by ()]Hello,____When i view the properties on the fields within the report that do not display any field data, when the view carries information.____They all say Alias.Fieldname: (Character)(DB: Char)____From the Show SQL box: ____select__ ALLEVENT."PIN", ALLEVENT."EVENT_TYPE", CASSEMPL."L_P__SURNAME", CASSEMPL."L_P__FORENAMES", CASSEMPL."P__BUSINESS_UNIT", CASSEMPL."P__AREA_OF_WORK"__ from __"CASS"."ALLEVENTS_VIEW" ALLEVENT, "CASS"."CASSEMPLOYEES_VIEW" CASSEmpl __where__ ALLEVENT."PIN" = CASSEMPL."PIN" __and ((ALLEVENT."ATTENDED_DATE" is null and ALLEVENT."DUE_DATE" is not null)) __order by__ ALLEVENT."PIN"____Hope this helps. I can forward a copy of the report should you require it.____Many thanks Paul
====> RE: Missing info from Reports
Posted: Tue Jun 15, 2004 4:11 am
by Paul_Woodward
in sql the nvarchar doesnt come across
====> RE: Missing info from Reports
Posted: Tue Jun 15, 2004 7:54 am
by kfleming
Can you try using a different ODBC driver?____Kathleen__R&R Support
=====> RE: Missing info from Reports
Posted: Tue Jun 15, 2004 9:07 am
by Paul_Woodward
Unfortunalty not, under licencing agreements we have to use the protocol installed with our application. ____I am using Data Direct 4.2 Oracle Wire Protocol. File is WHORA19.DLL version 04.20.0006, dated 05/30/2003.____Thanks____Paul
======> RE: Missing info from Reports
Posted: Fri Jun 25, 2004 9:50 am
by Paul_Woodward
Any further information on this problem...____Many thanks____Paul