Show Prior Month End Date
Hello,
I am using CR 8.5, when I run a report its based on data as of prior month end. So if I run a report today on 4/26/06 the data is as of 3/31/06. The report has a paramater date prompt.
{vvwNote.UV_AS_OF_DATE} = {?As_Of_Date}
My problem is if no data exists I surpress the Report Title and Date in PHA and
show PHB the Report Title and a statement "No Records Exists"
however, no matter what I do I cant seem to reflect the statement "No Records Exists" with a Month End Date.
I need to make this statement is several reports which I have yet to get to work.
What am I missing.
I am using CR 8.5, when I run a report its based on data as of prior month end. So if I run a report today on 4/26/06 the data is as of 3/31/06. The report has a paramater date prompt.
{vvwNote.UV_AS_OF_DATE} = {?As_Of_Date}
My problem is if no data exists I surpress the Report Title and Date in PHA and
show PHB the Report Title and a statement "No Records Exists"
however, no matter what I do I cant seem to reflect the statement "No Records Exists" with a Month End Date.
I need to make this statement is several reports which I have yet to get to work.
What am I missing.
ASKER
When I run the report I put in the prompt 3/31/06 and the
//@Last day of Previous Month
{?As_Of_Date} - day({?As_Of_Date})
reflects 2/28/06.
//@Last day of Previous Month
{?As_Of_Date} - day({?As_Of_Date})
reflects 2/28/06.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Actually we can run the report at anytime however, our data is always as of the prior month end date regardless if the last day falls on a weekend/holiday or not.
But I did resolve my issue, I was making it harder that it should be. Since I use a date parameter prompt I took out the formula date and put in PHB the parameter date. If no records exists, my date field will be null, so I need to use the parameter. Hope this makes some sense.
Thank you for your fast response.
But I did resolve my issue, I was making it harder that it should be. Since I use a date parameter prompt I took out the formula date and put in PHB the parameter date. If no records exists, my date field will be null, so I need to use the parameter. Hope this makes some sense.
Thank you for your fast response.
//@Last day of Previous Month
{?As_Of_Date} - day({?As_Of_Date})
You can then use this formula whereever you need it on the report.