Exporting reports to PDF

Does anybody know how to export reports to PDF so that it fit to page?

Thanks,

Addin

hii

do you want the visual studio report what ever you developed to in sql server 2005 to be exported into pdf format ?

then just see the preview of your report. then in that same page one botton is there just before to the fontsize called the export bottom. just see the drop down list to what you wanted to export your report ,you can choose there. you can see there that you can export your report to tiff format,web archive format,pdf format and excel format also.

hope you have asked this

then it will work fine for you

thanks and regards

mahasweta

|||

hii

you can do it on the same page of the rivew of the ssrs in visual studio.there is one botton, just before the font size ,caled export .just check there .you can export to any format you want.those are tiff format,webarchiev format,pdf and excel format

thanks and regards

mahasweta

|||Hi,
I am not clear about your question?
1)whether you want the data which is running in to the second page has to be fit in to a single page.
2)Do you have blank in second page without any data and you want to reduce no of pages to 1.
If you make this point clear.,then i can help you.|||Hi,

Let's say, i have this Transfer Notice report which has 10 columns.

When i export this report to PDF, i cant see all the 10 columns on page 1. It was split into 2 page.

Page 1 contains 1st - 7th columns, and..
Page 2 contains 8th - 10th columns.

I wanted to see the whole table in one page only. Is there any option so that i could "fit to page" the report?

Thanks for the answers!
|||

i think i have the exact same problem i think.

lets say i make a reporting thats A3 size, when i export to PDF the stupid thing renders it as A4 and mashes it over to another page.

|||Hi,
I got your problem .First check which layout you are using.whether its Landscape or Portrait.
Then your Components (such as List,matrix or Table) + margins(Left,Top,Right,Bottom) should be equal to or less than Page width and height.If the components extends the desired Page width and height then the data will be shifted to next page.
In your case ,Please check your page width.
Hope it was useful to you.

Cheers,
Shri|||Hi,

on the preview, I could set the layout to landscape. But when I export it to PDF, the result's still the same.

I've already check the margins, it's all okay.

Is there anyway to set the layout to landscape as default?

Thanks!
|||

I HAVE THE ANSWER!!!

example, my report needs to be A2 size.

go report>report properties>layout

set your page width and margins to the size you need (mine is 42cm,59.4cm)

this is the only thing that forces pdf rendering to go beyond the standard A4 size.

|||Great!

Thanks!

Exporting reports to Excel

Hi everybody:
I created a report and I exported it to Excel.
My report has a chart that is set to "no visible", exporting it to PDF I
have no problems, but exporting it to MSExcel, I can see the chart!!!!
Is this a bug? Is there any workaround to allow me to export to both PDF and
Excel?
Best regards
ErnestoDo you have conditional visibility on the chart?
--
Brian Welcker
Group Program Manager
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Ernesto Bascón" <ebascon@.hotmail.com> wrote in message
news:eDi8KwtkEHA.3720@.TK2MSFTNGP12.phx.gbl...
> Hi everybody:
> I created a report and I exported it to Excel.
> My report has a chart that is set to "no visible", exporting it to PDF I
> have no problems, but exporting it to MSExcel, I can see the chart!!!!
> Is this a bug? Is there any workaround to allow me to export to both PDF
> and
> Excel?
> Best regards
>
> Ernesto
>|||Yes, I have some like
Hidden
=IIF(fields!Name="Name", true, false)
"Brian Welcker [MSFT]" <bwelcker@.online.microsoft.com> wrote in message
news:ufXtiD7kEHA.3536@.TK2MSFTNGP12.phx.gbl...
> Do you have conditional visibility on the chart?
> --
> Brian Welcker
> Group Program Manager
> SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> "Ernesto Bascón" <ebascon@.hotmail.com> wrote in message
> news:eDi8KwtkEHA.3720@.TK2MSFTNGP12.phx.gbl...
> > Hi everybody:
> >
> > I created a report and I exported it to Excel.
> >
> > My report has a chart that is set to "no visible", exporting it to PDF I
> > have no problems, but exporting it to MSExcel, I can see the chart!!!!
> >
> > Is this a bug? Is there any workaround to allow me to export to both PDF
> > and
> > Excel?
> >
> > Best regards
> >
> >
> > Ernesto
> >
> >
>|||Are you running SP1? I think there was a fix around conditional visibility
in Excel.
--
Brian Welcker
Group Program Manager
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Ernesto Bascón" <ebascon@.hotmail.com> wrote in message
news:e9F0JOClEHA.536@.TK2MSFTNGP11.phx.gbl...
> Yes, I have some like
> Hidden
> =IIF(fields!Name="Name", true, false)
>
> "Brian Welcker [MSFT]" <bwelcker@.online.microsoft.com> wrote in message
> news:ufXtiD7kEHA.3536@.TK2MSFTNGP12.phx.gbl...
>> Do you have conditional visibility on the chart?
>> --
>> Brian Welcker
>> Group Program Manager
>> SQL Server Reporting Services
>> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>> "Ernesto Bascón" <ebascon@.hotmail.com> wrote in message
>> news:eDi8KwtkEHA.3720@.TK2MSFTNGP12.phx.gbl...
>> > Hi everybody:
>> >
>> > I created a report and I exported it to Excel.
>> >
>> > My report has a chart that is set to "no visible", exporting it to PDF
>> > I
>> > have no problems, but exporting it to MSExcel, I can see the chart!!!!
>> >
>> > Is this a bug? Is there any workaround to allow me to export to both
>> > PDF
>> > and
>> > Excel?
>> >
>> > Best regards
>> >
>> >
>> > Ernesto
>> >
>> >
>>
>

