Ya, good point

>>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.
>
>Well, since you can't figure out a way to make this work correctly with your Stored Proc, I'm assuming there's a learning experience going on anyway. <g>
>
>You probably should listen to the "voices of experience" and do a push to CR using DataSets, as is being recommended by 4 people now. =0)
>
>~~Bonnie
>
>
>
>
>>
>>>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?