Hey Dblank,
Tnx already for the reply this realy sets me in the good direction
now for your questions:
1: at the moment i'm only planning on filtering on notebooks but in the future i would like to expand this to other categories (printers : cross sell with cardtridge / paper / kabel's )
2: my report now has formula's on both the record as on the group
record
{ANT-hisarel.h_datum} > {?StartDatum} and {ANT-hisarel.h_datum} < {?StopDatum} and {ANT-hisarel.h_relnum} <> [3 , 25229 , 10229 , 13590]
where h_datum the date of the invoice is and start and stop datum give the start and the stop of the periode i want to check (i don't want to check last 4-5 years of sells just a given periode i let the user enter
the h_relnumer are customernumbers i don't count (intercompany sells )
Then on the group level i have:
IF {?Cross Verkoop op notebook aanwezig} = true THEN Sum ( mailto:%7b@TelCross - {@TelCross }, {ANT-hisarel.h_docnr})>=1 and Sum ( mailto:%7b@TelNotebook - {@TelNotebook }, {ANT-hisarel.h_docnr}) >=1 ELSE Sum ( mailto:%7b@TelCross - {@TelCross }, {ANT-hisarel.h_docnr})=0 and Sum ( mailto:%7b@TelNotebook - {@TelNotebook }, {ANT-hisarel.h_docnr}) >=1
the first parameter is meant to split the report up in
cross sell and not cross sell (one gives me all the records that are cross sell the second one all the records NOT cross sell and the information of our internal sales guy so we know who needs more training on cross selling and who is doing good .
now on the rest of your answer:
i don't understand how this will count my total
right now i greyed out the detail and grouped per invoice number and with the formula on group i get a nice list of all the cross sell invoices
problem is that my grand total (sum of telnotebook ) both the cross sells counts as the not cross sells
i'm lookign for a extra foruma that only counts groups displayed not not both (displayed and not displayed)
tnx again for the time !!
Adam
|