Or another way would be to pass in parameters, then use those parameters to do conditional stuff.
But as mentioned you could also do the condition before hand <crfreport> Select * from Table <cfif cond1 eq 0> ..... </cfif> </cfreport> Andrew Scott Senior Coldfusion Developer Aegeon Pty. Ltd. www.aegeon.com.au Phone: +613 8676 4223 Mobile: 0404 998 273 -----Original Message----- From: Kris Jones [mailto:[EMAIL PROTECTED] Sent: Friday, 9 March 2007 3:27 AM To: CF-Talk Subject: Re: CF Report Builder You could do the query in CF prior to calling the report, then pass the query into the report. I think you could also setup a parameter to the report, which when set would add the where clause as below? I've not tested this as I always pass my queries into the report rather than embed them. Cheers, Kris > While on the subject of report builder, how can you do conditional queries? > For example on a cfm template I could use the following... > > <cfquery> > SELECT * > FROM aTable > <cfif isDefined('url.someVar')> > WHERE someID = #url.somevar# > </cfif> > ORDER BY someID > </cfquery> > > However this is not possible in report builder so I currently use two > separate cfr files. Is there an alternative to this? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade & see new features. http://www.adobe.com/products/coldfusion Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272105 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
