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.
rozihan
0 Points
5 Posts
reportviewer : mysql + ms access
Oct 05, 2008 03:16 AM|LINK
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.