Print Page | Close Window

When No Parameters are entered

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=12051
Printed Date: 05 May 2024 at 12:15pm


Topic: When No Parameters are entered
Posted By: pgreer
Subject: When No Parameters are entered
Date Posted: 12 Jan 2011 at 9:30am
I want to be able to enter any 1 parameter and return all the records.  It returns none even though i have it set as an optional prompt.  Probably something simple that I am not seeing.   Here is my code i am at a loss.
 
 
{PAUDIT.DATE} = Minimum(not HasValue({?Start Date(yyyyMMdd)}) and
{PAUDIT.DATE} = Maximum(not HasValue({?End Date(yyyyMMdd)}) and
(not HasValue({?Medical Record Number}) OR {PAUDIT.MR_NUM} =
{?Medical Record Number}) and
(not HasValue({?Accession Number}) OR {PAUDIT.ACC_NUM} =
{?Accession Number})
 
Thanks in advance.


Replies:
Posted By: DBlank
Date Posted: 13 Jan 2011 at 4:13am
(not(hasvalue({?start Date})) or {PAUDIT.DATE} in {?start Date} to {?End Date})
and
(not(hasvalue({?Medical Record Number})) or {PAUDIT.MR_NUM} =
{?Medical Record Number})
AND
(not(hasvalue({?Accession Number})) or {PAUDIT.ACC_NUM} =
{?Accession Number})


Print Page | Close Window