>I see no problem using SPT to create a cursor with all the data you need for the report. The data is not for editing so a remote veiw is not necessary. If you use SPT, you can present a setup form to the user to enter some selection parameters. Then build your SQL and send it to Oracle.

Thanks Mark,

That would help me to stop worrying about performance hit amongst the options.