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?