Group expression gives #Error - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

Development Tools

Reporting Services Development

Group expression gives #Error

Author

Topic

bubberz
Constraint Violating Yak Guru

289 Posts

Posted - 2006-03-22 : 12:02:53

I have an expression such as:

=sum(
IIF( Fields!QuantityType.Value="LB", Fields!TotalQuantity.Value ,0)
,"Grp_Number"

)

....Grp_Number is the grouping where I'm trying to insert this summation / total.

Under Grp_Number, I have a 2nd grouping by QuantityType, where there's two possible values, LB or NLB. So, a Grp_Number could have possible 2nd groupings of:

1. only LB

2. only NLB

3. both

The only problem is when there's no LB, then the expression comes back as #Error.

Any suggestions are welcome!

Thanks!

snktheone
Starting Member

20 Posts

Posted - 2006-04-06 : 08:08:22

try using
=IIF(ISDBNULL( Fields!QuantityType.Value ),0,Fields!QuantityType.Value)

bubberz
Constraint Violating Yak Guru

289 Posts

Posted - 2006-04-06 : 10:57:32

Thanks snktheone!

I'll try that this week, or next week. I ended up giving the customer a Crystal XI report.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources