Date question? should be simple! 2

[PlaidEmp]

Seagate Crystal reports is merged with Track-It! a call tracking software. When I pick a report it prompts me for a date selection. How can I get the date range that I selected used as part of the report title.

Thank you,

 

[Lenell]

I'm no expert, but I've had this one before. Create a formula with the following value.

"'" + ToText(Minimum({?Date}),"M/d/yyyy&quot + " Through " +
ToText(Maximum({?Date}), "M/d/yyyy&quot + "'"

Then insert the formula name in your report heading

 

[PlaidEmp]

This fixed work but with a little more effort on my half.

Not much mind you.


This is how it is entered


"ToText(Minimum({?Date}),"M/d/yyyy&quot + " Through " +
ToText(Maximum({?Date}), "M/d/yyyy&quot"

the ?date is filled with the field that contains date in my case it was Tasks.Opendate for the correct info.

Thanks alot for the help.

 

[Lenell]

Great !!! I'm glad I was able to help. I see that you use Track-It also. Happy Crystal Reporting.

 

[PlaidEmp]

Since you use trackit you may be able to assist with my other problem. For some reason it didn't get posted here I belive. I am trying to create a call log report that gives me hourly totals by date. The problem is that I don't know the logic to sort it hour by hour. I just get a ugly graph with WAY to many bars. Does this make sence as far as what I want?