Business Card Report

Posted on 2009-04-16
Last Modified: 2012-05-06
Hello I have a report done for Avery business cards layout. I have populated the data with a spreadsheet. Right now I am getting one name per card, how can i make it change names every 5 pages to give 50 cards per name?
Question by:BSAS_ITGuy
    LVL 34

    Expert Comment

    I don't know of any particularly easy way to get multiple records per data record in CR.

     You could have a file/table with 50 records and link your spreadsheet to that, so that the report actually read 50 records for every row in your spreadsheet.

     A real brute force approach is to just create copies of the relevant section(s) in your report.  For example, if you wanted to print 5 labels for every record, you could actually create 5 copies of the label fields in your report.  But 50 copies would probably be a bit much.  :-)

    LVL 100

    Accepted Solution

    Can you make changes to the data tables?

    One way to do this is to create a table with 50 records
    The table would have a two fields
    Count and id
    50 rows of
    50      A

    Add a field to the Name table
    Value for all records is A

    Add both tables to the report
    NewTable INNER JOIN NameTable ON NewTable.ID = NameTable.Id

    This idea will allow you to add rows like
    1    A
    2    A
    2    A
    Thus allowing you to print any umber of cards for a person

    LVL 1

    Author Comment

    Sorry mlmcc, I can add another table but I am not understanding some of your instructions.

    You said add:
    Count and id
    50 rows of
    50      A

    So is it to be like this  Count       ID
                                            1          A
                                             2         B
                                             3          C    

    OR LIKE THIS              Count        ID
                                           50           A
                                            50          A
    LVL 1

    Author Comment

    Sorry mlmcc, I carefully studied you answer and I figured it out:

    My new sheet was like such: Count  ID
                                                   50       A
                                                   50       A
                                                   50       A
                                                    50       B
                                                     50      B
    I did this 50 times for each letter on the count sheet and on the name sheet I added the column ID and went, A, B, C, D, etc all the way down.
    I  joined the tables and place the ID on the report and supressed it and whoopi 50 duplicate cards. Thanks.
    LVL 1

    Author Closing Comment

    This was excellent , it seemed as though this was a first. It still worked.

    Featured Post

    Highfive + Dolby Voice = No More Audio Complaints!

    Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

    Join & Write a Comment

    Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
    There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
    Hi everyone! This is Experts Exchange customer support.  This quick video will show you how to change your primary email address.  If you have any questions, then please Write a Comment below!
    Sending a Secure fax is easy with eFax Corporate ( First, Just open a new email message.  In the To field, type your recipient's fax number You can even send a secure international fax — just include t…

    729 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    20 Experts available now in Live!

    Get 1:1 Help Now