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??
Joined: 21 Dec 2007
Online Status: Offline
Posts: 4374
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.
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
IP Logged
