Need help for parameter field

[sonadi]

I need help for how can I do as parameter field this scenario. if one account has two code number display one the report or if display any account that has one code. Please help.

 

[lbass]

This is unclear. Are you saying that you want to display only one code number if an account has two code numbers? Are there two fields, one for account ID and one for code number? What does your data look like?

-LB

 

[sonadi]

Need display one account that has two code number there one field
Example:

Account # code id
1234 905
1234 706

1345 905
2345 706


I want display first one as parameter.

 

[lbass]

A parameter for what? Are you trying to create a parameter picklist that contains account #'s that have multiple code IDs?

Or do you just want to display accounts that have more than one code in the body of your report?

-LB

 

[sonadi]

yes, I Want to display account that have more then one code.

 

[lbass]

Then insert a group on {table.account} and then go to report->selection formula->GROUP and enter:

distinctcount({table.codeID},{table.account}) > 1

Then if you need to do any calculations across accounts, be sure to use running totals, since non-group selected records will contribute to the more usual inserted summaries.

-LB