Crystal Reports Stored procedure executes multiple times

Report Design

Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design

Topic: Stored procedure executes multiple times

Post Reply

Post New Topic

Author	Message
krkanss Newbie Joined: 11 Feb 2013 Location: India Online Status: Offline Posts: 2	Topic: Stored procedure executes multiple times Posted: 12 Feb 2013 at 5:57pm
	I have created a crystal report which has three subreports and a stored procedure as datasource all use same parameters in the sp but the sp is executing 7 times. I think it should execute just one time for same parameter values. kindly help
	IP Logged


Sastry Moderator Joined: 16 Jul 2012 Online Status: Offline Posts: 537	Posted: 12 Feb 2013 at 6:07pm
	HI Go in File--Report Options-- un-check Verify Stored Procedures on First Refresh option. Do it for all your main report and sub reports.
	Thanks, Sastry
	IP Logged

krkanss Newbie Joined: 11 Feb 2013 Location: India Online Status: Offline Posts: 2	Posted: 12 Feb 2013 at 10:23pm
	Hi Sastry I have already done that but still facing same issue.I have also optimised my sp. what cud be the possible reason for multiple execution of sp Edited by krkanss - 12 Feb 2013 at 10:43pm
	IP Logged

Sastry Moderator Joined: 16 Jul 2012 Online Status: Offline Posts: 537	Posted: 13 Feb 2013 at 12:10am
	Hi Your parameter can't limit Stored procedure execution. Where you placed your sub reports ? If you are placing in Detail or Group then it will get processed multiple times. Check how many times your sub reports are repeated in your report. Edited by Sastry - 13 Feb 2013 at 12:12am
	Thanks, Sastry
	IP Logged

Printable version

Printable version

Forum Jump

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum