Multiple Information Lines
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=17964
Printed Date: 02 May 2024 at 5:41pm
Topic: Multiple Information Lines
Posted By: Siiig
Subject: Multiple Information Lines
Date Posted: 08 Nov 2012 at 9:52am
|
Greetings Crystal Report Forums!
I'm definitely new to Crystal development, and I usually rely on reverse engineering of what I've already got at my disposal. I don't have any examples to work with this time though. 
We use SAGE MAS as our backend, and I'm trying to pull warehouse quantities from the tables. I need to pull the quantities for three different warehouses, but the way they're stored in the tables is confusing me. They store like so... Item# // Warehouse 01 // Count Item# // Warehouse 02 // Count Item# // Warehouse 03 // Count Currently, What's in place is a sub report with a "sum" of the "count" field, but it doesn't output correctly (I've confirmed that in the tables). Any chance someone might have a suggestion for me? I know my question is quite vague, so if I can help clarify anything let me know! |
Replies:
Posted By: shanth
Date Posted: 08 Nov 2012 at 10:58am
| Can you explain in detail the main part? Like where(in which section/Detail) the sum(Count) in sub report and what was the error, what you are expecting,.. |
Posted By: Siiig
Date Posted: 09 Nov 2012 at 9:44am
|
I'm still not going to be able to explain it properly, but I did get it working.
I didn't think to look at the sub report's selection formula. Adding selection methods into there, as well as a group summary gave me what I was looking for. |