Hi Guys.
      I've got a question. How do you display a report conditionally using a calculation based on parameters.
I've got this report wherein i've created parameters for start date and end date. I have to display the report if the date range is <= 2 years. I've hardcoded the dates to use the first of the month for the start dates and the last of the month for the end date in static choices. i.e, when executed the report will display JAN-05 for the start date, but will actually use 2005-01-01 and JULY-2006 for 2006-07-31 resp.(say)
I created a data item for calculating the date range, namely, date_range as _months_between(?start_date?,?end_date?)
I write the expression in the conditional explorer as [date_range]<=24Â and applied it conditionally to display 'Date range out of scope'Â or to display the report accordingly.
However, it's not working and the report is showing 'Date ranger out of scope' for all date ranges.
I tried expressions parameterdisplayvalue("date_range")<='24' and parametervalue("date_range")<='24' but that isn't working either. Can you please help me with this.
Thanks in advance.