How to use sql tablename as an input parameter

[Tobbie]

Can someone please help. I need to know how I can use the tablename as a paramaeter for my sql query ????

Do you have to specify the tablename when creating the report? What do you do if the user can use the same report but on different tables ?? I hope you can understand what my question is, I am trying to explain it as best as I can.

Thank you to anyone who can help.

 

[kenhamady]

You change the table name at the time the report is designed. To change it at run time you would need to write a front end program (in VB, etc.). There is no way using just CR to have the user select the source table for the report. Ken Hamady

http://www.kenhamady.com/

On-site custom Crystal Reports Training and Consulting.
Quick Reference Guide to using Crystal in VB.