Creating Beginning Balance Column in Report

[tgtfranz]

I have a balance sheet that I am trying to recreate and am having way more trouble than I should with trying to get the data to return correctly. This is the only piece that I am missing. This balance sheet is made up of several subreports that are not linked to one another. It looks a little something like this: (Current Month End is returning the right balance)

Grouped on (AcctCode) Beg Bal Current Month End
Assets
Liability

Because this is coming from a new data set that just created on 02/28 the beginning balance is going to be equal to my current month end balance for this period.

When my dates change and there is a new period entered how do I control my data in my Beg Bal colum from being overwritten?

I have been working with several functions and formulas to try to get this and I am getting figures that seem to ignore the group that I am using.

Here is what I have. No idea if this is what I really want.

tonumber(if GroupName ({@AcctgGroup}) = "Cash and cash eqivalent" and
year(currentdate)-1 > 2007 then Sum ({GLAccounts.Balance}))

Please help I am in a crunch.

Thanks a million.

 

[lbass]

If you are saying you want the Beginning Balance always to be the same amount then use a conditional formula that hard codes the initial dates. I'm unclear on whether these are amounts up through 2/28 or through 3/31, but let's say it is 2/28. Then use a formula like {@amtsbefMar}:

if {@AcctgGroup} = "Cash and cash eqivalent" and
{table.date} < date(2007,3,1) then {GLAccounts.Balance}

Then create a second formula {@begbal}:

sum({@amtsbefMar})

-LB