Monday, September 15, 2008

Show selected Timeperiod in Narrative View without using Variables

If you have date prompt and want to apply "between" operator then you can't store selected values in presentation variable.
but We can show selected date range in narrative view without using presentation variable.
Resolving the issued we need to do following steps -

  • add two more columns on report.
1. RMIN(FROM DATE) /* From Date can any date column */
2. MAX(RMAX(FROM DATE)) /* For "TO DATE" */
(bcoz only "FROM DATE" prompt will appear for two date values)


  • Use both columns in narrative view with appropriate column sequence number.

but one problem here is that if your result doesn't contain records as per your input then it will give only available Min and Max date.

Regards,
Devendra Chhajlani

No comments: