Top 50% in bold on a report

  • Thread starter Thread starter Shirley A. Kerns
  • Start date Start date
S

Shirley A. Kerns

Hello to all
How can I get a reprt that returns X number of records to display th
top 50% in bold? I am sorting in descending order by cost. I hav
created a query that does this for me but when I use this query for
subreport it only shows the top 50% of records. Is a subreport eve
needed? I need all records to show but only the top 50% to appear i
bold text. Using conditional format on the report requires a
expression that I lack the ability to create. Can I just create th
formula in the properties of the text block? If so, how do yo
express that
Thank you in advance
Shirle
 
Assuming your report is printing in order, you can:
-add a text box
Name: txtRunSum
Control Source: =1
Running Sum: Over All
-Select a control to format
-Select Format->Conditional Format
-Choose "Expression Is"
-Enter this expression
[txtRunSum]<Count(*)/2
-Set the appropriate formats
-Click OK
-Preview Report
 
Hi Duane
Thanks for your speedy response
This worked to a degree. What I got when I ran the report was
descending list starting with the number 1 and ending with the las
recordset of 12. The top 6 records with the new text block wer
displayed in bold as needed. The problem is, it's not the fiel
needed to display in bold. Did I missunderstand? The field name i
[Cost]. How can I reference it to the field name of [Cost]? Can I d
it in the Conditional Format formula
Thank you so much for your help
Shirle
 
When I stated "-Select a control to format" I didn't mean the new text box.
This could be any one of the controls in your report.
 
Back
Top