Post reply

Information Needed

  • October 31, 2013 at 11:29 am

    #278659

    Can we create a SSRS report like tab's in excel.

    My manager want to me to create a report looks exactly like Excel tab formart.

    He want to view the all the reports in different tabs in one SSRS report.I have a data in 10 different tab's in Excel.

    Could you please tell me is it possible or not.If so, what is the report type name.

    I have to tell whether it is possible ot not to my manager.

    Please help me..!!!

  • October 31, 2013 at 11:49 am

    #1663212

    Hi DBA,

    There isn't a way to replicate excel-like tabs except doing so with images, and then linking to a different report.

    An alternative that may give you what you need is bookmarks. You can use them to navigate within groups, so it can simulate an excel tab if you setup your grouping correctly. Just have textboxes with the 'tabs' linking to a specific bookmark.

    Hope this helps as I've tried in the past to do the same thing 🙂

    Bill

  • October 31, 2013 at 12:01 pm

    #1663219

    Hi SSC,

    Thanks for you Prompt reply.

    Is it something you referring to Linked Report in SSRS???

  • October 31, 2013 at 12:31 pm

    #1663228

    Hi SSC,

    I have found one link. They are telling, by tabbed reports in ssrs we can achive our requirement.

    Please give me suggestions.

    Here is the link

    http://bistuffwithdigven.wordpress.com/2013/01/20/tabbed-ssrs-reports/

  • October 31, 2013 at 1:26 pm

    #1663245

    The link is similar to what I referred to in the first part of my reply. Yes. It is a hyperlink between reports.

    The bookmark method can link within the same report.

    Here is a link that should help: http://technet.microsoft.com/en-us/library/ms159823(v=sql.100).aspx

    Bill

  • November 1, 2013 at 8:18 am

    #1663423

    Have you looked at using a document map?

    Phil

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply