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!

*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.

Jobs

SSRS trouble with simple table and group by functionality

SSRS trouble with simple table and group by functionality

(OP)
am new to SSRS and need to build a simple table that shows the following desired result
division_name sent_leads referrals
East 20 5
West 15 3
North 45 10
South 36 11

The dataset it's based on brings in the following values:
org_name
, division_name
, count(sent_leads)
, count(referrals)
, year
, month

notice that it's got a month column. I need that month column for other charts on the same report but not for the particular one that I'm having trouble with.
When I attempt to get desired result in SSRS, the division names are getting repeated, for as many distinct months worth of data that I have in the dataset, even though I'm not pulling in the month as a column
division_name sent_leads referrals
East 56 2
East 46
East 20 5
West
West
West 15 3
North
North
North 45 10
South
South
South 36 11

In design view I use a table item, I have division name as parent group and sent_leads and referrals are Summed. It's pretty straight forward, but the sent_leads are getting broken down by however many distinct months are in the dataset.

How can I get true grouping by division?

RE: SSRS trouble with simple table and group by functionality

Couple of ideas:
1. try sticking the year and month in the group by section of the report
2. try just building another dataset that has things grouped the way you want.. assuming the query is not a very resource intensive query, tha tis.

"But thanks be to God, which giveth us the victory through our Lord Jesus Christ." 1 Corinthians 15:57

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!

Resources

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