Kinda like Mail labels but not.
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=20317
Printed Date: 06 May 2024 at 9:28pm
Topic: Kinda like Mail labels but not.
Posted By: Uncle Emmett
Subject: Kinda like Mail labels but not.
Date Posted: 27 Dec 2013 at 10:34am
I'm creating a report with specific Criteria.
1. It will be on an 8 1/2 x 11.
2. Each employee will have employee name, spouse, addresses 1 and 2, C/S/Z and two Phone numbers.
Totaling 6 line per employee.
3. Owner's name will appear on the top two columns with different addresses.
4. After that the employees in alphabetical order.
5. 2 roles with 7 employees per page.
6. The report uses only one table.
It looks like mailing labels but it is just a listing of employees.
I have taken the label wizard and got close to those spec's, but not the seven employees per page. I have just 6. Maybe a little more tweaking.
Then some questions arise;
How can I extract the owners name from the list and place them at the top and then start printing the other employees? Then suppress him later.
Should I create a sub-report with the rest of the employees. But how do I make it look like mailing labels?
Right now this list is run on an excel spread sheet with tons of macros to achieve the report.
I would appreciate any help at all. Please.
Mark
|
Replies:
Posted By: bwsanders
Date Posted: 31 Dec 2013 at 4:27am
Try using cross tabs. They are tricky but I was able to get something similar to this.
create your field that will have your emp info and put that for your columns and you can create a field for the owner and have that as the header maybe.
again, it's not a definite but it's worth a shot.
|
Posted By: Uncle Emmett
Date Posted: 02 Jan 2014 at 5:03am
|