Missing information from Reports

[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

[kfleming]

Is it all of the information from a specific table that is missing or is it only specific fields?____Kathleen__R&R Support

[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.

[kfleming]

What data type are the missing fields?____Kathleen__R&R Support

[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

[Paul_Woodward]

in sql the nvarchar doesnt come across

[kfleming]

Can you try using a different ODBC driver?____Kathleen__R&R Support

[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

[Paul_Woodward]

Any further information on this problem...____Many thanks____Paul