Thanks for the advice. The expression builder implies that you can use the
valueList function... which I still feel is an error. However, on your
suggestion, I created a userdefined function which creates a sub-query based on
the relevant grouping, and then used the valuelist function within that UDF..
this works fine, and is simple code. It was just very aggravating to get to
this point :)
> Um.... If I understand what you're saying, it doesn't have anything
> to
> do with report builder. Do you mean you're outputting a query using
> grouping and you want to have valuelist() work just for that group?
> Valuelist() has never worked that way. You'd have to create your own
> list.
>
> <cfoutput query="myquery" group="mygroup">
> <p>
> #mygroup#
> <cfset mylist = "">
> <cfoutput>
> <cfset mylist = listappend(mylist,
> myOtherColumnThatIWantToValueList)>
> </cfoutput>
> #mylist#
> </p>
> </cfoutput>
>
> On 10/5/06, david plotner <[EMAIL PROTECTED]> wrote:
> > I have not been able to find any input on how to resolve the
> non-functionality of the valueList function within ReportBuilder.
> Anyone have any luck with this, or finding any support for the
> ReportBuilder?
> >
> > I am still trying to find a way to aggregate one field across a
> group into a comma delimited list.
> >
> > Any thoughts, or suggestions for report support? Can't seem to get
> anything from Adobe...
> >
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four
times a year.
http://www.fusionauthority.com/quarterly
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:255673
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
