Jurdz
December 17th, 2008, 11:36 AM
I am using Crystal 8.5 Developer and Visual Basic 6
I have created a query (Query1.qry) using Crystal SQL Designer, and this query uses a parameter (@YS) which I eventually want to pass a value to from VB.
Now I create the report and use Query1.qry as the datasource of the report.
How do I now pass (for example) a value of 4 to the parameter @YS in the query definition on which the report is based?
When I open the report in design view, the DATABASE|SHow SQL Query is greyed out and cannot be selected (even before so I cant acces the query definition from the report, only the results of the query definition - I.E. the fields avalable to the report.
If I delete the query file, the report will tell me that it cant find the dictionary file but it allows me to continue and run the report anyway. So where is the query definition held if the report cant access the Query1.qry file?
I have created a query (Query1.qry) using Crystal SQL Designer, and this query uses a parameter (@YS) which I eventually want to pass a value to from VB.
Now I create the report and use Query1.qry as the datasource of the report.
How do I now pass (for example) a value of 4 to the parameter @YS in the query definition on which the report is based?
When I open the report in design view, the DATABASE|SHow SQL Query is greyed out and cannot be selected (even before so I cant acces the query definition from the report, only the results of the query definition - I.E. the fields avalable to the report.
If I delete the query file, the report will tell me that it cant find the dictionary file but it allows me to continue and run the report anyway. So where is the query definition held if the report cant access the Query1.qry file?