Formating For Financials

[Jason2121]

Hello

I am currently working on a Balance Sheet and I am running into a problem trying to keep all Assets on page 1 and the Liabilities & Equity on the second. I went into Section Expert for my Group Name which contains the following formula for the headings to each main Topic:

If {@Accounts} < "4000" Then "ASSETS"
else
If {@Accounts} < "4500" Then "LIABILITIES"
Else
If {@Accounts} < "9999.999999" Then "EQUITY"

I tried to use the the Common tab and selected New Page Before but this seperated the Equity and Liabilities on different pages.

Does anyone have any ideas or tips I could use to have only two pages, 1 for Assets and the second for Liabilities & Equity.

Thanks - Jason

 

[CoSpringsGuy]

you could add another formula like this

If {@Accounts} < "4000" Then "A"
else
If {@Accounts} < "4500" Then "A"
Else
If {@Accounts} < "9999.999999" Then "B"


keep the groups you have but add this as group 1 and do a new page after the footer. Hide the GR1 Header and GR2 Header


_____________________________________
Crystal Reports XI Developer Version
Intersystems Cache 5.X ODBC connection

 

[Jason2121]

That worked perfectly - Thanks