| Help needed in reports [message #366800] |
Thu, 03 August 2000 13:04  |
kartar singh
Messages: 1
Registered: August 2000
|
Junior Member |
|
|
Hi all
Need some help from u guys. This is an interesting one.
I am working on a report with multiple layouts. Based on some conditions I'm suppressing the other ayouts.
The report has 2 parameters
Layout- the user has the choice to select from 1 and 2 this is a drop down list
Order By, for layout 1, the user can choose from Item Number or Valuation Change,Item Number.
Order by for layout2 is Product Group, Product Code, Product Line
Order by is also a drop down list.
Since the order by user can select it, is dynamically built in after param form
Now comes the interesting part.
If the user selects layout as 1 then order by should
display Item Number or Valuation Change>
and it should supress Product code, Product type,Product line
and vice-versa. How do I do this???
|
|
|
|
| Re: Help needed in reports [message #366801 is a reply to message #366800] |
Fri, 04 August 2000 03:06  |
alkakaneja
Messages: 10
Registered: February 2000
|
Junior Member |
|
|
Hi Kartar,
I think what you can do is make two different repeating frames in the layout depending upon the users choise. you can then 'display(true)' or 'display(false)' from the format editor accordingly.
hope this helps,
alka
|
|
|
|
| Re: Help needed in reports [message #366871 is a reply to message #366800] |
Tue, 05 December 2000 16:02 |
Madhav Kasojjala
Messages: 42
Registered: November 2000
|
Member |
|
|
Hi Kartar,
If you are saying you want to restrict second parameter LOV based on the value of first parameter(also called conditional LOV) you can't do it in reports. This is a limitation.
Instead you can make the report having
where condition orderby etc., as lexical parameter
and use an Oracle Form to write ur own program
that feeds the parameters and develop "where condition in the background" and call report
through Run Product along with Lex. Parameter.
Didn't get it? mail me I will let u know
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
