|
|
||||||
|
#1
10-11-07, 04:24 PM
|
|
|
|
|
I am rendering a report from RS that has multiple tables. After each table I
have it setup to have a page break. This causes each table to be written to a different sheet within the excel workbook. This is fine. What I would like to know is if there is a way to write the table name to the excel workbook tab when the report is rendered instead of having the tabs show sheet1, sheet2, etc. DOes anyone know how or if this can be done? Thanks for your help, s |
|
|
|
#2
10-12-07, 04:02 AM
|
|
|
|
|
On Oct 11, 10:24 am, Susan R <Sus> wrote:
> I am rendering a report from RS that has multiple tables. After each table I > have it setup to have a page break. This causes each table to be written to > a different sheet within the excel workbook. This is fine. What I would > like to know is if there is a way to write the table name to the excel > workbook tab when the report is rendered instead of having the tabs show > sheet1, sheet2, etc. DOes anyone know how or if this can be done? > Thanks for your help, > s Several people have asked this same question on these forums w/pretty much the same response: this is not currently possible in SSRS. Sorry that I could not be of greater assistance. Regards, Enrique Martinez Sr. Software Consultant |
|
#3
10-26-07, 08:33 AM
|
|
|
|
|
Hi,
I never tried it my myself, but facing the same problem I found http://www.spacefold.com/lisa/post/C...-QnD-XSLT.aspx Seems to do the job, but is a little tricky to setup and works only for excel 2003 and newer. Simon "Susan R" wrote: [..] |
|
|
| Similar Threads | |
| export multiple sheets to multiple excel files I have a workbook with approx 30 sheets. I am trying to figure out how to save each sheet as it's own workbook (using the name of the worksheet as the file name) without... |
|
| Export multiple datatables from a C# form to Multiple Excel sheets How do I export multiple datatables from a C# form to Multiple Excel sheets using a datagrid with htmlwriter so it is simple, fast and efficient but can do it to mulitple... |
|
| Exporting multiple queries to multiple sheets within one excel fil I want to export 5 queries to 5 sheets within the same excel file. The following command keeps overwriting the same excel file. DoCmd.OutputTo acOutputQuery, "qry1",... |
|
| Multiple tables output to multiple sheets in single excel workbook Hi all, Been a while since I've done any access dev, and I can't for the life of me remember how to do this. I have 3 tables I need to export to Excel, preferably in one... |
|
| export to Excel - multiple sheets & renaming sheets I'm developing a website for work that exports some reports to excel. I am using the... Response.AddHeader... |
|
|
All times are GMT. The time now is 11:22 AM. | Privacy Policy
|
Rendering to Excel, multiple sheets