Crystal reports

[sanjaym]

I have been working in crystal reports,it works fine with data in the database
My problem is how can i generate report with MS Access dynamically.

Thanks in advance

[Mihai Anghel]

I don't know if you'll like my solution.
You can execute a 'Select ... into tempTable' query. With this select you can fill a temporrary table with the data you need. Next, you can use this temporrary table as source for your report.

I would use Crystal Report API's or Crystal Report Control in MS Access. By Setting the methods for the control or by calling the functions for CR one can acheive the desired results. Try using Crystal report control in Access as this is easier to work with.

Srini