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 |
|
pecunn
Starting Member
20 Posts |
 Posted - 2011-04-14 : 04:29:41
|
| Hi Guys,I had report with row header and coluom header, in query the months is sorted by financial year and i can see its working in SQL management Studio. However when i put in into the report is automatically sort by alphabet A-Z.I went to group header and all coloum header etc2 there is nothing say about sorting.I have tried to add sorting in tablix propertis to Z-A and it still sorted from A-Z.Can anyone help me how to sort by financial month? |
|
|
ajthepoolman
Constraint Violating Yak Guru
384 Posts |
Posted - 2011-04-14 : 09:21:35
|
| I have had instances where sorting didn't work the way I wanted it to. Probably a missed setting on my part, but that sort of "self help" is worthless when you are ready to fling the computer through a window. One hack I used is to add another int column to the resultset that had the proper ordering in it (1 through 100 or whatever) and then put that column into the group. I then hid the column. Hack, but it did the trick.Hey, it compiles. |
 |
|
|
pecunn
Starting Member
20 Posts |
Posted - 2011-04-14 : 21:09:23
|
| Ok thank you i will give a try.cheers ajthepoolman |
|
|
|
pecunn
Starting Member
20 Posts |
Posted - 2011-04-17 : 20:27:32
|
| Fixed this problem.There is sorting option under coloum group, delete that and everything sorted based on by query in dataset.Thanks all |
|
|
|
ajthepoolman
Constraint Violating Yak Guru
384 Posts |
Posted - 2011-04-18 : 09:22:01
|
| Oh I'm sorry I must have misread your post. I thought that you had set the sorting up under the group but it wasn't sorting the way you expected it to.Hey, it compiles. |
|
|
|
|
|
|
Sort by financial year