I am trying to write a commission report for Alpha with some highly complicated parameters and I need to know if it is even possible. What the managers are asking if I can do is to run a report that on each piece of paper would have all of the sales by a single rep during a period of time to be entered when prompted. Here is my problem:
1. Each record has four different fields where the reps initials could be located, and each of those four fields could have a different rep's initials or the same rep's initials in two of them and different reps in the others.
2. That same record has 9 payment amounts/date fields relating to the first two rep initial fields (the printed product), and 7 payment amount/date fields relating to the third and fourth rep initial fields (the online product).
3. The commissions are paid only on payment received in the payment fields relating to that specific rep initial field (printed or online), which is why we had to make four rep initial fields, as one rep could sell the printed product and a different rep could upgrade the printed product, so both would receive commissions off of the first 9 payment fields.
4. They would also like it to group the commission percentages together for that rep on their page of the report. (Ex: 25% printed and online, 15%, and 10% commissions). There is a commission field related directly to each rep initial field.
5. At the bottom of the report they would like a summary of the total amount of payment received and the commissions paid for all 16 payment date fields and 4 rep initial fields. It can't add the payment fields from the same record twice into that summary field or it can't be used as a double check from the deposit form.
Any thoughts on if Alpha can handle that many different filters, groups and/or variables? So far I have spent 10 hours trying to get this report to work as both a free-form and a layout report with no success. The only way I can think of designing it would require either multiple passes through the report when rendering it (which I don't know how to do, or if it will work) or multiple detail sections.
I currently have 4 separate reports (one for each rep initial field) that takes care of this situation, but the managers want it all down to one report. Looking for confirmation on if it is possible (and how to do it) or if I am correct in thinking it is too many variables for one report.
-Amanda
1. Each record has four different fields where the reps initials could be located, and each of those four fields could have a different rep's initials or the same rep's initials in two of them and different reps in the others.
2. That same record has 9 payment amounts/date fields relating to the first two rep initial fields (the printed product), and 7 payment amount/date fields relating to the third and fourth rep initial fields (the online product).
3. The commissions are paid only on payment received in the payment fields relating to that specific rep initial field (printed or online), which is why we had to make four rep initial fields, as one rep could sell the printed product and a different rep could upgrade the printed product, so both would receive commissions off of the first 9 payment fields.
4. They would also like it to group the commission percentages together for that rep on their page of the report. (Ex: 25% printed and online, 15%, and 10% commissions). There is a commission field related directly to each rep initial field.
5. At the bottom of the report they would like a summary of the total amount of payment received and the commissions paid for all 16 payment date fields and 4 rep initial fields. It can't add the payment fields from the same record twice into that summary field or it can't be used as a double check from the deposit form.
Any thoughts on if Alpha can handle that many different filters, groups and/or variables? So far I have spent 10 hours trying to get this report to work as both a free-form and a layout report with no success. The only way I can think of designing it would require either multiple passes through the report when rendering it (which I don't know how to do, or if it will work) or multiple detail sections.
I currently have 4 separate reports (one for each rep initial field) that takes care of this situation, but the managers want it all down to one report. Looking for confirmation on if it is possible (and how to do it) or if I am correct in thinking it is too many variables for one report.
-Amanda
Comment