SSRS Help...

• SQlLogic

  SSCrazy Eights

  Points: 9686

  More actions

  July 2, 2012 at 10:45 am

  #277155

  HI guys ..

  I need little help in SSRS reports. I want to display data like this

  IF Percentage < 40 and denominator <> 0 after running reports it should display

  Report1

  None

  query i am using in SSRS DATASET :

  SELECT ID , description,Numerator,Denominator ,Percentage,'Report1' as Report_NameFROM dbo.mytable Where Percentage < 40 and denominator <> 0

  Thanks ...

• Koen Verbeeck

  SSC Guru

  Points: 259115

  More actions

  July 2, 2012 at 11:51 pm

  #1508018

  Your question is not really clear. What part are you struggling with?

  Need an answer? No, you need a question
  My blog at https://sqlkover.com.
  MCSE Business Intelligence - Microsoft Data Platform MVP