Crystal Report 11 Best Data Source

[idreesbadshah]

Data Source of Crystal Report 11 Can be a Dataset or store procedure.Can any one tell me which one is better.Either fetch data from Database and fill it in dataset and assign it to crystal report or give crystal report datasource direct to store procedure.? Please explain benifits and draw backs of them And what about speed issue.If Crystal report has data soure stored procedure will be loaded fast or Report having datasource Dataset will be loded fast?

[jbracken1973]

I would lean towards a SP, that is what I use on all reports. If you decide to use SP, I would suggest that you would use a SP in each of your reports. This makes working with reports especially nicer if you are working with Infoview/Business objects. The only downside that I can think of is the limitation of is passing multiple values in a parameter from Crystal to the SP, a work around is to parse a comma separated strings. I don’t care to have a Crystal Record selection with a SP it seems redundant and a waste of resources. I can probably think of quite few pros for using a SP but I will just list a few: 1. You have more control of data result, there are many data routines that just is not efficient to try to do in one query statement. 2. You separate your data logic from your report design. Many time I will provide the data and someone else will write the report. 3. If you decide that you don’t like Crystal anymore and you will likely have an easier time with a conversion. 4. You control how the query is written thus if you have performance issues later you can adjust the query without even opening the report. 5. Without go in situations, you also can have a Crystal report execute a SP and that SP updates other tables. I hope this helps John