asked on

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

ASKER CERTIFIED SOLUTION

Mike McCracken

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

fmichail

ASKER

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.

fmichail

ASKER

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

fmichail

ASKER

Thanks a lot mlmcc That was a wonderful solution, I appreciate it.

Mike McCracken

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