I have to make report in which I can't specify constantly the name of the table, cause it depends on variable.

In one case I have to use fields from table SC0109.x and in another from SC0110.x or SC0111.x or SC0112.x etc. So is it possible to put as a (part of) number/name of the table any variable?

 

(If it helps, in my case, there will change the last two digits of the name of table. They will depend on the date: if it is 31.03 or before, it will be the last two digits of the year, if is after 31.03, it will be the last two digits of the year +1. Example: if date is 31.03.2008, I need 08, so the table is SC0108.x, if it is 01.04.2008, I need 09, so the table is SC0109.x etc.)  

 

The same rule apply to name of fields? (ex: SC0108.x and SC0108.y)

 

Thank you very much in advance for any help with my problems... :)  

 

 

PS. I use CR Designer 10, Crystal Syntax. 

 

PS2. I have tried one thing:

stringVar x:="SC01" & "08";

{x.123} // to show field SC0108.123

but of course it doesn't work. The error of formula is: "{x.123} This field name is not known"