asked on

How to call crystal report from VB?

I am doing an VB application where I need to create reports . I have designed a report & formed needed sql to pass to that report. But I don't know how to pass them off. Can anybody help me on that?

Otana

You need to place the Crystal Reports Control on your VB Form. Set the report property to your report, maybe some other properties. Set the action property to 1 to execute the report.

CR1.action=1

revathi

ASKER

I need to use sql for reporting i.e., runtime assignment of either recordset / query as such will be helpful. Any other suggestion is appreciated.
thanks

pepe2000

There is a property crReport.SQLQuery <SQL text here>

revathi

ASKER

Can you send me an sample code to illustrate this property usage. I tried but not able to get
thanks

ASKER CERTIFIED SOLUTION

pepe2000

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

revathi

ASKER

Thank you expters!.I found that RDC is helpful for assigning active data sources. I graded to average since only part of the code was helpful to me

revathi

ASKER

Thank you expters!.I found that RDC is helpful for assigning active data sources. I graded to average since only part of the code was helpful to me

revathi

ASKER

Thank you expters!.I found that RDC is helpful for assigning active data sources. I graded to average since only part of the code was helpful to me

revathi

ASKER

Thank you expters!.I found that RDC is helpful for assigning active data sources. I graded to average since only part of the code was helpful to me