I have attached the database with this question. what I am trying to get is the report based on the Classification.
I am looking for something like this
CustimerID 123456
Classification Record Type
1 New Video
1 New Audio
1 Old MMC
1 New Audio
1 New MMC
CustomerID 123456
Classification Record1 Type1
1 A PG
1 AA R
1 AA PG
1 A PG
1 AA R
so what I am trying to get is all the classification together in separate sections. Please see the file attached. Current report is not giving me these results.
Thanks
1
This Question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.
Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.
If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.
Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.
Save solutions to your questions, answers you’ve discovered through searching plus helpful articles in your personal knowledgebase for easy future access.
Access the answers to your technology questions today.
30-day free trial. Register in 60 seconds.
Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.
Try it out and discover for yourself.
30-day free trial. Register in 60 seconds.
Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.
syedasimmeesaq, I can't figure out what you are trying to do.
What grouping are you trying to get? Do you want to show all records for classification 1, broken down by customer, then the same for classification 2, classification 3 etc?
If that's the case you need to add grouping by classification to your main report and filter out the subreports by classification (by setting the master/child link to CustomerID;Classification)
See the file I uploaded
syedasimmeesaq,
The solution here is the exact same solution I posted here:
http://www.experts-exchang
I can't see any difference between the questions?
JeffCoachman
If you look at the grouping and sorting dialogue for the main report then before grouping by CustomerID preceeded grouping by Classification.
In the latest version of the file I uploaded you will see that the order in the grouping dialogue is CustomerID, then Classification.
That means the records are now first grouped by CustomerID. So all records for one customer are together. Within the customer's records they are then grouped by Classification which means that records for classification 1 are printed first, then classification 2 etc.
The master and child fields are the same. The purpose of that is to filter out the records in the subreport, to reflect what is the current record in the main report.
You need filtering by both customerID and classification so that only records for that particular customer and the classification which is being processed at that step are printed.
Business Accounts
Answer for Membership
by: frankyteePosted on 2008-07-02 at 23:51:05ID: 21923216
shouldn't "new" be in a seperate group from "old"?
if so then create a grouping on CustomerID, Classification, Record
in your report groups