This discussion is archived
2 Replies Latest reply: Aug 25, 2013 11:22 PM by Soofi RSS

How to display different form_letters for 2 conditions?

Vijetha Explorer
Currently Being Moderated

Hi everyone.

I have a new question. I absolutely have no idea on how to do it.

I have prepared a report using form_letter & tabular style.

In the form_letter style report, there is a subject line to the letter.

This subject line should change for a condition.

In the tabular style report, there is a column named as 'TYPE' - [ Cumulative & Non-cumulative ]

There are two subject lines. [ (Subject-1) & (Subject-2) ]

I want to display "Subject -1" when TYPE - Cumulative .

I want to display "Subject -2" when TYPE - Non-Cumulative .

How do i do this?

I want to paste the image regarding this, but i am unable to paste because the 'Insert image' is disabled. How do i insert image?

Thank You.

  • 1. Re: How to display different form_letters for 2 conditions?
    Priyasagi Pro
    Currently Being Moderated

    Hi Vijetha,

     

    Create a formula column named subject , data type is character and widh is 100(based on your subject length you can give).

    pl/sql formula is:

    function subjectformula return char is

    begin

    if :type='cumulative' then

    return (:subject-1);

    else

    return (:subject-2);

    end if;

    end;

     

    In the layout model create a field and call the formula column subject as source.

     

    I think it is helpful to you.

  • 2. Re: How to display different form_letters for 2 conditions?
    Soofi Explorer
    Currently Being Moderated

    Hi Vijetha,

     

    If you want to insert an image

    Then,

    --Add the data model which has the image column.

    --In Paper Layout ensure the image field- 'File Format Property' is set to Image.

    --Also ensure the table has Image files only.

     

    Then to make a image for two different condition ...

    You can opt for Conditional Formatting.

     

    Hope this helps....

     

    Regards,

    Soofi

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points