Question
Plexus Tech
ES
Last activity: 31 Jan 2019 16:30 EST
Reports: is posible a filter with data from a data Reference data?
In a report is it possible to use the values retrieved from a data Reference data in a filter?
I have a data Reference data called D_ReferenceDataF1 with a column with information I need to retrieve in format: "Value1", "value2",..., to include it as a multiple value of a filter in a column in a report. Using the invocation "D_ReferenceDataF1[...]..pxResults(...)"
Thanks so much.
Accepted Solution
Plexus Tech
ES
Hi Bhavya,
I appreciate your answer.
I have seen that it can be done including in the "Data Access" tab, in the "Class joins" section, the data Reference data component and works. I indicate the name of the data Reference data in the column "Class name" and in the column "Type" specific "include all rows in joined Class"
Thanks so much!
Miguel.
Coforge DPA
GB
Hi
I dont think you can use a parameterized Data page in report definition filter.
You would need to store the values in a separate string property as "Value 1","Value2" ... and then use that property in filter.
Regards
Bhavya
Accepted Solution
Plexus Tech
ES
Hi Bhavya,
I appreciate your answer.
I have seen that it can be done including in the "Data Access" tab, in the "Class joins" section, the data Reference data component and works. I indicate the name of the data Reference data in the column "Class name" and in the column "Type" specific "include all rows in joined Class"
Thanks so much!
Miguel.