Formula for the report

[junction123]

Currently my report uses the calendar date for the header

"Dated: " + totext(currentdate,"MMM dd yyyy&quot

I need to use a column "datetime" from a table tms_dates as the header date

Can I change my formula to select the datetime column from the table? Or should I add the table as a datasource within the report and reference the column?

Thanks in advance
junction123

 

[synapsevampire]

When you say Header, I'll assume the Report Header.

Adding the table may cause problems as Crystal expects a single data source, meaning that all tables would be joined.

I'd create a subreport and access jsut the table containing this date.

-k

 

[junction123]

You are right. I did get a couple of Warning messages about the tables being joined. I guess adding a subreport is a better solution.

Thanks!