Are you trying to use the SQL Command feature in Crystal? Yes, you can use a Crystal parameter with SQL.
1) go to your Database Expert, ODBC connection
2) click on Add Command, a new screen "Add Command to Report" will pop up
3) type in your select statement (query)
4) on the right side of the pop up screen, you will see a small window called "Parameter List"
5) Create your parameter there and select it in your query
One rather severe limitation with those parameters: you can't reference them in the report. So if you have start and end date parameters in the SQL - they are not available to print on the report to tell what dates the report was run for.
That is not true. Parameters created within a command appear in the parameter list just as would a parameter created in the usual way, and they can be displayed using the same techniques.
I've tried it in XI and they did not appear in the list of parameters when I tried to make a formula appending them into something usable like "For the Period "&{?Start Date}&" thru "&{?End Date}
Just tested to make sure, and they are visible in both the formula editor in the field explorer and in the record selection formula. There are some formula areas (e.g., customize group name) where parameters are not available, but that would be true whether they were created in a command or not.
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.