Print Page | Close Window

want to add a optional number type parameter

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=3567
Printed Date: 18 May 2024 at 12:05am


Topic: want to add a optional number type parameter
Posted By: dash_anup2000
Subject: want to add a optional number type parameter
Date Posted: 01 Jul 2008 at 4:51am

I am using Oracle 9i as database and Crystal XI as reporting tool.

 
I want to add a paramter of number type({?PmAmount}) and wanted to make it optional. I don't want to place any default value. I am also using range type in this parameter( for minAmount and Max Amount) with no default value
 
I tried one option
 
(If
 IsNull({?PmAmountThen
True
Else
{XXID_CHURCH_ERDM_ORG_DIS_V.AMOUNT} = {?PmAmount})
 
but its not working...
Please help me on this. This is very very urjent
Anup


-------------
Anup


Replies:
Posted By: venkatesha
Date Posted: 01 Jul 2008 at 6:49am
Can you clarrify whether its procedure parameter or report parameter check for 0 also. Which might help you
(If
 IsNull({?PmAmount}) || {?PmAmount}=0 Then
True
Else
{XXID_CHURCH_ERDM_ORG_DIS_V.AMOUNT} = {?PmAmount})


Print Page | Close Window