none
ID Card - Page Setup/Printing Problem

    Question

  • Hi,

    I'm trying to setup a report that will print identification cards for our staff.  I have altered the page setup in the report properties to the correct custom size of the ID card (8.5cm x 5.4cm) & placed a list on the report of the same size where I have placed the various details of the id card including the photo.  Everything appears to work fine & be set to the correct size in the designer but when deployed & printed from the machine that has the card printer the card has been squashed into the top left corner of the card & is about a tenth of the size it should be.  Settings on the card printer all seem to be okay as well.  Any ideas what may cause the report to print out so much smaller than the size it has been setup for?

    Friday, July 16, 2010 11:06 AM

Answers

All replies

  • Hi ,

    Have you checked the page margin sizes , The printable area is the page size minus the margins?

     


    Hope this helps Robert Edgson
    Friday, July 16, 2010 1:06 PM
  • Margins are all set to 0.  It's strange if you print the card on a normal networked printer on A4 the report prints to the correct size but when printed on the ID card printer it squashes to a tiny size (about 1cm X 2cm) in the top left corner of the card.
    Friday, July 16, 2010 1:46 PM
  • Hi ,

    can you print with another application to the IS card printer.

    If you can what page settings is that app using ?

     


    Hope this helps Robert Edgson
    Friday, July 16, 2010 2:04 PM
  • Yeh, use to do the ID cards via Microsoft Access & had no problems using that method.  Page settings in that were similar apart from it had a tiny margin rather than no margin at all.

    The only other thing I can mention is in Report Manager when you look at the print preview the report is stuck in the top left corner rather than filling the whole screen.  It's as though it thinks it should be printing to landscape A4.

    Friday, July 16, 2010 2:29 PM
  • HI

    Does your company secuirty policy allow you to post the the xml?

     

     

     


    Hope this helps Robert Edgson
    Friday, July 16, 2010 2:51 PM
  • Thanks for looking into this I'll have to see what I can do on monday (time to enjoy the weekend now) maybe post some screenshots or something.

    Friday, July 16, 2010 2:57 PM
  • Hi I have some other things for you think about on your return.

    1] what happens when you export to PDF doy you get the same size issue white space issue?

    2] Do you have page footers / headers

    3]  Reporting Service 2008 / R2 introduced a new Page level property called ConsumeContainerWhitespace, which is by default False.

    REF: http://msdn.microsoft.com/en-us/library/ee224246.aspx

    and http://blogs.msdn.com/b/selvar/ 

    Set ConsumeContainerWhitespace = True, which means that RS will consume all whitespace between contents and containers.


    Hope this helps Robert Edgson
    Sunday, July 18, 2010 7:51 AM
  • I've had a quick look at this & exporting to pdf produces an error every time. I tried removing a few items from the report & it appears the error is caused by a text box where the writing mode property had been set to vertical was causing the error (was a text box with vertically aligned text). Without the error it exports fine & the page settings are perfect in pdf, can print the ID card fine. Still have the same problem when printing directly from report manager though. As for your other checks, there are no page footers or headers & the whitespace setting is set correctly. So, I could get a working card printed by exporting to pdf & printing from there but I can't have the vertically aligned banner I wanted & still can print from report manager!
    Monday, July 19, 2010 8:48 AM
  • Hi onemoreround,

    SQL Server Reporting Services uses the RSClientPrint control to print a report. The RSClientPrint control generates the report to b EMF object, and then prints the report using a specified printer.  So, the issue can happen in 2 parts. One is that generating a report to EMF, and the other is the printer driver.

    I have seen some hotfixes that is related to printing issue, even though there is no similar issue that is related to ID printer. So I still recomment that:
            1. Apply the latest hotfix
            2. Update the driver for the ID printer.

    Then check the ID printing is fine or if the the workaround "exporting to PDF, and then print it" Robert provided is fine.

    Besides, you could submit a feedback at http://connect.microsoft.com/sql if that does not help.

    Below are the latest hotfix:
    SQL Server 2005 Service Package 3: http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=ae7387c3-348c-4faa-8ae5-949fdfbe59c4
    Cumulative update package 10 for SQL Server 2005 Service Pack 3: http://support.microsoft.com/kb/983329/en-us
    SQL Server 2008 SP1: http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=66ab3dbb-bf3e-4f46-9559-ccc6a4f9dc19
    Cumulative update package 9 for SQL Server 2008 Service Pack 1: http://support.microsoft.com/kb/2083921

    If you have any more questions, please feel free to ask.

    Thanks,
    Jin Chen


    Jin Chen - MSFT
    Thursday, July 22, 2010 6:30 AM
    Moderator