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!

How to display date in the report header

Status
Not open for further replies.

reddyogili

Programmer
Apr 8, 2005
24
0
0
US


Hello guys in my report i am having 2 parameters(Node and Manager). so i need to get the values for node and manager for a date. this is the formuale i am using in selection expert. This is working fine, with this formuale

if {?Node} <> "All" then
{REPORTER_STATUS.NODE} = {?Node} else
if {?Node} = "All" then true and

if {?Manager} <> "All" then
{REPORTER_STATUS.MANAGER} = {?Manager} else
if {?Manager} = "All" then true and

{REPORTER_STATUS.FIRSTOCCURRENCE} >= DateAdd ("d", -1, CurrentDate)
(i am using this to get the values of 1day back results from current time). Here firstoccurence is the datetime field

How will i display the date in my report header. Can some one suggest me about this.

Thank you,
Reddy.
 
Write a formula:

"Report from "&totext(Dateadd("d",-1,CurrentDate))

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top