Issue with Passing items form the Subreport into the Field explorer

[Former Member]

We ran into an issue where we are trying to bring table columns from the sub report into the main report field explorer. We've tried using variables and it has not been successful. The table in the main report and the sub report are unrelated. Any assistant would be greatly appreciated.

[JWiseman · Accepted solution]

hello,

if you need the fields in the main report then the table must be in the main report Database Expert. you either have to link the tables (but you mentioned that they are not related) or write a Command object that does a UNION on the two tables. see your database manual for the appropriate syntax though.

the other thing you can look into is Shared Variables which may be the easiest solution...i.e. a value is passed from the subreport to the main report via a variable within a formula. note that this won't show up in the field explorer. please have a look at your online help for shared variables to see if that will work for you.

cheers,

jamie

[Former Member · Accepted solution]

Jamie, 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.

[JWiseman · Accepted solution]

a shared stringvar variable will only bring back one value at a time unless it is an array type. however, you should be able to create a comma separated value that rolls up all of the data from the subreport to pass to the main report.

steps:

1) in your subreport create a new formula with syntax similar to

whileprintingrecords;

shared stringvar srt:= srt + {your subreport field} + ","

2) in your main report create a new formula with syntax similar to

whileprintingrecords;

shared stringvar srt

3) place this new main report formula below the subreport and you'll see the var with the rolled up values

you should now be able to use this new main report formula in the flash variable binding expert.

jamie

[Former Member · Accepted solution]

Jamie, that worked!! Thanks alot.

Is there a limit to the amount of flash variables you can use in crystal? Is there a limit on the size of the data you can pass?

Brian

[JWiseman · Accepted solution]

hey Brian, glad it worked.

as for the comma separated string running total, you can have up to 64k in that string which should in theory be more than enough to pass to the flash / xcelsius widget.

as far as limits go i am not sure about the number of flash vars and if there is a limit. i would imagine that limiting factors for this may come from the flash side of things as i am told that the number of records that can be consumed by the flash / xcelsius widgets is small.

perhaps someone that's done this technique a lot can comment on the number of flash vars and the number or rows that these embedded files can consume?

jamie