|
-
Jun 11th, 2007, 06:27 PM
#1
Thread Starter
Addicted Member
Parameters from Stored Procedures not shown during CR report creation wizard
I couldn't figured out this:
My system: VS C# 2005, SQL server 2000.
When I created a crystal report using a stored procedure with parameters as report datasource through report wizard, I had this problem:
If I chose OLE DB (ADO) connection, I could see it automatically set the parameters in the parameter fields in CR, which means everything is fine!
If I set the stored procedure as ADO.NET Dataset and use it as datasource, there is no pupup for parameters during report creation wizard. When I checked tableadapter for the stored procedure in the dataset, I can see the GetData(@mypara) works fine
I would prefer ADO.NET approach. but I couldn't figure out why it didn't work out.
Search around didn't find anything . Any clue?
thanks
I figured out why. CR treats the ADO.NET Dataset objects different from OLE DB Datasource. You wouldn't see real data unless you push the data into the dataset first. So there are no parameters popup. It is OK
Last edited by Winla; Jun 12th, 2007 at 02:10 PM.
-
Jun 12th, 2007, 03:37 AM
#2
Member
Re: Parameters from Stored Procedures not shown during CR report creation wizard
use OLE DB .net is a bit of a problem
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|