I was facing the following error while creating a new report in Jasper Studio.
When i try connecting to a domain, i am able to add only fields from one able.
As soon as i select field/s from 1 table, all other tables are greyed out.
Thanks in advance.
First of all designing reports based on domain is not a best practice as it has performance overhead, you may wish to take a look at our report development guide for detailed steps.
Thank you for the suggestion.
It would be of great help if you could send the link to Report Development guide or if there we any best practice guide.
Here is the link for report development guide
CA PPM Advanced Reporting and Database Schema Index - CA Technologies
The best practice document is getting prepared and should be out soon.
Thank you providing the details.
Hence you suggest to use the existing domains to build new reports,
Please correct me if i am wrong.
No, I am requesting you to write a SQL to build studio reports, you can use domain to build adhoc views.
Thank you for you suggestion.
We shall try regarding that and let you know in case of any issues.