Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
chriskhan2000
Aged Yak Warrior
544 Posts |
 Posted - 2005-05-25 : 10:25:04
|
| I want to be able to find a Max value from all records and display it. However when I use the Max Function, all i'm getting is the Max of that record. Anyone know how I would set it so that it will only pull the Max number from all records?Example:=MAX(Fields!Qty.Value) |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-05-25 : 12:25:56
|
| Could you show us a data example? I think what you are wanting is to put it in the grouping, but I'm not sure.Tara |
 |
|
|
chriskhan2000
Aged Yak Warrior
544 Posts |
Posted - 2005-05-25 : 13:46:10
|
| I just got it working now. By putting it in a textbox instead of a table. Example from textbox1.=MAX(Field!Qty.Value)Then in the detail section of the table I put it in the textbox5 like this and hid the column.=ReportItems!textbox1.ValueThen from Header section I set it to:=ReportItems!textbox5.ValueNot the best workaround, but seems to do what it's intended to do.Thanks. |
|
|
|
|
|
|
Custom Code to find Max?