Joined: 02 Jun 2015
Online Status: Offline
Posts: 3
Topic: AP Saving Report Posted: 20 May 2018 at 2:15pm
Hi
Can I ask for some assistance please. I would like to create a report which will pull data from my AP Invoice Line Table. I would like to have 2 columns of data,
Both columns will show the same fields eg. quantity and unit price, but from 2 different user defined date ranges. Once this has been done I plan on creating a formulated field to show the difference in cost. I'm struggling on how to set up the two columns that are pulling the data from the two different user defined date ranges.
Thanks in advanced
Joined: 29 Oct 2009
Online Status: Offline
Posts: 1587
Posted: 24 May 2018 at 5:49am
Since you are filtering data from two different date ranges. You will either need a sub-report or use a command (with sub-queries) to return the data correctly. A sub-report can affect performance.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum
IP Logged
