Collect data from DataSet and show in Text

Hi community,

I've following problem.
I'm using a StoredProcedure for data selection.
In my dataset I group by "Field A", now I want that all different values for "Field A" show up in the header like: value A, value B, value C

Is there any hint, how I could achive this?

regards
Meex

Find more posts tagged with

Comments

bhanley

The easiest solution in my opinion would be to create a second data set that simply does a SELECT DISTINCT on your column you need the values for. If there is some reason you cannot go that route, you could set up a Global Persistent variable and build your string out storing it there. A Global Persistent variable is simply a value you can use globally across the various report processes.

Meex

Thanx Brian,

I have the problem, that I just have that Stored Procedure and no chance to select data explicitly.
I also tried the way with GlobalPersistentVariables, but there I encountered following problems:
I tried to hook on the onFetch Event of my DataSet, there it seems that its not possible to get the data into to a onRender Event of e.g. a Label element, where I want to display the concatenated string. Maybe there's a problem with the order of the events execution?

Second try was to fetch the data per script directly on the group row. The problem is that I can fill the global var. But this var is empty when getting values in onRender phase of my Label.

Meex