locked
How to create excel like tab lay out? RRS feed

  • Question

  • User-1421069450 posted

    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.

     

    Monday, June 9, 2008 7:20 AM

Answers

All replies

  • User978097916 posted

    hello shehbazbashir

     use this link for demo application

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

    Monday, June 9, 2008 8:05 AM
  • User-1421069450 posted

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

    Monday, June 9, 2008 8:38 AM
  • User-1136466523 posted

    Hi,

    <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p> </o:p>

    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?

    <o:p> </o:p>

    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.

    <o:p> </o:p>

    For headers, you need to use a Excel DeviceInfo setting, SimplePageHeaders

    (see http://msdn.microsoft.com/en-us/library/ms155069(en-US,SQL.90).aspx ).

    <o:p> </o:p>

    If you want this to be the default, you can add it to the RSReportServer.config file

    (see http://msdn.microsoft.com/en-us/library/ms156281.aspx).

    <o:p> </o:p>

    Thanks.

    <o:p> </o:p>

     

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Tuesday, June 10, 2008 11:19 PM
  • User-1421069450 posted

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

    Tuesday, June 17, 2008 5:15 AM
  • User-1421069450 posted

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

    Tuesday, June 17, 2008 6:40 AM
  • User1805008792 posted

    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

     

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Thursday, June 26, 2008 1:22 AM
  • User-1148183825 posted

    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, 

    Thursday, June 26, 2008 1:56 AM
  • User-1421069450 posted

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

    Tuesday, July 1, 2008 5:41 AM
  • User-281188796 posted

    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

    Thursday, January 5, 2012 4:53 AM