Results 1 to 5 of 5

Thread: Need advice/help in preparing a report

  1. #1

    Thread Starter
    Hyperactive Member csKanna's Avatar
    Join Date
    Dec 2005
    Location
    Tech-Tips-Now.com
    Posts
    339

    Need advice/help in preparing a report

    I am working on a project. I want to print out idcards for staff from my VB6 program. I want my report to have 2 columns with 4 idcards each for the columns making 8 idcards of different staff on a page. I have tries Datareport in vb6 to no avail, i was only able to display a single photo on the report.

    1. What reporting tool can I use to get this type of report
    2. How do I go about using this report

    I am working on VB6 as my front end and Ms-Access as my back end. I dont want to use Access report.

    Please prompt reply will be highly appreciated.

    Thanks

  2. #2
    MS SQL Powerposter szlamany's Avatar
    Join Date
    Mar 2004
    Location
    Connecticut
    Posts
    18,263

    Re: Need advice/help in preparing a report

    We print images and labels by simply using the PRINTER object - gives you a very fine control over X/Y placement of text and images...

    *** Read the sticky in the DB forum about how to get your question answered quickly!! ***

    Please remember to rate posts! Rate any post you find helpful - even in old threads! Use the link to the left - "Rate this Post".

    Some Informative Links:
    [ SQL Rules to Live By ] [ Reserved SQL keywords ] [ When to use INDEX HINTS! ] [ Passing Multi-item Parameters to STORED PROCEDURES ]
    [ Solution to non-domain Windows Authentication ] [ Crazy things we do to shrink log files ] [ SQL 2005 Features ] [ Loading Pictures from DB ]

    MS MVP 2006, 2007, 2008

  3. #3

    Thread Starter
    Hyperactive Member csKanna's Avatar
    Join Date
    Dec 2005
    Location
    Tech-Tips-Now.com
    Posts
    339

    Re: Need advice/help in preparing a report

    But, How?

    Can you provide an example?

  4. #4
    I'm about to be a PowerPoster! Hack's Avatar
    Join Date
    Aug 2001
    Location
    Searching for mendhak
    Posts
    58,333

    Re: Need advice/help in preparing a report

    Moved to reporting section.

  5. #5
    MS SQL Powerposter szlamany's Avatar
    Join Date
    Mar 2004
    Location
    Connecticut
    Posts
    18,263

    Re: Need advice/help in preparing a report

    I do this to print a barcode label on a DYMO label writer:

    VB Code:
    1. Printer.Orientation = vbPRORLandscape
    2. Printer.Font = "Code39XS"
    3. Printer.FontBold = False
    4. Printer.FontSize = 18
    5.  
    6. Printer.Print "*" & strDate & "*"
    7. Printer.CurrentY = Printer.CurrentY + 180
    8. Printer.Print "*"; strMasId & "#" & strProcessor & "*"
    9. Printer.CurrentY = Printer.CurrentY + 180
    10. Printer.Font = "Courier new"
    11. Printer.FontSize = 8
    12. Printer.Print strName
    13. Printer.EndDoc
    We print pictures like this:

    VB Code:
    1. Dim picOut As IPictureDisp
    2.  
    3. Dim imgResizeW As Double, imgResizeH As Double
    4.  
    5. Set picOut = LoadPicture(strPicFile)
    6. Printer.PaintPicture picOut, prtItems(i, 2), prtItems(i, 3), imgResizeW, imgResizeH
    7. ' the arguments are picture, x, y, width, height - last two are optional

    *** Read the sticky in the DB forum about how to get your question answered quickly!! ***

    Please remember to rate posts! Rate any post you find helpful - even in old threads! Use the link to the left - "Rate this Post".

    Some Informative Links:
    [ SQL Rules to Live By ] [ Reserved SQL keywords ] [ When to use INDEX HINTS! ] [ Passing Multi-item Parameters to STORED PROCEDURES ]
    [ Solution to non-domain Windows Authentication ] [ Crazy things we do to shrink log files ] [ SQL 2005 Features ] [ Loading Pictures from DB ]

    MS MVP 2006, 2007, 2008

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