Community
Showing results for 
Search instead for 
Do you mean 
Reply

how can I group the report with the datetime field?

New Member
Posts: 6
Country: Thailand

how can I group the report with the datetime field?

I have problem when I group by the Opendate field( Date/time).

I want to group by date only no need the time.

 

Thank for help,

a.

 

 

Platinum Elite Contributor
Posts: 6,668
Country: USA

Re: how can I group the report with the datetime field?

More information please. Is this a standard report or a custom report? Where exactly are you trying to do the grouping? Etc.
Roy Laudenslager
ACT! Certified Consultant
ACT! Report Expert
Durkin Impact Report Designer
www.techbenders.com
royel@techbenders.com
541-343-8129
New Member
Posts: 6
Country: Thailand

Re: how can I group the report with the datetime field?

[ Edited ]

Case Custom Report,I want to create report about Opportunity  group by Opendate.

i have a problem that OpenDate feild have Data type is Date/Time.

When i group a report by OpenDate field,a report that show...

 

 

Opendate: 28/8/2008,1:45:35

Product               Quantiy                  

Shoe                       1 

Shirt                       2

__________________________

Opendate: 28/8/2008.3:30:40

Product               Quantiy                  

Shoe                       1 

Shirt                       2

__________________________

 

But i want to show data....

Opendate: 28/8/2008

Product               Quantiy                  

Shoe                       2

Shirt                       4

__________________________

I don't know how to do that report group by Date(data type) no need time.

 

 

 

Message Edited by aomega on 08-17-2008 08:38 PM
Platinum Elite Contributor
Posts: 6,668
Country: USA

Re: how can I group the report with the datetime field?

I understand what you want to do but there is no solution using the ACT! reports. With MSSQL, time information is also part of any date field. For fields in the report body, you can limit the property of a date/time field to the date only. However, the grouping provided by the sections access the SQL field data directly and is not subject to the report field properties.
Roy Laudenslager
ACT! Certified Consultant
ACT! Report Expert
Durkin Impact Report Designer
www.techbenders.com
royel@techbenders.com
541-343-8129