Wallegator
Programmer
I have two parameters in a report: Vendor Number and Job. If I select a Vendor number and a Job the report returns the correct grouped results. If I select one or the other the report does not include all of the records. What am I doing wrong? I'll paste my record selection formula below. Do I need to have a group selection formula as well? What is the difference between the two?
(
If {?VendorNumber}<>"All" Then {APM_MASTER__DISTRIBUTION.Vendor}={?VendorNumber}
Else if {?VendorNumber}="All" Then
True
)
And
(
If {?Job}<>"All" Then{APM_MASTER__DISTRIBUTION.Job} Like {?Job} & "*"
Else if {?Job}="All" Then
True
)
(
If {?VendorNumber}<>"All" Then {APM_MASTER__DISTRIBUTION.Vendor}={?VendorNumber}
Else if {?VendorNumber}="All" Then
True
)
And
(
If {?Job}<>"All" Then{APM_MASTER__DISTRIBUTION.Job} Like {?Job} & "*"
Else if {?Job}="All" Then
True
)