I am calling data page from data transform and data page inturn calls the report definition. I see sometimes data pages doesn't return right results.
I am configuring the grid layout that is sourced by report definition and one more grid sourced by data page. I do see different results in both grids. Grid configured by Report definition returns the correct result always. I thought the data page is cached that could be the reason, so I changed the data page to load once per interaction, and still my results are not correct. Please find teh below screenshots for your reference.
Another qn: Is it possible to call report definition directly from Data transform? If yes, please let me know the syntax to call report definition from data transform.
Use call activity function in the data transform, use the OOTB activity (Rule-Obj-Report-Definition.pxRetrieveReportData ) to execute the report definition. Pass the necessary parameters to execute the RD in the Data transform.
Have you run a trace with DB Query events enabled to see the SQL being generated in both scenarios? They should be the same. Are you performing any data transforms on the report results within the data page? Perhaps that's affecting the output.
Keep in mind that you might be better off referencing the report definition directly in the grid. RD-based grid layouts will use paging to only fetch the number of rows needed for display. If you use a data page, you'll fetch the full data set and paging will be done in memory. This places a heavier load on the server.