Results 1 to 9 of 9

Thread: print multiple records in one page

  1. #1

    Thread Starter
    Fanatic Member
    Join Date
    Sep 2002
    Posts
    779

    print multiple records in one page

    I have a report set up that I want to print 10 records on one page, but instead it prints 10 pages, the same record 10 times on each page. Can anyone tell me what i'm doing wrong?

  2. #2
    VB Guru ganeshmoorthy's Avatar
    Join Date
    Dec 2005
    Location
    Sharjah, United Arab Emirates
    Posts
    3,031

    Re: print multiple records in one page

    just try removing the check against begin new page.... and also check whether you have any sub sections/groups in your report...
    If an answer to your question has been helpful, then please, Rate it!

    Have done Projects in Access and Member management systems using BioMetric devices, Smart cards and BarCodes.


  3. #3
    VB Guru ganeshmoorthy's Avatar
    Join Date
    Dec 2005
    Location
    Sharjah, United Arab Emirates
    Posts
    3,031

    Re: print multiple records in one page

    also check your coding where you pass values to the report. i.e. in the loop have you put rs.movenext otherwise your query will pass the same values for the recordcount times in the loop...

    hope you understand
    If an answer to your question has been helpful, then please, Rate it!

    Have done Projects in Access and Member management systems using BioMetric devices, Smart cards and BarCodes.


  4. #4

    Thread Starter
    Fanatic Member
    Join Date
    Sep 2002
    Posts
    779

    Re: print multiple records in one page

    Here is my problem, I have a table with a column called tagcount. Suppose a certain record in this table has value of '5' for the tagcount field. I need to show this record 5 times on the same page. Is this possible?

  5. #5
    PowerPoster
    Join Date
    Oct 2002
    Location
    British Columbia
    Posts
    9,758

    Re: print multiple records in one page

    Assuming the field is printed in the Details section.

    Add 4 additional Detail sections. Place a copy of the desired fields into each section. Create a formula to Suppress these detail sections based on the TagCount field.

  6. #6

    Thread Starter
    Fanatic Member
    Join Date
    Sep 2002
    Posts
    779

    Re: print multiple records in one page

    I used the crystal report label wizard to create the report. 2 labels accross 5 labels down. So when displaying the lablels I want to check the tagcount field to see how many labels I need to print for that record.

  7. #7
    PowerPoster
    Join Date
    Oct 2002
    Location
    British Columbia
    Posts
    9,758

    Re: print multiple records in one page

    I used the crystal report label wizard to create the report. 2 labels accross 5 labels down. So when displaying the lablels I want to check the tagcount field to see how many labels I need to print for that record.
    Okay... Is that a question or a solution...

  8. #8
    Junior Member
    Join Date
    Feb 2006
    Posts
    27

    Re: print multiple records in one page

    If you want to do something "more dirty" you can use a temporary table, so before you load the report you run a stored procedure to fill the contents in the temporary table, and you point that table into the report...

    Regards,
    Tribo

  9. #9

    Thread Starter
    Fanatic Member
    Join Date
    Sep 2002
    Posts
    779

    Re: print multiple records in one page

    that was a question

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width