Using VB to set the source Data for a report

[MrHawkins]

Hello there,

I've used Crystal on and off for a while, but always the professional version. I've now got a copy of V10 developer and am looking to develop some slighty more advanced reports.

My question is is it possible to set the data source in code using VB? I have an SQL database with various tables in, the structures are all the same, but I need to give the user the ability to select the table of their choice to report on ....

The idea is to give the user a form to select the source table from so it's 100% idiot proof !!

 

[synapsevampire]

You don't need VB to do this, you can use the Add Command, paste in your SQL and use a parameter within to have the report prompt for the table name.

This would require the users know it though.

Check out:

http://support.businessobjects.com/communityCS/FilesAndUpdates/ADO_ConnectionMethods.zip.asp

-k