Solved

Crystal Reports - Page Not Displaying Using Section Expert

Posted on 2014-10-09
5
147 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
  • 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 100

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 100

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

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

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 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.
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…

832 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