Hi,
In my subreport I want to be able to change the sql query (in database\show sql query) so that it evaluate dinamically a parameter that I defined in the subreport (and wich I linked to a field in the main report).
However, if I make something like this:
SELECT
field1,
field2
FROM
databaseTable
WHERE
field1 = ?codParam
I can see that crystal doesn´t make ?codPAram = number gived
In fact, it leaves ?codParam as is (like if it was a string) and then, of course, give me an error.
How can I make this param dinamic inside "show sql query"?
Thank you
Sergio Oliveira
In my subreport I want to be able to change the sql query (in database\show sql query) so that it evaluate dinamically a parameter that I defined in the subreport (and wich I linked to a field in the main report).
However, if I make something like this:
SELECT
field1,
field2
FROM
databaseTable
WHERE
field1 = ?codParam
I can see that crystal doesn´t make ?codPAram = number gived
In fact, it leaves ?codParam as is (like if it was a string) and then, of course, give me an error.
How can I make this param dinamic inside "show sql query"?
Thank you
Sergio Oliveira