Sorting for report and subreport

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a report that contains a subreport. The report is a query that pulls
records by entering a fiscal year.

The main report has four fields:
Rank - this field is a running sum
Project #
Project Title
Fiscal Year

The subreport named (Combined) has a calculated field:
Score
Project #

The two reports are link by Project #. I need to sort the calculated field
(Score) which is in the subreport in descending order. How do I accompish
this?

Please help!!!!
TB
 
I want to sort the subreport. The calculation for "Score" comes from two
tables - Tech scores and Grant scores.

Tech scores (Table)
Question1
Question2
Question3

Grant scores(Table)
GCQuestion1
GCQuestion2
GCQuestion3

The calucation is computed in the report and not in the table - so the end
result is not stored anywhere. The calucation is as follows:

Question1 + Question2+Question3=Total
GCQuestion1+Question2+Question3=GCTotal
Total + GCTotal = Score (which is the field in the subreport that I want to
sort in descending order.)
 
You can't sort a report on values calculated in the report unless you can
calculate them in the report's record source. You can use expressions in
your Field/Expression for sorting and grouping like:

=[Quantity] * [UnitPrice] - [DiscountAmt]
You may be able to use:
=Question1+Question2+Question3+GCQuestion1+Question2+Question3

This assumes none of your field values are null.
 
Back
Top