Joined: 23 Jan 2012
Location: United States
Online Status: Offline
Posts: 5
Topic: Data from Sub report in Main Report Field Explorer Posted: 23 Jan 2012 at 4:21am
Hello,
I have a sub report in my main report and they are two unrelated sets of data. Using the formula explorer I'm trying to pass the entire data set from the sub report into the main report field explorer. I've tried looking at the Crystal white paper on how to pass data from the subreport to the main report, but that has not worked. Thanks.
Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
Posted: 23 Jan 2012 at 5:56am
The simple answer is that you can't. You can pass single values - individual fields, formulas, summarized (aggregated) fields, etc. but you can't pass the whole data set.
What are you trying to do with this data set? There may be another way to do this.
Joined: 23 Jan 2012
Location: United States
Online Status: Offline
Posts: 5
Posted: 23 Jan 2012 at 6:21am
Hi Dell, We are trying to embed an Xcelsius dashboard using flash variables to utilize Crystal's bursting feature. In order to bind the flash variable to the Dashboard, the data set has to be in the main field explorer. Since some of the tables are unrelated we have to use sub reports to avoid a cartesian. Using shared variables we have been unsuccessfully at bringing the whole data set back to the main field explorer.
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
