Show full column text while Exporting a report Table

[systems]

Hello, 
We have encounter an issue while exporting a Report, may be someone can advise us here.

Issue: While binding the data to Report Table fieldset , for one of the column we are showing only limited initial chars 
for better view. e.g. Substring(Fields.Note,0,20)

However, If we export the report into excel, the same text gets exported as it gets renders. i.e only 20 chars.
Is there a way to export the entire text for that column without getting cut short?

We use telerik reporting V8.2.14.1204
See attached image for better understanding.

Thanks,
Nitin

[Stef]

Hi Nitin,

The report exported through the viewer will have the same content as the one displayed in it. You can export programmatically a separate instance of the report or another one, where data is not truncated - Exporting Report Programmatically.

Regards,
Stef
Telerik

[systems]

Thanks Stef for your suggestion. 

However,If we opt for programmatic export, Is there a way we can plug an event on the existing Reporting Toolbar>Export action, from where we are currently exporting the reports.

Since we have many reports, we wish to keep the same user experience for this specific report too rather than having separate Export button on outside the report.

Also, do we have a demo tutorial/application which explains the programmatic export actions.

Thanks,

Nitin

 

[Stef]

Hi Nitin,

If you are using the old ASP.NET WebForms ReportViewer, you can use the approach from the Custom Toolbar for the Web ReportViewer blog post. It relies on using custom UI and the viewer's Client-side API. In the custom toolbar you can add your own export button.

If you are using the HTML5 Viewer, it is an HTML/JS/CSS based client-side widget. You can modify its HTML, CSS, JS template files (Providing Templates), or use external CSS/JS to add/remove HTML elements. The viewer's API allows you to use its methods and commands to perform the export operation from custom UI - data attributes and commands.


an example of exporting programmatically a report is available in the Print a report directly at client-side without displaying it in an ASP.NET ReportViewer code library post (exclude the deviceInfo line to get a PDF file at the client).

Regards,
Stef
Telerik

[systems]

Thanks Stef, Yes we are using HTML5 Report Viewer and I understand your sugestion to have custom template for such specific reports. In our case there are more than 40+ reports using the same template and we are loading the report as shown below. 

Would be interested to know if there is any export/rendor property to keep only excel option that we can set during report initialization

$("#reportViewer1")
            .telerik_ReportViewer({
                serviceUrl: '<%= ResolveClientUrl("~/api/reports/")%>',
                templateUrl: '<%= ResolveClientUrl("~/ReportViewer/templates/telerikReportViewerTemplate-8.2.14.1204.html")%>',
                reportSource: {
                    report: marcReportName + ", MaRc.Reports",
                    parameters: marcReportParameters
                },
                viewMode: telerikReportViewer.ViewModes.INTERACTIVE,
                scaleMode: telerikReportViewer.ScaleModes.SPECIFIC,
                scale: 1.0,
             // Some parameter here to set XLSX only as a export option
            });

           var viewer = $("#reportViewer1").data("telerik_ReportViewer");
           viewer.reportSource({
               report: viewer.reportSource().report, parameters: marcReportParameters,
           });
           viewer.refreshReport();

[Stef]

Hi,

The available export options are determined by the settings of the Reporting REST service's project. You can limit the export options for all viewers served by a given service, by adding the configuration settings from Limit export options in ReportViewer to certain format only.

If you want to limit the export options per report, then you will have to modify the viewer's UI (hide the default export options) and to provide custom UI listing only the export options you need. The custom UI can handle the export through the viewer's API (data attributes and commands).

Regards,
Stef
Telerik

[systems]

Hi stef,

   Particular report export option list customization problem solved by making changes in CSS.

   Below link is helpful for export option customization.

http://www.telerik.com/forums/disable-excel-from-report-viewer-export-option

Thanks

-Nitin