exporting reports into EXCEL format

Hi,

My organization is currently migrating from reporting services 2000 to reporting services 2005. We are having an issue with exporting reports into EXCEL format. Basically we have a table with five grouping hierarchy. The parent groupings toggle the visibility of the corresponding sub groupings. It works as expected when deployed to the report server, however when exported into Excel it expands to level 4 even though level 3 was not actually exploded.
Note that the same report exports correctly to Excel in the previous version of Reporting Services but in the 2005 version it skips one level of grouping.

Is this a bug in reporting services 2005? I saw some other people posting similar issues.

Any help would be much appreciated!

Thanks,
Radu

Hello,

In RS2000, excel renderer didn't include toggled items if we couldn't generate the outline and they current state was collapsed.

We changed this behavior in RS2005 based on customer input - the toggled items will be included in excel output regardless of thery collapse/expand state. Every time is possible we will generate the outline accordinglly.

I suspect you don't have an excel outline for level 4. Is this correct?

Thank you,

Nico

|||

Hi Nico,

Thanks a lot for your timely response!

We actually get an Excel outline for level 4. However, we miss level 3 information completely after the export to Excel. Our current process creates the report exploded up to level 3. Some users need to export it to Excel at exactly the same level of detail (and they do not need the data at the more detailed levels).

Also, the export to Excel takes much longer (and creates a much bigger file) in the new version (2005), probably because of exporting to the most detailed level. It also explodes to level 4 instead of level 3.

Could this be caused by the fact that the RDL file was originally created in RS2000 and subsequently migrated to RS2005? I still have the migration logs and got no errors or warnings there. I can provide the RDL file if necessary.

Is there a way to control what levels are exported to Excel and how they get exploded there? In this particular case we don't even need to export data for the most detailed levels (from level 4 and up).

Thanks in advance,

Radu

|||

Hi Radu,

In RS2005 all the levels will be included in the excel output and it is a behavior change from RS2000. You cannot control individual levels.

Can you send us the rdl, please? I would like to investigate the missing information (for level 3) part.

Thanks,

Nico

|||

Hi Nico,

Thanks for the clarification! Very good to know!

Nevertheless, it would have been nice to have the ability to select the depth (up to which level of grouping) for the export to Excel.

I would gladly send the RDL file but please advise me how to proceed: can I simply embed the code in my message (the RDL file is about 150 kB) or is there a way to attach the file?

Regards,

Radu

sql

Exporting report to WordML

I have been trying to use the XML export along with an XSL file to try and
generate WordML files from reporting services, and so far have had no real
success. I have tried using the XSLT Inference Tool and following the VERY
limited documentation that exists for it, but it just does not want to work
for me.
So, I have 2 questions:
1) Is there any good information/examples of using Word 2003, the XSLT
Inference Tool, and/or Visual Studio to get RS to output WordML files?
2) Why hasn't Microsoft released a WordML renderer for Reporting Services? I
can understand not having one for the old formats since MS is trying to phase
them out, but they have an XML renderer, and they are pushing the WordML
format, so it would seem to make sense to release a WordML renderer...Anyone have any thoughts/Hints/Tips for this?
"jwattsCOL" wrote:
> I have been trying to use the XML export along with an XSL file to try and
> generate WordML files from reporting services, and so far have had no real
> success. I have tried using the XSLT Inference Tool and following the VERY
> limited documentation that exists for it, but it just does not want to work
> for me.
> So, I have 2 questions:
> 1) Is there any good information/examples of using Word 2003, the XSLT
> Inference Tool, and/or Visual Studio to get RS to output WordML files?
> 2) Why hasn't Microsoft released a WordML renderer for Reporting Services? I
> can understand not having one for the old formats since MS is trying to phase
> them out, but they have an XML renderer, and they are pushing the WordML
> format, so it would seem to make sense to release a WordML renderer...
>

Exporting report (with graph subreport) to PDF

Hi All,
This is my first reporting services post (as I am pretty new to
working with this new technology), so if I am unclear on anything or
ignorant on anything please forgive me!
Current Situation:
--
I am exporting a report to PDF (in a Windows service). The parent
report is exporting correctly, but a subreport is erroring out. This
subreport is simply a graph at the bottom of the report, so it is
pretty crucial to the report that it is shown. The method I am using
to export this report is LocalReport.Render.
Things to keep in mind:
--
I am developing this service in VS 2005 in c#.
Is this even possible?Have you applied SQL Server 2005 SP2 to your development machine?
If not try this since applying that will also update the ReportViewer
control and the rest of the client components as well.
--
Chris Alton, Microsoft Corp.
SQL Server Developer Support Engineer
This posting is provided "AS IS" with no warranties, and confers no rights.
--
> From: MattW <mdw233@.gmail.com>
> Newsgroups: microsoft.public.sqlserver.reportingsvcs
> Subject: Exporting report (with graph subreport) to PDF
> Date: Mon, 08 Oct 2007 12:41:31 -0000
> Organization: http://groups.google.com
> Lines: 24
> Hi All,
> This is my first reporting services post (as I am pretty new to
> working with this new technology), so if I am unclear on anything or
> ignorant on anything please forgive me!
>
> Current Situation:
> --
> I am exporting a report to PDF (in a Windows service). The parent
> report is exporting correctly, but a subreport is erroring out. This
> subreport is simply a graph at the bottom of the report, so it is
> pretty crucial to the report that it is shown. The method I am using
> to export this report is LocalReport.Render.
>
> Things to keep in mind:
> --
> I am developing this service in VS 2005 in c#.
>
> Is this even possible?
>|||On Oct 8, 9:57 am, cal...@.online.microsoft.com (Chris Alton [MSFT])
wrote:
> Have you applied SQL Server 2005 SP2 to your development machine?
> If not try this since applying that will also update the ReportViewer
> control and the rest of the client components as well.
> --
> Chris Alton, Microsoft Corp.
> SQL Server Developer Support Engineer
> This posting is provided "AS IS" with no warranties, and confers no rights.
> --
>
> > From: MattW <mdw...@.gmail.com>
> > Newsgroups: microsoft.public.sqlserver.reportingsvcs
> > Subject: Exporting report (with graph subreport) to PDF
> > Date: Mon, 08 Oct 2007 12:41:31 -0000
> > Organization:http://groups.google.com
> > Lines: 24
> > Hi All,
> > This is my first reporting services post (as I am pretty new to
> > working with this new technology), so if I am unclear on anything or
> > ignorant on anything please forgive me!
> > Current Situation:
> > --
> > I am exporting a report to PDF (in a Windows service). The parent
> > report is exporting correctly, but a subreport is erroring out. This
> > subreport is simply a graph at the bottom of the report, so it is
> > pretty crucial to the report that it is shown. The method I am using
> > to export this report is LocalReport.Render.
> > Things to keep in mind:
> > --
> > I am developing this service in VS 2005 in c#.
> > Is this even possible... Hide quoted text -
> - Show quoted text -
Thanks Chris ... That did the trick!|||Not a problem :)
--
Chris Alton, Microsoft Corp.
SQL Server Developer Support Engineer
This posting is provided "AS IS" with no warranties, and confers no rights.
--
> From: MattW <mdw233@.gmail.com>
> Newsgroups: microsoft.public.sqlserver.reportingsvcs
> Subject: Re: Exporting report (with graph subreport) to PDF
> Date: Tue, 09 Oct 2007 13:38:21 -0000
> On Oct 8, 9:57 am, cal...@.online.microsoft.com (Chris Alton [MSFT])
> wrote:
> > Have you applied SQL Server 2005 SP2 to your development machine?
> >
> > If not try this since applying that will also update the ReportViewer
> > control and the rest of the client components as well.
> >
> > --
> > Chris Alton, Microsoft Corp.
> > SQL Server Developer Support Engineer
> > This posting is provided "AS IS" with no warranties, and confers no
rights.
> > --
> >
> >
> >
> > > From: MattW <mdw...@.gmail.com>
> > > Newsgroups: microsoft.public.sqlserver.reportingsvcs
> > > Subject: Exporting report (with graph subreport) to PDF
> > > Date: Mon, 08 Oct 2007 12:41:31 -0000
> > > Organization:http://groups.google.com
> > > Lines: 24
> >
> > > Hi All,
> >
> > > This is my first reporting services post (as I am pretty new to
> > > working with this new technology), so if I am unclear on anything or
> > > ignorant on anything please forgive me!
> >
> > > Current Situation:
> > > --
> > > I am exporting a report to PDF (in a Windows service). The parent
> > > report is exporting correctly, but a subreport is erroring out. This
> > > subreport is simply a graph at the bottom of the report, so it is
> > > pretty crucial to the report that it is shown. The method I am using
> > > to export this report is LocalReport.Render.
> >
> > > Things to keep in mind:
> > > --
> > > I am developing this service in VS 2005 in c#.
> >
> > > Is this even possible... Hide quoted text -
> >
> > - Show quoted text -
> Thanks Chris ... That did the trick!
>

