Active TopicsMemberlistSearchHelpRegisterLogin

Report Design
 Crystal Reports Forum : Crystal Reports for Visual Studio 2005 and Newer : Report Design
Message Icon Topic: AP Saving Report Post Reply Post New Topic
Author Message
Wayne beasley
Newbie
Newbie


Joined: 02 Jun 2015
Online Status: Offline
Posts: 3
Quote Wayne beasley Replybullet 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
IP IP Logged
kevlray
Admin Group
Admin Group
Avatar

Joined: 29 Oct 2009
Online Status: Offline
Posts: 1587
Quote kevlray Replybullet 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.
IP IP Logged
Printable version Printable version

Forum Jump 		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

HOME | FREE EBOOK | PROGRAMMING GUIDE | PURCHASE | REVIEWS | CONTACT ME | FAQ | LINKS | PRIVACY | CLICK PLAYS | KONACAD

© 2004-2026 Brian Bischof. All Rights Reserved.