I got this to work the inner loop to work by setting a variable for the Get_Report_Data.Client_ID value and using the inner loops, which I've always used, but I don't quite grasp how to use the grouping method in place of the inner loops.
By studying your examples below, it seems that I would need to group the various query data on the output and not for the query itself? And how would grouping provide information for the innermost query in place of setting a variable? Thanks for your help! Rick > (or just use the single query/cfoutput/group method ;) > <cfoutput query="Get_Report_Data" group="Client_ID"> > <!---Output client data---> > <cfoutput group="company_id"> > <!---Output company data---> > <cfoutput> > <!---Output account data---> > </cfoutput> > </cfoutput> > </cfoutput> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:261349 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
