Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Information Needed Expand / Collapse
Author
Message
Posted Thursday, October 31, 2013 11:29 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Thursday, April 24, 2014 8:19 PM
Points: 56, Visits: 240
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..!!!
Post #1510357
Posted Thursday, October 31, 2013 11:49 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Friday, November 21, 2014 7:04 AM
Points: 91, Visits: 2,342
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



Post #1510362
Posted Thursday, October 31, 2013 12:01 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Thursday, April 24, 2014 8:19 PM
Points: 56, Visits: 240
Hi SSC,

Thanks for you Prompt reply.

Is it something you referring to Linked Report in SSRS???
Post #1510370
Posted Thursday, October 31, 2013 12:31 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Thursday, April 24, 2014 8:19 PM
Points: 56, Visits: 240
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/
Post #1510379
Posted Thursday, October 31, 2013 1:26 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Friday, November 21, 2014 7:04 AM
Points: 91, Visits: 2,342
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



Post #1510399
Posted Friday, November 1, 2013 8:18 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, July 2, 2014 3:56 PM
Points: 11, Visits: 379
Have you looked at using a document map?
Phil
Post #1510603
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse