Show full column text while Exporting a report Table

7 posts, 0 answers
  1. systems
    systems avatar
    70 posts
    Member since:
    Dec 2013

    Posted 07 Jun Link to this post

    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

  2. Stef
    Admin
    Stef avatar
    3036 posts

    Posted 08 Jun Link to this post

    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
    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
  3. DevCraft banner
  4. systems
    systems avatar
    70 posts
    Member since:
    Dec 2013

    Posted 08 Jun in reply to Stef Link to this post

    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

     

  5. Stef
    Admin
    Stef avatar
    3036 posts

    Posted 09 Jun Link to this post

    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
    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
  6. systems
    systems avatar
    70 posts
    Member since:
    Dec 2013

    Posted 10 Jun Link to this post

    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();

  7. Stef
    Admin
    Stef avatar
    3036 posts

    Posted 10 Jun Link to this post

    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
    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
  8. systems
    systems avatar
    70 posts
    Member since:
    Dec 2013

    Posted 13 Jun in reply to Stef Link to this post

    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

Back to Top
DevCraft banner