• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1453
  • Last Modified:

CRystal Reports formula for Does Not Contain

I have a report where I only want to show records where a value is not shown, what can I put in the formula where a record does not contain a value
Thanks
Gordon
0
Gordon Hughes
Asked:
Gordon Hughes
  • 2
  • 2
3 Solutions
 
Trideep PatelProject LeadCommented:
0
 
PCIIainCommented:
Assuming the record select formula.

isnull({table.field})

If the 'value' is actually a linked table, and there is no record in that table, you need to link the table a a left outer join in the database expert and then use the above in select formula for any field in this table.

If you want to show "No Value" where the report currently shows blank, create a formula like

if(isnull({table.field}))then
  "No Value"
else
  {table.field}
0
 
Gordon HughesDirectorAuthor Commented:
Hi Guys

Thanks for your speedy input
I have overcome the problem by adding a numeric number to the transaction and then using the supress function against the record
This seen to achieve what I wanted
Thanks again
Gordon
0
 
PCIIainCommented:
Beware of using suppress instead of record select.
Suppressed records are still included in summary calculations, and if you suppress a lot, then moving the same rule to the selection formula will dramatically decrease the time taken to fetch the data from the database....
0
 
Gordon HughesDirectorAuthor Commented:
Hi
I do appreciate what you say, in this instance I don't think I need any summary information, so supressing I think is Ok
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: SQL Server Core 2016

This course will introduce you to SQL Server Core 2016, as well as teach you about SSMS, data tools, installation, server configuration, using Management Studio, and writing and executing queries.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now