Just to clarify, there are two different methods to get data to a CR. First is the pull method, where the CR actually pulls the data directly from the data source. This sounds like what you are doing. The other method is the push method, where you retrieve the data in your app using ADO.NET, and then supplying your in-memory dataset or collection class to your CR. I prefer the push method as it property fits a proper n-tier architecture.

>I bought his & Paddock's book on using SQL & Crystal. They talk extensively about using Typed DS. Problem is, my boss knows nothing about them and doesn't want to use this app as a learning experience. So, I'm using sprocs.
>
>>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?