I'm trying to correct an issue on a report that has a sub-report. The main report and the sub-report both use stored procedures - different stored procedures. The stored procedure for the main report asks for six parameters, while the stored procedure for the sub-report asks for the six identical parameters from the stored procedures for the main report, plus two more parameters.
When the original report is run, it asks for eight parameters (two parameters for the sub-report were created and linked to the parameters of the sub-report), and right now the report does not display any data. Sub-report, however, displays data just fine.
All parameters on the original report display with the question mark with an 'i" under the Parameter Fields.
I re-created the report with the same stored procedures and the same sets of parameters. The only difference this time is that the parameters for the main report have the question mark with an "i" and the two other parameters that the sub-report need have the checkmark.
The new report display data in both main and sub-report.
After this, I removed the sub-report from the original report and removed the parameters for the sub-report from the report, but the two parameters remain under the Parameter Fields. It does not even give me an option to delete them.
Why do these parameter remain, when sub-report is no longer on the report and the stored procedure for the main report does not ask for them?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.