• I think that you will need to use a value from the main reports dataset as the parameter value you are passing to the sub report.

    By use the main reports parameter, each time you call the sub report, you are telling it to produce the details for the 3 IDs. Instead what you want to do is tell the sub report that you want to

    - produce the report for ID 1 when you are processing the main report record for "Test 1"

    - produce the report for ID 2 when you are processing the main report record for "Test 2"

    - produce the report for ID 4 when you are processing the main report record for "Test 4"

    So instead of using something Parameters!Prm.Value as the value being passed to the sub report, you will need to use something like Fields!SomeFieldName.Value (where this has the values you want). If the value is not in the dataset, you should add it in. Alternatively, you could use a string function to get the value from the enter of the column that is already showing on the report as, for example "Test 1". Maybe use "=RIGHT (Fields.AnotherFieldName.Value, 1)" as the expression that is used as the parameter to the sub report.

    Thanks for your reply. I ended up using the Fields!SomeFieldName.Value from my dataset from the Main Report. That worked perfectly! Thanks so much.