help with a report - newbie

• wannabe1

  SSCommitted

  Points: 1960

  More actions

  February 20, 2015 at 8:43 am

  #314700

  Hello

  I am new to SSRS reports and I need advise on how to create a report. i have 2 tables.

  the report should like this. find pkg with version (group my major versions) and sum of all those counts and the last modified from all those sub packages.

  is this possible to do using SSRS. please let me know. -- thanks

  name sum(count) last_modified

  pkg-1.0 7 1/20/15

  pkg-0.9 11 7/3/14

  pkg-2.0 4 2/1/15

  1) table1

  id name

  1 pkg-1.0.1

  2 pkg-1.0.2

  3 pkg-0.9.2

  4 pkg-0.9.0

  5 pkg-0.9.1

  6 pkg-2.0

  2)stats

  id count modified

  1 2 2/15/14

  2 5 1/20/15

  3 1 1/1/14

  4 7 4/5/14

  5 3 7/3/14

  6 4 2/1/15

• SQL.AP

  Hall of Fame

  Points: 3244

  More actions

  February 23, 2015 at 11:08 pm

  #1779481

  Yes, you can do this in SSRS. Try using below query in your dataset and create a table in your report to display the output.

  SELECT name, SUM(count), MAX(modified) as last_modified

  FROM table1 a

  JOIN table2 b

  ON a.id = b.id

  GROUP BY name

  ____________________________________________________________

  AP