Putting CURRENT Date on Reports - D-Tools Forum

avaltdan · 10-18-2010, 04:29 PM

Hello All,

I'm trying to put the CURRENT DATE on a report (not the date modified, or created, or completed).

Does anyone know if there is a data field in the data explorer for this? And if so, where is it? I looked, but I couldn't find it. Perhaps it has a weird name?

Thanks for the help.

Dan

fryeguy · 10-18-2010, 10:07 PM

This code will use the Today() method.
The below code assumes you have a text box named "txtToday" located in a report section "Detail1":

Quote:

Sub Detail1_Format
Dim txtValToday As String = ""
txtValToday = Today().ToString("M/d/yy")
ReportUtilities.SetTextBoxValue(rpt,"Detail1" ,"txtToday", txtValToday)
End Sub

check out this link for additional info on formatting:
http://riderdesign.com/articles/Form...d-ASP.NET.aspx

grichards · 10-19-2010, 03:54 PM

optionally you can,

open report designer
select or create the Text field you want to display the date
Open its properties tab
update the "FormatString" property to "{RunDateTime:}"

there are a number of options about how RunDateTime time can be formatted in FormatString

for example: you can get creative like setting "FormatString" property to "This magnificent d-tools report was created on {RunDateTime:MM/dd/yyyy} at {RunDateTime: hh:mm tt}"...but that might be getting carried away.

enjoy

fryeguy · 10-20-2010, 08:02 PM

Thanks for the simpler solution. Are properties such is {RunDateTime} documented ?

grichards · 10-21-2010, 03:26 PM

Most of the reporting is not documented via dTools. but you can find some useful information in the dataDynamics ActiveReports documentation

be warned that dTools seems to have stripped or limited a lot of the features of ActiveReports in the Report Designer.

fryeguy · 10-21-2010, 03:54 PM

That is why I asked. It has been my experience that the ActiveReports classes have been a bit stripped down...

grichards · 10-22-2010, 03:45 PM

i've found that that quickest way to figure out this kind of thing is to randomly smash keys and occasionally press enter.... I think thats documented somewhere

SenoS · 10-22-2010, 08:29 PM

The field you are looking for in the Date Explorer is dtr:Created. I know the name might be misleading but that field will populate with the current date when the report is run.

fryeguy · 10-22-2010, 08:44 PM

you know Senos found this by trying grichards method listed above. Awesome.
Thanks!