×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

In Report Builder 3.0 SQL 2016, how do I change the order of groups?

In Report Builder 3.0 SQL 2016, how do I change the order of groups?

In Report Builder 3.0 SQL 2016, how do I change the order of groups?

(OP)
Newbie at SSRS but long time experienced Crystal Reports guy. I have developed a report with 3 groups. However I want to change the order of the groups. I cannot find a simple way to do this, as in a drag and drop of the grouped fields or sections. Can anyone point me in the right direction?

Software Training, Implementation, Programming and Support for Macola Progression, Macola ES, Macola 10, Synergy, and Crystal Reports.
Check out our Macola tools:
www.gainfocus.biz/exceladdin.html

RE: In Report Builder 3.0 SQL 2016, how do I change the order of groups?

The easiest solution is what I use for Months of the year. The system will usually alphebtise them. However if I set them up with a numberical value they I can order by that value, Example: 1 = January, 2 = February, etc. When displayed replace the number with the text string.

RE: In Report Builder 3.0 SQL 2016, how do I change the order of groups?

So to add a little more to my previous post. I have a field with numbers representing the order and specific months of the year. When I query I order by that numberical value but display the field that has the months by name.

RE: In Report Builder 3.0 SQL 2016, how do I change the order of groups?

(OP)
Sorry for the late reply, I got pulled off onto another project.

Nylia, you are telling me how to display month names but still sort by month value within a single group. This is not even close to what I am asking.

I have multiple groups. For example Order, Customer, Salesperson. I want to change so that it groups by Order, Salesperson, Customer. The only way I can see to do this is to delete and re-create the groups, which I really do not want to do. In crystal reports I could drag a group inside or outside another and it changed the order of groups in 5 seconds. I am looking for a similar solution in SSRS.

Software Training, Implementation, Programming and Support for Macola Progression, Macola ES, Macola 10, Synergy, and Crystal Reports.
Check out our Macola tools:
www.gainfocus.biz/exceladdin.html

RE: In Report Builder 3.0 SQL 2016, how do I change the order of groups?

Sorry thought you were grouping by month. At the bottome of the Reporting Servces Report Builder you have an area for Row Groups. Have you tried this. I use it to segment out the Weeks within a month.
It might also work to use a clustered index on the there fields that you are considering related, Order, Customer and Salesperson. This clustered index may assist with both speed and ordering.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close