Paramater field to change table

[thorny00]

Using CR v10
I have tables that have the same fields in them that are being used in the report. What I’d like to do is set up a parameter field where when a client is choosen, it points the report to that clients table. Example:
Client Table
Abc Abc.elig
Xyz Xyz.elig

Would this be possible? Thanks in advance for all of your help and time, it is greatly appreciated.

 

[lbass]

Insert a command and in the command, create a string parameter {?table}. Then set up your command like this:

Select {?table}.`Client`, {?table}.`Elig`
From {?table}

I first saw this idea in one of Synapsevampire's posts. Although you would ordinarily enclose a string parameter in single quotes in a command, you do not do that for this purpose.

-LB