Dynamic Table Names - Dream or Reality ?

[pstarling]

I want to be able to pass a parameter (the table name) at run time into a Crystal 8.5 report and report fields from the table whose name has just been passed through.

Every table in this database (at least that is what it's manufacturers call it!) is in the same format.

Is what I am trying to acheive possible?

 

[chelseatech]

You should be able to set location of the table via VB and change it that way. I've been able to it with file based DB's, but haven't looked at server based tables. Editor and Publisher of Crystal Clear

http://www.chelseatech.co.nz/pubs.htm

 

[dgillz]

You can do a set location on server based tables as well. I do not believe you can do this with a parameter as a pure crystal solution, you will have to go to VB and do this. Software Support for Macola, Crystal Reports and Goldmine
dgilsdorf@mchsi.com

 

[chrisjev]

Hi there,

You could create a Crystal Query that would be able to acheive this. The important part here is that the data structure of the Fields and Field order with be identical all the time.

In the query designer you can create a parameter called "Table" for example and the code would look like this in SQL:

Select * From {?Table}

Note the Parameter must be a string for this to work. As well make sure there is no saved data on the QRY. Now when you report off of that query in Crystal Reports you will be prompted for the Parameter and you must enter in the Table value in order to populate.

Please be warned that missing the table name or incorrect data structure could cause GPF's and Page Fault errors in the product.

CJ a.c.e.

 

[kenhamady]

Keep in mind that CD usually doesn't recommend combining apps with QRY Files. Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guide to using Crystal in VB

http://www.kenhamady.com/

tek@kenhamady.com