Skip to Content
0
Former Member
Sep 25, 2008 at 12:02 PM

Some SQL fields not showing data in Crystal XI R2

610 Views

I have a report that is using a stored procedure. In this stored procedure we have many fields that are being passed over to Crystal. A small portion of these fields do not show any data when you browse them in Crystal. But when you check on the SQL Server 2005 side, they contain data. So we know that the issue is probably on the Crystal side because there is data on the SQL side.

I originally thought that the problem may be caused by Null values in the database, but I used Crystal to convert the Null's to numeric zero if it was a number, and still there was no data showing up.

Also in the stored procedure, we are passing 2 parameters a start and end date. But that seems irrelevent to why some of the fields are not containing data like they should.

Why would some fields show no values at all, and some fields shows values?

Any ideas on how to correct this situation so data will show up for all the fields like they are suppose too?

Thanks everyone for their help!