I am trying to pass ID's to a subreport as they are listed in the main report. It works fine when I run it in the subreport and manually type in the ID into the parameter field but when I run it from the main report, it is giving me a "parameter is missing value" error.
Here is an example of my main report structure generated from an SQL query:
Table Structure:
Table Structure:
| Area |
| -------- |
| ID |
| -------- |
| SubReport|
Example report output: *Report generates a list of IDs and is grouped/sorted by the Area
Area: Atlanta
\t ID#1234
\t\t -Call Subreport for ID#1234 profile
\t ID#1235
\t\t -Call Subreport for ID#1235 profile
Area: Boston
\t ID#1236
\t\t -Call Subreport for ID#1236 profile
Parameter Settings in main report + subreport: (settings are identical)
A. Parameter Settings
- It is set to visually hidden
- Declared as a text field
- Available + default values (not specified)
B. DataSet Properties (Parameters)
- Parameter Name :prm_ID
- Parameter Value [@prm_ID]
Please let me know if I can provide any more information
EDIT:
Design View