Solved

Report builder 2008

Posted on 2014-09-30
2
416 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 15

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

Webinar: Aligning, Automating, Winning

Join Dan Russo, Senior Manager of Operations Intelligence, for an in-depth discussion on how Dealertrack, leading provider of integrated digital solutions for the automotive industry, transformed their DevOps processes to increase collaboration and move with greater velocity.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
SSRS 2013 - Overlapping reports 2 32
Downgrading MS SQL 2008 R2 Enterprise to MS SQL 2005 Standard? 12 68
SQL Error - Query 6 42
performance query 4 32
SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…

820 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