Isnull Problem
Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Technical Questions
Forum Discription: Formulas, charting data, Crystal syntax, etc.
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=20900
Printed Date: 19 May 2024 at 1:57am
Topic: Isnull Problem
Posted By: zunigap2302
Subject: Isnull Problem
Date 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
|
Replies:
Posted By: kostya1122
Date 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
|
Posted By: zunigap2302
Date 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?
|
|