>>>Hi all.
>>>
>>>I'm a bit stuck in creating my reports at this stage. I have been evaluating xtraReports, which seems to be a good choice for now. I use StrataFrame framework, which delivers me well structured business objects.
>>>So far, so good.
>>>
>>>I was used to get all my needed report data ready in a Cursor in VFP, and then just let the report use the temp cursor and do its job.
>>>
>>>Before I go through a wierd path, would you guys share your experiences in this matter?
>>>
>>
>>I have done the same with a SP in SQL that will provide the data held in a dataset. Crystal reports as the presentation device.
>
>Hi Stephen, thanks for the input.
>I see, doing it in a SP sounds good, I could write one for each different report that needed this. One thing, though, I would be stuck with SQL Server, wouldn't I? I might have clients with different Databases, so I expect that if I could code this inside the application would make things more flexible. Am I wrong in this?
Trick is that the SP when dragged from the server explorer onto an empty DataSet makes the xml your Crystal report is basing itself on. So you are tied to a back end that does SPs, but the benefits are good. I also prefix the SP name with the namespace of the app so RPT_spNameHere is easy to find for any maintenance.