Pass the value selected in the prompt to a report B and which has month and month -1 columns. Now in your currrent report use filter based on another request and filter the month column by month-1 column of report B.
thanks for ur reply but
but my requirement is different
actually i have some date columns
my condition is gldate<startdate
my values are
gldate values are like 1/31/2011,2/28/2011,3/31/2011,4/30/2011,5/31/2011 ...
startdate values 1/1/2011,2/1/2011,3/1/2011,4/1/2011,5/1/2011 ..
periodname --jan-11,feb-11,mar-11 likethsi
if i select periodname nov-11 then
startdate is 11/1/2011 and gldate is 11/30/2011
my condition is gldate<startdate its false then all gives 0's
my requirement is if i select periodname nov-11 then startdate is 11/1/2011 then iget the amount for the all gldate values <startdate
startdate i compare all gldate values its not filtered
then this condition get upto oct-11 values
i nees for nov-11 values are upto oct-11 values sum
plz how to dothis
if ur not understand plz reply to me
I find it difficult to understand. Let me put it this way
Are you saying you have a period as prompt and when you select a period you need to display data for period -1. eg: you select nov-11 then you get data till oct-11?
As I understand gldate is end of month date(1/31/2011,2/28/2011) and startdate is start month date(1/1/2011,2/1/2011,3/1/2011..)
You want to display only values for gldate< startdate for selected period
So for period nov-11 gldate = 11/30/2011 and startdate = 1/30/2011 so this implies that nov-11 shouldn't b displayed on rreport and shud only display from oct-11 which is same as displaying period-1.
Is this correct?