I am using vb5 with CR 4.6. and my CR knowledge is limited. Here is the problem, I need to supply the table name (from which the report is created) from vb. because tables are created by users of the program dynamically. The fields in the tables don't change. Is this possible through some kind of formula or sql query? I tried to read help files, tried ReplaceSelectionFormula, did some sql but couldn't even come close. It would be great if you could hint the steps to follow if this is possible.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Is it possible to create a report from a user selected table?
- Thread starter gere
- Start date
I would address this with a SQL query, that way the report would not care which table was being used. If you need more help I would be glad to create the SQL query if given the table & column names..
Email me at brian.mahler@honeywell.com or
brianmahler@msn.com
Email me at brian.mahler@honeywell.com or
brianmahler@msn.com
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question