Is it possible to create a tabbed lay out like excel in SQL Reporting services? I have two tables in the dataset which are to be displayed on separate tabs and needed to be exported in the same manner.
Thanks.
People can just tell you what to do... Don't expect them to do it for you
My question isn't related to exporting data into excel. My question is: Is it possible to show tabs in
SQL REPORTS andwhen some one hit the export button of sql Reporting service report is it possible for the report to export data on different tabs. I m asking
SPECIFICALLY about SQL Reporting Services.
I am already doing it by using ASP.NET data controls and Excel Export Librararies but i want to shift this report on the SQL reporting as it is a headache to manage 80 plus columns in my report.
Thanks for your help bro :)
People can just tell you what to do... Don't expect them to do it for you
From your description, do you want to create a Reporting Services report that contains multiple result sets and each result will be exported to a different tab
in Excel, right?
If so, you can try to put multiple tables in your report and then put page breaks before them. Each manual page break becomes a new tab.
For headers, you need to use a Excel DeviceInfo setting, SimplePageHeaders
Thats kool bro...that was exactly wat i was looking for...can you tell me another thing can i create a reporting services report which contains tabs display??
People can just tell you what to do... Don't expect them to do it for you
I just changed its status so that you look it under unresolved ...otherwise i have got answer to my question and will mark your post as answer after two days... :)
People can just tell you what to do... Don't expect them to do it for you
When you ask a question, remember to click "mark as answered" when you get a reply which answers your question; this ensures the right forum member gets credit for being helpful (and makes search more relevant too).
Marked as answer by shehbazbashir on Jul 01, 2008 09:43 AM
shehbazbashi...
Member
118 Points
76 Posts
How to create excel like tab lay out?
Jun 09, 2008 11:20 AM|LINK
Hi,
Is it possible to create a tabbed lay out like excel in SQL Reporting services? I have two tables in the dataset which are to be displayed on separate tabs and needed to be exported in the same manner.
Thanks.
Satyabrat
Member
324 Points
110 Posts
Re: How to create excel like tab lay out?
Jun 09, 2008 12:05 PM|LINK
hello shehbazbashir
use this link for demo application
www.codeproject.com/KB/aspnet/ExportClassLibrary.aspx
B.E.(C.Sc.)
Web developer
Livetek Solution
Dont forget to click "Mark as Answer" on the post that helped you.
shehbazbashi...
Member
118 Points
76 Posts
Re: How to create excel like tab lay out?
Jun 09, 2008 12:38 PM|LINK
Hi Satyabrat,
My question isn't related to exporting data into excel. My question is: Is it possible to show tabs in SQL REPORTS and when some one hit the export button of sql Reporting service report is it possible for the report to export data on different tabs. I m asking SPECIFICALLY about SQL Reporting Services.
I am already doing it by using ASP.NET data controls and Excel Export Librararies but i want to shift this report on the SQL reporting as it is a headache to manage 80 plus columns in my report.
Thanks for your help bro :)
Nai-Dong Jin...
All-Star
41630 Points
3558 Posts
Re: How to create excel like tab lay out?
Jun 11, 2008 03:19 AM|LINK
Hi,
From your description, do you want to create a Reporting Services report that contains multiple result sets and each result will be exported to a different tab in Excel, right?
If so, you can try to put multiple tables in your report and then put page breaks before them. Each manual page break becomes a new tab.
For headers, you need to use a Excel DeviceInfo setting, SimplePageHeaders
(see http://msdn2.microsoft.com/en-us/library/ms155069(en-US,SQL.90).aspx ).
If you want this to be the default, you can add it to the RSReportServer.config file
(see http://msdn2.microsoft.com/en-us/library/ms156281.aspx).
Thanks.
shehbazbashi...
Member
118 Points
76 Posts
Re: How to create excel like tab lay out?
Jun 17, 2008 09:15 AM|LINK
Thats kool bro...that was exactly wat i was looking for...can you tell me another thing can i create a reporting services report which contains tabs display??
shehbazbashi...
Member
118 Points
76 Posts
Re: How to create excel like tab lay out?
Jun 17, 2008 10:40 AM|LINK
I just changed its status so that you look it under unresolved ...otherwise i have got answer to my question and will mark your post as answer after two days... :)
akjoshi
Contributor
3636 Points
615 Posts
Re: How to create excel like tab lay out?
Jun 26, 2008 05:22 AM|LINK
Hi,
Check this article[http://www.codeproject.com/KB/reporting-services/AnUglyTabControlForSSRS.aspx] which shows a way to implement a tab control like structure in reports, it uses text boxes, tables and tables Visibility can be toggled by another report item property.
Also check my blog post for other details - http://weblogs.asp.net/akjoshi/archive/2008/06/26/A-tab-control-like-structure-in-reporting-services-report.aspx
I hope that will be helpful
shrainpatel
Member
631 Points
144 Posts
Re: How to create excel like tab lay out?
Jun 26, 2008 05:56 AM|LINK
Hi Mr. Joshi.
Its amazing article. Thanks for sharing your knowledge with us.
Regards,
My Blog
My Work Place
MARK AS ANSWER if post helps. It's required to boost somebody's moral to help community.
shehbazbashi...
Member
118 Points
76 Posts
Re: How to create excel like tab lay out?
Jul 01, 2008 09:41 AM|LINK
Thanks a lot man that was the thing i needed.
I was near to lose hope for this...lolxxxxxxx
a drink is due on me... ;)
rupendra.sha...
Member
2 Points
1 Post
Re: How to create excel like tab lay out?
Jan 05, 2012 08:53 AM|LINK
Your artical from the Code project has been removed.
can you please send me the source code and data source for this requirement to be completed.
Thanks