Export Wijmo Grid to PDF report with parameters

Posted by: kapil.r.shah on 16 October 2019, 2:16 am EST

  • Posted 16 October 2019, 2:16 am EST

    Hi,
    I want to render a Wijmo Grid data into a pdf report.

    I want to mention the filter parameters used to display the data on Wijmo Grid on the pdf report.
    The parameters are : StartDate, End Date, User , Application Type
    I also need Header ,Footer

    At the end of the report , I want to a section for the managers to sign the report.

    What PDF API should I use for the pdf report for the requirement above.

    A sample application with report will be helpful

    Thanks,
  • Replied 16 October 2019, 8:06 pm EST

    Hi Kapil,

    You could simply use the pdf module of Wijmo. The pdf module contains API to create simple PDF documents. Also, you can directly draw the FlexGrid using the FlexGridPdfConverter class. Please find the sample attached for reference. For more information, refer to the links below:



    Let us know if you any issues or have any additional queries.

    Regards,
    Ashwin

    wijmo-pdf-angular.zip
  • Replied 20 October 2019, 6:25 am EST

    Hi Ashwin,
    I have master detail wijmo grid. I want to generate a pdf report which will show parent child i.e master detail data. Which API will help me generate master child data.

    Will FlexGridPdfConverter class support generation of pdf report with parent child data?

    I also came across
    PDFViewer
    ReportViewer --
    JS Viewer.

    So what would be the best option for me to generate pdf report with parent -child data and mention parameters like startdate, enddate, user use to generate the report.

  • Replied 20 October 2019, 9:02 pm EST

    Hi Kapil,

    To also draw the detail rows, you will need to use the drawDetailRows property and then use the formatItem event of IFlexGridDrawSettings to draw the detail rows. Please find the attached sample for reference.

    Regarding PDFViewer, etc:

    The names that you provided are the viewer controls. They are not used to create PDF or Reports. They are just used to show and already generated PDF or reports. If you create a PDF using the Wijmo's PDF API, you can show the PDF document using the PDFViewer control.

    Let me know if you still have any doubts.

    ~regards

    wijmo-pdf-angular.zip
  • Replied 21 October 2019, 11:58 pm EST

    I ran the sample project. I see that I have to select the icon to expand the detail rows data of each parent and then run the report in order to see the details rows data on the PDF report.

    Is it possible to render the pdf report without expanding detail rows on the grid using IFlexGridDrawSettings?

    What other options I have?
    Is it possible to generate the pdf report with parent- child data using Active Reports and then use the PDF Viewer / JS viewer to show the report on the client side.

    Thanks,
  • Replied 23 October 2019, 7:51 pm EST

    Hello,

    While PDF is exporting the Detail Rows content should be present in the DOM to render in PDF. Hence, it is required to expand the Detail Rows

    >>Is it possible to generate the pdf report with parent- child data using Active Reports
    Yes, it is possible with AR using the following feature:
    https://help.grapecity.com/activereports/webhelp/AR13/webframe.html#NestedDataRegionsBoundtoDifferentData.html
    I have created the sample application to implement the same. Please refer to the attachment.
    JSViewer_MVC (5).zip

    Thanks,
    Mohit
Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels