Trying to remove grouping from query used in report

[kattatonic1]

Hi, I'm updating someone else's database. I am trying to stop the grouping of some data in a report. The users do not want it grouped.

The report has a record source that shows me the following in the Query Builder. I have never written any SQL. I have tried to read online to understand the statements.
SELECT
[Report Detailed Summary1].[Pricing Code],
[Report Detailed Summary1].Group1,
[Report Detailed Summary1].Service,
Mid([Report Detailed Summary1].Detail,3,Len([Report Detailed Summary1].Detail))

AS
detailIRU, Sum([Report Detailed Summary1].[One-Time Price])

AS
[One-Time Price], Sum([Report Detailed Summary1].[Capitalized Price])

AS
[Capitalized Price], Sum(IIf(IsNull([Report Detailed Summary1].[Annual on-going Price]),0,[Report Detailed
Summary1].[Annual on-going Price]))

AS
[Annual on-going Price], [Report Detailed Summary1].Detail, Sum(IIf(isnull([Report Detailed
Summary1].Quantity),0,[Report Detailed Summary1].Quantity))

AS
Quantity

FROM
[Report Detailed Summary1]

GROUP BY [Report Detailed Summary1].[Pricing Code],
[Report Detailed Summary1].Group1,
[Report Detailed Summary1].Service,
Mid([Report Detailed Summary1].Detail,3,Len([Report Detailed Summary1].Detail)),
[Report Detailed Summary1].Detail

ORDER BY
[Report Detailed Summary1].[Pricing Code],
[Report Detailed Summary1].Group1,
[Report Detailed Summary1].Service,
[Report Detailed Summary1].Detail;

I want all mentioned data listed on the report. I don't want the data grouped at all. If I remove the GROUP BY section of the statement, I get this error message:

"You tried to execute a query that does not include the specified expression 'Pricing Code' as part of an aggregate function."

Any help would be appreciated.

[ranman256]

In the grouping/sorting band of the report,...
turn the view OFF.

If you are talking about the QUERY, the turn off SUMMATION.

If you still need summation, remove the FIELD from the summation query.

[ssanfu]

You are talking about two different things: grouping in a query and grouping in a report.

Grouping in a query
The grouping in a query is for getting Totals (field sums). Grouping (and sorting) in a query does not affect the report, only forms and datasheet views.


Grouping in a report
To removing grouping in a report, open the report in design view. Look at the bottom of the window. If you don't see a pane that says "Group, Sort and Total",
click on "Design" (in the green hilite) and click on the "Group and Sort" icon.

Removing a grouping level will delete the controls within that grouping level.


-----------
Be sure to experiment on a copy of your dB...