I am trying to create a report where a almost-sequential number is to show next to each row. I say "almost" because there are certain circumstances that I need to add 2 instead of 1 to that number.
Now I started off by creating a function in the report builder. Here it is... Simply put, I pass in a number and it figures out how many to add to it. Then it sends that back to the report. <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> In the expression builder I have put: #report.calcNextAudit(param.startAudit, param.voids)# The problem I have is that the same number is printing over and over. I can't figure out how to keep the new value I received from the function in the report. If I could then the idea would be to send it into the function on the next record to get the next higher number. I hope this makes sense. I guess I only see a function as my solution to printing this number per record. So how do I keep the value saving the function result. Thanks for any help. 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:299809 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4