Sunday, March 25, 2012
changing the format for rendering a chart in a report on an aspx p
I have some customers that are experiencing the text displaying somewhat
broken up on a report with a chart in it on an aspx page.
If I right click on the report on the page the properties show the chart is
in PNG format.
I was told to change the type to jpg because jpg can handle fonts better.
I tried the Render IMAGE OutputFormat=JPEG on the URL but it acts like I
want to export it to JPG. I just want to display it on the aspx page in jpg
format.
Can this be done, if so how do i do it?Please check my response on your first posting.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Steve" <Steve@.discussions.microsoft.com> wrote in message
news:69172CD1-2139-42AC-A1B1-C00BDB796C93@.microsoft.com...
> Sorriy if this shows up twice. I posted it already but didn't see in the
> list.
> I have some customers that are experiencing the text displaying somewhat
> broken up on a report with a chart in it on an aspx page.
> If I right click on the report on the page the properties show the chart
> is
> in PNG format.
> I was told to change the type to jpg because jpg can handle fonts better.
> I tried the Render IMAGE OutputFormat=JPEG on the URL but it acts like I
> want to export it to JPG. I just want to display it on the aspx page in
> jpg
> format.
> Can this be done, if so how do i do it?
>sql
Friday, February 24, 2012
Changing labels inside the rdl on runtime
Is it possible to change labels inside a report before rendering it? I need
to localize some labels before the report is shown in my
WinForms-Application. I do not want to have one report for each language.
Sometimes I need to change some more things in the report not only labels.
So, how can I get access to all the controls (lists, textboxes, subreports
etc.) of my report?
Thanks
MichaelThe approach I took was a custom assembly with a resource file. I park the
language identifier in a property then use an accessor method in the
assembly to fetch the string from the correct resource file. You can pass
in the ReportItems object into a custom assembly or code behind. If the
report has a page with no rows I've had trouble with this and wasn't able to
figure it out.
Thanks,
Steve MunLeeuw
"Michael Reukauff" <mreukauff@.gmx.net> wrote in message
news:O$Tk2LdpGHA.4996@.TK2MSFTNGP05.phx.gbl...
> Hi
> Is it possible to change labels inside a report before rendering it? I
> need to localize some labels before the report is shown in my
> WinForms-Application. I do not want to have one report for each language.
> Sometimes I need to change some more things in the report not only labels.
> So, how can I get access to all the controls (lists, textboxes, subreports
> etc.) of my report?
> Thanks
> Michael
>
Tuesday, February 14, 2012
Changing Default Rendering Method of Reports
Ladies and Gents,
I have a question with regards to the default rendering extensions for reports. I am using RS 2005 with SP1.
I am accessing a report as follows:
http://<ReportServerName>/Reportserver?/<Folder>/<Report Name>
Sample: http://TestServer/Reportserver?/Special Reports/Dealer Report
This displays the parameter bar and the view report button. When pressing the view report button, the report is automatically rendered into HTML 4.0. Is there a way to use the existing parameter bar and automatically render the report to a different extension (such as PDF) when the parameters are entered and the View Report Button is pressed.
Thank You for any advice you can give,
Raph
No, but you can specify the render format in the report URL, e.g. http://TestServer/Reportserver?/Special Reports/Dealer Report&rs:Format=PDF&rs:Command=Render|||Teo,
Thank you for your reply, and for all the other documents and articles you have created about reporting services. They have been a great help during my current project.
I was trying to prevent reinventing the wheel. By that, I mean having to create a web form to capture the parameters for our reports when the report server seems to have one that works effectively (with the exception that the default format of report rendering is HTML 4.0 which behaves very poorly with alternative browsers) .
If you have any advice on any existing parameter capture tool that anyone has developed with RS that will allow us to choose the render method, I would be happy to take it.
Again, Thanks for the quick reply.
Raph
|||I understand but the standard toolbar is not customizable and you have no way to capture the event. If this was a custom web application and use the ASP.NET 2.0 ReportViewer control, then you could capture the event. Now, if you want to get innovative, you could create an HttpHandler that will change the URL requests accordingly. If you decide to do so, you may find my RSHttpHandler sample useful (see the Chapter 18 code in this download).|||Teo,
Again, thanks for the help. I will look into your suggestions and see if they can be leveraged to meet our needs.
Raph
|||I have a question similar to this - about changing default rendering:
I only want to change the default zoom to be page width. I'm not sure if I'm able to do this in the following environment:
RS 2005 SP2 on top of SharePoint Services 3.0 - I'm using the ReportViewer web part. Given that real estate is a bit of an issue when rendering webparts in a sharepoint page with other content, I'd like the default zoom to be page width based on the height and width of the webpart - so that I don't have to scroll horizontally within the webpart to see the report.
I know you can resize the webpart window - but I've got other content on the page, and I can't make it large enough to display the report width, so I'd like the default zoom to fit the size of the webpart (at least horizontally, scrolling vertically is not a big deal.
Is there a way to set this so that the Report Viewer web part can be configured to do this?
Thanks
|||I'm not really sure whether you could do this using your current technology, but it certainly seems possible:
http://msdn2.microsoft.com/en-us/library/ms152835.aspx
|||Unfortunately, the Report Viewer web part doesn't surface the ZoomMode property of the underlying ASP.NET Report Viewer control. I suggest you add this to the wish list.|||I had to write my own web part to accomplish this in sts 2.0. SQL Server 2005 Service pack 2 was released recently, this allows you to run Sharepoint integration mode and possibly get a better view on reports.The following example uses the rc:Zoom parameter to set the zoom property of the report to Page Width: http://servername/reportserver?/Sales/YearlySalesSummary&rs:Command=Render&rs:Format=HTML4.0&rc:Zoom=Page Width
Changing Default Rendering Method of Reports
Ladies and Gents,
I have a question with regards to the default rendering extensions for reports. I am using RS 2005 with SP1.
I am accessing a report as follows:
http://<ReportServerName>/Reportserver?/<Folder>/<Report Name>
Sample: http://TestServer/Reportserver?/Special Reports/Dealer Report
This displays the parameter bar and the view report button. When pressing the view report button, the report is automatically rendered into HTML 4.0. Is there a way to use the existing parameter bar and automatically render the report to a different extension (such as PDF) when the parameters are entered and the View Report Button is pressed.
Thank You for any advice you can give,
Raph
No, but you can specify the render format in the report URL, e.g. http://TestServer/Reportserver?/Special Reports/Dealer Report&rs:Format=PDF&rs:Command=Render|||Teo,
Thank you for your reply, and for all the other documents and articles you have created about reporting services. They have been a great help during my current project.
I was trying to prevent reinventing the wheel. By that, I mean having to create a web form to capture the parameters for our reports when the report server seems to have one that works effectively (with the exception that the default format of report rendering is HTML 4.0 which behaves very poorly with alternative browsers) .
If you have any advice on any existing parameter capture tool that anyone has developed with RS that will allow us to choose the render method, I would be happy to take it.
Again, Thanks for the quick reply.
Raph
|||I understand but the standard toolbar is not customizable and you have no way to capture the event. If this was a custom web application and use the ASP.NET 2.0 ReportViewer control, then you could capture the event. Now, if you want to get innovative, you could create an HttpHandler that will change the URL requests accordingly. If you decide to do so, you may find my RSHttpHandler sample useful (see the Chapter 18 code in this download).|||Teo,
Again, thanks for the help. I will look into your suggestions and see if they can be leveraged to meet our needs.
Raph
|||I have a question similar to this - about changing default rendering:
I only want to change the default zoom to be page width. I'm not sure if I'm able to do this in the following environment:
RS 2005 SP2 on top of SharePoint Services 3.0 - I'm using the ReportViewer web part. Given that real estate is a bit of an issue when rendering webparts in a sharepoint page with other content, I'd like the default zoom to be page width based on the height and width of the webpart - so that I don't have to scroll horizontally within the webpart to see the report.
I know you can resize the webpart window - but I've got other content on the page, and I can't make it large enough to display the report width, so I'd like the default zoom to fit the size of the webpart (at least horizontally, scrolling vertically is not a big deal.
Is there a way to set this so that the Report Viewer web part can be configured to do this?
Thanks
|||I'm not really sure whether you could do this using your current technology, but it certainly seems possible:
http://msdn2.microsoft.com/en-us/library/ms152835.aspx
|||Unfortunately, the Report Viewer web part doesn't surface the ZoomMode property of the underlying ASP.NET Report Viewer control. I suggest you add this to the wish list.|||I had to write my own web part to accomplish this in sts 2.0. SQL Server 2005 Service pack 2 was released recently, this allows you to run Sharepoint integration mode and possibly get a better view on reports.The following example uses the rc:Zoom parameter to set the zoom property of the report to Page Width: http://servername/reportserver?/Sales/YearlySalesSummary&rs:Command=Render&rs:Format=HTML4.0&rc:Zoom=Page Width
Changing Default Rendering Method of Reports
Ladies and Gents,
I have a question with regards to the default rendering extensions for reports. I am using RS 2005 with SP1.
I am accessing a report as follows:
http://<ReportServerName>/Reportserver?/<Folder>/<Report Name>
Sample: http://TestServer/Reportserver?/Special Reports/Dealer Report
This displays the parameter bar and the view report button. When pressing the view report button, the report is automatically rendered into HTML 4.0. Is there a way to use the existing parameter bar and automatically render the report to a different extension (such as PDF) when the parameters are entered and the View Report Button is pressed.
Thank You for any advice you can give,
Raph
No, but you can specify the render format in the report URL, e.g. http://TestServer/Reportserver?/Special Reports/Dealer Report&rs:Format=PDF&rs:Command=Render|||Teo,
Thank you for your reply, and for all the other documents and articles you have created about reporting services. They have been a great help during my current project.
I was trying to prevent reinventing the wheel. By that, I mean having to create a web form to capture the parameters for our reports when the report server seems to have one that works effectively (with the exception that the default format of report rendering is HTML 4.0 which behaves very poorly with alternative browsers) .
If you have any advice on any existing parameter capture tool that anyone has developed with RS that will allow us to choose the render method, I would be happy to take it.
Again, Thanks for the quick reply.
Raph
|||I understand but the standard toolbar is not customizable and you have no way to capture the event. If this was a custom web application and use the ASP.NET 2.0 ReportViewer control, then you could capture the event. Now, if you want to get innovative, you could create an HttpHandler that will change the URL requests accordingly. If you decide to do so, you may find my RSHttpHandler sample useful (see the Chapter 18 code in this download).|||Teo,
Again, thanks for the help. I will look into your suggestions and see if they can be leveraged to meet our needs.
Raph
|||I have a question similar to this - about changing default rendering:
I only want to change the default zoom to be page width. I'm not sure if I'm able to do this in the following environment:
RS 2005 SP2 on top of SharePoint Services 3.0 - I'm using the ReportViewer web part. Given that real estate is a bit of an issue when rendering webparts in a sharepoint page with other content, I'd like the default zoom to be page width based on the height and width of the webpart - so that I don't have to scroll horizontally within the webpart to see the report.
I know you can resize the webpart window - but I've got other content on the page, and I can't make it large enough to display the report width, so I'd like the default zoom to fit the size of the webpart (at least horizontally, scrolling vertically is not a big deal.
Is there a way to set this so that the Report Viewer web part can be configured to do this?
Thanks
|||I'm not really sure whether you could do this using your current technology, but it certainly seems possible:
http://msdn2.microsoft.com/en-us/library/ms152835.aspx
|||Unfortunately, the Report Viewer web part doesn't surface the ZoomMode property of the underlying ASP.NET Report Viewer control. I suggest you add this to the wish list.|||I had to write my own web part to accomplish this in sts 2.0. SQL Server 2005 Service pack 2 was released recently, this allows you to run Sharepoint integration mode and possibly get a better view on reports.The following example uses the rc:Zoom parameter to set the zoom property of the report to Page Width: http://servername/reportserver?/Sales/YearlySalesSummary&rs:Command=Render&rs:Format=HTML4.0&rc:Zoom=Page Width