Hello,
We are trying to use Ad-Hoc reporting with Crystal and Lotus Domino v6.0.2. I have crystal reports v8.5 on my machine with Lotus Notes SQL driver. I have created an ODBC connection to the database on the Lotus Domino Server using notes SQL. I create a report using ODBC connection and by selecting views I want from the database. Then I save the report with no data. So this report is now template. I create a virtual directory on my IIS Server pointing to this report. When User access my machine
http://127.0.0.1/Test. He is always asked for which data source to use. This is where the problem starts. You know how it goes with users. We don’t want it to be lengthy process. What other ways you guys can think of so we can use Crystal Reports gathering data from Lotus Domino databases and use for Ad Hoc reporting. Please let me know if you guys need more information.
Any help would be appreciated.
Thanks a Lot!!