Click here to Skip to main content
15,922,015 members
Home / Discussions / ASP.NET
   

ASP.NET

 
AnswerRe: Javascript function Calling from Dynamically creating button click event Pin
DoctorMick22-Apr-09 3:01
DoctorMick22-Apr-09 3:01 
QuestionCall Oracle Report Pin
sulimanpasha21-Apr-09 21:13
sulimanpasha21-Apr-09 21:13 
Questionset div width after griddata bound Pin
kishorgh21-Apr-09 21:05
kishorgh21-Apr-09 21:05 
QuestionDefault button in Panel control not working Pin
Niungareamit21-Apr-09 20:54
Niungareamit21-Apr-09 20:54 
AnswerRe: Default button in Panel control not working Pin
RonRasmussen23-Apr-09 3:45
RonRasmussen23-Apr-09 3:45 
QuestionGridview column visible invisible in Javascript problem Pin
Deepml21-Apr-09 20:31
Deepml21-Apr-09 20:31 
QuestionCrystal Report 11 Best Data Source Pin
idreesbadshah21-Apr-09 20:19
idreesbadshah21-Apr-09 20:19 
AnswerRe: Crystal Report 11 Best Data Source Pin
jbracken197322-Apr-09 3:32
jbracken197322-Apr-09 3:32 
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
Questionwasting time in this web site and forum!! Pin
leungoiyu21-Apr-09 20:11
leungoiyu21-Apr-09 20:11 
AnswerRe: wasting time in this web site and forum!! Pin
Ashfield21-Apr-09 21:13
Ashfield21-Apr-09 21:13 
AnswerRe: wasting time in this web site and forum!! Pin
SeMartens21-Apr-09 21:14
SeMartens21-Apr-09 21:14 
QuestionFileUpload Problem Pin
Niungareamit21-Apr-09 20:06
Niungareamit21-Apr-09 20:06 
Questionpostback trigger for Dynamical Controls Pin
sekannak21-Apr-09 19:51
sekannak21-Apr-09 19:51 
QuestionRefreshing a dropdownlist in a FormView Template Pin
Jogenshu21-Apr-09 19:35
Jogenshu21-Apr-09 19:35 
Questiongridview Pin
trimandir prajapati21-Apr-09 18:46
trimandir prajapati21-Apr-09 18:46 
AnswerRe: gridview Pin
Abhijit Jana21-Apr-09 19:10
professionalAbhijit Jana21-Apr-09 19:10 
GeneralRe: gridview Pin
trimandir prajapati21-Apr-09 20:41
trimandir prajapati21-Apr-09 20:41 
AnswerRe: gridview Pin
trimandir prajapati21-Apr-09 20:39
trimandir prajapati21-Apr-09 20:39 
QuestionChanging Crystalreport server in run time Pin
The_Collector21-Apr-09 17:55
The_Collector21-Apr-09 17:55 
QuestionHow to export images to Excel/PDF/WORD in ASP.NET using VB? Pin
leungoiyu21-Apr-09 15:51
leungoiyu21-Apr-09 15:51 
AnswerRe: How to export images to Excel/PDF/WORD in ASP.NET using VB? Pin
Christian Graus21-Apr-09 15:53
protectorChristian Graus21-Apr-09 15:53 
GeneralRe: How to export images to Excel/PDF/WORD in ASP.NET using VB? Pin
leungoiyu21-Apr-09 16:00
leungoiyu21-Apr-09 16:00 
GeneralRe: How to export images to Excel/PDF/WORD in ASP.NET using VB? Pin
Yusuf21-Apr-09 16:14
Yusuf21-Apr-09 16:14 
GeneralRe: How to export images to Excel/PDF/WORD in ASP.NET using VB? Pin
leungoiyu21-Apr-09 16:31
leungoiyu21-Apr-09 16:31 
GeneralRe: How to export images to Excel/PDF/WORD in ASP.NET using VB? Pin
Yusuf21-Apr-09 17:14
Yusuf21-Apr-09 17:14 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.