{SERREQUEST.CREDAT_0} = {?Date Range} and
(
//runs for all records if both are blank
(not(hasvalue({?Group Customer}) and not(hasvalue({?Customer BPC}))))
or
//run for only Group
(hasvalue({?Group Customer}) and {?Group Customer}={BPCUSTOMER.BPCGRU_0} and not(hasvalue({?Customer BPC})))
or
//run for only Customer
(hasvalue({?Customer BPC}) and {?Customer BPC}={SERREQUEST.SRENUM_0} and not(hasvalue({?Group Customer})))
)
So I decided to ask IT to give me views for the miscellaneous tables I had to clarify in my previous select statement, so I don't need that part anymore. I've used this select statement and it returns ALL customer records regardless of whether I enter a customer number or a group number specifically. As another note: I have this report grouped by sales SITE so that the records are grouped by the site in which the product was sold. Is this grouping what is causing the problem?
IP Logged
