Crystal Report 8.5 Connectivity(Parameterised or data as per record set) with Oracle using VB6

[compad]

Hello Friends, I would like to prepare simple crystal report and want to display in vb6 form. Here is the work I have done: 1 Crystal Report Created using Crystal Report 8.5 2 Designed Crystal Report and connect with Oracle 9i 3 Create standard exe project in vb6 4 Added Report which I have created. 5 While running i am getting following error. Server has not yet been opened. What is the solution to this, Please help me Thanks in Advance.

Adarsh Patel

[Lost User]

Using ODBC? Did you create a DSN? Can you connect and execute a select-statement using VB6 on the datasource?

Bastard Programmer from Hell :suss:

[compad]

When I try to execute/view report same as i have attached it, it works fully... But when i try to pass parameter / set my own data set it gives me error.

[Lost User]

That's not enough information. What's the difference between "view report" and "view report with parameter/set your own dataset"? Do you get an exception on any custom query that you execute? Can you try the report with the query "SELECT 1"?

Bastard Programmer from Hell :suss:

[compad]

Thanks for your reply, Now my report is working well... Thanks once again. Adarsh Patel