469,602 Members | 1,593 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,602 developers. It's quick & easy.

access commands into Reprorting Services

Hello. I have an access report that I need to emulate in reporting services. Here is what I am working on
=IIf ((Fields!SEQUENCE_NO.Value =10, "20"," (" & Fields!EQUENCE_NO.Value & ")")+ 10), "")

I need the value in the sequence_id feild if it is equal to 10 to be displayed in my report as 20 or stay the same
Jul 13 '07 #1
0 605

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

2 posts views Thread by Takuon Soho | last post: by
1 post views Thread by Raquel | last post: by
reply views Thread by Brad Rogers | last post: by
12 posts views Thread by Selva Chinnasamy | last post: by
3 posts views Thread by mehdi_mousavi | last post: by
15 posts views Thread by tmp123 | last post: by
14 posts views Thread by xander.grespesky | last post: by
reply views Thread by devrayhaan | last post: by
reply views Thread by gheharukoh7 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.