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?
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
ColdFusion MX7 and Flex 2
Build sales & marketing dashboard RIAâs for your business. Upgrade now
http://www.adobe.com/products/coldfusion/flex2
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272023
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
