cancel
Showing results for 
Search instead for 
Did you mean: 

Restricting data in cross tab report

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

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.

Answers (1)

Answers (1)

Former Member
0 Kudos

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