Re: Creating Report with ReportViewer in remote reporting
with mysql

You should create a client-side report (Local Report) using the RDLC. Have you
data access code fetch a dataset from MySQL. Bind this DataSet to your RDLC
programmatically and load the RDLC in the Report Viewer. Your code will go
something like this:

 rvReportViewer.LocalReport.ReportPath =
"MyReportFile.rdlc";ReportDataSource rdcReportSource =
newReportDataSource();

rdcReportSource.Name = "MyDataSetName";

DataSet ds = MyDataAccessLayerClass.GetSomeData();

rdcReportSource.Value = ds.Tables[0];

rvReportViewer.LocalReport.DataSources.Add(rdcReportSource);

rvReportViewer.LocalReport.SetParameters(parameters); //in case you want to pass
any application-specific values from your code to the report (e.g. Date Range
for the report)

rvReportViewer.LocalReport.Refresh();

Hope this helps...

Thanks for the reply.

The coding are helpful for local reporting. I'm trying to develop an application
that generate a report that was located in a server a.k.a remote reporting. Is
there any possible way...?

Hello, i'm a newbie in this asp.net and mysql technology. would someone help me
how can i create a report using the report viewer in the remote reporting with
mysql using rdlc without using the MS SQL server reporting technology. Is it any
way to do it?? Is it possible??

Thanks.