This question is related to input controls in custom jaspersoft report. I have a report that uses normal transactional data source 'CA PPM BEAN' to show data. Can I use 'CA PPM DWH BEAN' data source only to populate data in input controls?
I want to use DWH data source in input control so as to put security conditions on the data shown in parameters. If I am using normal odf security tables, then it's taking huge time to populate data in input controls, which would be for sure not at all convenient for end users.
Thanks in advance,
No you cannot use mixed datasource to build the reports. Please check how we use our out of box input controls and the performance is better,
Thanks Suman for your quick response.
I have checked the OTB input controls but as the data source is same in both the places (Input controls & Query design) in out of box reports, the performance is better.
However, currently I am using PPM data source in the report query. So, do you have any other suggestion to restrict the projects shown in input parameters, apart from the odf security tables in input control query?
Nope thats the table which holds the security.
Ok, so only option I am left with is to use DWH data source in my report, right?