Multiple Sites in Export

Sali zäme :-)
In a report, i have got multiple pages as it should be. Now, i'd like to
have just 1 sheet in an excel export including all data, but several pages in
preview are generating several sheets in excel. Any idea?
thxRemove all page breaks. Each time a page break is encountered a new excel
tab is generated.
--
Bruce Johnson [MSFT]
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"SwissSmurf" <SwissSmurf@.discussions.microsoft.com> wrote in message
news:79E05569-686E-4D28-BFCC-D341F7C4C14F@.microsoft.com...
> Sali zäme :-)
> In a report, i have got multiple pages as it should be. Now, i'd like to
> have just 1 sheet in an excel export including all data, but several pages
in
> preview are generating several sheets in excel. Any idea?
> thx|||Hi Bruce
How are you today? Hope you're fine :-)
In out report, we have got one table with a lot of data. In
table-properties, grouping and sorting, we inserted
"=Ceiling(RowNumber(Nothing)/15)" as a "group on"-expression and "page break
at end" to create pagebreaks after 15 entries. In this case, i can't remove
this property. Hope you have got an idea to resolve this problem :-)
Greez and thx,
SwissSmurf
"Bruce Johnson [MSFT]" wrote:
> Remove all page breaks. Each time a page break is encountered a new excel
> tab is generated.
> --
> Bruce Johnson [MSFT]
> Microsoft SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "SwissSmurf" <SwissSmurf@.discussions.microsoft.com> wrote in message
> news:79E05569-686E-4D28-BFCC-D341F7C4C14F@.microsoft.com...
> > Sali zäme :-)
> >
> > In a report, i have got multiple pages as it should be. Now, i'd like to
> > have just 1 sheet in an excel export including all data, but several pages
> in
> > preview are generating several sheets in excel. Any idea?
> >
> > thx
>
>