Grouping Problem using report Builder - 8 & passed query

[Guest]

Everyone,

I am trying to get the grouping to work but right now it does nothing.  I am using the <cfreport> tag to open the report and passing in a query returned from a cfc.

I have not set up RDS or anything, just adding fields as needed in report builder, making sure they are in the query I am passing.

When I add the group (based on the order_fence_id field), I do not get any change in the pdf generated, despite adding fields in either the Column Header or Group Header.

Any ideas / help is greatly appreciated.  Even a "you can't do it that way" would be nice if that really is the case.

Below is all the pertinent code I can think of...

Thanks in advance

Mark

I am pulling up a report from a grid, the code looks like this;

<cfif isDefined("CFGRIDKEY")>
    <cfset orderNumber = #CFGRIDKEY#>
</cfif>
<cfinvoke
    component = "anderson.components.orders"
    method = "displayOrderForm"
    orderId = "#orderNumber#"
    returnVariable = "orderFormData"
>

<cfreport
    format = "PDF"
    template = "OrderForm.cfr"
    query = "orderFormData"
>
</cfreport>

The cfc method looks like this;

<!---
    DISPLAY ORDER FORM
--->

<cffunction
    name="displayOrderForm"
    returnType="query"
>

    <cfargument
        name="orderId"
        type="numeric"
        required="yes"
    >

    <cfquery name="getSavedOrder" datasource="#session.datasource#">
        Select    *
        From        order_display
        Where        order_id = #arguments.orderId#
        Order By    order_fence_id
    </cfquery>
   
   
    <cfreturn getSavedOrder>
</cffunction>

[Guest]

FIXED!!

I setup coldfusion on the box I was running ReportBuilder, attached the database and used the built-in controls and everything worked.  The only thing different I can tell is that the prefix "query" was added, so it now groups on query.order_fence_id

I haven't had time to test it without the coldfusion and database hookup.  Hopefully this will help someone else who is using ReportBuilder on a machine without the database attached.

Mark Moellering