If you grid is sourced with the report definition then you can look into my use case to add a export link in your section to export the data into excel. If your grid is sourced with page list then in the activity you can use the page list instead of report definition as source of data.
I have applied your steps in my usecase but the things is my report definition properties are different . Iam attaching a screen shot please have a look on it. How should i add those properties in CSVProperties column in activity while calling Call pxConvertResultsToCSV. py|ID is working fine. If iam adding other propeties same as report definition as it is in the CSVProperties column then it is displaying error "invalid expression"
Please guide me for the same how to add my report definition properties in my usecase.
Can you run your report and expand the pyReportContentPage > pxResults > pxPages and show the output of your clipboard data as i would like to see the output of your report definition. Also show the Data access tab configuration of your report definition.
see i have used this soln for my above posted question:
firstly i run the report by calling Call Rule-Obj-Report-Definition.pxRetrieveReportData.
Then it asks for parameters: pyReportName: my report definition name i mentioned, pyReportClass: my report definition class name in which i have created my report, pyPageName: here we have to mention the page name which we have to define in pages and classes tab of class Code-Pega-List. In my case , the page name i set in pages and classes tab is Report with class Code-Pega-List.
Code-Pega-List will retrieve list of all records. Run this activity, once you get the correct execution of this step.
Then to export to pdf : Call pzViewExportToExcel then it asks for PrimaryPageName: PageName.pyReportDefinition. In my case it is Report.pyReportDefintion.