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!
>
>

Export to PDF only showing 1 Page

Hello,
I have a simple report (rdl available but the ms browser wont let me upload
it) that runs and displays fine on screen; when a user does an export to pdf
they only get the first page. On screen we are seeing 18 pages in total in
IE.
When we export to PDF we only get the first page; exporting to excel is
showing all the information correctly...
The server is windows 2003, sql 2000 sp4 the clients are windows 2000/ ie6
and either windows xp / ie6 / ie7 and the same is happening for all users.
We are accessing the reports from inside an iframe generally; calling the
report with the required parameters. Though when we try it using the URL the
same export happens.
There are about 40 reports on the server and only this one is affected.
Thanks
ChrisIt might be that some of the report elements are sitting on top of each
other.
Try opening the report in your designer, and move all the elements so that
you make sure none are covering the others. Then upload and see if this
solves it.
Kaisa M. Lindahl Lervik
"Chris Hoare" <choare@.nospam.nospam> wrote in message
news:0004CD40-F271-4AC9-9875-3276DC0B5558@.microsoft.com...
> Hello,
> I have a simple report (rdl available but the ms browser wont let me
> upload
> it) that runs and displays fine on screen; when a user does an export to
> pdf
> they only get the first page. On screen we are seeing 18 pages in total in
> IE.
> When we export to PDF we only get the first page; exporting to excel is
> showing all the information correctly...
> The server is windows 2003, sql 2000 sp4 the clients are windows 2000/ ie6
> and either windows xp / ie6 / ie7 and the same is happening for all users.
> We are accessing the reports from inside an iframe generally; calling the
> report with the required parameters. Though when we try it using the URL
> the
> same export happens.
> There are about 40 reports on the server and only this one is affected.
> Thanks
> Chris
>
>|||No there are no hidden overlapping The only expressions in the report handle
some color formatting on the numbers on the report to highlight exceptions.
We managed to get it to export on a pc running XP SP2 / Office 2003 last
night; but we havent had any luck with other reports.
Also tried deleting it out from reporting services manager, changing the
report history to store 1 copy of the report.|||Hi choare,
Thank you for the post.
Would you pleae send the report file to me? You may send to me directly. I
understand the information may be sensitive to you, my direct email address
is weilu@.ONLINE.microsoft.com (Please remove the ONLINE when you send the
mail), you may send the file to me directly and I will keep secure.
Sincerely,
Wei Lu
Microsoft Online Community 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.

export to excel without formatting

