July 19, 2011 at 10:40 pm
I want to put the details of a report field in the group footer, I've looked at the common operators in the expression builder, but I can't see anything that will do the trick.
If the rows returned by the dataset were
[font="Courier New"]Test 1
Test 2
Test 3[/font]
I'd like to be able to make the footer [font="Courier New"]Test 1, Test 2, Test 3[/font]
The actual query behind the dataset is very complex, and takes a long time to run, so I'd rather not duplicate the query.
July 21, 2011 at 9:43 am
Why would you want to repeat data that is in the report in the footer? That seems unnecessarily redundant.
Turning column values into an array is not something SQL does particularly well. You will have to spend some time searching for something like "SQL Server turn column values into comma separated list" or "SQL Server turn column into an array" and see if you find anything useful.
Good luck.
July 21, 2011 at 10:02 am
I would suggest, use UNPIVOT in your query/proc along with your normal data collection to add in the string combination of your values. Search this site, there are many examples.
So you'd want the result set something like:
someCol, unpivotedString
data1, 'data1, data2, data3'
date2, 'data1, data2, data3'
data3, 'data1, data2, data3'
then refer to the "=First(unpivotedValue)" or "=Last(unpivotedValue)" " in the footer's text property.
At least that's the outline of what I would try. Hope it helps.
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgViewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply