Formula displayed on Report header 1

[ginkoba]

Hi,

I have a formula in my record selection as in:

{FieldName} = "test"
and
{Status} Like "active"
and
{@purchasedate} IN MonthToDate

I want to be able to display the month's name on the page header just below the report title as in:

Report Title
Through Jan 28, 2010

I also would like to find a way to go back 30days, 60days and 90days grouped by @purchasedate to display as in:

Amount: Last 30 days Last 60 days Last 90days
$200 150 300 200

Any help would do.

Thanks much

 

[lbass]

Create a formula like this:

"Report Title"+chr(13)+
"Through "+totext(datadate,"MMM dd, yyyy")

Format the formula to "can grow". If you stretch it on both ends to the page borders, you can also center it on the page by clicking on the center icon.

To capture previous data, you need to change your selection formula to:

{@purchasedate} in currentdate - 90 to currentdate

Then use formulas like this:

if {@purchasedate} in currentdate - 30 then {table.amt}

Insert a sum on this at the group level (invoiceID?). Repeat for other intervals.

-LB

 

[ginkoba]

LB,
Thanks much. This is very good however I would like to show month to date only. For instance if today is 15th of the month, I would like it to display from the first day of that current month to present.
Eg, if today is 15,
display should read From Feb 01 through Feb 15, 2010.

Thanks

 

[lbass]

Your original post said:

Report Title
Through Jan 28, 2010

Anyway, you could use:

"Report Title"+chr(13)+
"From " + totext(datadate-day(datadate)+1,"MMM dd")+
" Through "+totext(datadate,"MMM dd, yyyy")

Datadate will show the date the report was refreshed.

-LB

 

[ginkoba]

Thanks LB. You are right I was not clear earlier on the question. This now works!

 

[ginkoba]

How do I apply this formula to the last 60days or 2 months through current date?

 

[lbass]

Use a formula like this:

"Report Title"+chr(13)+"From " + totext(datadate-59,"MMM dd, yyyy")+" Through "+totext(datadate,"MMM dd, yyyy")

-LB

 

[ginkoba]

Thanks LB, works!