?
Solved

Report builder 2008

Posted on 2014-09-30
2
Medium Priority
?
451 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 15

Accepted Solution

by:
Vikas Garg earned 2000 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

Does Your Cloud Backup Use Blockchain Technology?

Blockchain technology has already revolutionized finance thanks to Bitcoin. Now it's disrupting other areas, including the realm of data protection. Learn how blockchain is now being used to authenticate backup files and keep them safe from hackers.

Question has a verified solution.

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

Jaspersoft Studio is a plugin for Eclipse that lets you create reports from a datasource.  In this article, we'll go over creating a report from a default template and setting up a datasource that connects to your database.
How to increase the row limit in Jasper Server.
This tutorial will teach you the special effect of super speed similar to the fictional character Wally West aka "The Flash" After Shake : http://www.videocopilot.net/presets/after_shake/ All lightning effects with instructions : http://www.mediaf…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…

762 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