I need some help figuring out in the report builder how to work with a variable
and a function.
Basically this report is showing a sequential number beside each record. The
number however isn't always 1 more than the last. Sometimes it is 2 greater or
3. So I built a function to determine the new number.
<cffunction name="calcNextAudit">
<cfargument name="nextAudit" type="numeric">
<cfargument name="voids" type="string">
<cfset goodAudit = "N">
<cfloop condition="goodAudit EQ 'N'">
<cfif listFind(voids, nextAudit)>
<cfelse>
<cfset goodAudit = "Y">
</cfif>
<cfset nextAudit = nextAudit + 1>
</cfloop>
<cfreturn nextAudit >
</cffunction>
OK - so the function returns the "nextAudit" number and prints on record #1.
But then the next call to the function results in the same result
over-and-over. I can't figure out how to save the last function result and use
it to pass in the next time.
Any help is greatly appreciated.
Kim
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299810
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
