Hi,
Do you know a way to do the following (I'm using CR9):
1- Have a report paramater z that is a date range.
2- Have an SQL query which takes 2 parameters x and y
3- Have formulas which takes z values and converts them to be used by x and y
4- Finally and most important: link the formulas in 3 with x and y.
I can do the first three steps but I don't know how to make the fourth one.
I can also do something that works but gives me another problem:
I can have a report do the steps 1 and 3.
This report contains a subreport whose SQL query do step 2.
When linking report and sub-report, I can use formulas and that works as wanted.
The problem with this solution is that the main report queries the database and then the subreport queries it too. I don't want the database to return the results twice for nothing.
Thanks for your help
Marcel
Do you know a way to do the following (I'm using CR9):
1- Have a report paramater z that is a date range.
2- Have an SQL query which takes 2 parameters x and y
3- Have formulas which takes z values and converts them to be used by x and y
4- Finally and most important: link the formulas in 3 with x and y.
I can do the first three steps but I don't know how to make the fourth one.
I can also do something that works but gives me another problem:
I can have a report do the steps 1 and 3.
This report contains a subreport whose SQL query do step 2.
When linking report and sub-report, I can use formulas and that works as wanted.
The problem with this solution is that the main report queries the database and then the subreport queries it too. I don't want the database to return the results twice for nothing.
Thanks for your help
Marcel