Data Sets -> Generate SQL Views [message #1836333] |
Tue, 29 December 2020 11:21  |
Eclipse User |
|
|
|
Hello, I want to generate a Report form a very simple DataSet Query:
select * from CombinedViewOrdered
where "SAMPLE" is not null;
But the Problem is that every time I want to run the Report the ORACLE SQL View
"CombinedViewOrdered" has to be recreated (replaced)
And this View depends on another view called "CombinedView" that needs to be also recreated before I do my 'select' Query.
My Database User is allowed to create and replace views and to do selects, but NOT to execute stored procedures.
In an ORACLE SQL Development Environment I would just execute a single *.sql File that contains the statements that create the multiple views and then do the select at the end.
Now I am looking for the same way in BIRT Reporting Tool.
Basically every time when I create my Result Set with my Data Set I want that the views are replaced beforehand ( this needs to be executed by the BIRT reporting tool with the existing permissions of the Data Source)
How can I do that ?
Thanks in advance
|
|
|
|
Powered by
FUDForum. Page generated in 0.03450 seconds