Crystal Reports dynamic select db stored procedure for subreport

Technical Questions
Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions

Topic: dynamic select db stored procedure for subreport

Author	Message
futureinfuture Newbie Joined: 16 Jul 2009 Online Status: Offline Posts: 5	Topic: dynamic select db stored procedure for subreport Posted: 16 Jul 2009 at 2:23pm
	Hello; It seems that we only can create a report using a database procedure as datasource at design time. How to choose the database procedure based on primary report's data ( I will use procedure as subreport). e.g. dynamically choose datasource. Or using formula?? Any idea? Jean
	IP Logged

lockwelle Moderator Joined: 21 Dec 2007 Online Status: Offline Posts: 4372	Posted: 17 Jul 2009 at 7:07am
	can't dynamically choose a datasource. Sorry, Crystal must have the datasource defined in design time and is not subject to change at run time. You can have lots of subreports that link to different stored procs, but I wouldn't recommend that, as Crystal will evaluate them all, which will be a real drag on performance. Sorry can't be more helpful Edited by lockwelle - 17 Jul 2009 at 7:07am
	IP Logged

futureinfuture Newbie Joined: 16 Jul 2009 Online Status: Offline Posts: 5	Posted: 17 Jul 2009 at 8:10am
	Thanks for your quick info. It is what I expected answer.
	IP Logged

Post Reply

Post New Topic

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

This page was generated in 0.016 seconds.