help with show/hide

[unknownly]

One of my report works like this

the user inputs 3 paratmeter values


?Account group:
?unit:
?Period:


Based on the input values my report has to display data rolloing back upto 6 months say the input for above is input as

?Account group: derivative
?unit: 20016
?Period:Jan2004


Then my report displays as


code JAN2004 DEC2003 NOV2003 OCT2003 SEP2003 Aug2003

100 987870 67990890 8908678 76788990 (7989065) 636899
200 (59879) 68790789 2308897 873897 38739880 789897
300 ...so ..on

Now my user is asking for a tricky part: add a new parameter ?filteramount:

say for ?filteramount: 100000 is enter as input

I should be able to display the report where as all the months is <= ?filteramount

In the above given ex:

code = 200
where in JAN2004 (59879) is not greater than 100000 but in DEC2003 it is true so it should still display that amt


in group selection I tried this and it display 0 in JAN2004 staisfy the filter condition


abs(Sum ({@Total1}, {CODE})) >= tonumber({?filteramount}) or
abs(Sum ({@Total2}, {CODE})) >= tonumber({?filteramount}) or
abs(Sum ({@Total3}, {CODE})) >= tonumber({?filteramount}) or
abs(Sum ({@Total4}, {CODE})) >= tonumber({?filteramount}) or
abs(Sum ({@Total5}, {CODE})) >= tonumber({?filteramount}) or
abs(Sum ({@Total6}, {CODE})) >= tonumber({?filteramount})


I hope I made it clear. Any help is greatly appericated.


Thanks in advance,
Sweetie

 

[Madawc]

You haven't said which bit is failing to work, or what the actual output it. You should also say which version of Crystal.

Madawc Williams
East Anglia, Great Britain

 

[unknownly]

Thank you for the response.

I have resolved it.