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 |
|
osupratt
Posting Yak Master
238 Posts |
 Posted - 2008-03-14 : 10:12:32
|
| How would I get the rownumber() for a Group Footer in report designer? I put the syntax rownumber(nothing), but it is giving me the row numbers for the detail section. Any help would be appreciated. |
|
|
jhermiz
3564 Posts |
Posted - 2008-03-16 : 09:34:43
|
quote:
Originally posted by osupratt
How would I get the rownumber() for a Group Footer in report designer? I put the syntax rownumber(nothing), but it is giving me the row numbers for the detail section. Any help would be appreciated.
=RowNumber(YourGroupName)RowNumber nothing is generally used in the details section to label the row number with the count it is on. To get the row number of the group eliminate nothing and specify your group name.JonWeblog -- [url]http://weblogs.sqlteam.com/jhermiz[/url] |
 |
|
|
osupratt
Posting Yak Master
238 Posts |
Posted - 2008-03-17 : 10:16:19
|
| Do I just add a column and then in the Group field that I want put the RowNumber(MyGroupName)? I've tried this, but it gives me an error. Could you possibly be a bit more specific? My group name is Customer (this is when I click on 'edit group' and it pulls up the window with my name, etc. Is this correct?=RowNumber(Customer)???Thanks for any help. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-03-18 : 07:52:27
|
| You need to put it in the cell where you wnat to display the row number not inside the grouping |
|
|
|
|
|
|
row number on group footer