Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Report Design
Message Icon Topic: Kinda like Mail labels but not. Post Reply Post New Topic
Author Message
Uncle Emmett
Newbie
Newbie
Avatar

Joined: 24 Dec 2013
Online Status: Offline
Posts: 4
Quote Uncle Emmett Replybullet Topic: Kinda like Mail labels but not.
    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 

IP IP Logged
bwsanders
Senior Member
Senior Member


Joined: 05 Sep 2012
Location: United States
Online Status: Offline
Posts: 177
Quote bwsanders Replybullet 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.
IP IP Logged
Uncle Emmett
Newbie
Newbie
Avatar

Joined: 24 Dec 2013
Online Status: Offline
Posts: 4
Quote Uncle Emmett Replybullet Posted: 02 Jan 2014 at 5:03am
Thanks I look into it.
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.016 seconds.