Complex Report - views or temporary tables

[dbigelow]

I need to be able to have users enter parmeters which then would be used to build views or temporary tables basded on the user input -- I am using version 11 and not sure if this is even possible. I can write the code in SQL but again everything depends on the user input.

Thank you,

 

[IdoMillet]

Views don't support parameters -- Stored procedures do. Your question is too general. More specifics may allow a more productive discussion.

- Ido

view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[synapsevampire]

Use an SP to gather the criteria, create the Views, then use select <field list> from <view> to gnertae the data for the report.

Ido bringupagoodpoint in that your requirements are too vague, given your approach you'd be better servedto provide example data and expected output. You don't even post your software version or the database being used.

-k