Exporting report into multiple worksheet

I have a requirement to export the report into multiple excel worksheet. Is
that possible? Can someone please help me with that?
Thanks
--
Message posted via http://www.sqlmonster.comYes, it's possible.
You need to insert "page breaks".
See "Reporting Services Book Online" - article "How to add a page break
(Report Designer)".sql

Exporting Data

I have a requirement to run .rdl reports and also export the data for the
report into EXCEL. My quest is how can I export the data, is there an
dataelement in the RDL definition language that I can use.
ThankYouThe user can run the report and then use the export function. OR
you may call the report via HTML passing the parameters to render to Excel..
--
Wayne Snyder MCDBA, SQL Server MVP
Mariner, Charlotte, NC
(Please respond only to the newsgroup.)
I support the Professional Association for SQL Server ( PASS) and it's
community of SQL Professionals.
"kulwant" <kulwant@.discussions.microsoft.com> wrote in message
news:52A6BA63-B984-4131-B86E-12EF4D56AC24@.microsoft.com...
>I have a requirement to run .rdl reports and also export the data for the
> report into EXCEL. My quest is how can I export the data, is there an
> dataelement in the RDL definition language that I can use.
> ThankYou|||I am sorry but I have not made myself clear, what The users want is the
actual underline data that is used to generate the report.
"Wayne Snyder" wrote:
> The user can run the report and then use the export function. OR
> you may call the report via HTML passing the parameters to render to Excel..
> --
> Wayne Snyder MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> (Please respond only to the newsgroup.)
> I support the Professional Association for SQL Server ( PASS) and it's
> community of SQL Professionals.
> "kulwant" <kulwant@.discussions.microsoft.com> wrote in message
> news:52A6BA63-B984-4131-B86E-12EF4D56AC24@.microsoft.com...
> >I have a requirement to run .rdl reports and also export the data for the
> > report into EXCEL. My quest is how can I export the data, is there an
> > dataelement in the RDL definition language that I can use.
> >
> > ThankYou
>
>

Export restrict to Excel only

Hi All,
I have a requirement to restrict the Export the SSRS report into EXCEL
format only.
Anyone have any idea?
Thanks.If you are posting a link to the report inside of an application, you could
just post one with the argument rs:format=excel in the link. That is only a
suggestion though.
"Shailesh K" wrote:
> Hi All,
> I have a requirement to restrict the Export the SSRS report into EXCEL
> format only.
> Anyone have any idea?
> Thanks.
>|||Thanks for quick response.
Actually we are using report viewer control to display the report on our web
page.
In ReportViewer's toolbar..there is dropdown to export format[pdf and excel].
We have requirement to show only Excel option in dropdown, so that user is
able to export in Excel only.
Sorry for incomplete description of problem in previous post!
-Shailesh
"beeradg" wrote:
> If you are posting a link to the report inside of an application, you could
> just post one with the argument rs:format=excel in the link. That is only a
> suggestion though.
> "Shailesh K" wrote:
> > Hi All,
> >
> > I have a requirement to restrict the Export the SSRS report into EXCEL
> > format only.
> >
> > Anyone have any idea?
> >
> > Thanks.
> >