Exporting pdf from RS to a Win Form

I'm using Reporting Services 2005 and .Net framework 2.0 and want to display
reports from RS in my Windows form. My questions are:
1) I've got the pdf from the Render-method in the RS Web Service, and tried
to display the pdf in a WebBrowser in my Windows Form using the
WebBrowser.DocumentStream property. But I don't know how set the content type
to application/pdf. I only get the binary displayed in the browser.
Suggestions?
2) If I access, from the same browser as in 1), a pdf through an URL, it
works fine. So, is if possible to retreive a report as a pdf through an URL
reference directly?
3) I could try to display the pdf some kind of other pdf container in my
winform. Does anyone know some nice tools to do this?
Regards,
Tomsi2) According to Books online for SQL Server CTP April 2005, it should be
possible to specify rs:Format=PDF as a parameter in the URL. But this doesn't
help me. It just seems to ignore the parameter... What could be wrong? Or
just simply doesn't the 2005 version support URL access directly?
"Tomsi" wrote:
> I'm using Reporting Services 2005 and .Net framework 2.0 and want to display
> reports from RS in my Windows form. My questions are:
> 1) I've got the pdf from the Render-method in the RS Web Service, and tried
> to display the pdf in a WebBrowser in my Windows Form using the
> WebBrowser.DocumentStream property. But I don't know how set the content type
> to application/pdf. I only get the binary displayed in the browser.
> Suggestions?
> 2) If I access, from the same browser as in 1), a pdf through an URL, it
> works fine. So, is if possible to retreive a report as a pdf through an URL
> reference directly?
> 3) I could try to display the pdf some kind of other pdf container in my
> winform. Does anyone know some nice tools to do this?
> Regards,
> Tomsi|||I ran into this problem as well. I need to display pdf documents
within windows forms and I am trying to utilize the webbrowser control
but can't seem to set the contenttype to 'application/pdf'. Did you
ever find a solution?
Tomsi wrote:
> I'm using Reporting Services 2005 and .Net framework 2.0 and want to display
> reports from RS in my Windows form. My questions are:
> 1) I've got the pdf from the Render-method in the RS Web Service, and tried
> to display the pdf in a WebBrowser in my Windows Form using the
> WebBrowser.DocumentStream property. But I don't know how set the content type
> to application/pdf. I only get the binary displayed in the browser.
> Suggestions?
> 2) If I access, from the same browser as in 1), a pdf through an URL, it
> works fine. So, is if possible to retreive a report as a pdf through an URL
> reference directly?
> 3) I could try to display the pdf some kind of other pdf container in my
> winform. Does anyone know some nice tools to do this?
> Regards,
> Tomsi|||1) As a temporary solution I save the pdf-stream to a file, and access the
file with the WebBrowser.Url-property:
--
string fileName = Path.GetTempFileName() + ".pdf";
FileStream fs = new FileStream(fileName, FileMode.Create);
fs.Write(bytes, 0, bytes.Length);
fs.Close();
_browserReport.Url = new Uri(fileName);
--
But I would like to know how to do this without saving to disk.
2) As far as I can read the SQL Server 2005 documentation, it should work to
get a pdf through URL access from Reporting Services by setting the attribute
"Format=PDF" in the URL. But I can't get it to work in the CTP april
2005-version.
3) Haven't tried this further out. I think Adobe sells some kind of SDK
which might help.
So my answer is that I'm still looking for a good solution.
Tomsi
"rich.beaver@.gmail.com" wrote:
> I ran into this problem as well. I need to display pdf documents
> within windows forms and I am trying to utilize the webbrowser control
> but can't seem to set the contenttype to 'application/pdf'. Did you
> ever find a solution?
> Tomsi wrote:
> > I'm using Reporting Services 2005 and .Net framework 2.0 and want to display
> > reports from RS in my Windows form. My questions are:
> >
> > 1) I've got the pdf from the Render-method in the RS Web Service, and tried
> > to display the pdf in a WebBrowser in my Windows Form using the
> > WebBrowser.DocumentStream property. But I don't know how set the content type
> > to application/pdf. I only get the binary displayed in the browser.
> > Suggestions?
> >
> > 2) If I access, from the same browser as in 1), a pdf through an URL, it
> > works fine. So, is if possible to retreive a report as a pdf through an URL
> > reference directly?
> >
> > 3) I could try to display the pdf some kind of other pdf container in my
> > winform. Does anyone know some nice tools to do this?
> >
> > Regards,
> > Tomsi
>sql

