Last post Aug 23, 2012 12:50 AM by Ajay2707
Aug 17, 2012 12:36 PM|vc_ind|LINK
I am using crystal report XI. I have one SP which I call in my main report and sub report. I want to avoid calling SP twice. Is there any way?
Or Can I generate a report without sub-report in below format.
Department wise report
Report Name Dept Name Member Count
Contract Distribution Centre 4
Employee Distribution Centre 10
Contract Customer Service 3
Report Name Member Name Dept Name
Contract name1 Distribution Centre
Contract name2 Distribution Centre
..... ...... .....
Aug 23, 2012 12:50 AM|Ajay2707|LINK
There is no option to stop calling sp twice. Because If it not executed then your sub report data will not comes.
For your problem, you can do it by simply make one sp which give the same result as you mention above. For that make function or inner query or sub-query.
So grouping will done in sp and give column name for that. The same column in use in report.
In your case, Dept Name and Member Name, use 2 sp in report and in report formula give join formula. so it works as a one sp in grouping.