Multiple cfoutput groups

Question

I have a report and need the results displayed in multiple
groups. From one query result set I am using the cfoutput tag with
the query and group attributes to display the results (types and
number of workers) by mealtime (Lunch and Dinner). This works fine
but I also need the types of workers grouped (with each mealtime)
by which part of the restaurant they work in (front, back,
management). To do this within the aforementioned cfoutput tag I
added another cfoutput tag with a second group option. This almost
worked but the problem is that I am only getting the first row of
data from each one of the subgroups (where they work) and not all
of the rows. I tried adding the query attribute to the nested
cfquery attribute but that is not allowed.

Has any one used multiple group attributes in nested cfoutput
tags? Can it be done? If so, what am I don't wrong. If not is there
another way?

Thanks,

Jason

Anonymous · Accepted Answer

CF won't allow you to nest two query driven cfoutput tags. I posted this question to my cfgroup and they were able to answer it.

ANSWER:
At the lowest level, you will want a simple cfoutput without a group on it.

<cfoutput query="qry_my_query" group="outer_grouping_column">

<cfoutput group="inner_grouping_column">

<cfoutput>

</cfoutput>

</cfoutput>

</cfoutput>

Answered by Matt Jones and Brad Wood of the KCDevCore group. Thanks guys!

Newsgroup_User · Answer

jasonpresley wrote:> Has any one used multiple group attributes in nestedcfoutput tags? Yes, many times.> Can it be done? Of course, that is the whole point of the group attribute.> If so, what am I don't wrong. I don't know. You did not show what you actually did!> If not is there another way?Several, but it does not sound like they are necessary.If I had to *guess* from your imprecise description, itsounds like you have forgotten the final inner block withoutany group parameter.The basic structure is as follows:Stuff to output once per value of aColumn Stuff to output once per value of bColumn . . . Stuff to output once per value of nColumn Stuff to output for every record in the query Stuff to output oncer per value of nColumn Stuff to output once per value of bColumn Stuff to output once per value of aColumn

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded