Hi folks

We are trying to control cost in various production departments so I'm trying to report on transactions recorded against various GL codes. I've written a report which lists all GL transactions in a certain fiscal period, I can then group it by GL code to get what I need.

The only problem I have is that if there was no transaction in a given period against a certain GL code then that GL code will be omitted from my report (naturally).

Is there any way that I can configure the report to list all of the GL codes that I'm interesteed in and if there is no transaction, then let it show a Zero?

Id appreciate any suggestions you might have.
thanks

Edited by marco007 - 22 Jan 2014 at 3:46am

HI lockwelle
that worked alright, but not on my Crystal reports. I'm using CR11.5.3.417 and as far as I can see there seems to be some glitch which causing a problem when using a left outer join between the GL Account table and the GL Jrn Detail table.

I've been advised to patch up but I havent attempted this yet.

thanks for your reply