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

Export to Excel Problem

When I try to export a report to Excel I get the following message:
"Internet Explorer was not able to open this internet site. The requested
site is either unavailable or cannot be found. Please try again later."
The report renders fine and will export to a pdf with no errors.
Anyone have any suggestions?
ThanksDo you have Excel on the machine you are trying to export Excel?
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"sperotti" <sperotti@.discussions.microsoft.com> wrote in message
news:A2B259A6-2DD3-4BE3-8DD9-A0242F8E13C5@.microsoft.com...
> When I try to export a report to Excel I get the following message:
> "Internet Explorer was not able to open this internet site. The requested
> site is either unavailable or cannot be found. Please try again later."
> The report renders fine and will export to a pdf with no errors.
> Anyone have any suggestions?
> Thanks
>|||Yes. I have Excel 2003.
"Bruce L-C [MVP]" wrote:
> Do you have Excel on the machine you are trying to export Excel?
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "sperotti" <sperotti@.discussions.microsoft.com> wrote in message
> news:A2B259A6-2DD3-4BE3-8DD9-A0242F8E13C5@.microsoft.com...
> > When I try to export a report to Excel I get the following message:
> >
> > "Internet Explorer was not able to open this internet site. The requested
> > site is either unavailable or cannot be found. Please try again later."
> >
> > The report renders fine and will export to a pdf with no errors.
> >
> > Anyone have any suggestions?
> >
> > Thanks
> >
>
>

export through DTS

Hi Everyone I got another problem every time I try to import data to Sql from Access 2000 it keeps give me an error message that says row 2271. Errors encountered so far in this tabel 1 insert error, column 8 (DOB, DBTYPE_DBTIMESTAMP), status 6: Data overflow. Invalid Character value for cast sepcification.

anyone got any suggestionsWhat is the record in row 2271?|||the same data in 2271 exsist in the rest of the database. columns Category, rehire, firstname..lastname..etc hiredate (date formats date/time)|||I guess, Derrick was asking what is the value of column 8 (DOB) at record 2271. It has to be different vs. let's say record #2270. Is the data type in access also datetime or it's a varchar?|||oh sorry the data in access is date/time data type, not varchar|||Here's where I'm going with this. Give us the CREATE TABLE statement for the SQL Server table you're importing into. Then give use the entire row of data from records 2270 and 2271. We should be able to see what's going on from that easily.

Export SSRS Report to Excel - 65000 lines are limitation?

Currenly work with dataset which has 100000 records, when i export ssrs
report to excel it displayed error message "can't export more than 65000
lines"
I m blocked !!!!I believe that Excel 2007 now has a limit of 1 000 000 rows by 16 384
columns.
Alain Quesnel
alainsansspam@.logiquel.com
www.logiquel.com
"Nilesh" <Nilesh@.discussions.microsoft.com> wrote in message
news:1791E023-4FC2-4296-8D02-32F4586538B4@.microsoft.com...
> Currenly work with dataset which has 100000 records, when i export ssrs
> report to excel it displayed error message "can't export more than 65000
> lines"
> I m blocked !!!!
>