SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Information Needed


Information Needed

Author
Message
DBA12345
DBA12345
Valued Member
Valued Member (68 reputation)Valued Member (68 reputation)Valued Member (68 reputation)Valued Member (68 reputation)Valued Member (68 reputation)Valued Member (68 reputation)Valued Member (68 reputation)Valued Member (68 reputation)

Group: General Forum Members
Points: 68 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..!!!
Bill-89778
Bill-89778
Old Hand
Old Hand (301 reputation)Old Hand (301 reputation)Old Hand (301 reputation)Old Hand (301 reputation)Old Hand (301 reputation)Old Hand (301 reputation)Old Hand (301 reputation)Old Hand (301 reputation)

Group: General Forum Members
Points: 301 Visits: 2506
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



DBA12345
DBA12345
Valued Member
Valued Member (68 reputation)Valued Member (68 reputation)Valued Member (68 reputation)Valued Member (68 reputation)Valued Member (68 reputation)Valued Member (68 reputation)Valued Member (68 reputation)Valued Member (68 reputation)

Group: General Forum Members
Points: 68 Visits: 240
Hi SSC,

Thanks for you Prompt reply.

Is it something you referring to Linked Report in SSRS???
DBA12345
DBA12345
Valued Member
Valued Member (68 reputation)Valued Member (68 reputation)Valued Member (68 reputation)Valued Member (68 reputation)Valued Member (68 reputation)Valued Member (68 reputation)Valued Member (68 reputation)Valued Member (68 reputation)

Group: General Forum Members
Points: 68 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/
Bill-89778
Bill-89778
Old Hand
Old Hand (301 reputation)Old Hand (301 reputation)Old Hand (301 reputation)Old Hand (301 reputation)Old Hand (301 reputation)Old Hand (301 reputation)Old Hand (301 reputation)Old Hand (301 reputation)

Group: General Forum Members
Points: 301 Visits: 2506
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



pshields
pshields
Valued Member
Valued Member (51 reputation)Valued Member (51 reputation)Valued Member (51 reputation)Valued Member (51 reputation)Valued Member (51 reputation)Valued Member (51 reputation)Valued Member (51 reputation)Valued Member (51 reputation)

Group: General Forum Members
Points: 51 Visits: 403
Have you looked at using a document map?
Phil
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search