3 Replies Latest reply: Jul 30, 2013 10:12 AM by WVanSluys RSS

    How to spilt columns dynamically in the report based on Date Parameters

    894333


      Hi All,

       

      We have an XML Publisher report in which the parameters are Fom date and To date.

      User wants the data in the report to be split dynamically based on the months in the From date and To date interval.

      Eg. if the From date is 01-JAN-2013 and To date is '31-MAR-2013' then the report should show 3 columns JAN,FEB and MAR and the corresponding data.

       

      if the From date is 01-JAN-2013 and To date is '31-MAY-2013' then the report should show 5 columns JAN,FEB,MAR,APR and MAY and the corresponding data.

       

      Can anyone please advise, how can we spilt the months and data dynamically in the report.

       

      Regards,

      Shruti