Print Page | Close Window

AP Saving Report Printed From: Crystal Reports Book Category: Crystal Reports for Visual Studio 2005 and Newer Forum Name: Report Design Forum Discription: The best way to design a report and problems you have encountered URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=22604 Printed Date: 23 Apr 2024 at 6:27pm Topic: AP Saving Report Posted By: Wayne beasley Subject: AP Saving Report Date 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 Replies: Posted By: kevlray Date 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.

Print Page | Close Window