Results 1 to 7 of 7

Thread: Producing Reports

  1. Mar 24th, 2006, 12:08 PM #1
    rasty1611
    rasty1611 is offline

    Thread Starter
    Lively Member
    Join Date
    Feb 2006
    Posts
    111

    Producing Reports

    Hi,

    can anyone please enlight me in how can I produce reports with Visual Basic? I am using Adodc's to extract data and present them in forms through a Datagrid, but I also wish these data (extracted with an SQL statement) to be printed as a report.. But I don't know how to do it. Can anyoone pls heeelp?

    thx
    Reply With Quote Reply With Quote
  2. Mar 24th, 2006, 12:34 PM #2
    juanmf
    juanmf is offline
    Member juanmf's Avatar
    Join Date
    Dec 2005
    Location
    Mordor
    Posts
    46

    Re: Producing Reports

    search information on "datareport" and export to excel.
    If an answer to your question has been helpful, then please, Rate it! where are u?
    On Staying Informed and Intellectual Self-Defense

    There's no way to be informed without devoting effort to the task, whether we have in mind what's happening in the world, or anything else. Understanding doesn't come free. But it's feasible for anyone who is part of a cooperative community -- Same holds for "intellectual self-defense."

    By Noam Chomsky
    Reply With Quote Reply With Quote
  3. Mar 24th, 2006, 12:48 PM #3
    Hack
    Hack is offline
    I'm about to be a PowerPoster! Hack's Avatar
    Join Date
    Aug 2001
    Location
    Searching for mendhak
    Posts
    58,333

    Re: Producing Reports

    Moved to reporting section

    There is also Crystal Reports as well as Access itself.
    Reply With Quote Reply With Quote
  4. Mar 24th, 2006, 01:22 PM #4
    rasty1611
    rasty1611 is offline

    Thread Starter
    Lively Member
    Join Date
    Feb 2006
    Posts
    111

    Re: Producing Reports

    No, you didn't understand. I am developing a system for users and besides viewing fields from the database I want to give to the user the possibility of printing data... So I cannot use Access or excel. I want to have a button, lets say, and that button when pressed prints the data. Please suggest something more appropriate.

    thx a million!
    Reply With Quote Reply With Quote
  6. Mar 25th, 2006, 01:35 AM #5
    PeterBorroloola
    PeterBorroloola is offline
    Member
    Join Date
    Aug 2004
    Location
    Northern Territory, Australia
    Posts
    61

    Re: Producing Reports

    what version vb?
    Reply With Quote Reply With Quote
  7. Mar 25th, 2006, 07:50 AM #6
    rasty1611
    rasty1611 is offline

    Thread Starter
    Lively Member
    Join Date
    Feb 2006
    Posts
    111

    Re: Producing Reports

    6.0 proffessional
    Reply With Quote Reply With Quote
  8. Mar 25th, 2006, 06:28 PM #7
    PeterBorroloola
    PeterBorroloola is offline
    Member
    Join Date
    Aug 2004
    Location
    Northern Territory, Australia
    Posts
    61

    Re: Producing Reports

    if you've got the vb6 cd, look in x:/common/tools/vb/crysrept

    this is crystal reports 4.x - once loaded, you can add the Active X component to vb, add it to your project, and use this to draw up reports.

    format the report in the CR application, then call it from vb by:

    crpReports.ReportFileName = "whatever.rpt"
    crpReports.Destination = 0 ' show report in window first
    crpReports.PrintReport

    where crpReports is the cr4 object added to the project.

    a warning: cr is up to version 11, cr4 is considered hopelessly outdated. But the developer edition of cr11 (the only one you can call from vb) costs US$600 - I'm prepared to put up with cr4 for now.

    good luck, this may open a can of worms, Peter
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width