September 5, 2014 at 3:40 pm
Have finance report grouped by internal grouping number to group accounts together by Title Group and Company Number (i.e. Prepaid Expenses = Title Group; 1500 = internal grouping number; 001, 002, 003.... 007 = Company Number). See attached jpg image file.
1. Subtotals by Company are working. Need to another subtotal for actual group (i.e. Prepaid Expenses subtotal for Company 001 + Prepaid Expenses for Company 002, etc. to have subtotal called 'Prepaid Expenses'). How do I get SSRS to create this other 2nd level of subtotal?
2. Right now 'Prepaid Expenses' Group Title is repeating for each group. How can I get it so that there is only 1 Group Title with Company grouping under it?
Example:
Prepaid Expenses
Company 1 Acct detail Company 1 Acct Amount
Company 1 Acct detail Company 1 Acct Amount
Company 1 Acct Amount subtotal
Company 2 Acct detail Company 2 Acct Amount
Company 2 Acct detail Company 2 Acct Amount
Company 2 Acct Amount subtotal
Total Prepaid Expenses (Company 1 Acct Amount subtotal + Company 2 Acct Amount subtotal)
2. Need to create 3rd level subtotal of Total Expense from selected 2nd level subtotals (i.e Prepaid Expenses [2nd level subtotal from #1 above] + Total Spare Parts Inventory = Total Expenses).
Example:
Total Prepaid Expenses (Company 1 subtotal + Company 2 subtotal)
Total Spare Parts Inventory (Company 1 subtotal + Company 2 subtotal)
Total Expenses
Viewing 0 posts
You must be logged in to reply to this topic. Login to reply