I thought about passing the paramters to the SP and execute the appropriate query there, but I would rather not have to if I can. It would be nice to stay within Crystal for such a trivial thing.
Thanks,
Eric
Hi,
I am trying to dynamically select the db.table used in my query based on the value of a parameter. Something like:
Select *
From
If {?RptPath} = 'GL' Then
gl_table
else
msa_table
end If
Any suggestions on how this would be achievable?
Thanks,
Eric
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.