exporting pdf file issue in reporting services

I am trying to export a report as a pdf file which may be around 160MB in
size and the report is giving issues, its timing out or gives me out of
memory, can someone let me know if you faced an issue like this and how it
can be fixed.Look at the available resources that you have on the server (IIS, RAM) the
other thing make your IIS session longer, if I am not wrong you can set it in
reporting services configuration if not go to your IIS administration and set
it for the reportserver site.
"jagan" wrote:
> I am trying to export a report as a pdf file which may be around 160MB in
> size and the report is giving issues, its timing out or gives me out of
> memory, can someone let me know if you faced an issue like this and how it
> can be fixed.|||I already tried this and also increased the session time out, but not working.
"Paul.G." wrote:
> Look at the available resources that you have on the server (IIS, RAM) the
> other thing make your IIS session longer, if I am not wrong you can set it in
> reporting services configuration if not go to your IIS administration and set
> it for the reportserver site.
> "jagan" wrote:
> > I am trying to export a report as a pdf file which may be around 160MB in
> > size and the report is giving issues, its timing out or gives me out of
> > memory, can someone let me know if you faced an issue like this and how it
> > can be fixed.|||What version of RS?
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"jagan" <jagan@.discussions.microsoft.com> wrote in message
news:9E4AA6AE-DB11-4600-B75D-EFDF49DD5277@.microsoft.com...
>I am trying to export a report as a pdf file which may be around 160MB in
> size and the report is giving issues, its timing out or gives me out of
> memory, can someone let me know if you faced an issue like this and how it
> can be fixed.

Exporting Dates to Excel as date format

Hi,

I'm currently having problems exporting formatted dates from reporting services 2005 to excel.

Basically what I require is a way to format a date in reporting services so that it only shows the date without the time (preferably british format) and when it is exported to excel it is still formatted as a date.

This is so the user can sort the data file via date, I appreciate it is easy to select the column and format the cells but i would prefer to have a 'cleaner' solution to this problem which avoids the need for users to be formatting exported reports.

Originally I was formatting the dates as convert(varchar,@.date,103) in the SP which converts it to a character string and excel picks this up as a character as would be expected. So I changed this to a date and set about trying to format the date in Reporting Services, so far i've been unsuccesfull using cdate (brings back the time) and format as it again converts it to a character string.

Any help or advice would be greatly appreciated,

R

i had the same problem before,

i inserted a space before the mm/yyyy when after converted it into char.

it should work

sql

Exporting DataSets from multiple datasources

