Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 446
  • Last Modified:

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.
0
LMNowak
Asked:
LMNowak
  • 2
  • 2
1 Solution
 
bdreed35Commented:
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.
0
 
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.
0
 
bdreed35Commented:
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?
0
 
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.
0

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now