Exporting Reporting Data to MS Access

Is it possible Reporting data to MS Access.
As such it is possible to export data from Report Manager to MS Excel,
PDF, HTML etc. Now I have a situation in my project to export data from
Report Manager to MS Access. Is this possible programmatically or in
any manner?The best would be to export it as CSV. Access can handle that. But, no,
there is no direct support for Access.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
<kishore.lakkimsetty@.wipro.com> wrote in message
news:1139381808.546186.62460@.f14g2000cwb.googlegroups.com...
> Is it possible Reporting data to MS Access.
> As such it is possible to export data from Report Manager to MS Excel,
> PDF, HTML etc. Now I have a situation in my project to export data from
> Report Manager to MS Access. Is this possible programmatically or in
> any manner?
>

Exporting report to multiple PDF's

Is it possile for a report to be exported to multiple PDF files, each pdf file would be for a group in the report and would ideally use field information for the group to construct the pdf filename?

The purpose of this is to provide a separate PDF for access over the web, so for example we have a scheduled report that generates a report grouped by sales region we would end up with SalesRegionA.PDF, SalesRegionB.PDF etc.

Hi Hugh,

What you can do is have a parameter in your report which will have the groups...ie you can have a parameter for Sales Region, then what you can do is run batch script, which has a command that calls a .rss file passing in some values -which will export your values to pdf...

you can create a batch script that calls the .rss file like below...

rs -i RunReports.rss -s http:..localhost/reportserver -1 0 -v directory="%1 -v reportname= "Name of report" -v filename="Name of file.pdf" -v format="pdf" -v params="this is were the parameter value goes" -v debug.

rs -i RunReports.rss -s http:..localhost/reportserver -1 0 -v directory="%1 -v reportname= "Name of report 2" -v filename="Name of file.pdf 2" -v format="pdf" -v params="this is were the parameter 2 value goes" -v debug.

