Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Report Design
Message Icon Topic: want to add a optional number type parameter Post Reply Post New Topic
Author Message
dash_anup2000
Newbie
Newbie
Avatar

Joined: 26 Feb 2008
Location: India
Online Status: Offline
Posts: 8
Quote dash_anup2000 Replybullet Topic: want to add a optional number type parameter
    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
IP IP Logged
venkatesha
Newbie
Newbie


Joined: 29 Jun 2008
Online Status: Offline
Posts: 35
Quote venkatesha Replybullet 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})
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.031 seconds.