Can we apply filter on report related to sys date

[rrbo]

Hi All,
I have a cross tab report , In that i have a object MONTH at row level. Month contains values 1,2,3,4...to 12.

I wanna filter on MONTH based on Sysdate. If sys date month is MAY(5) then that should filter for 3,4 and 5. If Sys date month is October then that should filter for 8,9,10.

I am unable to get how to do this. If u find somethinmg about this please post it. If you get an idea at Universe level about this , give me syntax for that.

Thanks
rrbo

 

[BizObjSME]

Create a dynamic filter: Format Filters->Global->Add (the date column)->DEFINE (create a formula with an IF..ELSE).

That should do it.

 

[rrbo]

Hi BizObjSME,

Thanks for reply.

But my report is like slice and dice with Master Detail Cross Tab .

I wanna apply at block level. As per you that will come as Global filter(Report level).

Coz i have two blocks in the report and both blocks having the month fileld, i have to apply filters for both month fields with different conditions. I said above the one condition.

to apply both filters we need to create dynamic filters at each block level i believe.

If u find something please post it ASAP.

Thanks
rrbo

 

[Sridharan]

You can create a report level variable with the appropriate condition required for the block or table and then manually apply the filter on this variable and later you can change this local variable from VBA and your block should change automatically.

Sri

 

[skrandel]

I don't understand. Just move the filter from being a global filter to being a block filter.

Steve Krandel
BASE Consulting Group

http://www.baseconsulting.com

 

[Sridharan]

Steve,

rrbo trying to do this stuff from VBA SDK. I don't think there is a direct way of applying block level filters from SDK. Thats why I gave that solution.

Sri