This discussion is archived
1 Reply Latest reply: Nov 18, 2012 11:26 PM by Voltaire RSS

Reg Date Prompts

Bhargav K Newbie
Currently Being Moderated
Hi All,

can any one help me...pls

I have 2 prompts year and quarter.

Eg.. if i select 2011 and q1

it should display the begining month of the first quarter (that should be 'JAN') like wise if i select 2011 and q2 then it should display begining month of second quarter (that should be 'Mar')..

can any one help me
  • 1. Re: Reg Date Prompts
    Voltaire Journeyer
    Currently Being Moderated
    Hi Bhargav,

    Two Changes to be done.

    1. Prompt: for the Qtr column set a presentation variable like v_qtr.
    2. Report: Add a calculated column with the below formula

    case @{v_qtr} when 1 then 'Jan' when 2 then 'Apr' when 3 then 'Jul' when 4 then 'Oct' end

    Let me know if this helped.

    Regards,
    Jay

    Edited by: Voltaire on Nov 18, 2012 11:26 PM

Legend

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