• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 175
  • Last Modified:

Data environment reports

Can anybody tell me how to use a data environment reports in VB.
Please give me a little elaborate example if possible.

let me give you this case.

i have to show a report. data is stored in a table in access. i have to fetch this data through a select *...query and show it in the report.

1 Solution
Mahdi MansourDesign Monitoring & Evaluation ManagerCommented:
first: u havt to add dataEnvironment from the menu->Project->more activex designers->dataenvironment

a new window will open ,go to the connection propertes
select provider: microsoft jet 4.0 ....... "for access db"
press next and then enter ur db name "with the path "
press ok.

then right click on the connection1->add command1
right click on command1:
source of data:Table
objectName: here u choose the name of ur table that u want to show in ur report
then from Menu->project->Add Data Report
from propertes of the data report :
data source: DataEnvironment1
DataMember: Command1

then go to the coomand1 and grad it and drop it in the data report.

now to show ur report from let say a coomandbutton on aform


seitoAuthor Commented:

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now