| Running Oracle 6i Reports On Web [message #110997] |
Fri, 11 March 2005 13:27  |
Matloob
Messages: 39
Registered: December 2004
|
Member |
|
|
hi there
my problem is that
i have develop a report which take some paramteres to provide me some precise sort of information
i want to run that on web
and the user can enter the parameters on web and then the report can be displayed plz do provide me the way how to do sooo.
thanks
|
|
|
|
| Re: Running Oracle 6i Reports On Web [message #111002 is a reply to message #110997] |
Fri, 11 March 2005 14:56  |
Steve Corey
Messages: 336
Registered: February 2005
Location: RI
|
Senior Member |
|
|
This can be a lengthy process.
You will need:
Access to the System Administrator responsibility
Creation of a flexfield value set (will tell you how)
Creation of values for that particular value set (may not apply)
Before I can truly answer this, I need to know a little more from you. Do you want a list of values for the possible parameter values? OR do you want just a parameter field the user enters some information and then the SQL handles the result sets?
If former, then there are two possible ways to do it:
Create a list of values from a table column OR
Create a list of values with your own possible values
If it is the latter, then setup is quick and simple. What I mean by SQL handling the result sets is
User enters value 'ABCD' and the parameter is say PO Number
In your SQL you would have in your WHERE clause
AND table_name.po_number_column LIKE :p_parameter || '%'
So, get back to me on which of the 3 you need or if you need all 3.
Choices again are:
1) List of values with values from a table column
2) List of values with your own values inserted
3) Just enter some information and my SQL will handle it
|
|
|
|
| Re: Running Oracle 6i Reports On Web [message #111004 is a reply to message #111002] |
Fri, 11 March 2005 15:12 |
Matloob
Messages: 39
Registered: December 2004
|
Member |
|
|
Hi Steve
thanks for ur reply basically i m using two of the option's
1)List of values with values from a table column
3) Just enter some information and my SQL will handle it
plz do tell me that how does it will be ruend through web (accessed through web)
thanks
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