Is their away to have reporting services call a dataset from an access
database and export it into a sql server table through automation in a
project with 2 datasources. One datasource from access and the other from
sql server. I can do this with a DTS, but could I do it another way to work
around a DTS.
RandyUrghh, i don´t think that the way reporting services should be used. If you
really really really wanna do this, set up an linked server on sql server to
point to access and write a procedure in which you do your importing stuff.
Return from the procedure some kind of return code to display this in your
report.
But (BTW) is a really nasty way to use RS :(
HTH (either), Jens Suessmeyer.
--
http://www.sqlserver2005.de
--
"Randy" <Randy@.discussions.microsoft.com> schrieb im Newsbeitrag
news:5218EBE9-A92E-4528-B381-9E835A72A978@.microsoft.com...
> Is their away to have reporting services call a dataset from an access
> database and export it into a sql server table through automation in a
> project with 2 datasources. One datasource from access and the other from
> sql server. I can do this with a DTS, but could I do it another way to
> work
> around a DTS.
> Randy|||Let me add my voice to what Jens is saying. This is definitely NOT a good
idea.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Jens Süßmeyer" <Jens@.Remove_this_For_Contacting.sqlserver2005.de> wrote in
message news:ebfg4dERFHA.904@.tk2msftngp13.phx.gbl...
> Urghh, i don´t think that the way reporting services should be used. If
you
> really really really wanna do this, set up an linked server on sql server
to
> point to access and write a procedure in which you do your importing
stuff.
> Return from the procedure some kind of return code to display this in your
> report.
> But (BTW) is a really nasty way to use RS :(
> HTH (either), Jens Suessmeyer.
> --
> http://www.sqlserver2005.de
> --
>
> "Randy" <Randy@.discussions.microsoft.com> schrieb im Newsbeitrag
> news:5218EBE9-A92E-4528-B381-9E835A72A978@.microsoft.com...
> > Is their away to have reporting services call a dataset from an access
> > database and export it into a sql server table through automation in a
> > project with 2 datasources. One datasource from access and the other
from
> > sql server. I can do this with a DTS, but could I do it another way to
> > work
> > around a DTS.
> >
> > Randy
>

Exporting Data from Reporting Services into Multiple Excel Worksheets

Hi,

Please help me.

I need to export around 1 million records to excel. As we know that there is a limit of approx 65,000 rows in one worksheet so the exporting functionality is failing. One way is that I should be able to configure the Reporting Service in such a way so that once 65,000 records gets populated in the first worksheet, then the rest 35,000 records gets popultaed in the second worksheet.

I am not able to find out how this can be achieved in Reporting Services. Please help me in this.

Thanks in advance.

Regards

Raman

Hello Raman,

Take a look at this link, in the 'Page Breaks' section, it may help you.

http://msdn2.microsoft.com/en-us/library/ms157328.aspx

It requires that you set a group with a group expression on X number of rows, then you page break on the group.

Hope this helps.

Jarret

exporting an analysis server db from one server to another

how do i export an analysis services from one server to another? i recently upgraded from analysis services 2000, so i didnt create the analysis services database and cubes in server 2005. Remember how you could save your db in analysis server 2000 as a cab file. is there any way to do that in analysis server 2005, so that i could simply then copy teh file over to a new server and add it?

In BI-Dev studio there is a project/template where you can import and generate scripts for that SSAS2005 cube to a project/script. If you successfully import this you will have scripts that you can deploy to a second server.

The other way is the Deployment Wizard, under start/programs/sql server 2005/Analysis services. This wizard requires a SSAS2005 project.

HTH

Thomas Ivarsson

|||my problem is trying to get the cubes as a SSAS2005 project. they are deployed using 2005, but just cant get them as a project.|||

Have you started BI-Dev Studio and tried the template I have described?

Regards

Thomas Ivarsson

|||

If you simply trying to create a project based on the existing cubes, you can simly go into BI Dev studio and create new project using "Import Analysis Services 9.0 database" project type.

Edward Melomed.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

Exporting a report to Excel

I am trying to export a report for SQL Reporting Services Report to
Excel. Unfortunately the number of rows in my report are greater that
the maximum allowable 65536 rows in an Excel sheet. Does anyone have a
workaround that would allow for a SQL Reporting Services Report to be
exported to Excel spread out over multiple sheets to make up for the
65536 row limitation?If you have groups in your report, you can set the Group page break options
on the grouping ans sorting tab. When exporting to Excel, each group becomes
a separate
worksheet in the workbook file. I don't recall what the worksheet limit is.
The one problem is that you cannot title each page, so they come out as
sheet1, sheet2, ... sheet(n)
"jbaldwin00@.gmail.com" wrote:
> I am trying to export a report for SQL Reporting Services Report to
> Excel. Unfortunately the number of rows in my report are greater that
> the maximum allowable 65536 rows in an Excel sheet. Does anyone have a
> workaround that would allow for a SQL Reporting Services Report to be
> exported to Excel spread out over multiple sheets to make up for the
> 65536 row limitation?
>sql

Exporting a report to a text file

Is there anyway to export a report to a text file in SQL Reporting Services?
Thanks
Zack GallingerYou can export to the .csv format from the Report Viewer if you're running
MSSQL 2005 Standard or Enterprise. Express and Workgroup versions of MSSQL
2005 do not offer that feature.
Alain Quesnel
alainsansspam@.logiquel.com
www.logiquel.com
"Zack" <Zack@.discussions.microsoft.com> wrote in message
news:73DCD5BB-93DB-4BDD-A565-9B087183F958@.microsoft.com...
> Is there anyway to export a report to a text file in SQL Reporting
> Services?
> Thanks
> Zack Gallinger|||On Dec 5, 12:27 pm, "Alain Quesnel" <alainsanss...@.logiquel.com>
wrote:
> You can export to the .csv format from the Report Viewer if you're running
> MSSQL 2005 Standard or Enterprise. Express and Workgroup versions of MSSQL
> 2005 do not offer that feature.
> Alain Quesnel
> alainsanss...@.logiquel.com
> www.logiquel.com
> "Zack" <Z...@.discussions.microsoft.com> wrote in message
> news:73DCD5BB-93DB-4BDD-A565-9B087183F958@.microsoft.com...
> > Is there anyway to export a report to a text file in SQL Reporting
> > Services?
> > Thanks
> > Zack Gallinger
Actually, exporting to CSV is an option in the Express Edition as
well. Of course, you also have the option of using URL access to
export a report to a specific format as well. This link should be
helpful. http://msdn2.microsoft.com/en-us/library/ms153586.aspx. If
you need the report exported programmatically, you can access the
report and export it to CSV/etc via the ReportServices Web Service
(http://msdn2.microsoft.com/en-us/library/
microsoft.wssux.reportingserviceswebservice.rsexecutionservice2005.reportexecutionservice.render.aspx ).
Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||I based my answer on this:
http://www.microsoft.com/sql/technologies/reporting/rsfeatures.mspx
Did I misinterpret?
Alain Quesnel
alainsansspam@.logiquel.com
www.logiquel.com
>
> Actually, exporting to CSV is an option in the Express Edition as
> well. Of course, you also have the option of using URL access to
> export a report to a specific format as well. This link should be
> helpful. http://msdn2.microsoft.com/en-us/library/ms153586.aspx. If
> you need the report exported programmatically, you can access the
> report and export it to CSV/etc via the ReportServices Web Service
> (http://msdn2.microsoft.com/en-us/library/
> microsoft.wssux.reportingserviceswebservice.rsexecutionservice2005.reportexecutionservice.render.aspx
> ).
> Hope this helps.
> Regards,
> Enrique Martinez
> Sr. Software Consultant
>|||On Dec 5, 10:21 pm, "Alain Quesnel" <alainsanss...@.logiquel.com>
wrote:
> I based my answer on this:http://www.microsoft.com/sql/technologies/reporting/rsfeatures.mspx
> Did I misinterpret?
> Alain Quesnel
> alainsanss...@.logiquel.com
> www.logiquel.com
>
> > Actually, exporting to CSV is an option in the Express Edition as
> > well. Of course, you also have the option of using URL access to
> > export a report to a specific format as well. This link should be
> > helpful.http://msdn2.microsoft.com/en-us/library/ms153586.aspx. If
> > you need the report exported programmatically, you can access the
> > report and export it to CSV/etc via the ReportServices Web Service
> > (http://msdn2.microsoft.com/en-us/library/
> > microsoft.wssux.reportingserviceswebservice.rsexecutionservice2005.reportexecutionservice.render.aspx
> > ).
> > Hope this helps.
> > Regards,
> > Enrique Martinez
> > Sr. Software Consultant
This documentation seems to be out of date. Currently, all options
available for export in SSRS Std Edition are also available in SSRS
Express Edition w/Advanced Services.
Regards,
Enrique Martinez
Sr. Software Consultant

Exporting & Importing certain tables

We have a database which services a number of websites. We want to move
individual tables for each website from the exisiting server to the new SQL
2005 Cluster as we modify the websites to point to the new location.
Is this possible or do I need to restore the whole database?
Thanks,
Neil Paddock.SSSIS/DTS, BCP, Import/Export Wizard, BULKCOPY will all allow you to easily
move individual tables from one database/server to another. See BOL for
details.
TheSQLGuru
President
Indicium Resources, Inc.
"Neil Paddock" <NeilPaddock@.discussions.microsoft.com> wrote in message
news:AA18F359-6356-48EF-B458-32060A0552BE@.microsoft.com...
> We have a database which services a number of websites. We want to move
> individual tables for each website from the exisiting server to the new
> SQL
> 2005 Cluster as we modify the websites to point to the new location.
> Is this possible or do I need to restore the whole database?
> Thanks,
> Neil Paddock.
>|||Thanks for the info.
I have attempted to copy a table from one database to another using
Import/Export Wizard but I'm receiving an error message:
Validating (Error)
Messages
Error 0xc0202049: Data Flow Task: Failure inserting into the read-only
column "Employee_id".
(SQL Server Import and Export Wizard)
Error 0xc0202045: Data Flow Task: Column metadata validation failed.
(SQL Server Import and Export Wizard)
Error 0xc004706b: Data Flow Task: "component "Destination -
employee_details" (130)" failed validation and returned validation status
"VS_ISBROKEN".
(SQL Server Import and Export Wizard)
Error 0xc004700c: Data Flow Task: One or more component failed validation.
(SQL Server Import and Export Wizard)
Error 0xc0024107: Data Flow Task: There were errors during task validation.
(SQL Server Import and Export Wizard)
It seems to be a validation error to do with the destination being read
only? How do I change this?
Thanks,
Neil Paddock.
"TheSQLGuru" wrote:

> SSSIS/DTS, BCP, Import/Export Wizard, BULKCOPY will all allow you to easil
y
> move individual tables from one database/server to another. See BOL for
> details.
> --
> TheSQLGuru
> President
> Indicium Resources, Inc.
> "Neil Paddock" <NeilPaddock@.discussions.microsoft.com> wrote in message
> news:AA18F359-6356-48EF-B458-32060A0552BE@.microsoft.com...
>
>sql

Exporting & Importing certain tables

We have a database which services a number of websites. We want to move
individual tables for each website from the exisiting server to the new SQL
2005 Cluster as we modify the websites to point to the new location.
Is this possible or do I need to restore the whole database?
Thanks,
Neil Paddock.
SSSIS/DTS, BCP, Import/Export Wizard, BULKCOPY will all allow you to easily
move individual tables from one database/server to another. See BOL for
details.
TheSQLGuru
President
Indicium Resources, Inc.
"Neil Paddock" <NeilPaddock@.discussions.microsoft.com> wrote in message
news:AA18F359-6356-48EF-B458-32060A0552BE@.microsoft.com...
> We have a database which services a number of websites. We want to move
> individual tables for each website from the exisiting server to the new
> SQL
> 2005 Cluster as we modify the websites to point to the new location.
> Is this possible or do I need to restore the whole database?
> Thanks,
> Neil Paddock.
>
|||Thanks for the info.
I have attempted to copy a table from one database to another using
Import/Export Wizard but I'm receiving an error message:
Validating (Error)
Messages
Error 0xc0202049: Data Flow Task: Failure inserting into the read-only
column "Employee_id".
(SQL Server Import and Export Wizard)
Error 0xc0202045: Data Flow Task: Column metadata validation failed.
(SQL Server Import and Export Wizard)
Error 0xc004706b: Data Flow Task: "component "Destination -
employee_details" (130)" failed validation and returned validation status
"VS_ISBROKEN".
(SQL Server Import and Export Wizard)
Error 0xc004700c: Data Flow Task: One or more component failed validation.
(SQL Server Import and Export Wizard)
Error 0xc0024107: Data Flow Task: There were errors during task validation.
(SQL Server Import and Export Wizard)
It seems to be a validation error to do with the destination being read
only? How do I change this?
Thanks,
Neil Paddock.
"TheSQLGuru" wrote:

> SSSIS/DTS, BCP, Import/Export Wizard, BULKCOPY will all allow you to easily
> move individual tables from one database/server to another. See BOL for
> details.
> --
> TheSQLGuru
> President
> Indicium Resources, Inc.
> "Neil Paddock" <NeilPaddock@.discussions.microsoft.com> wrote in message
> news:AA18F359-6356-48EF-B458-32060A0552BE@.microsoft.com...
>
>

Exporting & Importing certain tables

We have a database which services a number of websites. We want to move
individual tables for each website from the exisiting server to the new SQL
2005 Cluster as we modify the websites to point to the new location.
Is this possible or do I need to restore the whole database?
Thanks,
Neil Paddock.SSSIS/DTS, BCP, Import/Export Wizard, BULKCOPY will all allow you to easily
move individual tables from one database/server to another. See BOL for
details.
--
TheSQLGuru
President
Indicium Resources, Inc.
"Neil Paddock" <NeilPaddock@.discussions.microsoft.com> wrote in message
news:AA18F359-6356-48EF-B458-32060A0552BE@.microsoft.com...
> We have a database which services a number of websites. We want to move
> individual tables for each website from the exisiting server to the new
> SQL
> 2005 Cluster as we modify the websites to point to the new location.
> Is this possible or do I need to restore the whole database?
> Thanks,
> Neil Paddock.
>|||Thanks for the info.
I have attempted to copy a table from one database to another using
Import/Export Wizard but I'm receiving an error message:
Validating (Error)
Messages
Error 0xc0202049: Data Flow Task: Failure inserting into the read-only
column "Employee_id".
(SQL Server Import and Export Wizard)
Error 0xc0202045: Data Flow Task: Column metadata validation failed.
(SQL Server Import and Export Wizard)
Error 0xc004706b: Data Flow Task: "component "Destination -
employee_details" (130)" failed validation and returned validation status
"VS_ISBROKEN".
(SQL Server Import and Export Wizard)
Error 0xc004700c: Data Flow Task: One or more component failed validation.
(SQL Server Import and Export Wizard)
Error 0xc0024107: Data Flow Task: There were errors during task validation.
(SQL Server Import and Export Wizard)
It seems to be a validation error to do with the destination being read
only? How do I change this?
Thanks,
Neil Paddock.
"TheSQLGuru" wrote:
> SSSIS/DTS, BCP, Import/Export Wizard, BULKCOPY will all allow you to easily
> move individual tables from one database/server to another. See BOL for
> details.
> --
> TheSQLGuru
> President
> Indicium Resources, Inc.
> "Neil Paddock" <NeilPaddock@.discussions.microsoft.com> wrote in message
> news:AA18F359-6356-48EF-B458-32060A0552BE@.microsoft.com...
> > We have a database which services a number of websites. We want to move
> > individual tables for each website from the exisiting server to the new
> > SQL
> > 2005 Cluster as we modify the websites to point to the new location.
> >
> > Is this possible or do I need to restore the whole database?
> >
> > Thanks,
> > Neil Paddock.
> >
> >
>
>

Exported PDF Security

Hi All
I am using SQL Reporting Services. I looked into the properties of the
generated .pdf file and it allows user to edit the file contents using a
full version Adobe Acrobat.
Is it possible to make the exported PDF file uneditable ? Any help on this
will be hisghly appreciated
Thanks
Vaibhav SharmaIf anyone says yes, well theyre wrong.
The issue here is not Reporting Services but rather the PDF Spec,
Using tools I will NOT mention here , I can edit any PDF , from any
source "AT-WILL"
The funny part is the tools I use are the same tools "I" use for allpdf
work and I have had developers/designers choke on their words many a
times over this exact issue.
I go by the xiom of , "If a client can read it, so can I" (client being
client tool, webbrowser, pdfviewer etc) but you can always take that a
step further and say "If I can read it I can change it"
NOW All that said is there a way to "Lock" a PDF Against edit for the
other 99% of people, yes, but I am unsure if RS has it implemented, I
have not seen it anywhere in the docs.|||RS does not support any type of locking of the PDF. You could write your own
extension to do this.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"WertmanTheMad" <cwertman@.webchamps.com> wrote in message
news:1104179054.142883.151010@.f14g2000cwb.googlegroups.com...
> If anyone says yes, well theyre wrong.
> The issue here is not Reporting Services but rather the PDF Spec,
> Using tools I will NOT mention here , I can edit any PDF , from any
> source "AT-WILL"
> The funny part is the tools I use are the same tools "I" use for allpdf
> work and I have had developers/designers choke on their words many a
> times over this exact issue.
> I go by the xiom of , "If a client can read it, so can I" (client being
> client tool, webbrowser, pdfviewer etc) but you can always take that a
> step further and say "If I can read it I can change it"
> NOW All that said is there a way to "Lock" a PDF Against edit for the
> other 99% of people, yes, but I am unsure if RS has it implemented, I
> have not seen it anywhere in the docs.
>|||Any pointers on how to do that? I mean how to go about writing an extension.
TIA
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:OZBq3bF7EHA.1260@.TK2MSFTNGP12.phx.gbl...
> RS does not support any type of locking of the PDF. You could write your
> own
> extension to do this.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "WertmanTheMad" <cwertman@.webchamps.com> wrote in message
> news:1104179054.142883.151010@.f14g2000cwb.googlegroups.com...
>> If anyone says yes, well theyre wrong.
>> The issue here is not Reporting Services but rather the PDF Spec,
>> Using tools I will NOT mention here , I can edit any PDF , from any
>> source "AT-WILL"
>> The funny part is the tools I use are the same tools "I" use for allpdf
>> work and I have had developers/designers choke on their words many a
>> times over this exact issue.
>> I go by the xiom of , "If a client can read it, so can I" (client being
>> client tool, webbrowser, pdfviewer etc) but you can always take that a
>> step further and say "If I can read it I can change it"
>> NOW All that said is there a way to "Lock" a PDF Against edit for the
>> other 99% of people, yes, but I am unsure if RS has it implemented, I
>> have not seen it anywhere in the docs.
>|||I know it is possible because 3rd parties have come up with additional
rendering extensions but looking at it another way (and definitely easier)
you could have a delivery extension (if you are sending this via
subscriptions). Your delivery extension could save the report as a pdf file,
then run it through whatever utility that locks the pdf and then you send it
on via the email. Look in the help on delivery extension.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Vaibhav" <consultvaibhav@.yahoo.com> wrote in message
news:eC7tX7F7EHA.2196@.TK2MSFTNGP14.phx.gbl...
> Any pointers on how to do that? I mean how to go about writing an
extension.
> TIA
>
> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> news:OZBq3bF7EHA.1260@.TK2MSFTNGP12.phx.gbl...
> > RS does not support any type of locking of the PDF. You could write your
> > own
> > extension to do this.
> >
> > --
> > Bruce Loehle-Conger
> > MVP SQL Server Reporting Services
> >
> > "WertmanTheMad" <cwertman@.webchamps.com> wrote in message
> > news:1104179054.142883.151010@.f14g2000cwb.googlegroups.com...
> >> If anyone says yes, well theyre wrong.
> >>
> >> The issue here is not Reporting Services but rather the PDF Spec,
> >>
> >> Using tools I will NOT mention here , I can edit any PDF , from any
> >> source "AT-WILL"
> >>
> >> The funny part is the tools I use are the same tools "I" use for allpdf
> >> work and I have had developers/designers choke on their words many a
> >> times over this exact issue.
> >>
> >> I go by the xiom of , "If a client can read it, so can I" (client being
> >> client tool, webbrowser, pdfviewer etc) but you can always take that a
> >> step further and say "If I can read it I can change it"
> >>
> >> NOW All that said is there a way to "Lock" a PDF Against edit for the
> >> other 99% of people, yes, but I am unsure if RS has it implemented, I
> >> have not seen it anywhere in the docs.
> >>
> >
> >
>|||Thanks very much.
But in my case i am not sending file by susbscription, i am displaying
report as link and generating it on demand like an invoice pdf file.
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:ebWjTnG7EHA.2608@.TK2MSFTNGP10.phx.gbl...
>I know it is possible because 3rd parties have come up with additional
> rendering extensions but looking at it another way (and definitely easier)
> you could have a delivery extension (if you are sending this via
> subscriptions). Your delivery extension could save the report as a pdf
> file,
> then run it through whatever utility that locks the pdf and then you send
> it
> on via the email. Look in the help on delivery extension.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Vaibhav" <consultvaibhav@.yahoo.com> wrote in message
> news:eC7tX7F7EHA.2196@.TK2MSFTNGP14.phx.gbl...
>> Any pointers on how to do that? I mean how to go about writing an
> extension.
>> TIA
>>
>> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
>> news:OZBq3bF7EHA.1260@.TK2MSFTNGP12.phx.gbl...
>> > RS does not support any type of locking of the PDF. You could write
>> > your
>> > own
>> > extension to do this.
>> >
>> > --
>> > Bruce Loehle-Conger
>> > MVP SQL Server Reporting Services
>> >
>> > "WertmanTheMad" <cwertman@.webchamps.com> wrote in message
>> > news:1104179054.142883.151010@.f14g2000cwb.googlegroups.com...
>> >> If anyone says yes, well theyre wrong.
>> >>
>> >> The issue here is not Reporting Services but rather the PDF Spec,
>> >>
>> >> Using tools I will NOT mention here , I can edit any PDF , from any
>> >> source "AT-WILL"
>> >>
>> >> The funny part is the tools I use are the same tools "I" use for
>> >> allpdf
>> >> work and I have had developers/designers choke on their words many a
>> >> times over this exact issue.
>> >>
>> >> I go by the xiom of , "If a client can read it, so can I" (client
>> >> being
>> >> client tool, webbrowser, pdfviewer etc) but you can always take that a
>> >> step further and say "If I can read it I can change it"
>> >>
>> >> NOW All that said is there a way to "Lock" a PDF Against edit for the
>> >> other 99% of people, yes, but I am unsure if RS has it implemented, I
>> >> have not seen it anywhere in the docs.
>> >>
>> >
>> >
>>
>|||If you have your own UI (i.e. not using Report Manager but using your own
ASP.net application) then you could use the same technique by using web
services to first render PDF on your server, run the untility and then send
the resultant protected PDF to the user. If you want to use Report Manager
portal then there is not an easy solution that I can think of.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Vaibhav" <consultvaibhav@.yahoo.com> wrote in message
news:Of5HKMP7EHA.3908@.TK2MSFTNGP12.phx.gbl...
> Thanks very much.
> But in my case i am not sending file by susbscription, i am displaying
> report as link and generating it on demand like an invoice pdf file.
>
> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> news:ebWjTnG7EHA.2608@.TK2MSFTNGP10.phx.gbl...
> >I know it is possible because 3rd parties have come up with additional
> > rendering extensions but looking at it another way (and definitely
easier)
> > you could have a delivery extension (if you are sending this via
> > subscriptions). Your delivery extension could save the report as a pdf
> > file,
> > then run it through whatever utility that locks the pdf and then you
send
> > it
> > on via the email. Look in the help on delivery extension.
> >
> > --
> > Bruce Loehle-Conger
> > MVP SQL Server Reporting Services
> >
> > "Vaibhav" <consultvaibhav@.yahoo.com> wrote in message
> > news:eC7tX7F7EHA.2196@.TK2MSFTNGP14.phx.gbl...
> >> Any pointers on how to do that? I mean how to go about writing an
> > extension.
> >>
> >> TIA
> >>
> >>
> >> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> >> news:OZBq3bF7EHA.1260@.TK2MSFTNGP12.phx.gbl...
> >> > RS does not support any type of locking of the PDF. You could write
> >> > your
> >> > own
> >> > extension to do this.
> >> >
> >> > --
> >> > Bruce Loehle-Conger
> >> > MVP SQL Server Reporting Services
> >> >
> >> > "WertmanTheMad" <cwertman@.webchamps.com> wrote in message
> >> > news:1104179054.142883.151010@.f14g2000cwb.googlegroups.com...
> >> >> If anyone says yes, well theyre wrong.
> >> >>
> >> >> The issue here is not Reporting Services but rather the PDF Spec,
> >> >>
> >> >> Using tools I will NOT mention here , I can edit any PDF , from any
> >> >> source "AT-WILL"
> >> >>
> >> >> The funny part is the tools I use are the same tools "I" use for
> >> >> allpdf
> >> >> work and I have had developers/designers choke on their words many a
> >> >> times over this exact issue.
> >> >>
> >> >> I go by the xiom of , "If a client can read it, so can I" (client
> >> >> being
> >> >> client tool, webbrowser, pdfviewer etc) but you can always take that
a
> >> >> step further and say "If I can read it I can change it"
> >> >>
> >> >> NOW All that said is there a way to "Lock" a PDF Against edit for
the
> >> >> other 99% of people, yes, but I am unsure if RS has it implemented,
I
> >> >> have not seen it anywhere in the docs.
> >> >>
> >> >
> >> >
> >>
> >>
> >
> >
>

Export to Word or RTF in SQL Reporting services

does any know if SQL server reporting services will be offering a RTF format
export or Word export' I need this function - it force me to use crystal
reports (ARRGH!!)
Or does anyone know of a provider that made one?I know SoftArtisans (www.softartisans.com) is working on something in this
area. The feature did not make it on the list for SQL 2005.
--
Brian Welcker
Group Program Manager
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Chicago Dave" <Chicago Dave@.discussions.microsoft.com> wrote in message
news:767BAA7C-EE40-4858-BF0E-2CA3F22C032C@.microsoft.com...
> does any know if SQL server reporting services will be offering a RTF
> format
> export or Word export' I need this function - it force me to use crystal
> reports (ARRGH!!)
> Or does anyone know of a provider that made one?
>

Export to Tab Delimited TXT - SQL Reporting Services

I am new to Reporting tools. How can I export the output to Tab Delimited TXT. I found some solutions, however, I could not understand how to proceed with them... anybody can explain the solution step by step...

Hi Pradeep,

Try some of these links

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=924133&SiteID=1

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=74882

|||

Thanks Sudhir for the reply, however, I need to export the SQL Reporting Services REPORT output to TAB Delimited TXT file.

|||

Hi,

From your description, it seems that you want to change the CSV extension to a Tab delimited output in your reporting service, right?

If so, you should add a new extension line to the RSReportServer.config file to enable the Tab delimited output.

In the config file, you should change the following settings:

1. For tab-delimited report, use
<FieldDelimiter> </FieldDelimiter>

2. For name override, you must specify language attribute:
<Name Language="en-US">TXT (Tab Delimited Text File)</Name>

For more information, see:http://msdn2.microsoft.com/en-us/library/ms156281.aspx

Thanks.

export to rtf

where is the export to rtf as promised on the microsoft reporting services
2005 site?Yes, where is it ? We need it for one our clients. This should be pretty
basic stuff.
"GeoffF" wrote:
> where is the export to rtf as promised on the microsoft reporting services
> 2005 site?

Export to PowerPoint

Is there a way to export a MS Rep Services report to PowerPoint?
Thank you.No out of the box solutions, but you can write your own extensions
Amarnath
"TheTechie" wrote:
> Is there a way to export a MS Rep Services report to PowerPoint?
> Thank you.|||What about exporting to excel and having that excel a linked object
within powerpoint?
On Feb 11, 10:02 am, Amarnath <Amarn...@.discussions.microsoft.com>
wrote:
> No out of the box solutions, but you can write your own extensions
> Amarnath
>
> "TheTechie" wrote:
> > Is there a way to export a MS Rep Services report to PowerPoint?
> > Thank you.- Hide quoted text -
> - Show quoted text -|||Yes you can export it to EXCEL.
You can attach a image, but not powerpoint file.
You can do one thing, you can give a link to Powerpoint file, through a URL.
Amarnath
"steve" wrote:
> What about exporting to excel and having that excel a linked object
> within powerpoint?
>
> On Feb 11, 10:02 am, Amarnath <Amarn...@.discussions.microsoft.com>
> wrote:
> > No out of the box solutions, but you can write your own extensions
> >
> > Amarnath
> >
> >
> >
> > "TheTechie" wrote:
> > > Is there a way to export a MS Rep Services report to PowerPoint?
> >
> > > Thank you.- Hide quoted text -
> >
> > - Show quoted text -
>
>|||Thanks . This is amazing. If MS is serious about using RS for business
reporting, they should introduce PPT export. Are there any plans? My I was
searching the web and could not find any reference to some commercially
available 3rd party extensions to do the PPT export. I would appreciate a
reference to such product. Developing own extensions seems like a big
effort.
"Amarnath" wrote
> No out of the box solutions, but you can write your own extensions
> Amarnath
> "TheTechie" wrote:
> > Is there a way to export a MS Rep Services report to PowerPoint?
> >
> > Thank you.|||I feel, instead of creating a ppt automatically, ofcourse its a challenge,
instead you can have a link for the same. because the report format is
different and when you take it to ppt, all the formatting will have to adjust
accordingly, which is I think a quite a task, but not impossible. As far as
in the next version, nothing as been announced as of now.
Amarnath
"TheTechie" wrote:
> Thanks . This is amazing. If MS is serious about using RS for business
> reporting, they should introduce PPT export. Are there any plans? My I was
> searching the web and could not find any reference to some commercially
> available 3rd party extensions to do the PPT export. I would appreciate a
> reference to such product. Developing own extensions seems like a big
> effort.
>
> "Amarnath" wrote
> > No out of the box solutions, but you can write your own extensions
> >
> > Amarnath
> >
> > "TheTechie" wrote:
> >
> > > Is there a way to export a MS Rep Services report to PowerPoint?
> > >
> > > Thank you.

Export to pdf fail

Hello,

I'm using SQL Reporting services 2000 SP2.
I create a report and when i select pdf format in the export dropdownlist and i click on export, a popup (open/save) appears but when i click ok, i've an error message : "IE can't download Format=PDF of IP_ADRESSE".

If i do the same thing with excel type in the dropdownlist it works!

Do you know why?Have you tried looking in the log files or Event viewer on the server?|||Yes I have an exception in the reporting services log but nothing in the event viewer.
The exception :
[code]
w3wp!library!d10!08/25/2006-14:18:52:: i INFO: Call to RenderNext( '/EPMDB_Report/EPM_Full_Dashboard' )
w3wp!chunks!d10!08/25/2006-14:18:52:: i INFO: ### GetReportChunk('RenderingInfo_PDF', 2), chunk was not found! this=3ffd3365-b936-477e-9108-c7ad88799346
w3wp!reportrendering!d10!08/25/2006-14:18:52:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.WrapperReportRenderingException: Exception of type Microsoft.ReportingServices.ReportRendering.ReportRenderingException was thrown., ;
Info: Microsoft.ReportingServices.ReportProcessing.WrapperReportRenderingException: Exception of type Microsoft.ReportingServices.ReportRendering.ReportRenderingException was thrown. > Microsoft.ReportingServices.ReportRendering.ReportRenderingException: Exception of type Microsoft.ReportingServices.ReportRendering.ReportRenderingException was thrown. > System.ArgumentOutOfRangeException: Index and length must refer to a location within the string.
Parameter name: length
at System.String.Substring(Int32 startIndex, Int32 length)
at Microsoft.ReportingServices.Rendering.ImageRenderer.CanvasPDF.ProcessString(TextBox context, String text, CanvasFontPDF font, CanvasPenPDF pen, Double left, Double top, Double paddingTop, Double width, Double height, Boolean wordTrim, String fontLanguage, Int32& charactersFitted, Int32& linesFilled, String& streamString)
at Microsoft.ReportingServices.Rendering.ImageRenderer.CanvasPDF.DrawString(TextBox context, OutlineObjects outlines, Boolean wordTrim, String text, CanvasFont font, CanvasPen pen, Double left, Double top, Double paddingTop, Double width, Double height, String fontLanguage, ReportUrl hyperLinkURL)
at Microsoft.ReportingServices.Rendering.ImageRenderer.TextBox.RenderToPage(Measurement parentClipBorder)
at Microsoft.ReportingServices.Rendering.ImageRenderer.RenderingItemContainer.RenderToPage(Measurement parentClipBorder)
at Microsoft.ReportingServices.Rendering.ImageRenderer.Rectangle.RenderToPage(Measurement parentClipBorder)
at Microsoft.ReportingServices.Rendering.ImageRenderer.RenderingItemContainer.RenderToPage(Measurement parentClipBorder)
at Microsoft.ReportingServices.Rendering.ImageRenderer.ImageRendererBase.ProcessPages(CompositionBase theComposition, Report theReport, Boolean needTotalPages, Int32 startPage, Int32 endPage, Boolean render)
at Microsoft.ReportingServices.Rendering.ImageRenderer.PdfReport.RenderReport(Report report, NameValueCollection deviceInfo, EvaluateHeaderFooterExpressions evaluateHeaderFooterExpressions, CreateAndRegisterStream createAndRegisterStreamCallback)
at Microsoft.ReportingServices.Rendering.ImageRenderer.ImageRendererBase.Render(Report report, NameValueCollection reportServerParameters, NameValueCollection deviceInfo, NameValueCollection clientCapabilities, EvaluateHeaderFooterExpressions evaluateHeaderFooterExpressions, CreateAndRegisterStream createAndRegisterStream)
End of inner exception stack trace
at Microsoft.ReportingServices.Rendering.ImageRenderer.ImageRendererBase.Render(Report report, NameValueCollection reportServerParameters, NameValueCollection deviceInfo, NameValueCollection clientCapabilities, EvaluateHeaderFooterExpressions evaluateHeaderFooterExpressions, CreateAndRegisterStream createAndRegisterStream)
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderSnapshot(CreateReportChunk createChunkCallback, RenderingContext rc, GetResource getResourceCallback)
End of inner exception stack trace
w3wp!webserver!d10!08/25/2006-14:18:52:: e ERROR: Reporting Services error Microsoft.ReportingServices.ReportProcessing.WrapperReportRenderingException: Exception of type Microsoft.ReportingServices.ReportRendering.ReportRenderingException was thrown. > Microsoft.ReportingServices.ReportRendering.ReportRenderingException: Exception of type Microsoft.ReportingServices.ReportRendering.ReportRenderingException was thrown. > System.ArgumentOutOfRangeException: Index and length must refer to a location within the string.
Parameter name: length
[/code]

It seems to be a problem with the length parameter but i don't known what to do.

Any idea?|||Ok I find th problem.
In my rdl file I have the language define as 'en' and for exporting in pdf the format has to been syntaxed like this: xx-XX.
I put my rdl in en-US and it works.

Thanks @.+|||I found I had put some HTTP headers in at the website level on IIS to disable caching on some non-related ASP applications running in the same IIS instance.

I removed the HTTP headers:

Cache-Control: no-cache

Pragma: no-cache