Results 1 to 7 of 7
  1. #1
    Join Date
    Apr 2004
    Location
    Madrid, Spain
    Posts
    13

    Question Unanswered: IŽd like to hide one panel and print a blank page

    I am using
    - Oracle Reports 6i (6.0.8.13.1)
    - Oracle 8i Enterprise Edition Release 8.1.7.4.0
    - Windows 2000 SP4
    and I have a report with 2 horizontal panels in the main section. This panels shows different data except one case, in that situation I want to display only one of them.
    Any idea? Any help would be appreciated, thanks in advance.

  2. #2
    Join Date
    Oct 2003
    Posts
    43

    Re: IŽd like to hide one panel and print a blank page

    I think conditional formatting is available in your version of Reports, if it is then.

    Select the field you want to hide in certain situations.
    Go to the format menu, and select conditional formatting.
    You will the be able to specify the conditions which will cause the item to change.
    Finally select the type of change you want to take place, i.e. hide the object, change background foreground colour etc.
    Compile the form.
    Run it and you should have an item with conditional formatting on it.

  3. #3
    Join Date
    Apr 2004
    Location
    Madrid, Spain
    Posts
    13

    Smile

    I know that, thank you, but I want to hide the whole panel, and in certain fields when applying conditional format based on other fields gives error because of 'incorrect frequency'.

    Any other idea?

    Thanks anyway

  4. #4
    Join Date
    Apr 2004
    Location
    Madrid, Spain
    Posts
    13
    Could it be possible to hide a non-repiting frame insted of the panel depending on a field which is in that frame?

  5. #5
    Join Date
    Oct 2003
    Posts
    43
    You probably know this too, but you can have frame level conditional formatting:


    this code for the first frame.
    -- Automatically Generated from Report Builder.
    if (:frame_check != 'A')
    then
    return (FALSE);
    end if;

    return (TRUE);

    this code for the second frame.
    -- Automatically Generated from Report Builder.
    if (:frame_check != 'B')
    then
    return (FALSE);
    end if;

    return (TRUE);

  6. #6
    Join Date
    Apr 2004
    Location
    Madrid, Spain
    Posts
    13
    Yes, I didnŽt remember, thank you.
    But in my case, I have put a global variable called GV_PRINT and the logic is something like this

    if NUM_FACTURA like '%CFI%' then
    GV_PRINT := 'N'
    else
    GV_PRINT := 'S'
    end if;

    In the format trigger, in the biggest frame in the 2nd panel I put
    If GV_PRINT = 'N' then
    return FALSE;
    end if;
    return TRUE;

    IŽm surprised, as sometimes GV_PRINT gets the correct value and sometimes not. Also, when I hide the frame it doesnŽt appear anymore,
    why could this be happening?
    Last edited by Pucca; 04-21-04 at 06:14.

  7. #7
    Join Date
    Apr 2004
    Location
    Madrid, Spain
    Posts
    13

    Unhappy

    Still doesnŽt work, perhaps using explicit anchors? Can they be defined in the object navigator?

    Thanks in advance.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •