1 Replies - 380 Views - Last Post: 11 September 2013 - 11:08 AM Rate Topic: -----

#1 Atad  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 9
  • Joined: 14-October 12

SSRS Syntax

Posted 11 September 2013 - 10:46 AM

The programmer I work with is not available and I need help completing an SSRS report. I am trying to group by field name"acct". If acct=4035 or 4033 then I want "Industrial" to appear. Else I want "Grant" to appear. I am used to Crystal.

I have played with the 'choose' function and the 'IIf' function.

This is not school work. It is for my job. Can someone help?
Is This A Good Question/Topic? 0
  • +

Replies To: SSRS Syntax

#2 andrewsw  Icon User is online

  • Fire giant boob nipple gun!
  • member icon

Reputation: 3215
  • View blog
  • Posts: 10,785
  • Joined: 12-December 12

Re: SSRS Syntax

Posted 11 September 2013 - 11:08 AM

I don't work with SSRS but based on this page I assume it would be:

IIf(Fields!acct.Value=4035 Or Fields!acct.Value=4033,"Industrial","Grant")

Was This Post Helpful? 1
  • +
  • -

Page 1 of 1