Complex query for returning data
Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
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=20908
Printed Date: 04 May 2024 at 12:37am
Topic: Complex query for returning data
Posted By: johnformby
Subject: Complex query for returning data
Date Posted: 23 Jul 2014 at 10:29pm
Hello,
I have a table in my DB that tracks movement of inventory. There are many different transactions, but I need to target a couple of specific scenarios for a report:
1. Weighing inventory out of the warehouse (transaction 1) where a future transaction is receiving at dispatch bay (transaction 2).
2. Weighing inventory out of a second warehouse (transaction 1) where a future transaction is receiving at dispatch bay (transaction 2).
Is it possible to build a report to only look at these scenarios? In addition to these transactions in the table, I have others such as receipt into warehouse, movement between warehouses etc. that I want to completely ignore.
Each transaction has a different ID number.
Any assistance that can be provided would be very much appreciated.
Kind Regards,
John
|
Replies:
Posted By: lockwelle
Date Posted: 25 Jul 2014 at 5:04am
|
if they have transaction types that are unique, you could apply a filter to the data to only allow the correct data into your report.
|
|