Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Technical Questions
Message Icon Topic: Isnull Problem Post Reply Post New Topic
Author Message
zunigap2302
Newbie
Newbie


Joined: 22 Jul 2014
Location: United States
Online Status: Offline
Posts: 2
Quote zunigap2302 Replybullet Topic: Isnull Problem
    Posted: 22 Jul 2014 at 8:26am
I have a report that has null values.(Postdate). I used the following formula to fill the Nulls (PostdateFill)

if isnull({TKPay.PostDate}) then previous({TKPay.PostDate}) else ({TKPay.PostDate})

The Problem I'm running into is multiple Null values in a row. A little help on this would be great. Thanks( I cant have any nulls in postdatefill as my report will use this column at a pay period post.)

Postdate   PostdateFill   
20140721   20140721
20140721   20140721
                 20140721
20140721   20140721
                 20140721
           
20140721   20140721

Edited by zunigap2302 - 22 Jul 2014 at 8:31am
IP IP Logged
kostya1122
Senior Member
Senior Member
Avatar

Joined: 13 Jun 2011
Online Status: Offline
Posts: 475
Quote kostya1122 Replybullet Posted: 22 Jul 2014 at 9:50am
you could try to group on some field then you could use
maximum (Postdate  , some field)
instead of previous
IP IP Logged
zunigap2302
Newbie
Newbie


Joined: 22 Jul 2014
Location: United States
Online Status: Offline
Posts: 2
Quote zunigap2302 Replybullet Posted: 22 Jul 2014 at 11:53am
I used the maximum and it worked however I ran into a problem. The group I used was for individual date. I need to figure a formula for holidays that have no postdate in the group... any suggestions?

Edited by zunigap2302 - 22 Jul 2014 at 11:54am
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.029 seconds.