formula for column (acc-col):
if {tbl.accno} between ["806101","806981"] then "806101 to 806981"
else if {tbl.accno} between ["806B01","806F01"] then "806B01 to806F01"
...
else "808811 to 808819"
and you can put which field for the detail in cross-tab.
till here try to preview it.
then create a parameter to restrict which data you want to be printed.
- from Field Explorer
- right click 'Parameter Fields'
- click 'New' and put any name for the parameter (xyz)
from here you can see all the options.
then create 'Select Expert'
- click 'Report' menu
- select 'Selection Formulas' - 'Record'
- and put the parameter that you just create
e.g.: {xyz?}={tbl.accno}
till here it will print only data for what you enter in parameter.
let see what you've got.
IP Logged
