How to create excel like tab lay out?

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.

Re: How to create excel like tab lay out?

hello shehbazbashir

use this link for demo application

www.codeproject.com/KB/aspnet/ExportClassLibrary.aspx

Re: How to create excel like tab lay out?

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 :)

Re: How to create excel like tab lay out?

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.

Re: How to create excel like tab lay out?

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??

Re: How to create excel like tab lay out?

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... :)

Re: How to create excel like tab lay out?

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

Re: How to create excel like tab lay out?

akjoshi

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

Hi Mr. Joshi.

Its amazing article. Thanks for sharing your knowledge with us.

Regards,

Re: How to create excel like tab lay out?

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... ;)

Re: How to create excel like tab lay out?

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