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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Report Footer Date Range Incorrect

Status
Not open for further replies.
Oct 21, 2002
14
US
In a report footer (Crystall Reports 11) we display the date range the report is run. "Data as of 12/31/2006" displays when using the parameters 1/1/2006-12/31/2006.
I have a second date parameter for the second page for the next year (2007).
When we export using Microsoft Word - Editable RTF the date stays at 12/31/2006 on the second pages footer.
When exporting using Microsoft Word - RTF [only] the date is correct 7/13/2007 on the footer.

Obviously a bug?
Any work-arounds or hot-fixes correct this?
 
What formula(s) are you using to display the parameter(s)? Is this one date range parameter? Two date range parameters? Two instances of a multiple value datee range parameter?

-LB
 
Formulas @DateFrom & @DateTo
Each page will get a date range based on year (dateGroup)
So, there could be multiple pages (2006,2007, etc)

>Initial post correction: This is a page footer not report footer.
The Page footer date is: (date, by group)
"Data As Of: " (command.@DateTo, command.@DateGroup)
 
What are your ACTUAL formulas? What are the contents of the nested formulas you reference? So far I don't see any references to parameters. Please also show the actual resulting display.

-LB
 
These are the parameter:
The {@DateFilledTo} is a Parameter passed to the storedproc
{@ToDate} = maximum({storedproc;1.DateTo}, {storedproc;1.DateGroup})
Page Footer: "Data as of " {@ToDate}
 
I recreated the problem, and agree that it appears to be a bug. I couldn't find a hot fix that addressed this. Maybe you should notify Business Objects.

-LB
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top