2 layouts in the same report 2

[latha9]

Hi,

I have created 2 reports but depending on the user selection i have to run the one report.

example i have th user parameter with 2 list of values.if the user selects one option one report has to run ,if the user selects the second option another report has to run.Can anyone please let me know how to create this report.

Thanks,
Latha

 

[BJCooperIT]

Add a trigger to your group frames something like:

function M_G_PRVYR_GRPFRFormatTrigger return boolean is
begin
  if    :P_YEAR = 2005  then
        return(TRUE);
  else  return(FALSE);
  end if;
end;

[sup]Beware of false knowledge; it is more dangerous than ignorance.[/sup][sup] ~George Bernard Shaw[/sup]
Consultant Developer/Analyst Oracle, Forms, Reports & PL/SQL (Windows)
My website: Emu Products Plus

 

[nagornyi]

Put each layout into separate frame of the variable vertical elasticity, place the frames one above another, but not overlapping, and create format triggers for each frame that would dijsplay the frame only for the appropriate values of the parameter.

 -----------
|           |
| LAYOUT 1  |
|           |
|           |
 -----------
 -----------
|           |
| LAYOUT 2  |
|           |
|           |
 -----------

 

[nagornyi]

Dear BJCooperIT ,
could you please kindly help me to understand how your approach solves the posted problem?
Thanks.

 

[BJCooperIT]

My approach is basically the same as yours, but you explained the layout better. If the report parameters had to do with requesting last year's reports (layout 1) or this year's report (layout 2), I was just trying to give a sample of the trigger on last year's frame that would produce this.

 

[nagornyi]

Now I see. Thanks!