technopax.blogg.se

In your scenario, for the first requirement:” put a description next to each link describing what the report is about ”. Will the fact that I develop the reports in VS (and then deploy them to servers) give me any more options? I also do all my report development in visual studio (VS 2015 Pro). What's a little annoying about this is I could do everything in excel (including drill down reports) by writing everything in perl over a decade ago but I still dont have extensive access to excel creation/control/customizationo from within SSRS.Ĩ0% of all my reports are delivered as excel. Lot of people still want their reports delivered as excel spreadsheets/workbooks. Is this posisble? This might be the best solution if I could get it to work.Īdditionally, I assume there is no way to use the excel hyperlink function then? It would be nice if the excel functions were available in the expression language.

worksheet)) is not available in the bookmark drop down and I coulndn't figure out the expression syntaxįor making the action go to a book mark in a 2nd tablix (using a different dataset). I tried to get the bookmark to work but my additional worksheets will always be using different data-sets. Is there a way to do this with the document map?

The document map might work except that I have a requirement to put a description next to each link describing what the report is about. MSDN Support, feel free to contact for the quick response. If you have any compliments or complaints to This can be beneficial to other community members reading this thread. Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. If you have any question, please feel free to ask. SQL Server Reporting Services Bookmarks and Document Maps for help. Then export to excel, you will get the result below If you want to set hyperlink on record in Tablix, you could click on corresponding cells to set DocumentMapLabel on it. Repeat this operation to set this on second Tablix. Then choose first Tabilx, set DocumentMapLabel with name you want. I assume that your report might be similar to below If so, you could use DocumentMap or Bookmark in SSRS report to achieve this goal. Based on your description, I understand your requirement as that you want to click the hyperlink to go to other sheet, after you export report to excel, right? If I have something misunderstood, please correct me.