Show Prior Month End Date


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.
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Create a formula to calculate it off of your parameter:

//@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.
LMNowakAuthor Commented:
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.
I am confused.  You stated that when you run the report it is based on Prior MOnth End. Is that not the case if you run it on the last day of a month?

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
LMNowakAuthor Commented:
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.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Crystal Reports

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.