SQLTeam.com | Weblogs | Forums

Ssrs 2008 with different groupings


#1

In an new ssrs 2008 report, I need to come up with a way(s) to uniquely define how data will appear on the different parts of the report. The only thing that the two part of the report will have in common
is the customer name and customer number.

The data for the first report will look like the following and will need to be grouped by cso_date:

Customer number customer name cso_date item_number
45 customer1 12/03/2001 16
45 customer1 9/12/2010 15
45 customer1 9/12/2010 24
45 customer1 9/12/2010 82
45 customer1 11/03/2010 07
45 customer1 11/03/2010 16

Table defintions
Customer number int,
customer name varchar(30),
cso_date datetime,
item_number int

The data for the second report will look like the following and will need to be grouped by attend_date:

Customer number customer name attend_date Course Number
45 customer1 11/03/2011 2256
45 customer1 9/12/2012 1803
45 customer1 9/12/2012 5689
45 customer1 9/12/2012 1288
45 customer1 1/03/2013 1288
45 customer1 11/03/2013 1803

Table defintions
Customer number int,
customer name varchar(30),
attend_date datetime,
Course Number int

The t-sql that I write, I keep getting all the same data in all the same rows. I want data that is
unique for report 1 versus report 2.

Thus can you tell me how to do the following:

  1. Write the t-sql so that I can uniquely define rows for report #1 versus the rows for report #2?
  2. In the ssrs 2008 report, would you tell me how to uniquely identify the parts of the report that are just for that section of the report?

#2

Hi jassie1,

  1. For unique rows join two tables based on Customer name or number.
  2. The above result set will gives the unique rows, In ssrs add group is available for grouping the data.

Hope it will helps.

Thanks


#3

problem was sql had 2 select statements


#4

Hi,

Please share your sql query and expected report output.