Oracle 10gXE
APEX 3.2

If I have a LOV on a page, which the user can either select PDF, HTML, or CSV reports, is it possible that the button used to run the report will either link to a URL (for Oracle Reports) if either PDF or HTML is selected, or go to a page within the app, passing the item values if CSV is selected?

The reason being is that we have a need to provide the end user with different output formats of the same report. The Oracle Report looks fine for PDF and HTML output, but the CSV output is not so great, requiring us to almost create a separate version for the CSV report. APEX seems to do a much better job for CSV output, although it would mean copying the SQL out of each Oracle Report and creating an APEX report page for each one. I already have a "parameter page" working for the Oracle Reports, where the user can provide all the input needed for the report to run, but want to avoid having to create separate APEX report pages that each contain the same parameter selection.

Any ideas?

Why dont you try to reference that page (Apex report) with its URL instead of page # ? this way , your button will have three different Links to branch to based on the selected report type.

Denes,

Are you suggesting maybe having a single report page based on the all the Report Regions that are used for CSV reporting? Which APEX dictionary view contains this information?

Denes,

Thanks for the information. You've got quite an informative site there!