Print Page | Close Window

Aged Report

Printed From: Crystal Reports Book
Category: Crystal Reports for Visual Studio 2005 and Newer
Forum Name: Writing Code
Forum Discription: .NET programming API, report integration
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=6744
Printed Date: 25 Apr 2024 at 4:27pm


Topic: Aged Report
Posted By: bec9196
Subject: Aged Report
Date Posted: 16 Jun 2009 at 10:46am
Hi.  I am trying to create a formula that will allow me to calculate how long a request has been in the system based on a certain milestone.  I have the formula for the milestone and it seems to work. 
 
My problem is that I can not figure out how to make the aged formula (see what I have below).  The error i receive says that "the remaining text does not appear to be part of the formula and the date after the comma in the first row is highlighted.  I have taken tried taking out the comma and then I get an error stating that says  "the remaining text does not appear to be part of the formula"
 
HELP PLEASE!
 
 
mailto:%7b@Milestone - {@Milestone } = "Aged 0 to 30 days",
 ({requests.rpt_date} - 30) to CurrentDate,
 
 


-------------
Becca


Print Page | Close Window