2 Replies Latest reply: Aug 26, 2013 1:22 AM by Soofi RSS

    How to display different form_letters for 2 conditions?

    Vijetha

      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

          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

            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