Advanced Report Creator - Errors when I add Ledger

Discuss your general Proclaim related queries here.
coastal_living
Posts: 18
Joined: Mon Sep 27, 2021 11:58 am
Has thanked: 8 times

Advanced Report Creator - Errors when I add Ledger

Post by coastal_living »

I have a report that runs perfectly fine, until I add in the Ledger. Why is it giving me an error message, is the JOIN wrong somehow?
Ledger error message.jpg
Ledger error message.jpg (155.6 KiB) Viewed 558 times

danny
Posts: 75
Joined: Sun Mar 11, 2012 11:28 pm
Has thanked: 3 times
Been thanked: 5 times

Re: Advanced Report Creator - Errors when I add Ledger

Post by danny »

what do eclipse say?

coastal_living
Posts: 18
Joined: Mon Sep 27, 2021 11:58 am
Has thanked: 8 times

Re: Advanced Report Creator - Errors when I add Ledger

Post by coastal_living »

Will eclipse help with queries like this?

danny
Posts: 75
Joined: Sun Mar 11, 2012 11:28 pm
Has thanked: 3 times
Been thanked: 5 times

Re: Advanced Report Creator - Errors when I add Ledger

Post by danny »

have u asked them?
if yes then what did they say
if no then ask them

galexander
Posts: 63
Joined: Fri Jul 25, 2014 8:22 am
Location: Manchester
Has thanked: 2 times
Been thanked: 5 times

Re: Advanced Report Creator - Errors when I add Ledger

Post by galexander »

Hi, there is some basic functionality to change between inner and outer joins in an advanced report (the button to the right of the table list) but you would have to test to make sure any changes weren't impacting on the overall report data