I'm going to be reading a parm in o

[dwilliams]

I'm going to be reading a parm in off of the url
such as

http://this

host machine/this report?parm=value
and I want to be able to build a SQL query in the Crystal SQL Desinger. If I create a query here can I just copy and paste it to the report? Also, I'd like to add an additional condition on the query after it's in the report, i.e. the parm being passed by the url, can I do something like
SELECT value from table where table.id={?parm}
?
If anyone has any input at all please don't hesitate to respond. Thanks ahead of time.

Dan

 

[dcm]

Dan: You will need to define your parameter first in both the query and the report based upon the query. The effect of this is that you can then pass the parameter value you require to the report (with Saved Data turned off) and this will pass it to the query (also with Saved Data turned off) and then this will incoporate it into the select statement just as you wish David C. Monks
david.monks@chase-international.com

http://www.chase-international.com

Accredited Seagate Enterprise Partner