Solved

Crystal Reports - Page Not Displaying Using Section Expert

Posted on 2014-10-09
5
151 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

Secure Your Active Directory - April 20, 2017

Active Directory plays a critical role in your company’s IT infrastructure and keeping it secure in today’s hacker-infested world is a must.
Microsoft published 300+ pages of guidance, but who has the time, money, and resources to implement? Register now to find an easier way.

Question has a verified solution.

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

Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…

733 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