I have created a new document such as
DocumentInstance doc = reportEngine.newDocument(unvId);
I am able to create a new report with fields available in universe dynamically. I am able to view the SQL also. I want to create a report with dynamic sql. I am able to change the sql instead of existing SQL. But the number of columns and type of columns should be same otherwise it is giving an exceptions.
Can anybody tell me how to create a report using a dynamic sql?
Thanks in advance.