(note you can have mutiple statements, allowing you to pass different values in the reportname, params section...

Your .rss file will use these values to render through the reports and export the files, i beleive there are examples on the Web of this.

Or what you can do is use a data driven subscription which is much easier (you will have to create the parameter in your report still). You have to create a table in your SQL Server DB, to hold the parameters ie all the Sales Region and use the Subscription to look at this tables..to do this go to subscriptions in report manager (when viewing the report), then go to data driven subscriptions, then follow the steps which are pretty simple...

Hope this helps.

|||Thans for your suggestions, I'd sort of moved in the direction of a a data driven subscription anyway but I think there's still quite a bit more to do, especially working out how to trigger the subscription from an application - I've started looking at the fireevent api.

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 Problems

i ve used SOAP API in my web application and thus generated the report in
html giving user an opton to export the report to excel or PDF when user
exports the report to excel it works perfectly but when it is exported to PDF
as usual open/save dialogue box appear what so ever is the response acrobate
reader loads but instead of opening the exported report it gives an error
which stats that
file is corrupt cant b corrected and thus cant b open
can anyone tell whats the problem in all that case
i use reponse.addheader and response.write methods to enable user to export
to pdf kindly help it outMuhammad Hammad wrote:
> i ve used SOAP API in my web application and thus generated the
Which PDF-Reader do you use?
You need Adobe-Reader >= Version 6.0!
best regards
Frank
--
www.xax.de|||well frank i m already using acrobate reader 6.0 professional
"Frank Matthiesen" wrote:
> Muhammad Hammad wrote:
> > i ve used SOAP API in my web application and thus generated the
> Which PDF-Reader do you use?
> You need Adobe-Reader >= Version 6.0!
> best regards
> Frank
> --
> www.xax.de
>
>
>|||Going to version 7 is free, and seems to be worth it. Also, do you have
RS SP1 installed? It has some rendering fixes.|||well i m installed with RS sp 1. as far as acrobate reader 7 is concerned i
ll chceck that out and let it b known
"Parker" wrote:
> Going to version 7 is free, and seems to be worth it. Also, do you have
> RS SP1 installed? It has some rendering fixes.
>

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 PDF - Adding empty page

Hi,

I created a report using dynamic display( I hide the column using the expression in Property->Visibility).By using expression the column which is having null is hided.When I try to export the report to PDF,the empty pages are displaying along with data.Ie.,The report contyains only 5 pages but in PDF it is displaying 10 pages(5pages data with 5 empty pages).

Any Suggestions appreciated!

Thanks

Please verify that the definition width of your table (regardless of any hidden columns) is less than the width of the body.

Also, be sure that:

Body.Width < Report.PageWidth - Report.LeftMargin - Report.RightMargin

-Chris

|||

Chris Baldwin - MSFT wrote:

Please verify that the definition width of your table (regardless of any hidden columns) is less than the width of the body.

Also, be sure that:

Body.Width < Report.PageWidth - Report.LeftMargin - Report.RightMargin

-Chris

I am trying to accomplish the same thing and my problem is the Body width as mentioned by Chris.. it is too wide since my available set of columns is fairly large. Are there any known tricks to work around this limitation, using matrices, or whatever technique?

- Ron

Exporting PDF - Adding empty page

Hi,

I created a report using dynamic display( I hide the column using the expression in Property->Visibility).By using expression the column which is having null is hided.When I try to export the report to PDF,the empty pages are displaying along with data.Ie.,The report contyains only 5 pages but in PDF it is displaying 10 pages(5pages data with 5 empty pages).

Any Suggestions appreciated!

Thanks

Please verify that the definition width of your table (regardless of any hidden columns) is less than the width of the body.

Also, be sure that:

Body.Width < Report.PageWidth - Report.LeftMargin - Report.RightMargin

-Chris

|||

Chris Baldwin - MSFT wrote:

Please verify that the definition width of your table (regardless of any hidden columns) is less than the width of the body.

Also, be sure that:

Body.Width < Report.PageWidth - Report.LeftMargin - Report.RightMargin

-Chris

I am trying to accomplish the same thing and my problem is the Body width as mentioned by Chris.. it is too wide since my available set of columns is fairly large. Are there any known tricks to work around this limitation, using matrices, or whatever technique?

- Ron

Exporting of Large Reports (Report Manager)

How can I increase the performance when attempting to export large reports to
an MS Excel or PDF file?
The report currently has an average of 29,995 records and is approximately
19,398,584 bytes in size. (650+ pages)
However, when rendering the report, the report takes only 30+ seconds.
http://reportserv/Reports/Pages/Report.aspx?ItemPath=%
2fMember_Verification%2fReports%2fIPC_Members_Verification
Thank you in advance for your support.If it takes 30 seconds to html then it will take as much as 10 times longer
to Excel or PDF. For Excel there is a work around.
Depending on how you design your reports you can do the following to export
to Excel. Or, what I do sometimes is make a copy of the report and clean it
up for data export and then hide it in list view. If you export from Report
Manager (RS 2000) it puts CSV data in unicode which Excel puts all in one
column. If you export in ASCII then Excel does just as you want. To prevent
a problem with cells (Excel will object to sorting the data) you need to
remove any textboxes you have (for instance with a title, showing the
parameters run etc) and instead add additional header rows, merge the cells
and put your text in there instead. I add a link at the top of the report
that says Export Data. With RS 2005 you can be able to configure it to use
ASCII instead of Unicode when exporting to CSV.
So, in RS 2000 I add a link at the top of the page and then use Jump to URL.
Here is an example of a Jump to URL link I use. This causes Excel to come up
with the data in a separate window:
="javascript:void(window.open('" & Globals!ReportServerUrl &
"?/SomeFolder/SomeReport&ParamName=" & Parameters!ParamName.Value &
"&rs:Format=CSV&rc:Encoding=ASCII','_blank'))"
If you don't want to have it appear in a new window then do this in jump to
URL:
=Globals!ReportServerUrl & "?/SomeFolder/SomeReport&ParamName=" &
Parameters!ParamName.Value & "&rs:Format=CSV&rc:Encoding=ASCII"
Very nice and very fast. CSV ASCII will be just as fast as HTML.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Terry" <Terry@.discussions.microsoft.com> wrote in message
news:5429586F-A50A-43F9-B913-E7E7B98A7F15@.microsoft.com...
> How can I increase the performance when attempting to export large reports
> to
> an MS Excel or PDF file?
> The report currently has an average of 29,995 records and is approximately
> 19,398,584 bytes in size. (650+ pages)
> However, when rendering the report, the report takes only 30+ seconds.
> http://reportserv/Reports/Pages/Report.aspx?ItemPath=%
> 2fMember_Verification%2fReports%2fIPC_Members_Verification
> Thank you in advance for your support.|||The solution worked! Thank you very much.
However, is there a way of scheduling the report using the same solution?
"Bruce L-C [MVP]" wrote:
> If it takes 30 seconds to html then it will take as much as 10 times longer
> to Excel or PDF. For Excel there is a work around.
> Depending on how you design your reports you can do the following to export
> to Excel. Or, what I do sometimes is make a copy of the report and clean it
> up for data export and then hide it in list view. If you export from Report
> Manager (RS 2000) it puts CSV data in unicode which Excel puts all in one
> column. If you export in ASCII then Excel does just as you want. To prevent
> a problem with cells (Excel will object to sorting the data) you need to
> remove any textboxes you have (for instance with a title, showing the
> parameters run etc) and instead add additional header rows, merge the cells
> and put your text in there instead. I add a link at the top of the report
> that says Export Data. With RS 2005 you can be able to configure it to use
> ASCII instead of Unicode when exporting to CSV.
> So, in RS 2000 I add a link at the top of the page and then use Jump to URL.
> Here is an example of a Jump to URL link I use. This causes Excel to come up
> with the data in a separate window:
>
> ="javascript:void(window.open('" & Globals!ReportServerUrl &
> "?/SomeFolder/SomeReport&ParamName=" & Parameters!ParamName.Value &
> "&rs:Format=CSV&rc:Encoding=ASCII','_blank'))"
> If you don't want to have it appear in a new window then do this in jump to
> URL:
> =Globals!ReportServerUrl & "?/SomeFolder/SomeReport&ParamName=" &
> Parameters!ParamName.Value & "&rs:Format=CSV&rc:Encoding=ASCII"
>
> Very nice and very fast. CSV ASCII will be just as fast as HTML.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "Terry" <Terry@.discussions.microsoft.com> wrote in message
> news:5429586F-A50A-43F9-B913-E7E7B98A7F15@.microsoft.com...
> > How can I increase the performance when attempting to export large reports
> > to
> > an MS Excel or PDF file?
> >
> > The report currently has an average of 29,995 records and is approximately
> > 19,398,584 bytes in size. (650+ pages)
> >
> > However, when rendering the report, the report takes only 30+ seconds.
> >
> > http://reportserv/Reports/Pages/Report.aspx?ItemPath=%
> > 2fMember_Verification%2fReports%2fIPC_Members_Verification
> >
> > Thank you in advance for your support.
>
>|||It looks to me like you can't from the report manager. I don't know if you
can use web services (my guess is that you can). In RS 2005 you can
configure RS to automatically use CSV ASCII (which is what I have done).
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Terry" <Terry@.discussions.microsoft.com> wrote in message
news:68EB7C88-F34A-4254-B963-A0F5F3FDE734@.microsoft.com...
> The solution worked! Thank you very much.
> However, is there a way of scheduling the report using the same solution?
>
> "Bruce L-C [MVP]" wrote:
>> If it takes 30 seconds to html then it will take as much as 10 times
>> longer
>> to Excel or PDF. For Excel there is a work around.
>> Depending on how you design your reports you can do the following to
>> export
>> to Excel. Or, what I do sometimes is make a copy of the report and clean
>> it
>> up for data export and then hide it in list view. If you export from
>> Report
>> Manager (RS 2000) it puts CSV data in unicode which Excel puts all in one
>> column. If you export in ASCII then Excel does just as you want. To
>> prevent
>> a problem with cells (Excel will object to sorting the data) you need to
>> remove any textboxes you have (for instance with a title, showing the
>> parameters run etc) and instead add additional header rows, merge the
>> cells
>> and put your text in there instead. I add a link at the top of the report
>> that says Export Data. With RS 2005 you can be able to configure it to
>> use
>> ASCII instead of Unicode when exporting to CSV.
>> So, in RS 2000 I add a link at the top of the page and then use Jump to
>> URL.
>> Here is an example of a Jump to URL link I use. This causes Excel to come
>> up
>> with the data in a separate window:
>>
>> ="javascript:void(window.open('" & Globals!ReportServerUrl &
>> "?/SomeFolder/SomeReport&ParamName=" & Parameters!ParamName.Value &
>> "&rs:Format=CSV&rc:Encoding=ASCII','_blank'))"
>> If you don't want to have it appear in a new window then do this in jump
>> to
>> URL:
>> =Globals!ReportServerUrl & "?/SomeFolder/SomeReport&ParamName=" &
>> Parameters!ParamName.Value & "&rs:Format=CSV&rc:Encoding=ASCII"
>>
>> Very nice and very fast. CSV ASCII will be just as fast as HTML.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>>
>> "Terry" <Terry@.discussions.microsoft.com> wrote in message
>> news:5429586F-A50A-43F9-B913-E7E7B98A7F15@.microsoft.com...
>> > How can I increase the performance when attempting to export large
>> > reports
>> > to
>> > an MS Excel or PDF file?
>> >
>> > The report currently has an average of 29,995 records and is
>> > approximately
>> > 19,398,584 bytes in size. (650+ pages)
>> >
>> > However, when rendering the report, the report takes only 30+ seconds.
>> >
>> > http://reportserv/Reports/Pages/Report.aspx?ItemPath=%
>> > 2fMember_Verification%2fReports%2fIPC_Members_Verification
>> >
>> > Thank you in advance for your support.
>>

Exporting multiple Reports to one file... URGENT

Hello frendz.
I want to export multiple reports to one file i.e. in one text file , pdf file, excel file
can anyone guide me .. how i can do that.. ?
thanks
DhavalYou can export one report in one file. Export reports in different files and combine them as a whole. I dont think there is an option to export multiple reports to single file

Exporting Japanese characters to PDF

When I export my report containing Japanese characters to PDF, the Japanese
text gets translated to a string of question marks ("? ? ? ?"). Yet the
Japanese characters display just fine in Visual Studio Preview, or when I
export the report to Excel, or when I execute the report's stored proc in
Query Analyzer. Is this a bug in the PDF translator?i have the same problem.help!
"MattGauch" <MattGauch@.discussions.microsoft.com> дÈëÏûÏ¢
news:921D902A-FEE0-4B7E-A1F1-F4E158D9DF3C@.microsoft.com...
> When I export my report containing Japanese characters to PDF, the
Japanese
> text gets translated to a string of question marks ("? ? ? ?"). Yet the
> Japanese characters display just fine in Visual Studio Preview, or when I
> export the report to Excel, or when I execute the report's stored proc in
> Query Analyzer. Is this a bug in the PDF translator?
>|||Try the report after you changed the fonts to "Arial Unicode MS" font.
Eralper
http://www.kodyaz.com
"news.microsoft.com" wrote:
> i have the same problem.help!
> "MattGauch" <MattGauch@.discussions.microsoft.com> �´�ë�û�¢
> news:921D902A-FEE0-4B7E-A1F1-F4E158D9DF3C@.microsoft.com...
> > When I export my report containing Japanese characters to PDF, the
> Japanese
> > text gets translated to a string of question marks ("? ? ? ?"). Yet the
> > Japanese characters display just fine in Visual Studio Preview, or when I
> > export the report to Excel, or when I execute the report's stored proc in
> > Query Analyzer. Is this a bug in the PDF translator?
> >
> >
>
>|||That did the trick - THANKS!! Still don't understand why it would export and
show up fine in Excel, however?
- Matt
"eralper" wrote:
> Try the report after you changed the fonts to "Arial Unicode MS" font.
> Eralper
> http://www.kodyaz.com
>
> "news.microsoft.com" wrote:
> > i have the same problem.help!
> > "MattGauch" <MattGauch@.discussions.microsoft.com> �´�ë�û�¢
> > news:921D902A-FEE0-4B7E-A1F1-F4E158D9DF3C@.microsoft.com...
> > > When I export my report containing Japanese characters to PDF, the
> > Japanese
> > > text gets translated to a string of question marks ("? ? ? ?"). Yet the
> > > Japanese characters display just fine in Visual Studio Preview, or when I
> > > export the report to Excel, or when I execute the report's stored proc in
> > > Query Analyzer. Is this a bug in the PDF translator?
> > >
> > >
> >
> >
> >|||I can not answer why it works on VS.Net preview but the Arial Unicode MS is a
very huge fiel about 3 MB in size so containing nearly all fonts in many
languages.
"MattGauch" wrote:
> That did the trick - THANKS!! Still don't understand why it would export and
> show up fine in Excel, however?
> - Matt
>
> "eralper" wrote:
> >
> > Try the report after you changed the fonts to "Arial Unicode MS" font.
> >
> > Eralper
> > http://www.kodyaz.com
> >
> >
> > "news.microsoft.com" wrote:
> >
> > > i have the same problem.help!
> > > "MattGauch" <MattGauch@.discussions.microsoft.com> �´�ë�û�¢
> > > news:921D902A-FEE0-4B7E-A1F1-F4E158D9DF3C@.microsoft.com...
> > > > When I export my report containing Japanese characters to PDF, the
> > > Japanese
> > > > text gets translated to a string of question marks ("? ? ? ?"). Yet the
> > > > Japanese characters display just fine in Visual Studio Preview, or when I
> > > > export the report to Excel, or when I execute the report's stored proc in
> > > > Query Analyzer. Is this a bug in the PDF translator?
> > > >
> > > >
> > >
> > >
> > >|||This can be a problem with Acrobat itself. RS doesn't embed fonts into
its PDF reports. (Probably, to avoid copyright violation issues
arising from redistributing fonts along with documents.) When
displaying such documents, Acrobat is tailored to substitute fonts,
based on fonts' characteristics, not name. If no match is found, it
uses some generic font, and, if that font doesn't contain the
characters used in the document, guess what it is going to display?
Right, a bunch of question marks...
On Thu, 3 Feb 2005 01:25:03 -0800, "eralper"
<eralper@.discussions.microsoft.com> wrote:
>I can not answer why it works on VS.Net preview but the Arial Unicode MS is a
>very huge fiel about 3 MB in size so containing nearly all fonts in many
>languages.
>"MattGauch" wrote:
>> That did the trick - THANKS!! Still don't understand why it would export and
>> show up fine in Excel, however?
>> - Matt
>>
>> "eralper" wrote:
>> >
>> > Try the report after you changed the fonts to "Arial Unicode MS" font.
>> >
>> > Eralper
>> > http://www.kodyaz.com
>> >
>> >
>> > "news.microsoft.com" wrote:
>> >
>> > > i have the same problem.help!
>> > > "MattGauch" <MattGauch@.discussions.microsoft.com> дÈëÏûÏ¢
>> > > news:921D902A-FEE0-4B7E-A1F1-F4E158D9DF3C@.microsoft.com...
>> > > > When I export my report containing Japanese characters to PDF, the
>> > > Japanese
>> > > > text gets translated to a string of question marks ("? ? ? ?"). Yet the
>> > > > Japanese characters display just fine in Visual Studio Preview, or when I
>> > > > export the report to Excel, or when I execute the report's stored proc in
>> > > > Query Analyzer. Is this a bug in the PDF translator?
>> > > >
>> > > >
>> > >
>> > >
>> > >|||I have similar problem. My barcode font (C39HrP36DmTt) gets converted to
somewhat like Arial on export to PDF or printing. Although in IE font is
displayed well.
I experimented with preinstalled Windows fonts like Blackadder ITC and Curlz
MT and got the same.
I have Reporting Services with SP 2. My font is installed on server.
Andrej.
"Usenet User" wrote:
> This can be a problem with Acrobat itself. RS doesn't embed fonts into
> its PDF reports. (Probably, to avoid copyright violation issues
> arising from redistributing fonts along with documents.) When
> displaying such documents, Acrobat is tailored to substitute fonts,
> based on fonts' characteristics, not name. If no match is found, it
> uses some generic font, and, if that font doesn't contain the
> characters used in the document, guess what it is going to display?
> Right, a bunch of question marks...
>
> On Thu, 3 Feb 2005 01:25:03 -0800, "eralper"
> <eralper@.discussions.microsoft.com> wrote:
> >I can not answer why it works on VS.Net preview but the Arial Unicode MS is a
> >very huge fiel about 3 MB in size so containing nearly all fonts in many
> >languages.
> >
> >"MattGauch" wrote:
> >
> >> That did the trick - THANKS!! Still don't understand why it would export and
> >> show up fine in Excel, however?
> >>
> >> - Matt
> >>
> >>
> >> "eralper" wrote:
> >>
> >> >
> >> > Try the report after you changed the fonts to "Arial Unicode MS" font.
> >> >
> >> > Eralper
> >> > http://www.kodyaz.com
> >> >
> >> >
> >> > "news.microsoft.com" wrote:
> >> >
> >> > > i have the same problem.help!
> >> > > "MattGauch" <MattGauch@.discussions.microsoft.com> �´�ë�û�¢
> >> > > news:921D902A-FEE0-4B7E-A1F1-F4E158D9DF3C@.microsoft.com...
> >> > > > When I export my report containing Japanese characters to PDF, the
> >> > > Japanese
> >> > > > text gets translated to a string of question marks ("? ? ? ?"). Yet the
> >> > > > Japanese characters display just fine in Visual Studio Preview, or when I
> >> > > > export the report to Excel, or when I execute the report's stored proc in
> >> > > > Query Analyzer. Is this a bug in the PDF translator?
> >> > > >
> >> > > >
> >> > >
> >> > >
> >> > >
>|||Arial Unicode MS won't always work. In order to enable Japanese for
non-unicode programs (PDF), see the following url:
http://www.greggman.com/japan/xp-ime/xp-ime.htm.
"Andrej" wrote:
> I have similar problem. My barcode font (C39HrP36DmTt) gets converted to
> somewhat like Arial on export to PDF or printing. Although in IE font is
> displayed well.
> I experimented with preinstalled Windows fonts like Blackadder ITC and Curlz
> MT and got the same.
> I have Reporting Services with SP 2. My font is installed on server.
> Andrej.
>
>
> "Usenet User" wrote:
> > This can be a problem with Acrobat itself. RS doesn't embed fonts into
> > its PDF reports. (Probably, to avoid copyright violation issues
> > arising from redistributing fonts along with documents.) When
> > displaying such documents, Acrobat is tailored to substitute fonts,
> > based on fonts' characteristics, not name. If no match is found, it
> > uses some generic font, and, if that font doesn't contain the
> > characters used in the document, guess what it is going to display?
> > Right, a bunch of question marks...
> >
> >
> > On Thu, 3 Feb 2005 01:25:03 -0800, "eralper"
> > <eralper@.discussions.microsoft.com> wrote:
> >
> > >I can not answer why it works on VS.Net preview but the Arial Unicode MS is a
> > >very huge fiel about 3 MB in size so containing nearly all fonts in many
> > >languages.
> > >
> > >"MattGauch" wrote:
> > >
> > >> That did the trick - THANKS!! Still don't understand why it would export and
> > >> show up fine in Excel, however?
> > >>
> > >> - Matt
> > >>
> > >>
> > >> "eralper" wrote:
> > >>
> > >> >
> > >> > Try the report after you changed the fonts to "Arial Unicode MS" font.
> > >> >
> > >> > Eralper
> > >> > http://www.kodyaz.com
> > >> >
> > >> >
> > >> > "news.microsoft.com" wrote:
> > >> >
> > >> > > i have the same problem.help!
> > >> > > "MattGauch" <MattGauch@.discussions.microsoft.com> �´�ë�û�¢
> > >> > > news:921D902A-FEE0-4B7E-A1F1-F4E158D9DF3C@.microsoft.com...
> > >> > > > When I export my report containing Japanese characters to PDF, the
> > >> > > Japanese
> > >> > > > text gets translated to a string of question marks ("? ? ? ?"). Yet the
> > >> > > > Japanese characters display just fine in Visual Studio Preview, or when I
> > >> > > > export the report to Excel, or when I execute the report's stored proc in
> > >> > > > Query Analyzer. Is this a bug in the PDF translator?
> > >> > > >
> > >> > > >
> > >> > >
> > >> > >
> > >> > >
> >
> >

Exporting is not wokring if we place an Image in the Report Header

Hi all..

In my report, i am placing an Image(Embedded) in the Header section. But while i am exporting the document to pdf , it is not displaying any data except the Header Image 3 times. I tried this by placing the image in a List data region also. But still the same problem.

Can any one help me if you come across these kind of issue?

Thanks in advance

Is the image positioned right again the report report border?

Are you using sub reports in the body or is it just straight data?

What is the format of the image?

Will export correctly to Excel?

|||

Exporting to Excel is okay. But to the PDF it is not exporting and displaying the Image(JPEG) thrice.

I placed the image in the header and placed within the report border. I am not using any sub reports. It is straight data.

Can any one faced this kind of problem? pleae give me some solution.

thanks in advance.

|||

Just out of interest, can you change the image type to a gif and try it. I've had PDF exports that have 'issues' with jpg.

Exporting in SSRS 2005

Hi,

I'm developing a web app in .NET 2.0 using SSRS 2000 and 2005. Some of the reports need to be exported directly to PDF when clicked, but the problem is in the fact that the user must select the parameters from the report manager window.

Is there any way to allow the direct export to PDF when generate is clicked, or to limit the options the user has to export to in the report manager.

P.S. If it is possible, I DO NOT want to accomplish this using code.

Thanks,

Hello,

Here's how to get rid of the other export options:

Navigate to {System Root}:\Program Files\Microsoft SQL Server\MSSQL.{RS_Instance_ID}\Reporting Services\ReportServer

Open rsreportserver.config in your favorite text editor

Search for <Render>

You should see the available rendering extensions here

<Extension Name="XML" ... />

<Extension Name="EXCEL" ... />

...

In order to just have PDF available, comment out all but the line for PDF

<!-- <Extension Name="XML" ... /> -->

<!-- <Extension Name="EXCEL" ... /> -->

...

Save the file and close it

Please note, that if you do this, these options won't be available to anyone in Report Manager.

Hope this helps.

Jarret

|||Jarrett. I also had need to do this and it worked. However, I now need to restore one of the ones I had removed. I uncommented out the one I want back, saved the file, and started up Report Manager. The options under export didn't change. The uncommented one didn't reappear. Any help would be appreciated. Thanks, Jim.|||Restart your SQL Server service and ReportServer service completely. Otherwise, check if you did not accidentally make a spelling mistake or something in the Config file. Eduard

Exporting in SSRS 2005

Hi,

I'm developing a web app in .NET 2.0 using SSRS 2000 and 2005. Some of the reports need to be exported directly to PDF when clicked, but the problem is in the fact that the user must select the parameters from the report manager window.

Is there any way to allow the direct export to PDF when generate is clicked, or to limit the options the user has to export to in the report manager.

P.S. If it is possible, I DO NOT want to accomplish this using code.

Thanks,

Hello,

Here's how to get rid of the other export options:

Navigate to {System Root}:\Program Files\Microsoft SQL Server\MSSQL.{RS_Instance_ID}\Reporting Services\ReportServer

Open rsreportserver.config in your favorite text editor

Search for <Render>

You should see the available rendering extensions here

<Extension Name="XML" ... />

<Extension Name="EXCEL" ... />

...

In order to just have PDF available, comment out all but the line for PDF

<!-- <Extension Name="XML" ... /> -->

<!-- <Extension Name="EXCEL" ... /> -->

...

Save the file and close it

Please note, that if you do this, these options won't be available to anyone in Report Manager.

Hope this helps.

Jarret

|||Jarrett. I also had need to do this and it worked. However, I now need to restore one of the ones I had removed. I uncommented out the one I want back, saved the file, and started up Report Manager. The options under export didn't change. The uncommented one didn't reappear. Any help would be appreciated. Thanks, Jim.|||Restart your SQL Server service and ReportServer service completely. Otherwise, check if you did not accidentally make a spelling mistake or something in the Config file. Eduard

Exporting in different Formats

Is there a way to hide the address bar, while exporting the reports to PDF or
Excel. Currently when i click export it opens up a new window with the
address bar containing the whole URL including the parameters i am passing.It is possible when you write your custom code, using web services. You gan
then render the page to any format, without having to show the page..
"prankster" wrote:
> Is there a way to hide the address bar, while exporting the reports to PDF or
> Excel. Currently when i click export it opens up a new window with the
> address bar containing the whole URL including the parameters i am passing.
>

Exporting from snapshot data

Is there anyway possible to grab a snapshot via some vb.net or c# code and
then export it to pdf, txt, etc...?Yes,
If you've created a snapshot then you can get to the snapshot via the REnder
Method on the Reporting Services' SOAP interface.
Chapter 9¾ (Our Harry Potter Themed Chapter with Voldemort Basic.NET quips)
deals with SOAP and pages 585 - 592 - should show you all the details you
need to know about how to create a snapshot via code and also how to render
it.
Peter Blackburn
Hitchhiker's Guide to SQL Server 2000 Reporting Services
http://www.sqlreportingservices.net
"Mike H" <Mike H@.discussions.microsoft.com> wrote in message
news:62F37D51-6862-415C-9C87-FE82685FC6D3@.microsoft.com...
> Is there anyway possible to grab a snapshot via some vb.net or c# code and
> then export it to pdf, txt, etc...?sql

Exporting embedded images to PDF

Hi,
we experience problems whenever we try to export reports containing images
to a PDF-document. As far as we found out, this issue occurs only with images
set to 256 colours (8 bpp). Images set to 16.7 m pixels do not cause any
problems. Due to the fact that this is a mayor issue for our company weâ'd
like to know whether this problem will be fixed soon. Converting all images
to high colour is not a feasible workaround for us.
Regards,
Carsten Schlotmann
Informationstechnik & eBusiness
A. F. Dornbracht GmbH & Co. KGYou should report this as a bug... Then you can see the status...
http://lab.msdn.microsoft.com/productfeedback/default.aspx
--
Wayne Snyder MCDBA, SQL Server MVP
Mariner, Charlotte, NC
I support the Professional Association for SQL Server ( PASS) and it''s
community of SQL Professionals.
"Markus Behde" wrote:
> Hi,
> we experience problems whenever we try to export reports containing images
> to a PDF-document. As far as we found out, this issue occurs only with images
> set to 256 colours (8 bpp). Images set to 16.7 m pixels do not cause any
> problems. Due to the fact that this is a mayor issue for our company weâ'd
> like to know whether this problem will be fixed soon. Converting all images
> to high colour is not a feasible workaround for us.
> Regards,
> Carsten Schlotmann
> Informationstechnik & eBusiness
> A. F. Dornbracht GmbH & Co. KG|||Sorry, but it's a problem on SQL Server 2000 with Reporting Services SP2 and
at the Product Feedback Center I can only report bugs for SQL Server 2005!
"Wayne Snyder" wrote:
> You should report this as a bug... Then you can see the status...
> http://lab.msdn.microsoft.com/productfeedback/default.aspx
> --
> Wayne Snyder MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> I support the Professional Association for SQL Server ( PASS) and it''s
> community of SQL Professionals.
>
> "Markus Behde" wrote:
> > Hi,
> >
> > we experience problems whenever we try to export reports containing images
> > to a PDF-document. As far as we found out, this issue occurs only with images
> > set to 256 colours (8 bpp). Images set to 16.7 m pixels do not cause any
> > problems. Due to the fact that this is a mayor issue for our company weâ'd
> > like to know whether this problem will be fixed soon. Converting all images
> > to high colour is not a feasible workaround for us.
> >
> > Regards,
> >
> > Carsten Schlotmann
> > Informationstechnik & eBusiness
> >
> > A. F. Dornbracht GmbH & Co. KG|||Hi Carsten,
Welcome to use MSDN Managed Newsgroup!
From your descriptions, I understood you encounter problems when rendering
256 color images to PDF format. If I have misunderstood your concern,
please feel free to point it out.
I have generated a 256 colors bmp file with mspaint and inserted it into my
report as Embeded image. The rendered pdf file looks as expected.
You may send the sample files/solution based on sample database
AdventureWorks within a zipped package to me. My direct email address is
v-mingqc@.online.microsoft.com (make sure to REMOVE "online" before you
click SEND as "online" is only for SPAM), you may send the file to me
directly and I will keep secure.
You may also contact Microsoft Customer Service and Support and open a
support incident and work with a dedicated Support Professional.
Please be advised that contacting phone support will be a charged call.
However, if you are simply requesting a hotfix be sent to you and no other
support then charges are usually refunded or waived. if this turned out to
be a known issue/bug in our product, you will also be refunded or waived.
To obtain the phone numbers for specific technology request please take a
look at the web site listed below.
http://support.microsoft.com/default.aspx?scid=fh;EN-US;PHONENUMBERS
Thank you for your patience and cooperation. If you have any questions or
concerns, don't hesitate to let me know. We are always here to be of
assistance!
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi Carsten,
Thanks for your email and sample.
This was confirmed to be a known issue and will be fixed in Reporting
Services 2005 Service Pack 1.
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================This posting is provided "AS IS" with no warranties, and confers no rights.

Exporting drill down to PDF

Hi,
We are exporting all of our reports to pdf for printing. If I export a drill down report at the highest level of detail, it displays exactly as it looks in reporting services. However, if I go back to the report and drill down a level, then exporting to pdf, it still displays the highest level of detail. I would like it to display exactly what is shown drilled down or up. Please advise.
Thanks!How our you exporting your reports (SOAP, Report Manager, or Report
Designer)?
Would you try an experiment. Could you load the sample report, Company
Sales.rdl then try changing the toggle settings and then export the report
to PDF.
I tried this using Reporting Services with S1 installed and was not able to
reproduce the problem.
--
Bruce Johnson [MSFT]
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"clutch" <clutch@.discussions.microsoft.com> wrote in message
news:0D2A2576-FC38-4741-9894-D054762BDFEE@.microsoft.com...
> Hi,
> We are exporting all of our reports to pdf for printing. If I export a
drill down report at the highest level of detail, it displays exactly as it
looks in reporting services. However, if I go back to the report and drill
down a level, then exporting to pdf, it still displays the highest level of
detail. I would like it to display exactly what is shown drilled down or
up. Please advise.
> Thanks!|||I am exporting via Report Manager. Can I presume that then S1 will take care
of this challenge?
"Bruce Johnson [MSFT]" wrote:
> How our you exporting your reports (SOAP, Report Manager, or Report
> Designer)?
> Would you try an experiment. Could you load the sample report, Company
> Sales.rdl then try changing the toggle settings and then export the report
> to PDF.
> I tried this using Reporting Services with S1 installed and was not able to
> reproduce the problem.
> --
> Bruce Johnson [MSFT]
> Microsoft SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "clutch" <clutch@.discussions.microsoft.com> wrote in message
> news:0D2A2576-FC38-4741-9894-D054762BDFEE@.microsoft.com...
> > Hi,
> >
> > We are exporting all of our reports to pdf for printing. If I export a
> drill down report at the highest level of detail, it displays exactly as it
> looks in reporting services. However, if I go back to the report and drill
> down a level, then exporting to pdf, it still displays the highest level of
> detail. I would like it to display exactly what is shown drilled down or
> up. Please advise.
> >
> > Thanks!
>
>