Don't like ads? PRO users don't see any ads ;-)
Public Pastes
Guest

Untitled

By: a guest on Jun 1st, 2012  |  syntax: None  |  size: 0.66 KB  |  hits: 22  |  expires: Never
download  |  raw  |  embed  |  report abuse  |  print
Text below is selected. Please press Ctrl+C to copy to your clipboard. (⌘+C on Mac)
  1. How to draw line after every group in SQL Server Reporting Services?
  2. =Iif(Fields!ProductionCountry.Value = Previous(Fields!ProductionCountry.Value) OR Fields!ProductionCountry.Value = First(Fields!ProductionCountry.Value, "mydataset"),"None","Solid")
  3.        
  4. If ( current row belongs to the same group as the previous row  OR current group row is the first of the dataset, set border to none, set border to solid)
  5.        
  6. =IIF((Previous(Fields!ProductionCountry.Value) <> Fields!ProductionCountry.Value)
  7.     OR (Previous(Fields!IndustryName.Value) <> Fields!IndustryName.Value)
  8.     OR (Previous(Fields!ProductGroup.Value) <> Fields!ProductGroup.Value),
  9.     "Solid",
  10.     "None")
create a new version of this paste RAW Paste Data