Crystal Reports selecting blank or empty cells

Technical Questions
Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions

Topic: selecting blank or empty cells
	Page of 2 Next >>

Author	Message
GLWalker Newbie Joined: 14 Apr 2010 Location: United States Online Status: Offline Posts: 6	Topic: selecting blank or empty cells Posted: 14 Apr 2010 at 12:25am
	Is there a way to select cells that are empty (no values)? I have been able to select cells any other way, but I have been unable to select blank cells. Please help.... Thanks
	IP Logged

DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	Posted: 14 Apr 2010 at 3:34am
	if it is a string... *isnull(table.field) or table.field=""* if in the formula editor you change the option from 'Exceptions for Nulls" to "Default Values for Nulls" then you only need to do... *table.field=""* Edited by DBlank - 14 Apr 2010 at 3:53am
	IP Logged

GLWalker Newbie Joined: 14 Apr 2010 Location: United States Online Status: Offline Posts: 6	Posted: 19 Apr 2010 at 11:46am
	I do agree that doing it the way that you suggested should work. But it doesn't. I have tried both ways with no luck. Any other ideas? = Anybody?
	IP Logged

kevlray Admin Group Joined: 29 Oct 2009 Online Status: Offline Posts: 1587	Posted: 19 Apr 2010 at 11:53am
	Quick question. Is the field in a linked table? If so, are you doing a left outer join?
	IP Logged

Savan Senior Member Joined: 14 Dec 2007 Location: India Online Status: Offline Posts: 162	Posted: 19 Apr 2010 at 11:22pm
	you can put some value if the cell is blank or empty by using formulas, based on that you can select the records matching the value for that field Savan
	Thanks Savan
	IP Logged

GLWalker Newbie Joined: 14 Apr 2010 Location: United States Online Status: Offline Posts: 6	Posted: 20 Apr 2010 at 12:05am
	*Originally posted by kevlray* Quick question. Is the field in a linked table? If so, are you doing a left outer join? No, it is a single table.
	IP Logged

DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	Posted: 20 Apr 2010 at 3:48am
	GL, can you please post a little more specific descirption of what you are trying to do and what exactly you have attempted that has not worked.
	IP Logged

GLWalker Newbie Joined: 14 Apr 2010 Location: United States Online Status: Offline Posts: 6	Posted: 20 Apr 2010 at 10:58am
	What I am trying to do is: I have a table that has about 10 columns. One of which is for Invoice #'s PO #'s Etc... I am only interested in the Invoice Fiield - selecting the cells that are blank. Of course this means that it has not been paid yet. What I have tried: *isnull(table.field) or table.field=""* *table.field=""* 'Exceptions for Nulls" to "Default Values for Nulls" Changed Also, less than 0 & less than z. I have even tried it on one of the sample databases - the product table. I always get the same result - one row - all coulms blank (empty). I have tried the same in the other colums with the same result. This is crazy - It should not be this hard....... Edited by GLWalker - 20 Apr 2010 at 10:59am
	IP Logged

DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	Posted: 20 Apr 2010 at 11:24am
	So lets say you remove any filter from your select expert and you place the invoice# field on the details section. Can see all rows including 'Empty" rows? You can sort ascending to move the 'empty' rows to the top.... Edited by DBlank - 20 Apr 2010 at 11:25am
	IP Logged

GLWalker Newbie Joined: 14 Apr 2010 Location: United States Online Status: Offline Posts: 6	Posted: 20 Apr 2010 at 11:35am
	*Originally posted by DBlank* So lets say you remove any filter from your select expert and you place the invoice# field on the details section. Can see all rows including 'Empty" rows? You can sort ascending to move the 'empty' rows to the top.... Yes, I can & and I see all of the 'Empty' cells on the top rows. Question for you: Can you go to - say any report that you have. Try this on any field that has blank cells - are you able to select the blank cells only?
	IP Logged

Page of 2 Next >>

Post Reply

Post New Topic

Printable version

Printable version

Forum Jump

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum

This page was generated in 0.016 seconds.