Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: A Number is Required Error Post Reply Post New Topic
Author Message
BoltzGirl
Groupie
Groupie
Avatar

Joined: 22 Jan 2013
Online Status: Offline
Posts: 89
Quote BoltzGirl Replybullet Topic: A Number is Required Error
    Posted: 24 May 2017 at 11:48am
I have a very simple report going and created a formula as follows:

If {PD.SeqNumber} = '1'
Then
{PD.Code}

The {PD.SeqNumber}field IS a Number field, but I keep getting "A Number is required here" highlighting my '1'.

What am I doing wrong here?   

Using SAP Crystal Reports 2013 Support Pack 7
Version 14.1.7.1853

Edited by BoltzGirl - 24 May 2017 at 11:49am
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 25 May 2017 at 2:43am
remove your quotes from around the 1. When you add the quotes it is reading it as a string not an integer

If {PD.SeqNumber} = 1
Then
{PD.Code}
IP IP Logged
BoltzGirl
Groupie
Groupie
Avatar

Joined: 22 Jan 2013
Online Status: Offline
Posts: 89
Quote BoltzGirl Replybullet Posted: 25 May 2017 at 5:32am
DBlank - thank you so much for reminding me of this! I totally forgot and should have just taken a break from it!    Thanks again, it worked like a gem!
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.016 seconds.