Flex and Report Builder
I built a screen in Flex that lets you select what filters to have for the report. Date ranges, etc. The CF Report Builder report just accepts a query. The first thought/attempt was to pass all the filters through the URL to the report using navigateToURL(). This worked fine, but other filters were going to be complex variable types. Not to mention the security hole it opened up and creating a very long URL.
So instead I passed all the filter information to a CFC function that stored the filter to the session scope. When that returns, Flex calls the report, which creates the query based on session variables. A bit roundabout way of doing it, but it works!
Advertisement
