I have some questions regarding the ColdFusion Report builder that Iâm hoping
you can help me. Or maybe you can point me in the direction of someone who
might.
The report Iâm trying to build has the header area which contains summary and
the graph contains the detail. There can be many summaries with their
details. We used different approaches to build the report, but the one that
got us closer to the results we wanted was to build the report I used 2
queries. Iâm trying to pass my variable (id) to the 2nd query to get the
related graph. When the report is for 1 single summary/graph, I pass the id to
my 2nd query and it works. But when the report is for multiple summary/graph,
only the first row selected from the 1st query will pass to the 2nd query.
Therefore I have 1 graph with all the data retrieved for all the summaries. It
seams like the <cfloop> doesnât do anything(??!!) Another approach I tried
was to put my graph in a subreport and pass the id as param.id, didnât work
either.
In case it helps, here is the code on my cfm page:
<cfloop query="GetRpt ">
<cfset request.getGraph = getGraph()>
<cfreport format="pdf" template=" payment_Detail.cfr"
permissions="AllowPrinting" Query="GetRpt " overwrite="yes"/>
<cffunction name="getGraph" returntype="query">
<cfset var GraphQuery = ''>
<cfquery name="GraphQuery" datasource="#request.dsn#" >
SELECT id , to_char(invoice_dt, 'MM/DD/RRRR') as invoice_dt
, to_char(invoice_dt, 'RRRR/MM/DD') as sort_invoice_dt
, TO_NUMBER(payment_line_amt,'999999999999') as payment_line_amt
, INVOICE_LINE_AMT
FROM PAYMENT_DETAIL
WHERE ID =#GetRpt.ID#
ORDER BY sort_invoice_dt
</cfquery>
<cfreturn GraphQuery>
</cffunction>
</cfloop>
In the query builder of my chart series I call the request.getGraph so the
chart can see the query. As I said when I pass one id then itâs ok but when
more than 1 id is passed it shows the graph based on the 1st selected row of
data for all other data retrieved by the 1st query.
I want to be able to show the first summary followed by itâs detail graph,
then the second summary followed by itâs detail graph, etc.
Any help or suggestions will be greatly appreciated.
Thank you in advance
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:316608
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
