Showing posts with label preview. Show all posts
Showing posts with label preview. Show all posts

Thursday, March 29, 2012

Export formats

I have created report project using Business Intelligence Development Studio. When i use Preview tab or run report from Visual Studio in debug mode there is 6 formats available for export. But when i open the same report in Windows Forms based application using ReportViewer control there is only 2 export formats: PDF and Excel. How can i configure ReportViewer control to show all export formats?

I do not know what "Windows Forms based application" you are using, but the list of available formats is in rsReportServer.config in the <Render> section. You should see about 10 <Extension Name> entries. This tag has a 'Visible' attribute that can hide extensions (Visible="false"). This is how our custom viewer determines what is available.

Also note that the server returns these in the order that they are in the config file, so you can arrange them here. And, the first item will be the default.

Scotteb

|||

The report viewer controls are limited to PDF and Excel:

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

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

Thanks, Donovan.

|||

Igor,

Is your Windows Forms application configured to use the ReportViewer control in local mode, or in server mode?

ReportViewer control in local mode (where your report is in .rdlc file in the application project, and your application doesn't connect to the Reporting Services server) has only PDF and Excel renderers. They are built into the control itself.

If you want to use renderers from the report server, you would have to use the control in server mode, publishing the report to the Reporting Services server and changing data binding as appropriate.

|||

Donovan Smith - MS wrote:

The report viewer controls are limited to PDF and Excel:

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

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

OK, i have read something like that. But Microsoft's RSReportHost.exe use the same ReportViewer control and has 6 formats available.

|||

Denis Levin MSFT wrote:

Is your Windows Forms application configured to use the ReportViewer control in local mode, or in server mode?

ReportViewer control in local mode (where your report is in .rdlc file in the application project, and your application doesn't connect to the Reporting Services server) has only PDF and Excel renderers. They are built into the control itself.

If you want to use renderers from the report server, you would have to use the control in server mode, publishing the report to the Reporting Services server and changing data binding as appropriate.

ReportViewer control in my application is configured to use server mode. And report is on server.

|||

scotteb wrote:

I do not know what "Windows Forms based application" you are using, but the list of available formats is in rsReportServer.config in the <Render> section. You should see about 10 <Extension Name> entries. This tag has a 'Visible' attribute that can hide extensions (Visible="false"). This is how our custom viewer determines what is available.

My <Render> section looks like this:

<Render>

<Extension Name="XML" Type="Microsoft.ReportingServices.Rendering.XmlDataRenderer.XmlDataReport,Microsoft.ReportingServices.XmlRendering"/>

<Extension Name="NULL" Type="Microsoft.ReportingServices.Rendering.NullRenderer.NullReport,Microsoft.ReportingServices.NullRendering" Visible="false"/>

<Extension Name="CSV" Type="Microsoft.ReportingServices.Rendering.CsvRenderer.CsvReport,Microsoft.ReportingServices.CsvRendering"/>

<Extension Name="IMAGE" Type="Microsoft.ReportingServices.Rendering.ImageRenderer.ImageReport,Microsoft.ReportingServices.ImageRendering"/>

<Extension Name="PDF" Type="Microsoft.ReportingServices.Rendering.ImageRenderer.PdfReport,Microsoft.ReportingServices.ImageRendering"/>

<Extension Name="RGDI" Type="Microsoft.ReportingServices.Rendering.ImageRenderer.RemoteGdiReport,Microsoft.ReportingServices.ImageRendering" Visible="false" LogAllExecutionRequests="false"/>

<Extension Name="HTML4.0" Type="Microsoft.ReportingServices.Rendering.HtmlRenderer.Html40RenderingExtension,Microsoft.ReportingServices.HtmlRendering" Visible="false" LogAllExecutionRequests="false"/>

<Extension Name="HTML3.2" Type="Microsoft.ReportingServices.Rendering.HtmlRenderer.Html32RenderingExtension,Microsoft.ReportingServices.HtmlRendering" Visible="false"/>

<Extension Name="MHTML" Type="Microsoft.ReportingServices.Rendering.HtmlRenderer.MHtmlRenderingExtension,Microsoft.ReportingServices.HtmlRendering"/>

<Extension Name="EXCEL" Type="Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer,Microsoft.ReportingServices.ExcelRendering"/>

</Render>

As you can see XML, CSV, IMAGE and MHTML formats are not disabled. And they are indeed available when report is rendered by Microsoft's RSReportHost.exe. But in my own application ReportViewer control shows only Excel and PDF.

|||

Just to troubleshoot the issue, can you render the report in Report Manager (http://localhost/Reports) on the server, and check which rendering extensions are available in the server's Export drop-down box.

Thanks

|||

Denis Levin MSFT wrote:

Just to troubleshoot the issue, can you render the report in Report Manager (http://localhost/Reports) on the server, and check which rendering extensions are available in the server's Export drop-down box.

Server's drop-down box is also limited to PDF and Excel formats. Is this limitation of reporting services in SQL Server 2005 express edition?

|||

Yes. Export on SQL2005 Express Edition is limited to PDF and Excel.

Thanks, Donovan

sql

Friday, March 9, 2012

Expect Parameters which was not supplied when hit the preview tab

I'm creating my reports and connect to the stored procedure. The results of
data returned when I'm on Data Tab. However when I hit the Preview Tab I got
the error said "An error has occured during report processing. Query
execution failed for data set "TheNameOfMyData". Procedure
"MyWebProcedureName" expect parameters "@.Blah_1" which was not supplied".
What was wrong with the errors? Do I have to pass the parameters. If
so...how do I pass the parameters? Help would much appreciate.One of two things has happened. Either you do not have report parameters or
you have report parameters and the query parameters are not mapped to the
report parameter. Usually, but not always, RS creates the report parameter
automatically for you.
In the data tab click on the ..., go to parameters tab. It should like all
your query parameters and what report parameter it maps to. If empty then go
to layout, click somewhere on blank part of the report. go to the menu
report->parameters. You need to have a report parameter per query parameter
(or rather you should have the report parameters you want to map to the
query parameters to be listed). If not there then add them. Then go back to
the data tab, click on the ... and map the query parameters to the report
parameters.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"MissQti" <MissQti@.discussions.microsoft.com> wrote in message
news:2F93E890-EB2E-4346-A9CF-6A8DA5E49AF3@.microsoft.com...
> I'm creating my reports and connect to the stored procedure. The results
> of
> data returned when I'm on Data Tab. However when I hit the Preview Tab I
> got
> the error said "An error has occured during report processing. Query
> execution failed for data set "TheNameOfMyData". Procedure
> "MyWebProcedureName" expect parameters "@.Blah_1" which was not supplied".
> What was wrong with the errors? Do I have to pass the parameters. If
> so...how do I pass the parameters? Help would much appreciate.|||BIG THANKS to Bruce for the help. It worked when I mapped the report
parameter to query parameters.
"Bruce L-C [MVP]" wrote:
> One of two things has happened. Either you do not have report parameters or
> you have report parameters and the query parameters are not mapped to the
> report parameter. Usually, but not always, RS creates the report parameter
> automatically for you.
> In the data tab click on the ..., go to parameters tab. It should like all
> your query parameters and what report parameter it maps to. If empty then go
> to layout, click somewhere on blank part of the report. go to the menu
> report->parameters. You need to have a report parameter per query parameter
> (or rather you should have the report parameters you want to map to the
> query parameters to be listed). If not there then add them. Then go back to
> the data tab, click on the ... and map the query parameters to the report
> parameters.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "MissQti" <MissQti@.discussions.microsoft.com> wrote in message
> news:2F93E890-EB2E-4346-A9CF-6A8DA5E49AF3@.microsoft.com...
> > I'm creating my reports and connect to the stored procedure. The results
> > of
> > data returned when I'm on Data Tab. However when I hit the Preview Tab I
> > got
> > the error said "An error has occured during report processing. Query
> > execution failed for data set "TheNameOfMyData". Procedure
> > "MyWebProcedureName" expect parameters "@.Blah_1" which was not supplied".
> >
> > What was wrong with the errors? Do I have to pass the parameters. If
> > so...how do I pass the parameters? Help would much appreciate.
>
>