Solved

Report builder 2008

Posted on 2014-09-30
2
411 Views
Last Modified: 2014-10-09
After run stored procedure i will get the
ID
NULL
NULL
1
NULL

I need to ignore all the Null value and need take display in the Report field value 1 only.
I used MAX (Field!ID.value) but its not working any idea appriciate.

I have to use stored procedure (some one wrote i can't change/amend)
0
Comment
Question by:ukerandi
2 Comments
 
LVL 14

Accepted Solution

by:
Vikas Garg earned 500 total points
ID: 40353939
Hi,

If it is coming from the stored procedure then simply you can put filter in the resultant data set

Where id is not null

and it will return only non null values
0
 
LVL 10

Author Comment

by:ukerandi
ID: 40353972
It's not possible , I need different way. Because under  null row other fields have values
0

Featured Post

DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Hello, In my precious Article  (http://www.experts-exchange.com/Database/Reporting/A_15280-Create-Project-in-Microstrategy-Part-I.html)we saw the Configuration part for Microstrategy which included Metadata Creation and DataSource Preparation as …
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
This Micro Tutorial will teach you how to censor certain areas of your screen. The example in this video will show a little boy's face being blurred. This will be demonstrated using Adobe Premiere Pro CS6.
This is used to tweak the memory usage for your computer, it is used for servers more so than workstations but just be careful editing registry settings as it may cause irreversible results. I hold no responsibility for anything you do to the regist…

912 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

24 Experts available now in Live!

Get 1:1 Help Now