Hello!
Is it just me or does anyone else find that the Join Types in Crystal are
pants (jockeys)?
I am trying to do an Extended Trial Balance - I want to list ALL GL
Accounts, whether they have Balances for a Period or not. Also I want to
list the Opening Balance and use that in a formula.
The Opening Balance table I have no problem with - I can tell it to use the
year from the parameter or zero - this seems to list all GL Accounts and
displays the Opening Balance for that year.
However, adding the Period Balance into the equation causes Accounts to be
left out of the report if they have no Balance activity that Period. I have
used the same principle as on the Opening Balance table - if the year/period
matches, pull out that record, or if the year = 0 also pull it out.
But it doesn't work for the Period Balances...
I have used Left Outer Joins here, from the GLAcct table to GLPerBal, and
from GLAcct to GLOpnBal.
We are on Vantage 4, Crystal 8.
Hope you can help.
Anton Wilson,
Systems Analyst,
Deanestor Healthcare
www.deanestor.co.uk
Is it just me or does anyone else find that the Join Types in Crystal are
pants (jockeys)?
I am trying to do an Extended Trial Balance - I want to list ALL GL
Accounts, whether they have Balances for a Period or not. Also I want to
list the Opening Balance and use that in a formula.
The Opening Balance table I have no problem with - I can tell it to use the
year from the parameter or zero - this seems to list all GL Accounts and
displays the Opening Balance for that year.
However, adding the Period Balance into the equation causes Accounts to be
left out of the report if they have no Balance activity that Period. I have
used the same principle as on the Opening Balance table - if the year/period
matches, pull out that record, or if the year = 0 also pull it out.
But it doesn't work for the Period Balances...
I have used Left Outer Joins here, from the GLAcct table to GLPerBal, and
from GLAcct to GLOpnBal.
We are on Vantage 4, Crystal 8.
Hope you can help.
Anton Wilson,
Systems Analyst,
Deanestor Healthcare
www.deanestor.co.uk