Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

formula for the data

Status
Not open for further replies.

michelin

Technical User
Dec 18, 2011
38
US
Is there some kind of way (I guess a formula) that I could use in the header to see what data is in report?

For example. The date range I'm using in my report is "last full month"- in my case- January 2013. Report is scheduled to be sent out every month on the 1st. The header says data range: January 2013. I have to MANUALLY change it every month. Is there how it would be done automatically? I'm using Crystal Reports 12.

Thank you in advance!
 
I've got it. I add to the header a field from the database {responsedate} and I formated it to see January-2013. :)
 
Or you could use a formula like this:

monthname(month(minimum(lastfullmonth)))+" "+totext(year(minimum(lastfullmonth)),"0000")

-LB
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top