Hi. I have created a main SSRS 2005 report from what it is possible to call some subreports. Is it possible export in PDF or Excel also the subreports when I require the export inside the main report? Many thanks

Hi, In Reporting Services 2005, we can export report with some subreports to PDF directly. To export to Excel, please be aware that if place subreports in table or matrix in the main report, subreports would not be exported. One workaround is to use List control to simulate table and place subreport in it. For the detailed steps, you can refer to the similar thread: http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/7cbba683-a162-4be1-a71c-a7c7f6e832bf Thanks, Tony ChainTony Chain

Hi Tony, I have tried to export a report in PDF format from BIDS and Report Manager launching the operation from the main report, but any subreports aren't exported ??? Thanks

Hi Tony, perhaps my issue isn't clear. In my main report I have created a link to pass to a subreport for a table field. I haven't use the subreport control. Thanks

Hi, In Reporting Services, the PDF rendering is designed renders what you see in the original report, so the related reports of links in the main report would not be exported with the main report. To export linked reports when export the main report, we can place these reports as subreport in the bottom of the main report. Then they will also be exported. Thanks, Tony ChainTony Chain

Hi, about the excel exporting, the requirement is to maintain the link action when I click on a specific cell of the report table. When I export the report, if I click on the cell I navigate to the report server. I don't want main and linked reports on the same worksheet and a possible solution shoul be to use the subreport control to have the subreports exported on different worksheet of the same excel file, but when I click on the cell I must navigate to the right worksheet of the subreport. If I cannot navigate to the path containing the exported and saved linked reports, but I need to find a workaround solution. The SSRS should be less limited and allows more personalization. Any ideas for me, please? Many thanks

Hi, By default, if export report to Excel, click the linked cell will navigate to the corresponding report on Report Server. If you need to use Subreport control in report and export them in one Excel file with separate worksheet. Please refer to the steps below: 1. In the main Table, right click the cell with link action and select Properties. Click the Navigation tab in Textbox Properties window. 2. Select Jump to bookmark then specify an expression in the dropdown list. Please be aware that the expression will be evaluated to Bookmark ID. 3. In the main report, place each Subreport control in separate Rectangle control. 4. For each Rectangle, specify Bookmark property to a Bookmark ID correspond to the expression specified in the linked cell. 5. Specify the PageBreakAtStart of each Rectangle to True. After that, when exported the main report to Excel file, subreports will be stored in separate worksheets. Clicking the linked cell will navigate to the corresponding worksheet. For more information about Add a Bookmark Link, please see: http://msdn.microsoft.com/en-us/library/ms156286(v=SQL.90).aspx Thanks, Tony ChainPlease remember to mark the replies as answers if they help and unmark them if they provide no help

Hi Tony. I have tried to follow your steps. I have created two rdl files, one as the main report. In the main report I have designed a data set to fill the table put in the layout. I want to navigate to drill down report when I click on a field of the table in the main report. In the second rdl I have the dataset with the code and the description about the field in the main report. In the main report, I have created a rectangle, inside it I have put a subreport specifying as subreport the second rdl (drill-down report). Which expression do I write for Jump to bookmark property for the table field in the main report? I have tried to indicate a string and so for the bookmark id of the rectangle but no action has occur ??? I can see the error message it cannot view the subreport. Any helps for me, please?

Hi pscorca, Sorry for the delayed response. For example, we have a table in the main report with 3 records and 3 rectangles as the illustration shows: ID Name 1 AAA 2 BBB 3 CCC Rectangle 1 Bookmark AAA Rectangle 2 Bookmark BBB Rectangle 3 Bookmark CCC Now we need users click cells in the Name column to navigate the corresponding subreport. To achieve this, we can first specify the detailed cell to jump to bookmark with the expression like =Fields!Name.Value. Then, set Bookmark property for each Rectangle controls to an existing value in the Name Column. After that, click the cell will navigate to a specific rectangle. Please also set page break for rectangles and add subreports in them. If it still doesn’t work for you, please post the error message. Thanks, Tony Chain Please remember to mark the replies as answers if they help and unmark them if they provide no help