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 |
|
wondering_sa
Starting Member
8 Posts |
 Posted - 2012-04-25 : 21:50:46
|
Hi Everybody! Having this strange problem with grouping in tabular report.The dataset looks like this:--------------------------------------------SELECT customer_code, ship_to_code, address_name, contact_phone, dest_zone_code, territory_code, salesperson_code, stateFROM t1--------------------------------------------Trying to group by territory_code, and then by state. And for some puzzling reason some of the states are listed more than once Tried using wizard, adding groups manually, and got the same result in both cases.Any help would be greatly appreciated. Thank you for your time!  |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-04-25 : 22:39:17
|
| what all you've included inside group?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
wondering_sa
Starting Member
8 Posts |
Posted - 2012-04-26 : 00:14:54
|
| Thanks for your reply, visakh16! :)I tried to strip down the report as much as possible to isolate the issue. At this point there is only one field 'customer_code'. (Hopefully, that's what you are asking about) |
|
|
|
|
|
|
Multiples in Grouping