Changing Selection Path
Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Technical Questions
Forum Discription: Formulas, charting data, Crystal syntax, etc.
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=22727
Printed Date: 30 Apr 2024 at 7:59pm
Topic: Changing Selection Path
Posted By: Lord Yorkshire
Subject: Changing Selection Path
Date Posted: 12 Feb 2019 at 6:05am
I have an issue in finding some information.
I want to put in a Customer Name. Lets Say Joe Bloggs.
This belongs to a group of Customers. Let’s says code 0006
I then want to see detail about every customer in group 0006
Input
Joe Bloggs
I need my Output to be
Joe Bloggs Credit Limit £5,500 Group Code 0006
Joe Bloggs Scotland Credit Limit £10,000 Group Code 0006
J Bloggs. Inc Credit Limit £5000 Group Code 0006
Joseph Bloggs Credit Limit £20,00 Group Code 0006
Not all Customers are part of a Customer Group. So if there is no Group, I just want that customer
So how do I get Crystal to see if there is a Group Code for a Customer, then show me all the customers for that code, but if there is no Group code, just show me that customer.
Any help would be most appreciated.
|
Replies:
Posted By: Lord Yorkshire
Date Posted: 13 Feb 2019 at 5:58am
After a good nights sleep. It was obvious. The main report shows the Customer, then i pass through the Group Code ( if there is one ) to a subreport.
The subreport then shows all customers in that group.
|
|