Fields Blank When Summing Account Balances
I am new to the forum and I think there must be something fundamental I am missing. have gone back several pages and not found anyone else with this problem...
I am connecting to Sage 200 to summarise an account's transactions into current, 30 days overdue, 60 days overdue and 90 days overdue. I have created a formula for each of these periods in the details section of the report which I am the totalling in the report footer section together with the account code and name. This works fine where there are accounts with transactions but the report does not display any fields at all where the account has no transactions.
Is there any way to force Crystal Reports to show this data when there are no transactions against the selected customer account or am I missing something obvious?
Any help would be greatly appreciated.