join report definition result retrieve using data page
i'm use report definition for join two table(use Data access) then i'm add that report definition in data page but i can't retrieve second table result.
data page retrieve pxResult(1),pxResult(2) how can i retrieve this pxResult(1) and (2) data
Accepted Solution
Updated: 4 Jul 2023 12:04 EDT
Coforge
IN
if you have used correct joining conditions & also getting expected data on running RD standalone. Then you will also get the results in data page (it should be of type list). But you won’t find the results of joining tables directly in pxResults. You will see 2 pages under each pxResults of data page containing data from respective joined classes.
example :
D_DataPage.pxResults(1).pxPages(A)
D_DataPage.pxResults(1).pxPages(B)
HCL Technologies Limited
IN
Could you please tell the applies to class of your report definition rule? Also could you please confirm whether your data page has list structure not the Page.
Thanks,
Bala
Accepted Solution
Updated: 4 Jul 2023 12:04 EDT
Coforge
IN
if you have used correct joining conditions & also getting expected data on running RD standalone. Then you will also get the results in data page (it should be of type list). But you won’t find the results of joining tables directly in pxResults. You will see 2 pages under each pxResults of data page containing data from respective joined classes.
example :
D_DataPage.pxResults(1).pxPages(A)
D_DataPage.pxResults(1).pxPages(B)