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

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics