hi..

i'm trying to make a report using reportviewer but donno how.

i'm using oledbprovider that connect to microsoft access as my primary data for login dan roles control.but i'm using mysql as a primary data for another process like storing record for my application.now i wanna make a report that can view record from mysql table.how can i configure datasource? because when i trying to design report.rdlc and link with mysql table it wont work.

 in my server explorer it display data connection to

1. localhost (mysql) 

2. users.mdb (microsoft access file)

 when i click report->report data sources. in project data source it just display "string(oledbrolesprover.getAllroles())" and others function from microsft access table.

do how can i use mysql to create report?

thanks in advance.