Is is possible to render a report to excel without formatting?
For example, I have a report that displays like this in my web browser.
Country State City Sales
USA MN A 100.00
B 50.00
C 50.00
CA A 500.00
B 25.00
TX A 225.00
B 63.25
C 100.00
When I export it to excel I would like every cell to be filled in.
Country State City Sales
USA MN A 100.00
USA MN B 50.00
USA MN C 50.00
USA CA A 500.00
USA CA B 25.00
USA TX A 225.00
USA TX B 63.25
USA TX C 100.00
Any info or help on this would be great.Will export to CSV work?
Steve MunLeeuw
"retkow" <retkow@.discussions.microsoft.com> wrote in message
news:FD8A536E-9B93-414E-850F-9772A810E98F@.microsoft.com...
> Is is possible to render a report to excel without formatting?
> For example, I have a report that displays like this in my web browser.
> Country State City Sales
> USA MN A 100.00
> B 50.00
> C 50.00
> CA A 500.00
> B 25.00
> TX A 225.00
> B 63.25
> C 100.00
> When I export it to excel I would like every cell to be filled in.
> Country State City Sales
> USA MN A 100.00
> USA MN B 50.00
> USA MN C 50.00
> USA CA A 500.00
> USA CA B 25.00
> USA TX A 225.00
> USA TX B 63.25
> USA TX C 100.00
> Any info or help on this would be great.
>|||Exporting to CSV does work, but the users and customers who run the reports
will not consider this a reasonable option. The reporting tool my company is
using right now allows exporting to excel without formatting.
"Steve MunLeeuw" wrote:
> Will export to CSV work?
> Steve MunLeeuw
> "retkow" <retkow@.discussions.microsoft.com> wrote in message
> news:FD8A536E-9B93-414E-850F-9772A810E98F@.microsoft.com...
> > Is is possible to render a report to excel without formatting?
> >
> > For example, I have a report that displays like this in my web browser.
> >
> > Country State City Sales
> > USA MN A 100.00
> > B 50.00
> > C 50.00
> > CA A 500.00
> > B 25.00
> > TX A 225.00
> > B 63.25
> > C 100.00
> >
> > When I export it to excel I would like every cell to be filled in.
> >
> > Country State City Sales
> > USA MN A 100.00
> > USA MN B 50.00
> > USA MN C 50.00
> > USA CA A 500.00
> > USA CA B 25.00
> > USA TX A 225.00
> > USA TX B 63.25
> > USA TX C 100.00
> >
> > Any info or help on this would be great.
> >
>
>|||what is the difference'
i mean seriously?
they have one additional step where they need to use 'SaveAs' instead of
Save?
write a clientside macro for them
"retkow" <retkow@.discussions.microsoft.com> wrote in message
news:0ECC938F-1B10-494A-BF33-8E8BB5DCE471@.microsoft.com...
> Exporting to CSV does work, but the users and customers who run the
> reports
> will not consider this a reasonable option. The reporting tool my company
> is
> using right now allows exporting to excel without formatting.
>
> "Steve MunLeeuw" wrote:
>> Will export to CSV work?
>> Steve MunLeeuw
>> "retkow" <retkow@.discussions.microsoft.com> wrote in message
>> news:FD8A536E-9B93-414E-850F-9772A810E98F@.microsoft.com...
>> > Is is possible to render a report to excel without formatting?
>> >
>> > For example, I have a report that displays like this in my web browser.
>> >
>> > Country State City Sales
>> > USA MN A 100.00
>> > B 50.00
>> > C 50.00
>> > CA A 500.00
>> > B 25.00
>> > TX A 225.00
>> > B 63.25
>> > C 100.00
>> >
>> > When I export it to excel I would like every cell to be filled in.
>> >
>> > Country State City Sales
>> > USA MN A 100.00
>> > USA MN B 50.00
>> > USA MN C 50.00
>> > USA CA A 500.00
>> > USA CA B 25.00
>> > USA TX A 225.00
>> > USA TX B 63.25
>> > USA TX C 100.00
>> >
>> > Any info or help on this would be great.
>> >
>>|||The problem with a csv file is if some of the values returned in a report
have commas in this will cause the report to not load correctly in excel.
"aaron_kempf@.hotmail.com" wrote:
> what is the difference'
> i mean seriously?
> they have one additional step where they need to use 'SaveAs' instead of
> Save?
> write a clientside macro for them
>
>
> "retkow" <retkow@.discussions.microsoft.com> wrote in message
> news:0ECC938F-1B10-494A-BF33-8E8BB5DCE471@.microsoft.com...
> > Exporting to CSV does work, but the users and customers who run the
> > reports
> > will not consider this a reasonable option. The reporting tool my company
> > is
> > using right now allows exporting to excel without formatting.
> >
> >
> >
> > "Steve MunLeeuw" wrote:
> >
> >> Will export to CSV work?
> >>
> >> Steve MunLeeuw
> >>
> >> "retkow" <retkow@.discussions.microsoft.com> wrote in message
> >> news:FD8A536E-9B93-414E-850F-9772A810E98F@.microsoft.com...
> >> > Is is possible to render a report to excel without formatting?
> >> >
> >> > For example, I have a report that displays like this in my web browser.
> >> >
> >> > Country State City Sales
> >> > USA MN A 100.00
> >> > B 50.00
> >> > C 50.00
> >> > CA A 500.00
> >> > B 25.00
> >> > TX A 225.00
> >> > B 63.25
> >> > C 100.00
> >> >
> >> > When I export it to excel I would like every cell to be filled in.
> >> >
> >> > Country State City Sales
> >> > USA MN A 100.00
> >> > USA MN B 50.00
> >> > USA MN C 50.00
> >> > USA CA A 500.00
> >> > USA CA B 25.00
> >> > USA TX A 225.00
> >> > USA TX B 63.25
> >> > USA TX C 100.00
> >> >
> >> > Any info or help on this would be great.
> >> >
> >>
> >>
> >>
>
>|||I believe you can set the CSV rendering device info to put quotes around
strings. Then you will have no problem with commas in the data. The only
device info I have used is to make the CSV rendering in Report Manager to be
ASCII. This is what I put in rsreportserver.config:
<Extension Name="CSV"
Type="Microsoft.ReportingServices.Rendering.CsvRenderer.CsvReport,Microsoft.ReportingServices.CsvRendering">
<Configuration>
<DeviceInfo>
<Encoding>ASCII</Encoding>
</DeviceInfo>
</Configuration>
</Extension>
Note that you can put device info on your url string so you could test this
without changing the file. My guess is that you would do this:
<Extension Name="CSV"
Type="Microsoft.ReportingServices.Rendering.CsvRenderer.CsvReport,Microsoft.ReportingServices.CsvRendering">
<Configuration>
<DeviceInfo>
<Encoding>ASCII</Encoding>
<Qualifier>"</Qualifier>
</DeviceInfo>
</Configuration>
</Extension>
I searched on CSV in the help for RS 2005 (btw, while you can put device
info on the URL, making a change to the config file only works with RS2005).
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"retkow" <retkow@.discussions.microsoft.com> wrote in message
news:61E0F0BB-02EF-4145-A70E-392C0C986312@.microsoft.com...
> The problem with a csv file is if some of the values returned in a report
> have commas in this will cause the report to not load correctly in excel.
>
> "aaron_kempf@.hotmail.com" wrote:
>> what is the difference'
>> i mean seriously?
>> they have one additional step where they need to use 'SaveAs' instead of
>> Save?
>> write a clientside macro for them
>>
>>
>> "retkow" <retkow@.discussions.microsoft.com> wrote in message
>> news:0ECC938F-1B10-494A-BF33-8E8BB5DCE471@.microsoft.com...
>> > Exporting to CSV does work, but the users and customers who run the
>> > reports
>> > will not consider this a reasonable option. The reporting tool my
>> > company
>> > is
>> > using right now allows exporting to excel without formatting.
>> >
>> >
>> >
>> > "Steve MunLeeuw" wrote:
>> >
>> >> Will export to CSV work?
>> >>
>> >> Steve MunLeeuw
>> >>
>> >> "retkow" <retkow@.discussions.microsoft.com> wrote in message
>> >> news:FD8A536E-9B93-414E-850F-9772A810E98F@.microsoft.com...
>> >> > Is is possible to render a report to excel without formatting?
>> >> >
>> >> > For example, I have a report that displays like this in my web
>> >> > browser.
>> >> >
>> >> > Country State City Sales
>> >> > USA MN A 100.00
>> >> > B 50.00
>> >> > C 50.00
>> >> > CA A 500.00
>> >> > B 25.00
>> >> > TX A 225.00
>> >> > B 63.25
>> >> > C 100.00
>> >> >
>> >> > When I export it to excel I would like every cell to be filled in.
>> >> >
>> >> > Country State City Sales
>> >> > USA MN A 100.00
>> >> > USA MN B 50.00
>> >> > USA MN C 50.00
>> >> > USA CA A 500.00
>> >> > USA CA B 25.00
>> >> > USA TX A 225.00
>> >> > USA TX B 63.25
>> >> > USA TX C 100.00
>> >> >
>> >> > Any info or help on this would be great.
>> >> >
>> >>
>> >>
>> >>
>>