Question
Virtusa
IN
Last activity: 12 May 2025 5:29 EDT
Filter relationship is not populating in report definition
Hi
I have sub report which results one of the property called Type. I need to use this property (Type) as a filter in main report when i try to use this property as a filter in main report filter relation is not populating it was just showing blank. Please Let me know if any answers.
Attached screenshot for reference.
Thanks,
Yasvanth T.
Capgemini
IN
Hi @Yasvanth Tanuku,
I guess their might be a configuration issue in subreport on data access tab.
While configuring sub report we need to specify where the columns are going to be used (see below)
Also you need to provide alias to the sub report columns and use the alias in main report.
Hope it helps! Let me know if it works.
Thanks, Ankit
Virtusa
IN
@im-ankit I have selected it properly there is no issue with configuration in sub report
one more thing the property that I want to use as filter is exposed
Capgemini
IN
@Yasvanth Tanuku, If possible could you share the subreport configurations.
Also if the filter you are applying filter in main report is based on subreport column, then I guess it makes more sense to use that filter directly is subreport so the it will give filtered data to main report reducing the need of using the filter in main report.
