Exporting to Multiple Excel worksheets

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

ironryan77@gmail.com - 30 Mar 2006 19:29 GMT

I am having trouble exporting my SRS data to multiple Excel worksheets.
I have four tables. I want each of these tables to appear on a
different worksheet even if there is no data for it. For one of my
queries, there was only data for 3 of these tables. First I selected
"Insert a Page Break after this table" for all of my Table properties.

When I exported this output to Excel, it only showed me 3 worksheets.
But I want it to always show me all four worksheets even if there is no
data for that table. And I believe it should still show me something
on this 4th worksheet because in SRS on each table's property I entered
in "No Data Available" for the NoRows table property. Instead what it
does is the Excel file includes this 4th table on the same worksheet as
one of the other tables. And I clearly see the text "No Data
Available", but it's not on its own page.

So again, how do I automatically have all 4 tables show up on 4
different tabs (worksheets).

Reply to this Message

Bassist695 - 30 Mar 2006 19:44 GMT

Try selecting "Insert a Page Break Before this table" for your 4th
table and see what happens.

Mike

Reply to this Message

Ryan D - 30 Mar 2006 21:16 GMT

I tried this, but this didn't fix it either.

> Try selecting "Insert a Page Break Before this table" for your 4th
> table and see what happens.
>
> Mike

Reply to this Message

WaikikiFrog - 30 Mar 2006 21:47 GMT

Try to use GROUP in the layout design. Each group will be distributed as
individual worksheet accordingly.

>I am having trouble exporting my SRS data to multiple Excel worksheets.
> I have four tables. I want each of these tables to appear on a
[quoted text clipped - 13 lines]
>So again, how do I automatically have all 4 tables show up on 4
>different tabs (worksheets).

Reply to this Message

Amarnath - 31 Mar 2006 08:19 GMT

Just return a space character on any of the table fields so that RS will
thing that the table needs to be printed on the fourth sheet as well. If you
have empty it wont return but just insert a space if no records are
available.

Amarnath.

> I am having trouble exporting my SRS data to multiple Excel worksheets.
> I have four tables. I want each of these tables to appear on a
[quoted text clipped - 13 lines]
> So again, how do I automatically have all 4 tables show up on 4
> different tabs (worksheets).

Reply to this Message

Ryan D - 31 Mar 2006 15:34 GMT

I have tried all of the above suggestions, but none of them work. Have any
of you ever tried to do what I'm doing? Regarding Amarnath's response, it
would not be easy for me to insert a space since I am filtering the data from
one table. In other words, my SP selects data into one table which is then
filtered in SRS based on the grouping. Unless there is a way to form an
expression so that it inserts a space. Is this possible?

Regarding Frog's post, I created a group for this table and set the filter,
but this did not work either. And I have tried adding header and footer
where all of the footers contain the text "End of Record", but for this one
table with no data in it, neither header nor footer display. Only the text I
enter into the NoRows property displays. If I remove the text from NoRows
then there is a big space on that part of the worksheet, but I still only
have 3 total worksheets.

> Just return a space character on any of the table fields so that RS will
> thing that the table needs to be printed on the fourth sheet as well. If you
[quoted text clipped - 20 lines]
> > So again, how do I automatically have all 4 tables show up on 4
> > different tabs (worksheets).

Reply to this Message