Vertical alignment issue with SSRS

• Bad_Karma

  Default port

  Points: 1439

  More actions

  May 15, 2018 at 10:50 am

  #1990557

  So, I think your problem might be related to using a rectangle directly instead of a List. A list will repeat the rectangle for every "group" you designate it for. Whereas a rectangle by itself is stagnant. However, I'd suggest just using a single Tablix instead and using the row grouping to achieve your format. If you need to page break you can go to the group properties and tell it to break on each member of the group. The below is a sample of achieving the beginnings of the format you're trying to achieve (minus any page breaking).
  

  Here is the output
  

  Test dataset I used. 
  DECLARE @Agency table
(
  NumAgency  varchar(2)
  ,NumDepartment varchar(13)
)

  INSERT INTO @Agency
VALUES
( 'A1' -- NumAgency - varchar(2)
  ,'D1' -- NumDepartment - varchar(13)
)
,( 'A1' -- NumAgency - varchar(2)
  ,'D2' -- NumDepartment - varchar(13)
)
,( 'A1' -- NumAgency - varchar(2)
  ,'D3' -- NumDepartment - varchar(13)
)
,( 'A2' -- NumAgency - varchar(2)
  ,'B1' -- NumDepartment - varchar(13)
)
,( 'A2' -- NumAgency - varchar(2)
  ,'D2' -- NumDepartment - varchar(13)
)

  DECLARE @InfoDepartment table
(
  NumDepartment varchar(3)
  ,NameDepartment varchar(30)
  ,InfosSup   varchar(20)
)

  INSERT INTO @InfoDepartment
(
  NumDepartment
  ,NameDepartment
  ,InfosSup
)
VALUES
( 'D1' -- NumDepartment - varchar(3)
  ,'Test D1' -- NameDepartment - varchar(30)
  ,'ABC' -- InfosSup - varchar(20)
)
,( 'D2' -- NumDepartment - varchar(3)
  ,'Test D2' -- NameDepartment - varchar(30)
  ,'ABC' -- InfosSup - varchar(20)
)
,( 'D3' -- NumDepartment - varchar(3)
  ,'Test D3' -- NameDepartment - varchar(30)
  ,'ABC' -- InfosSup - varchar(20)
)
,( 'B1' -- NumDepartment - varchar(3)
  ,'Test B1' -- NameDepartment - varchar(30)
  ,'ABC' -- InfosSup - varchar(20)
)
,( 'B2' -- NumDepartment - varchar(3)
  ,'Test B2' -- NameDepartment - varchar(30)
  ,'ABC' -- InfosSup - varchar(20)
)

  SELECT  a.NumAgency
    ,a.NumDepartment
    ,b.NameDepartment
    ,b.InfosSup
FROM   @Agency AS a
JOIN   @InfoDepartment AS b ON a.NumDepartment = b.NumDepartment
ORDER BY  1
    ,2

• Thom A

  SSC Guru

  Points: 99143

  More actions

  May 15, 2018 at 10:54 am

  #1990560

  Looks like you haven't set your groups up properly. This'll likely be easier to trouble shoot with consumable sample data and the rdl of your report (which you'll need to upload as a txt file).

  Thom~

  Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
  Larnu.uk

• Anthony G

  SSC Veteran

  Points: 225

  More actions

  May 15, 2018 at 1:42 pm

  #1990599

  Thank you for your answers! Bad_Karma, I'll try your solution and Thom A you're probably right. Thanks Again !