Re-Tooling an Ordered List Report

[jaymoore1756]

I have a set of ordered list reports (balance sheets) that are balanced and working. The code for the subtotaling is contained in L1, L1Desc (level 1) and L2, L2Desc (level 2). The users want to add a total for assets and a total for liabilities that the reports currently are not doing. My question is can I some how nest the new subtotals in the current levels or do I have to create a new level and recreate the headers and the footers. And if I have to re-create the report what would be the best way to go about making the changes. Thanks

Example -- current report

Header 1
L1 desc

i.e Current Assets


Header 2
L2 desc

i.e cash

Footer 1
subtotal L1 desc

i.e Current Assets


Footer 2
subtotal L2 desc

i.e cash

Example -- modified report

Header 1
Insert  Desc  --Assets

L1 desc

i.e Current Assets


Header 2
L2 desc

i.e cash

Footer 1

Insert  subtotal --Assets

subtotal L1 desc

i.e Current Assets


Footer 2
subtotal L2 desc

i.e cash

[blom0344]

it may help to post a screenshot from the report list layout, cause it is pretty difficult to understand what you mean..

[jaymoore1756]

I have been on the road ... So I will get some screen shots posted. Thanks

[jaymoore1756]

Screenshot 1

[jaymoore1756]

Screenshot 2

[jaymoore1756]

Screenshot 3

[jaymoore1756]

Sample code

L1 Desc

If ([Ferc Account] = '13100' or [Ferc Account] = '13101' or [Ferc Account] = '13601' or [Ferc Account] = '13102' or [Ferc Account] = '13103' or [Ferc Account] = '13104' or [Ferc Account] = '13602' or [Ferc Account] = '13603' or [Ferc Account] = '13605' or [Ferc Account] = '13604' or [Ferc Account] = '13105' or [Ferc Account] = '12510' or [Ferc Account] = '12520' or [Ferc Account] = '12530' or [Ferc Account] = '12540' or [Ferc Account] = '12550' or [Ferc Account] = '13106' or [Ferc Account] = '13500' or [Ferc Account] = '13501' or [Ferc Account] = '14200' or [Ferc Account] = '14202' or [Ferc Account] = '14400' or [Ferc Account] = '14401' or [Ferc Account] = '14402' or [Ferc Account] = '14300' or [Ferc Account] = '14301' or [Ferc Account] = '14302' or [Ferc Account] = '14303' or [Ferc Account] = '14305' or [Ferc Account] = '14306' or [Ferc Account] = '14307' or [Ferc Account] = '14308'  or [Ferc Account] = '17400' or [Ferc Account] = '18401' or [Ferc Account] = '14304' or [Ferc Account] = '15400' or [Ferc Account] = '15500' or [Ferc Account] = '15601' or [Ferc Account] = '15602' or [Ferc Account] = '15603' or [Ferc Account] = '16300' or [Ferc Account] = '16420' or [Ferc Account] = '16421' or [Ferc Account] = '16422' or [Ferc Account] = '16423' or [Ferc Account] = '16501' or [Ferc Account] = '16502' or [Ferc Account] = '16503') Then ('Current Asset')

L1

If ([Ferc Account] = '13100' or [Ferc Account] = '13101' or [Ferc Account] = '13601' or [Ferc Account] = '13102' or [Ferc Account] = '13103' or [Ferc Account] = '13104' or [Ferc Account] = '13602' or [Ferc Account] = '13603' or [Ferc Account] = '13605' or [Ferc Account] = '13604' or [Ferc Account] = '13105' or [Ferc Account] = '12510' or [Ferc Account] = '12520' or [Ferc Account] = '12530' or [Ferc Account] = '12540' or [Ferc Account] = '12550' or [Ferc Account] = '13106' or [Ferc Account] = '13500' or [Ferc Account] = '13501' or [Ferc Account] = '14200' or [Ferc Account] = '14202' or [Ferc Account] = '14400' or [Ferc Account] = '14401' or [Ferc Account] = '14402' or [Ferc Account] = '14300' or [Ferc Account] = '14301' or [Ferc Account] = '14302' or [Ferc Account] = '14303' or [Ferc Account] = '14305' or [Ferc Account] = '14306' or [Ferc Account] = '14307' or [Ferc Account] = '14308' or [Ferc Account] = '17400' or [Ferc Account] = '18401'  or [Ferc Account] = '14304' or [Ferc Account] = '15400' or [Ferc Account] = '15500' or [Ferc Account] = '15601' or [Ferc Account] = '15602' or [Ferc Account] = '15603' or [Ferc Account] = '16300' or [Ferc Account] = '16420' or [Ferc Account] = '16421' or [Ferc Account] = '16422' or [Ferc Account] = '16423' or [Ferc Account] = '16501' or [Ferc Account] = '16502' or [Ferc Account] = '16503') Then ('01')

L2 desc

If ([Ferc Account] = '13100' or [Ferc Account] = '13101' or [Ferc Account] = '13601' ) Then ('Gas System General Account') ELSE (

L2

If ([Ferc Account] = '13100' or [Ferc Account] = '13101' or [Ferc Account] = '13601' ) Then ('01') ELSE (

[jaymoore1756]

This is resolved. To resolve this I rebuilt the report. 1st ... striped out all the subtotals and summaries,  2nd ... updated the ordered list by creating new data items required for the report... 3rd re-created the header and footers .... 4th recreated the subtotals and summaries. Tested and modified as appropriate.