Solved

Crystal Reports - Page Not Displaying Using Section Expert

Posted on 2014-10-09
5
152 Views
Last Modified: 2014-10-09
I am using the below code on the section expert of a page.  I want to suppress the page based on the below values.  

When I comment the below code the page displays.  I put the field on the page just to see what value was displaying.  It is displaying NE.  It should display.

But when I uncomment out the below code the page does not display but it should.  

Any idea why it is not displaying with the below code?

ISNULL({Header.state}) or 
{Header.state} <> 'CA' or 
{Header.state} <> 'IL' or 
{Header.state} <> 'NE' or 
{Header.state} <> 'NH' or 
{Header.state} <> 'NY' or 
{Header.state} <> 'RI' or 
{Header.state} <> 'WV' 

Open in new window

0
Comment
Question by:CipherIS
[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
  • 2
5 Comments
 
LVL 18

Accepted Solution

by:
vasto earned 500 total points
ID: 40371335
Your logic will always suppress the page because the state will be <>'CA' or <> 'NE' it cannot be equal to both of them . If you want to suppress the page for all states except those use


ISNULL({Header.state}) OR NOT {Header.state} IN  ['CA','IL','NE' ...'WV']
0
 
LVL 1

Author Comment

by:CipherIS
ID: 40371353
Should I have  parens after NOT and at end?

ISNULL({Header.nlc_state}) OR
NOT ( {Header.nlc_state} IN ['CA', 'IL', 'NE', 'NH', 'NY', 'RI', 'WV'] )

when I don't I receive an error - "Boolean is required here"
0
 
LVL 101

Expert Comment

by:mlmcc
ID: 40371355
That should solve it assuming you want to suppress if the state is NULL or it is one of the listed states.

If that doesn't solve the issue try to put the requirement in words rather than code.

mlmcc
0
 
LVL 101

Expert Comment

by:mlmcc
ID: 40371360
Yes you probably need ( ) as you used them

mlmcc
0
 
LVL 18

Expert Comment

by:vasto
ID: 40371372
I don't have crystal right now so the formula is probably not syntax perfect, you need to add all the states that should be shown and yes, () probably should be added after NOT
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
This is a high-level webinar that covers the history of enterprise open source database use. It addresses both the advantages companies see in using open source database technologies, as well as the fears and reservations they might have. In this…
There's a multitude of different network monitoring solutions out there, and you're probably wondering what makes NetCrunch so special. It's completely agentless, but does let you create an agent, if you desire. It offers powerful scalability …

726 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