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:3760
Subscription: http://www.houseoffusion.com/groups/CF-Newbie/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
