I have never done anything with cfreport BUT could you not use <cfsavecontent>?
<cfreport I imagine is like <cflocation, as soon as it hits that first tag bam it goes off and everything else stops processing.. So could you use <cfsavecontent> and keep appending after the query calls and then only use 1 <cfreport? If that's not okay you may have to set up buttons or links to open up different reports.. 3 seperate pages with 1 query on each page. On Tue, Jun 17, 2008 at 10:27 AM, John Beirne <[EMAIL PROTECTED]> wrote: > Bilal, > > Thanks for the reply. I think you got me closer to the solution but we're > not quite there yet. I tried adding <cfreport> tags to call the three > reports I'm using but still only got the first one. I'll use your sample to > illustrate what I did. >> <CFQUERY name="firstQuery" datasource="realdatabase"> >> SELECT A,B,C >> FROM table >> ORDER BY DATE >> </CFQUERY> > > <cfreport format="pdf" template="reports/rptWIRDate.cfr" > query="firstQuery"></cfreport> > >> >> <cfquery name="secondQuery" dbtype="query"> >> SELECT * >> FROM firstQuery >> ORDER BY CENTER >> </cfquery> > > > <cfreport format="pdf" template="reports/rptWIRCenter.cfr" > query="secondQuery"></cfreport> >> >> <cfquery name="thirdQuery" dbtype="query"> >> SELECT * >> FROM firstQuery >> ORDER BY BUSINESS UNIT >> </cfquery> > > > <cfreport format="pdf" template="reports/rptWIRBusinssUnit.cfr" > query="thirdQuery"></cfreport> > > I'll see if I can use these three reports as subreports in one report. If > that doesn't work, I'll check back. > > Thanks again!! > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Newbie/message.cfm/messageid:3761 Subscription: http://www.houseoffusion.com/groups/CF-Newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
