| Procedure in Creating the parametric reports [message #89726] |
Sat, 10 July 2004 05:02  |
syed umair ali shah
Messages: 8
Registered: July 2004
|
Junior Member |
|
|
hi and salam to all ... can anyone tell me the procedure of making the parametriv report ... i want to create a report on which i pass parameter as date and it will generate the report on the basis of that date and date will match in table and only that record would be print whose date is matched as parameter ...
it is urgent so do gelp me please ...
thanks in advance ...
|
|
|
|
| Re: Procedure in Creating the parametric reports [message #89730 is a reply to message #89726] |
Mon, 12 July 2004 07:29  |
Steve
Messages: 190
Registered: September 1999
|
Senior Member |
|
|
syed -
to make a parameter in Oracle Reports 1) open your data model, 2) locate the WHERE clause and add the following syntax: :parameter_name = column_name
3) Hit OK in data model and Oracle Reports should notify you that a bind parameter was created.
note, the above will work only if you are looking for an EXACT match. If you want to allow partial entries, no entries, etc. etc. then you need a little more work. The :parameter_name is called a bind variable and requires the colon preceding it to signify as such. Hope I've helped.
Steve
|
|
|
|
|
|
| Re: Procedure in Creating the parametric reports [message #89737 is a reply to message #89733] |
Wed, 14 July 2004 07:49 |
Steve
Messages: 190
Registered: September 1999
|
Senior Member |
|
|
syed -
If you mean when the user is prompted to input a value and you want them to be able to type in only a portion of the value then this is the approach:
The Following would be a condition in the WHERE clause:
column_name LIKE :parameter_name || '%'
OR
column_name LIKE '%' || :parameter_name || '%'
The second approach will allow the user to enter ANY part of the parameter, where as the first will allow them to enter the beginning of the parameter. If you play around with them you will see what I mean. Take it easy!
Regards,
Steve
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
