By using this website, you agree to our Terms of Use (click here)
Ok, I'm sure I'm missing something super simple.
i have a report that I want to summarize open/unpaid balances for a customer where certain Sales Orders are Flagged (with a manual) Checkbox.
I have the schema and all data flowing properly in the report EXCEPT when it comes to totaling the report. I assumed that I could accomplish this with grouping, but that doesn't seem to work.
In the report you can see i have 2 Sales Orders. The report should calculate the total unpaid, but it is circling through and adding up the unpaid balance from ALL the lines on the SO.
I thought if i put the 'totals' in a group and grouped by Customer AcctCD that it would sum at that level but I"m obviously missing something:
RPX attached.
It seems like maybe you're suppressing the Orders rather than excluding them with Conditions in the report schema. If that's the case, you can still exclude them from the totals, but you'll need to enhance your formula to something like this:
Sum( IIf( ManualCheckbox=true, [SOOrder.BlahBlah], 0) )
@timrodman thanks tim, i used a subreport to get totals and display. works..but getting aligned was a nightmare