Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

put default number in a data cell of a matrix

Status
Not open for further replies.
igor22

igor22

Programmer
Sep 18, 2003
50
US
Hi,
If there is no match in the matrix - it displays an empty cell. Is there a way to display some default number instead?

Thanks,
Igor
 
Sort by date Sort by votes
You could try something like this:

=iif(Sum(Fields!ID.Value)=0, 0, Sum(Fields!ID.Value))
 
Upvote 0 Downvote
actually, the following code did the trick:
=iif(Sum(Fields!ID.Value)=nothing, 0, Sum(Fields!ID.Value))
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Theresajn
  • Locked
  • Question
Collapse all Datasets in Report Data Pane
Replies
0
Views
391
Theresajn
Theresajn
Johnhny
  • Locked
  • Question
SSRS Grouping Imputes missing data
Replies
0
Views
420
Johnhny
Johnhny
Tom_2023
  • Locked
  • Question
SSRS wrapping text in Excel
Replies
0
Views
428
Tom_2023
Tom_2023
nomi_ssrs
  • Locked
  • Question
xml column from sql server - used in ssrs
Replies
0
Views
409
nomi_ssrs
nomi_ssrs
Ashajohn2021
  • Locked
  • Question
Report to give Average # of cases > than 6, 7, 8 days
Replies
0
Views
376
Ashajohn2021
Ashajohn2021

Part and Inventory Search

Sponsor

Back
Top