Open a sub report on drill down in SSRS 2008
I develop a report in SSRS 2008.
Which has columns A,B,C,D,E,F,G,H,I
Columns D,E,F,G,H cells are meged and a sub report is pleaced there which is initially hidden and the sub report can be display toggled
by the Column B item.
Data are grouped by columns A item.
Column I data item contains the total
row count for group wise data item based on group for column A.
My problem is that initially when the sub report is hidden , a blank space is also created with the main report without any border.But I want to show the cell borders as usual and when the sub report is toggeled , the data item will be show/hide.
Please help me for that.How can I meet the requirement.Thanks Santosh
December 28th, 2010 6:45pm
Hi Santosh,
As you posted, if we hide the Subreport, the borders of it will also be hidden. In order to keep the borders all the time, as a workaround, we can use nest the Subreport in a Rectangle.
For example, please refer to the steps below:
1.
Remove the Subreport in the Tablix temporarily.
2.
Instead, add a Rectangle control into the merged cell.
3.
Set the
BorderStyle property of the Rectangle to Solid.
4.
Add the Subreport into the Rectangle. You may adjust the location and the size of it.
5.
Set the
Hidden and ToggleItem properties of the Subreport.
As a result, if the Subreport is hidden, the borders of the Rectangle will still be kept.
Thanks,
Tony ChainTony Chain [MSFT]
MSDN Community Support | Feedback to us
Get or Request Code Sample from Microsoft
Please remember to mark the replies as answers if they help and unmark them if they provide no help.
Free Windows Admin Tool Kit Click here and download it now
December 30th, 2010 4:37am