Problem with Crystal Report in VB Application

[SSonnier]

I'm developing a simple Visual Basic application that passes user selected date ranges to a crystal report for viewing. It works fine on one straight detail report, but when I try to run a cross tab report or add grouping to the report, no data is returned ( with the VB Application). It returns data fine when I run the cross tab report from Crystal alone.

Does anyone have any idea why? I can see the correct selection critaeria on the report within the VB application, but still no data is pulled back to the report. I've asked this question in another group. Hope someone will be able to direct me.



Thanks!

 

[synapsevampire]

Share the correct record selection criteria you see in VB.

Many databases have facilities to see what the database is being passed (such as TRACE in SQL Server), and you mght also use the ODBC Trace facility to check this.

-k

 

[SSonnier]

Thanks,

I'm trying to run a custom report for a employee tracking program. Instances are entered into an application that uses dbase files.

An example of the selection formula that I see when I view the empty crystal report is "{order.date} in MonthToDate"

Thank you

 

[FVTrainer]

You probably should post the code that you are using to pass the record selection formula, as in:

report.RecordSelectionFormula = "{order.date} in MonthToDate"

It's also helpful if you list the version of Crystal you are using and which method you are using for working with the report (e.g., RDC, Automation Server, etc.).