Active TopicsMemberlistSearchHelpRegisterLogin

Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Simple Report Causing me headache! Post Reply Post New Topic
Author Message
glynners
Newbie
Newbie
Avatar

Joined: 20 Jun 2011
Location: United Kingdom
Online Status: Offline
Posts: 5
Quote glynners Replybullet Topic: Simple Report Causing me headache!
    Posted: 03 Apr 2012 at 12:40am

Hi all

I have a pretty simple report with two tables. A candidate detail (Learners) table and the table recording all planned contact with the candidate (Reviews)
 
"Learners" is linked to "Reviews" by an ID number
 
Now I need to quality check these "Reviews" are entered at correct intervals (every 6wks).   At the moment I am using a simple formula that tells me how many weeks the review is after the start date (@difference)...so this reads 6,12,18,24 etc
 
I want to either highlight when the gap is not 6 weeks (greater or less) OR have the formula say that the review is planned X number of weeks after the last one.
 
The detail line on the report has the Planned Review Date & the @difference fields on... like I say, very basic but with the amount of pages to check through we need something to highlight incorrect intervals & it has me stumped
 
Might be the fact I just come back from a three week holiday but I cant get the calculation right in my head!
 
Any help would be greatly appreciated
 
IP IP Logged
rkrowland
Senior Member
Senior Member
Avatar

Joined: 20 Dec 2011
Location: England
Online Status: Offline
Posts: 259
Quote rkrowland Replybullet Posted: 03 Apr 2012 at 12:52am

There'll be a better way than this using next/prev functions but I don't have time to post it at the min.

 
You could calculate if the difference is an exact multple of 6 and perform conditional formatting based on the result.
 
{@difference}/({@difference}/6)
 
If this field isn't equal to 6 then it means the planned deadline isn't a multple of 6. You can apply conditional formatting if the field doesn't equal 6.
 
If that's sufficient let me know, if not I'll write you a more complex next/prev formula when  I have time.
 
Regards,
Ryan.
IP IP Logged
glynners
Newbie
Newbie
Avatar

Joined: 20 Jun 2011
Location: United Kingdom
Online Status: Offline
Posts: 5
Quote glynners Replybullet Posted: 03 Apr 2012 at 3:26am
Hi Ryan thanks for the reply. 
 
However, that calculation always equal 6 no matter what number is in the @difference field.
 
Cheers
Glyn
 
 
IP IP Logged
rkrowland
Senior Member
Senior Member
Avatar

Joined: 20 Dec 2011
Location: England
Online Status: Offline
Posts: 259
Quote rkrowland Replybullet Posted: 03 Apr 2012 at 3:31am

My bad, forgot to put a round in there....

{@difference}/round({@difference}/6,0)
 
Try that...

 
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.
HOME | FREE EBOOK | PROGRAMMING GUIDE | PURCHASE | REVIEWS | CONTACT ME | FAQ | LINKS | CLICK PLAYS | COACH FORUMS | TROPICAL FISH

© 2004-2024 Brian Bischof. All Rights Reserved.