Solved

Report builder 2008

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

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

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

If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
In a recent question (https://www.experts-exchange.com/questions/28997919/Pagination-in-Adobe-Acrobat.html) here at Experts Exchange, a member asked how to add page numbers to a PDF file using Adobe Acrobat XI Pro. This short video Micro Tutorial sh…
This video shows how to use Hyena, from SystemTools Software, to bulk import 100 user accounts from an external text file. View in 1080p for best video quality.

809 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