how to test RDL report and how to chage datasource at runtime

fmichail
fmichail used Ask the Experts™
on
How to preview Microsoft report (rdlc) in the reportviewer cntrol in the winform if I am using a stored procedure to retreive the data. please notice that the stored procedure includes a parameter.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Most Valuable Expert 2012
Top Expert 2014

Commented:
This MSDN article gives a pretty thorough walk-through of creating reports in .NET:

https://msdn.microsoft.com/en-us/library/ms252073%28VS.80%29.aspx?f=255&MSPPError=-2147217396

In my case, I created a DataSource for my report, and then retrieved the data needed to populate the report using standard Datatables and such. I then filled my DataSource table(s) with that data, and then used this code to setup and show my report:

 With rvJobCost
                    .LocalReport.DataSources.Clear()
                    Dim rds As New ReportDataSource("ReportData", jobs.Tables("Report"))
                    .LocalReport.DataSources.Add(rds)
                    .LocalReport.SetParameters(params)
                    .RefreshReport()
End With

In the code block above, the rds object is filled using the jobs.Tables("Report"), which was created from the datasource used when creating the report.

I have no idea if this is "best practice" or not, but hopefully some of the more knowledgeable .NET Experts will chime in with better ideas!

Author

Commented:
Thanks Scott

The code that you provided is used in runtime, however, how to test the report duing design time (i.e. preview it).

I will read the link that you provided, and let you know, hopefully it has a good way to handle subreports programatically.
Most Valuable Expert 2012
Top Expert 2014
Commented:
You asked how to change the datasource at runtime, so I'm not sure what you mean by your last comment.

If you want to preview the report, just run the application from Visual Studio and view the report in your reportviewer (assuming you have one).

Author

Commented:
Hi Scott,
Actually it is my mistake, I changed the description of my question (Before I got any answer).Your Answer, and the link is greatly appreciated. And now I know from you that the way to test thereport is always through running it in areport viewer. nks Scott

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial