title: Grouping in SSRS?
body: <p>i am new to the <strong>SSRS</strong> and Have data as below </p>
  
  <pre><code>RCnt Jobnumber NJCT          JD                 pmt    flag cnt1 cnt2
  2   001008      0   PRESSURE SEAL               PSI Y   0   0   2
  2   001008      0   PRESSURE SEAL               PSI Y   0   0   10
  2   001008      0   PRESSURE SEAL               PSI Y   0   0   1
  1   001009      0   Single Sheet Duplex Legal   PSI Y   0   0   1
  1   001009      0   Single Sheet Duplex Legal   PSI Y   0   0   4
  6   001010      0   Single Sheet Duplex Legal   PSI Y   0   0   6
  5   001011      0   Single Sheet Duplex Legal   PSI Y   0   0   5
  5   001011      0   Single Sheet Duplex Legal   PSI Y   0   0   3
  13  001012      13  Single Sheet Duplex Legal   PSI Y   0   13  0
  13  001012      17  Single Sheet Duplex Legal   PSI Y   0   17  0
  13  001012      8   Single Sheet Duplex Legal   PSI Y   0   8   0
  </code></pre>
  
  <p>And i want to display it as below ,</p>
  
  <pre><code>jobNumber  NJCT   JD                          cnt2   Rcnt
  001008    0     PRESSURE SEAL                13        2
  001009    0     Single Sheet Duplex Legal    5         1
  001010    0     Single Sheet Duplex Legal    6         6
  001011    0     Single Sheet Duplex Legal    8         5
  001012    38    Single Sheet Duplex Legal    0         13  
  
  TOTAL    38                                 32         27
  </code></pre>
  
  <p>I know this grouping can be done at the server level in query but i don't have access to query and  have to format this data as below in report using <strong>SSRS</strong> may be this is simple grouping i don't know when i googled about grouping it given me column level and row level grouping which left me very confused so any help related to this will be very helpful.Any links are also welcome to get grouping like this in <strong>SSRS</strong> report.</p>