Previewing Data from SQL Server in Crystal 1

[SmileyFace]

I have a problem with viewing data in the crystal report when it comes from SQL server. I have used a stored procedure to get the fields into the report and when I run the stored procedure in the Query Analyser it runs fine. But when I bring the data into crystal, certain fields appear and certain just come up as boxes.

This report was working fine until just recently. The data is not corrupt in any way. Please help.

 

[synapsevampire]

If it was working, and you didn't change anything, then you may have a corrupt report, or a corrupt install.

Just in case, open the report in Crystal and do a Database->Verify Database

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com