I have a VB6 application I am developing for a friend and I have created a report with crystal reports. The report will show in the CRViewer object but I can not get the report to show any data. I have text fields for labeling the information but my database fields will not display data. If I open the report in Crystal I can preview the report with data but can not get VB to import the data.

After I get the report to show something, I would like to know if anyone would have a suggestion on how to specify a certain record to show.

Thanks

Chris Bowles

Hi,

Some possibilities here.

First, let me know which version of CR you are using and what DB?

CHOICE:
1)VB CR4.6 ACCESS
or
2)VB CR(higher) with any Database server like MS-SQL ORACLE...

Assuming as CHOICE#1,
Then, If the data is not seen in the report, may be it depends on SQL Statement which you have referred in the VB code. Try this. Hope it might help. And un-check that check box, report options/property page in the CR editor (save the data in report).

If CHOICE#2,
Then, are you using Stored Procedures? (cursors or temp tables), So make sure the input parameter you are passing to the SP, returns data in the SQL Query analyzer. If you have any formula fields, check its not a problem in the calculation with type miss match. This I have faced some times, where I see the data in the viewer but not when called from VB.

This is not a proper suggestion, but might help you in thinking. In your next post explain bit more clearly with the attempts you made to fix and what choices you are using.

With Regards,
Raghavendra Mudugal