using case when in filter in Report Studio

[consultantshaz]

Hi Experts

Need your guidance on the follwing :

I have billcycle parameters and the two conditions based on these parameters
I want to filter the following conditions:

case
when (?billcycle? = 20100201)
then (20100201 and 20100231)
when (?billcycle? = 20100220)
then (20100220 and 20100305)
end

note:
20100231 is dynamic (_last_day_of_month)
20100305 is dynamic (example, eg. when ?billcycle? = 20100320 then
20100320 and 20100405 and so on)

if you have suggestions to make this a dynamic condition, thank you in
advance.


in the filter to be like this ( date between DataItem )
how this is possible?

Since its urgent appreciate your swift response.

[CognosPaul]

This can be done fairly easily with macros.

You can do something like this:

[DateStamp] between #timestampmask(prompt('pDate','date',$current_timestamp),'yyyymmdd')# and #timestampmask(_last_of_month(prompt('pDate','date',$current_timestamp),'yyyymmdd'))#

[consultantshaz]

Thanks for the reply .. I will apply and let you know.