create a param called 'year' as numeric with min and max values to force a user to stay in the rang you want

use that in the select expert as

{?year} = tonumber(left({Command.CPS_REQUEST_BATCH_ID},4))

 

or if you just want to leave it a string make a param 'year' as a string type

select statement as

 

       I have another question which you might have a solution. In the Report Footer I have placed the cumulative total for each month.

i.e Jan   feb     mar     apr     may

             100     0         0          0

 

 

Is there anyway that i can suppress the totals which are after february?? Because they would all be zeros.

May be using something like

 month(currentdate) = 03 > Extract then supress? Am not quite sure.

 

I dont want to display apr and may and next month i want to show totals until april and suppress all other month and so on.

 

 

Regards,

Nav

 

 

 

 

 

Regards,

Nav

I have 12 for each month. Basically am having these formulas in the detail section and suppress the detail. Finally doing a summmary of this formulas in the report footer

 

@janC =

If {@Extract} = '01' and {Command.REQ_STATUS} = 'D' then ({Command.COUNT(1)})