question

parupalli avatar image
parupalli asked

sub reports in ssrs

I have two reports with same data set(or using same stored procedure and query). I want to include one report in other as subreport and when i click the id column in main report i have to see the details in sub report or else the sub report must be hidden help me doing this.....

ssrs
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Fatherjack avatar image
Fatherjack answered

Create a report and add a dataset - datasetA Add a table to your report and set its datasource to DatasetA. Save this as Report1, this will be your subreport.

Create a new report add a dataset - datasetB Add a table to this report and set its datasource to DatasetB Add a subreport object to this report and pick Report1 from you project. Set the properties of the subreport object to have its visibility controlled by another object and select the relevant part of the table in the report to control it.

10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

parupalli avatar image
parupalli answered

thanks for you reply What i need is a bit more complicated. I will explain what i need more clearly. ENTITY_ID(enter value when we run the report)

report 1: entity id entityname entitytype entitynumber 1234 name1 type1 4554 1235 name2 type2 4589 If i click on 1234(any row in entity id) then all the details must be diplayed in the sub report below. The sub report must be hidden until i click on the 1234(or on any row in entity id)column in main report. AND BOTH REPORTS MUST BE DRILL DOWN REPORTS

2 comments
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Fatherjack avatar image Fatherjack ♦♦ commented ·
This would have worked better as a comment to my previous answer or as additional information in your original question ... Just for next time! ;)
0 Likes 0 ·
Scot Hauder avatar image Scot Hauder commented ·
He doesn't have enough points to leave a comment on others answers, this is one of my suggestions for the site, to allow anyone (those under 50pts) to make comments
0 Likes 0 ·
Fatherjack avatar image
Fatherjack answered

If you have a sub report then the parameter for that can be satisfied by a value from the parent report, simply enter the details in the navigation tab for the sub report object where it is embedded in the parent report. When you pick the report you get a dialog to match parameters in the child report to values or parameters in the parent one.

10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Guenter avatar image
Guenter answered

For a subreport to be invisble on start you must put it into a separate row of the table where your parent drilldown takes place. Mark this line as Visibility:Hidden and define a ToggleItem in your visible part of the parent data row.

Making the subreport drilldown is the same thing as making a normal report drilldown. You can even cascade subreports.

But be careful: the report (at least using SSRS 2005) will render all items in a dropped down state before displaying them in the collapsed state, so rendering time depends on the potential maximum rows visible when the user has clicked all drop-down buttons...

10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.