Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Multiple Datasets From A Single Stored Proc
Message
From
26/06/2008 00:30:12
 
General information
Forum:
ASP.NET
Category:
Reporting
Miscellaneous
Thread ID:
01325445
Message ID:
01326825
Views:
15
Kevin,

I know absolutely nothing about Crystal ... it's too bad Kevin G got banned, but I remember him saying stuff about using DataSets with Crystal rather than using the Stored Procs. In other words, your Report is designed using a DataSet (.xsd I assume, but I don't know) instead of a sproc. When running the report, your app first fills the DataSet, then passes it to Crystal. Don't ask me how to do that, I have no clue. But, perhaps that might give *you* a clue to get you started ...

~~Bonnie



>I posted about this earlier this week, but I still haven't found a solution.
>
>I have a stored procedure which returns 2 data sets. When I load the sproc in Crystal Reports, I can only see the first dataset.
>I really don't want to call seperate procedures for each dataset.
>
>Anyone know how to do this?
Bonnie Berent DeWitt
NET/C# MVP since 2003

http://geek-goddess-bonnie.blogspot.com
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform