Exporting reports to excel - chart quality

Hello there,
I got following problem, I have some charts in my report and I need to
export reports to excel, all charts are being converted into images,
which is fine, but the quality of this conversion is not good and for
example axis labels are barely readable, while for example exporting
to pdf produces a good quality chart. So my question: is there any way
to increase quality of output image during conversion charts to
excel ?On Aug 16, 5:10 am, bachu...@.op.pl wrote:
> Hello there,
> I got following problem, I have some charts in my report and I need to
> export reports to excel, all charts are being converted into images,
> which is fine, but the quality of this conversion is not good and for
> example axis labels are barely readable, while for example exporting
> to pdf produces a good quality chart. So my question: is there any way
> to increase quality of output image during conversion charts to
> excel ?
I agree w/you in terms of the chart quality in PDF versus Excel. The
only thing that I can think of is to increase the axis label size/
font. Another alternative is to create a separate report for each
export option and set the font according to what best works for the
export and then tie them both to export buttons in a custom ASP.NET
application and swap the 2 report based on the export option selected.
Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||Thanks for reply. However I cant do what you suggest, because in my
solution excel file requires further editing by user before printing,
which is ofc impossible in pdf, besides increasing font size not
necessarily improve quality. And what is very surprising same font,
same size but different type of chart generate different quality
image. Labels of axis in column chart look terrible while labels for
pie chart looks quite good.
There are options to change default dpi for exporting using
ImageRenderer, I was rather hoping there is a way to change
configuration of ExcelRenderer or eventually some easy way to create
overridden version and changing some default properties :(
Regards
Adam
On 17 Aug, 03:53, EMartinez <emartinez...@.gmail.com> wrote:
> On Aug 16, 5:10 am, bachu...@.op.pl wrote:
> > Hello there,
> > I got following problem, I have some charts in my report and I need to
> > export reports to excel, all charts are being converted into images,
> > which is fine, but the quality of this conversion is not good and for
> > example axis labels are barely readable, while for example exporting
> > to pdf produces a good quality chart. So my question: is there any way
> > to increase quality of output image during conversion charts to
> > excel ?
> I agree w/you in terms of the chart quality in PDF versus Excel. The
> only thing that I can think of is to increase the axis label size/
> font. Another alternative is to create a separate report for each
> export option and set the font according to what best works for the
> export and then tie them both to export buttons in a custom ASP.NET
> application and swap the 2 report based on the export option selected.
> Hope this helps.
> Regards,
> Enrique Martinez
> Sr. Software Consultant

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

Export to PDF

Hi,
Export to PDF of the sample Reporting Services Report, with Euro sign
is ok for the chart but for the table it is cripted.
Any idea if this is caused by the euro sign ?
MarcoWhat font are you using? How are you displaying the Euro? Someone else
complained about this but I couldn't get it to repro.
--
Brian Welcker
Group Program Manager
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Marco Groeneveld" <olap@.gmsbv.nl> wrote in message
news:211f845f.0406292114.54dea325@.posting.google.com...
> Hi,
> Export to PDF of the sample Reporting Services Report, with Euro sign
> is ok for the chart but for the table it is cripted.
> Any idea if this is caused by the euro sign ?
> Marco|||Hi,
You can test it on internet:
http://128.171.208.112/ReportServer?%2fProduct+Line+Sales&rs%3aCommand=Render&rs%3aFormat=HTML4.0&ProductCategory=1&ProductSubCategory=2&StartDate=1-1-2003+0%3a00%3a00&EndDate=31-12-2003+0%3a00%3a00&rc%3azoom=100&rc%3aParameters=True&rc%3aHTMLFragment=False&rc%3aToolbar=True&rc%3aJavaScript=True&rc%3aLinkTarget=_top&rc%3aArea=Toolbar
Just export to PDF and see the result.
Regards, Marco
www.gmsbv.nl
"Brian Welcker [MSFT]" <bwelcker@.online.microsoft.com> wrote in message news:<OJCKTimXEHA.3716@.TK2MSFTNGP11.phx.gbl>...
> What font are you using? How are you displaying the Euro? Someone else
> complained about this but I couldn't get it to repro.
> --
> Brian Welcker
> Group Program Manager
> SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "Marco Groeneveld" <olap@.gmsbv.nl> wrote in message
> news:211f845f.0406292114.54dea325@.posting.google.com...
> > Hi,
> >
> > Export to PDF of the sample Reporting Services Report, with Euro sign
> > is ok for the chart but for the table it is cripted.
> >
> > Any idea if this is caused by the euro sign ?
> >
> > Marco|||Hi,
You can test it on internet:
http://128.171.208.112/ReportServer?%2fProduct+Line+Sales&rs%3aCommand=Render&rs%3aFormat=HTML4.0&ProductCategory=1&ProductSubCategory=2&StartDate=1-1-2003+0%3a00%3a00&EndDate=31-12-2003+0%3a00%3a00&rc%3azoom=100&rc%3aParameters=True&rc%3aHTMLFragment=False&rc%3aToolbar=True&rc%3aJavaScript=True&rc%3aLinkTarget=_top&rc%3aArea=Toolbar
Just export to PDF and see the result.
Regards, Marco
www.gmsbv.nl
"Brian Welcker [MSFT]" <bwelcker@.online.microsoft.com> wrote in message news:<OJCKTimXEHA.3716@.TK2MSFTNGP11.phx.gbl>...
> What font are you using? How are you displaying the Euro? Someone else
> complained about this but I couldn't get it to repro.
> --
> Brian Welcker
> Group Program Manager
> SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "Marco Groeneveld" <olap@.gmsbv.nl> wrote in message
> news:211f845f.0406292114.54dea325@.posting.google.com...
> > Hi,
> >
> > Export to PDF of the sample Reporting Services Report, with Euro sign
> > is ok for the chart but for the table it is cripted.
> >
> > Any idea if this is caused by the euro sign ?
> >
> > Marco|||Marco, I cannot see any problem. The ? sign is displayed correctly in both,
the web site and the pdf. Only one: Your date is incorrect (You have Friday,
**July** 30th)
roland|||"The ? sign :).."... I mean the euro sign...
roland|||After some tests it looks like that PDF export of the euro sign will
only be possible with Acrobat Reader 6 and not with 5.
"Brian Welcker [MSFT]" <bwelcker@.online.microsoft.com> wrote in message news:<OJCKTimXEHA.3716@.TK2MSFTNGP11.phx.gbl>...
> What font are you using? How are you displaying the Euro? Someone else
> complained about this but I couldn't get it to repro.
> --
> Brian Welcker
> Group Program Manager
> SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "Marco Groeneveld" <olap@.gmsbv.nl> wrote in message
> news:211f845f.0406292114.54dea325@.posting.google.com...
> > Hi,
> >
> > Export to PDF of the sample Reporting Services Report, with Euro sign
> > is ok for the chart but for the table it is cripted.
> >
> > Any idea if this is caused by the euro sign ?
> >
> > Marco|||This is indeed related to the version of the Acrobat Reader (works as of version 6.0), but I have also found a workaround for people who can only use Acrobat Reader 5.0:
Avoid the usage of Arial, Courier and Times New Roman as font type, since these are the fonts that can not be displayed properly with the euro symbol. Alternative could be Arial Unicode MS, Garamond, Microsoft Sans Serif or Verdana, these all look OK when I tested this.
"Marco Groeneveld" wrote:
> After some tests it looks like that PDF export of the euro sign will
> only be possible with Acrobat Reader 6 and not with 5.
> "Brian Welcker [MSFT]" <bwelcker@.online.microsoft.com> wrote in message news:<OJCKTimXEHA.3716@.TK2MSFTNGP11.phx.gbl>...
> > What font are you using? How are you displaying the Euro? Someone else
> > complained about this but I couldn't get it to repro.
> >
> > --
> > Brian Welcker
> > Group Program Manager
> > SQL Server Reporting Services
> >
> > This posting is provided "AS IS" with no warranties, and confers no rights.
> >
> > "Marco Groeneveld" <olap@.gmsbv.nl> wrote in message
> > news:211f845f.0406292114.54dea325@.posting.google.com...
> > > Hi,
> > >
> > > Export to PDF of the sample Reporting Services Report, with Euro sign
> > > is ok for the chart but for the table it is cripted.
> > >
> > > Any idea if this is caused by the euro sign ?
> > >
> > > Marco
>

Export To PDF

Hi,

I have a table and a chart in my report .When i export it to PDF format the title of the report overlaps with the table and the chart spans 2 pages.

Is there a remedy for this?

I'm not sure I understand what's going on. Can you be more descriptive about the layout of the report?

In order to keep your chart on a single page, you can increase the report page width/height (Menu -> Report -> Report Properties) to change your page dimensions to accomodate the whole chart.

Thanks, Donovan

|||

Hi,

ok..Its like this..

i am generating a month wise report based on parameters supplied by an aspx page.This is being done dynamically by building the requisite RDL.

In the RDL generated i have a table which displays month - wise stats as well as a Title for the table(for which i have put a textbox atop the table).

when i view it from the report server he layout of the report is fine.Bit if the same report is exported to PDF, the title textbox overlaps with the tabular display.This is one problem.

The other one is that in the same report i have a chart beneath the table.When i generate a report for a long time period (say 1 yr), i have set the chart width to expand correspondingly.

When the report is viewed in Acrobat reader the chart spans 2 pages...ie...data for some months are displayed on the 1st page and the rest in the second.

I suppose i' m clear now....

|||

If the report items themselves overlap, our HTML will "push" one of the items around on the page rather than displaying the items on top of one another. Our PDF will not. Would you verify that this is not the cause of the first issue?

For the second, you can dynamically (at creation time) change the <Width> tag of the <Report> element based upon how much data the user is requesting. This will allow you to keep the PDF page wide enough to fit the chart on one page rather than breaking it across pages.

Thanks, Donovan

|||

Hi,

Thanks 4 ur reply...

As 4 the first issue of overlapping i have solved it myself...had to do wit setting the Top width in the report..

As for the second issue,I am right now doing it the way u 've suggested above. But in doing so, it spans well on the Page whereas when viewed in PDF it breaks across to the second page.

One more thing....Is there a way to minimize the gap betwwen the Plotarea of the chart and the Border of the chart?

Thanks once again....

|||

Could it be you're not taking into account margins? If you have a report page width of 20" and a body width of 20" with 1" margins on the left and right, you will still get a second horizontal page.

|||What are the Top, Left, Width and Height values for the chart? Is (Chart.Left + Chart.Width) > Body.Width, which is Report.Width - Report.LeftMargin - Report.RightMargin?|||

Hi,

CHart Width is 9 in., chart top is 1.875in,I have not specified left and height for the chart

|||Are you using the default page width and margin width for the report, which is 8.5" x 11" and 1" for margins? If so, this is the reason the chart is spanning two pages. The chart width needs to be less than or equal to the page width - the margins. In this case, the chart's width should be 6.5".|||

Hi,

You can try to design your report as normal ASP.NET page and then convert that page to PDF using the he HTML to PDF library for .NET from http://www.dotnet-reporting.com or the PDF Reports Generator Library for .NET from http://www.winnovative-software.com is what you need. It's pure .NET library, it doesn't use a printer driver. There is also a free html to pdf converter application built on top of this library. The conversion can be done with only a few lines of code:

Code Snippet

PdfConverter pdfConverter = new PdfConverter();
pdfConverter.PdfDocumentOptions.PdfPageSize = PdfPageSize.A4;
pdfConverter.PdfDocumentOptions.PdfPageOrientation = PDFPageOrientation.Portrait;
pdfConverter.PdfDocumentOptions.PdfCompressionLevel = PdfCompressionLevel.Normal;
pdfConverter.PdfDocumentOptions.GenerateSelectablePdf = true;
pdfConverter.PdfDocumentOptions.ShowFooter = false;
pdfConverter.PdfDocumentOptions.ShowHeader = false;
pdfConverter.LicenseFilePath = Server.MapPath(@."~/Bin");
byte[] downloadBytes = pdfConverter.GetPdfFromUrlBytes(MyURL);

Regards,

Razva

Export To PDF

Hi,

I have a table and a chart in my report .When i export it to PDF format the title of the report overlaps with the table and the chart spans 2 pages.

Is there a remedy for this?

I'm not sure I understand what's going on. Can you be more descriptive about the layout of the report?

In order to keep your chart on a single page, you can increase the report page width/height (Menu -> Report -> Report Properties) to change your page dimensions to accomodate the whole chart.

Thanks, Donovan

|||

Hi,

ok..Its like this..

i am generating a month wise report based on parameters supplied by an aspx page.This is being done dynamically by building the requisite RDL.

In the RDL generated i have a table which displays month - wise stats as well as a Title for the table(for which i have put a textbox atop the table).

when i view it from the report server he layout of the report is fine.Bit if the same report is exported to PDF, the title textbox overlaps with the tabular display.This is one problem.

The other one is that in the same report i have a chart beneath the table.When i generate a report for a long time period (say 1 yr), i have set the chart width to expand correspondingly.

When the report is viewed in Acrobat reader the chart spans 2 pages...ie...data for some months are displayed on the 1st page and the rest in the second.

I suppose i' m clear now....

|||

If the report items themselves overlap, our HTML will "push" one of the items around on the page rather than displaying the items on top of one another. Our PDF will not. Would you verify that this is not the cause of the first issue?

For the second, you can dynamically (at creation time) change the <Width> tag of the <Report> element based upon how much data the user is requesting. This will allow you to keep the PDF page wide enough to fit the chart on one page rather than breaking it across pages.

Thanks, Donovan

|||

Hi,

Thanks 4 ur reply...

As 4 the first issue of overlapping i have solved it myself...had to do wit setting the Top width in the report..

As for the second issue,I am right now doing it the way u 've suggested above. But in doing so, it spans well on the Page whereas when viewed in PDF it breaks across to the second page.

One more thing....Is there a way to minimize the gap betwwen the Plotarea of the chart and the Border of the chart?

Thanks once again....

|||

Could it be you're not taking into account margins? If you have a report page width of 20" and a body width of 20" with 1" margins on the left and right, you will still get a second horizontal page.

|||What are the Top, Left, Width and Height values for the chart? Is (Chart.Left + Chart.Width) > Body.Width, which is Report.Width - Report.LeftMargin - Report.RightMargin?|||

Hi,

CHart Width is 9 in., chart top is 1.875in,I have not specified left and height for the chart

|||Are you using the default page width and margin width for the report, which is 8.5" x 11" and 1" for margins? If so, this is the reason the chart is spanning two pages. The chart width needs to be less than or equal to the page width - the margins. In this case, the chart's width should be 6.5".|||

Hi,

You can try to design your report as normal ASP.NET page and then convert that page to PDF using the he HTML to PDF library for .NET from http://www.dotnet-reporting.com or the PDF Reports Generator Library for .NET from http://www.winnovative-software.com is what you need. It's pure .NET library, it doesn't use a printer driver. There is also a free html to pdf converter application built on top of this library. The conversion can be done with only a few lines of code:

Code Snippet

PdfConverter pdfConverter = new PdfConverter();
pdfConverter.PdfDocumentOptions.PdfPageSize = PdfPageSize.A4;
pdfConverter.PdfDocumentOptions.PdfPageOrientation = PDFPageOrientation.Portrait;
pdfConverter.PdfDocumentOptions.PdfCompressionLevel = PdfCompressionLevel.Normal;
pdfConverter.PdfDocumentOptions.GenerateSelectablePdf = true;
pdfConverter.PdfDocumentOptions.ShowFooter = false;
pdfConverter.PdfDocumentOptions.ShowHeader = false;
pdfConverter.LicenseFilePath = Server.MapPath(@."~/Bin");
byte[] downloadBytes = pdfConverter.GetPdfFromUrlBytes(MyURL);

Regards,

Razva

export to excel, file not found

With sp1 installed, when a user exports a chart to excel via url
(ReportServerUrl/MyReport&rs:Command=Render&rs:Format=EXCEL ... I set this up
as a link on the report) everything works when the user has office xp
installed, but with office 2000, the user can only use the save as feature,
and then open the excel rendered chart. If the user selects "open" from the
dialog prompt, they get an error:
C:\Documents and Settings\User\Local Settings\Temporary Internet
Files\Content.IE5\KJYHDDL\Chart[1].xls Could not be found. Check the
spelling of the name ...
Is this the result of a browser setting, or server security on my end?
Thanks for any help.Have you installed Reporting Services SP1 on the server? This is required
for Office 2000 support.
--
Brian Welcker
Group Program Manager
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"JeffW" <JeffW@.discussions.microsoft.com> wrote in message
news:396BF27F-0526-43BC-BB78-D59DDE5B6058@.microsoft.com...
> With sp1 installed, when a user exports a chart to excel via url
> (ReportServerUrl/MyReport&rs:Command=Render&rs:Format=EXCEL ... I set this
> up
> as a link on the report) everything works when the user has office xp
> installed, but with office 2000, the user can only use the save as
> feature,
> and then open the excel rendered chart. If the user selects "open" from
> the
> dialog prompt, they get an error:
> C:\Documents and Settings\User\Local Settings\Temporary Internet
> Files\Content.IE5\KJYHDDL\Chart[1].xls Could not be found. Check the
> spelling of the name ...
> Is this the result of a browser setting, or server security on my end?
> Thanks for any help.|||Brian,
Thanks for your reply.
I have installed sp1 on the server, and verified that both my dev
environment and server are running version 8.00.878.00. Also, the excel
export does work, when the user chooses to save the file and then open it
(office 2000). It only fails when they try to open the exported chart
directly from the dialog that says "You are downloading the file ... Would
you like to open the file or save it to your computer ...". And it only
happens when to office 2000 or less users.
After installing sp1 on the server, I did not reboot or anything, but
confirmed that the version matched my dev environment that also has sp1.
Should I create the report from scratch or are there files/timestamps I
should be looking for on the server related to the renderer/exporter?
Thanks,
JeffW
"Brian Welcker [MSFT]" wrote:
> Have you installed Reporting Services SP1 on the server? This is required
> for Office 2000 support.
> --
> Brian Welcker
> Group Program Manager
> SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "JeffW" <JeffW@.discussions.microsoft.com> wrote in message
> news:396BF27F-0526-43BC-BB78-D59DDE5B6058@.microsoft.com...
> > With sp1 installed, when a user exports a chart to excel via url
> > (ReportServerUrl/MyReport&rs:Command=Render&rs:Format=EXCEL ... I set this
> > up
> > as a link on the report) everything works when the user has office xp
> > installed, but with office 2000, the user can only use the save as
> > feature,
> > and then open the excel rendered chart. If the user selects "open" from
> > the
> > dialog prompt, they get an error:
> >
> > C:\Documents and Settings\User\Local Settings\Temporary Internet
> > Files\Content.IE5\KJYHDDL\Chart[1].xls Could not be found. Check the
> > spelling of the name ...
> >
> > Is this the result of a browser setting, or server security on my end?
> >
> > Thanks for any help.
>
>