Creating A Report in VB from a database

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • acphiri
    New Member
    • Aug 2007
    • 5

    Creating A Report in VB from a database

    Hello there,
    Please someone to help:I am trying to create a report in VB with access 2003.I've first moved to project/Data environment/data report.In data report i can only go as far as "drawing" the text ("UNBOUND") controls.I dont know what to do next and what properties I need to set to these text boxes.Could anyone help by listing for me step by step,from start, what I need to do.Will greatly appreciate any assistance.
    Andy
  • QVeen72
    Recognized Expert Top Contributor
    • Oct 2006
    • 1445

    #2
    Hi,

    In DataEnvironment , Add a Connection Object Set the Database/Login/Password and Test The Conn. And Add a Command Object to this Connection (By Right Click). Goto Properties of Command Object, Change to SQL Query, Design the Query and Save. Expand the Command Object, depending on the Query, u will be having ield Objects.
    Now in DataReport Drag and Drop the Field Objects of the Command object.
    Save and Run
    to call report :

    DataReport1.Sho w

    REgards
    Veena

    Comment

    Working...