SSRS : No results retrieved or appearing although appearing on a different report

• Andy H Kwok

  SSC Enthusiast

  Points: 147

  More actions

  December 11, 2015 at 5:33 am

  #306147

  I have this report on SSRS

  

  The above highlighted field has the following formula (img below)

  

  All the results are retrieved by a stored procedure

  CREATE PROCEDURE [dbo].[SIGLEENSEIGNE]

  AS

  BEGIN

  SELECT

  CASEWHEN Code_Juridique LIKE 'M%' AND John_Jack.Enseigne IS NOT NULL AND John_Jack.Enseigne <> ''

  THEN ' / ' + John_Jack.Enseigne

  WHEN (John_Jack.Sigle IS NULL OR John_Jack.Sigle ='')

  AND (John_Jack.Enseigne IS NULL OR John_Jack.Enseigne ='')

  THEN ''

  ELSE John_Jack.Sigle + ' / ' + John_Jack.Enseigne

  END as SigleEnseigne1

  FROM John_Jack

  END

  updated part

  No results are appearing because when I use this `First(Fields!SigleEnseigne1.Value, "SigleEnseigne")`, it only gets me the first row and the first row is empty ...

  From my discussion with some people around the @, I must have another column in my stored procedure or stored somewhere else , for ssrs to do the lookup and to use the second dataset.

  I don't like the idea as it will get ridiculously tedious, I'm therefore all ears if you have any other solutions.

  Thanks