hazelsisson
Programmer
Hi!
I have a portal application which outputs data based on options the user chooses, and the resulting data can be downloaded in an Excel format. I have managed this in the past by creating a portal report using the "reports From SQL Query" option, which accepts the user's chosen parameters.
The problem is that my current query is a ref cursor, and the query can be anything from 3 lines long to 15 depending on which options the user chooses.
Is there any way I can pass the whole query to the report rather than just bind variables? The query also specifies joins with other tables as required.
Another idea I had was to put the data into a temporary table and then select it from that, but I don't think the report generator recognises the temporary table until it has been created.
I hope that all makes sense! Any advice would be greatly appreciated.
Thanks,
Hazel
I have a portal application which outputs data based on options the user chooses, and the resulting data can be downloaded in an Excel format. I have managed this in the past by creating a portal report using the "reports From SQL Query" option, which accepts the user's chosen parameters.
The problem is that my current query is a ref cursor, and the query can be anything from 3 lines long to 15 depending on which options the user chooses.
Is there any way I can pass the whole query to the report rather than just bind variables? The query also specifies joins with other tables as required.
Another idea I had was to put the data into a temporary table and then select it from that, but I don't think the report generator recognises the temporary table until it has been created.
I hope that all makes sense! Any advice would be greatly appreciated.
Thanks,
Hazel