Skip to Content
Former Member
Aug 04, 2008 at 12:04 PM

Dynamic SQL to new Document



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.