how to create a report (NON-CRYSTAL REPORT) in VS 2010 and run it on runtime using a stored procedure

I am trying to use the reporting tool of VS 2010 (it does not support crystal anymore). I can draw the report, however, I got no way to pass the data to it in run time, and have no idea how to display it. The data are from a stored procedure (not a straight forward select statement, it has logic that could use cursors or any other SQL object). I created a design time simple stored procedure (dummy) which has the required interface to help me designing the report, and In run time  I used the report viewer control but I cannot do any thing after that.... The product (the reporting concept) looks like a nightmare puzzle to deal with. Please help with some illustration code in vb.net. Thanks
fmichailAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

mlmccCommented:
VD2010 does support Crystal.  In fact there is a version specifically for VS2010.  It is free but SAP/Crystal has made it a separate download.

If you are interested in using Crystal you can download it from here
http://scn.sap.com/docs/DOC-7824

Other support files
http://scn.sap.com/community/crystal-reports-for-visual-studio

mlmcc

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
fmichailAuthor Commented:
Wow that was fast response mlmcc

I prefer to work using the crystal reports if there would be no issues using my code from VS 2008.

However, I got lost inside SAP, can you please provide some link or instuctions of what to do to install crystal reports in vs2010 from SAP site?. I appreciate your help.
fmichailAuthor Commented:
Hi mimcc,
I selected pack 14 and started to install it, I hope it works, however, I have couple of questions and concerns, which I appreciate if you answer them :
1- Can I distribute the PRT files as usual
2- Do I need to include any runtime component in distribution?

Thanks again
fmichailAuthor Commented:
Thanks a lot mlmcc That was a wonderful solution, I appreciate it.
mlmccCommented:
I haven't researched the licensing but I haven't seen anything that indicates they changed it for the VS versions.  As far as I know you are free to distribute the application, the runtimes, and the report files.

mlmcc
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Visual Basic.NET

From novice to tech pro — start learning today.