Thread: data report use

    #1
  1. Just another guy
    Devshed Frequenter (2500 - 2999 posts)

    Join Date
    Jun 2003
    Location
    Wisconsin
    Posts
    2,953
    Rep Power
    261

    data report use


    I'll admit right up front that vb is not my language, and I'm basically clueless about it. Anyway, I'm trying to make a data report to display certain information from a database, so that the report (or something like it?) can be attached to an email and later printed. My "Step by Step with Visual Basic 6.0 Professional" book doesn't seem to mention data reports at all, and I don't know how to use them. I've made my data environment and command, and bound my text fields to the desired records, but now what? I'm not looking for a specific answer so much as some links to some good resources. Google is not very helpful when you have no idea what you're looking for, lol. Anything about basic data report construction and usage would be very helpful. Thanks for helping my learning process .
    --Dave--

    U2kgSG9jIExlZ2VyZSBTY2lzLCBOaW1pdW0gRXJ1ZGl0aW9uaXMgSGFiZXM=

    My hobby: collecting US coins
  2. #2
  3. No Profile Picture
    Contributing User
    Devshed Regular (2000 - 2499 posts)

    Join Date
    Jan 2003
    Location
    No es importante
    Posts
    2,065
    Rep Power
    14
    The online MSDN can be useful. Maybe you should narrow your beginnings and attempt to prose a question.
  4. #3
  5. Just another guy
    Devshed Frequenter (2500 - 2999 posts)

    Join Date
    Jun 2003
    Location
    Wisconsin
    Posts
    2,953
    Rep Power
    261
    Oh, I'm trying, believe me.
  6. #4
  7. No Profile Picture
    Contributing User
    Devshed Regular (2000 - 2499 posts)

    Join Date
    Jan 2003
    Location
    No es importante
    Posts
    2,065
    Rep Power
    14
    Can you create a data environment and a data report?
  8. #5
  9. Just another guy
    Devshed Frequenter (2500 - 2999 posts)

    Join Date
    Jun 2003
    Location
    Wisconsin
    Posts
    2,953
    Rep Power
    261
    Ok, now I have a better handle on things, and the question is:
    Can a data report be attached as a viewable file to an email?
    I can make a data environment, command, and datareport. What I need to do is take information from a database and populate some fields in a form, with some other fields remaining blank. All fields need to be labeled. This form then is attached and sent via email. I tried to do this with an excel sheet via asp, but couldnt make the connection work. Thus, I am trying to do a similar thing with a data report instead. This may not be the clearest question, I can clarify as needed (I hope).

    Summary: I need to make a form with some fields containing data from a database (gotten from an internet form), then attach the form to an email. Can a data report do this? (via export perhaps?)
    Last edited by karsh44; June 30th, 2003 at 08:06 AM.
  10. #6
  11. No Profile Picture
    Contributing User
    Devshed Regular (2000 - 2499 posts)

    Join Date
    Jan 2003
    Location
    No es importante
    Posts
    2,065
    Rep Power
    14
    The data report has export functionality. You can do this.
  12. #7
  13. Just another guy
    Devshed Frequenter (2500 - 2999 posts)

    Join Date
    Jun 2003
    Location
    Wisconsin
    Posts
    2,953
    Rep Power
    261
    Ok, final question. I've made a data report and environment. I bound the appropriate fields to the right values. Now I'm just having a problem making empty fields. When I do "datareport1.show" to check things, I get "Error: Datafield'(empty)' not found". How would I go about adding empty fields to the report? (preferably with borders, like excel cells)
  14. #8
  15. No Profile Picture
    Contributing User
    Devshed Regular (2000 - 2499 posts)

    Join Date
    Jan 2003
    Location
    No es importante
    Posts
    2,065
    Rep Power
    14
    You can either create static entries in the query or just create an empty text box or label in the report.
  16. #9
  17. Just another guy
    Devshed Frequenter (2500 - 2999 posts)

    Join Date
    Jun 2003
    Location
    Wisconsin
    Posts
    2,953
    Rep Power
    261
    Ok, that should do it for this particular project. Thanks a lot for your help, vpendleton.

IMN logo majestic logo threadwatch logo seochat tools logo