on 10-16-2008 1:04 PM
Hi
I am creating a cross tab report.In that I want to restrict the column dynamically.The column depends upon the parameter field.
say for example if i enter the parameter as 2007,it should display field from 2004-2007 only rather than displaying all years.
Thanks in Advance,
Eswari
Hi,
You can use a formula. e.g
< Basic format>
Select case year({Command.tradeDate})
case 2005 to 2007
formula = 1
Case else
formula = 0
end select
Then on the crosstab column group options, choose "specified order" and on the "Other" tab choose "Discard all others"
Hope this helps
Regards
Dotun.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Eswari,
Give the following in Record Selection :
year({Orders.Order Date}) in (({?yearparameter}-2) to {?yearparameter})
Note : Order Date is a database field and Yearparameter is parameter.
Thanks,
Sastry
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.