Combine and the dates and display the resuls in the Text object

[Anonymous]

Hi All,

Now i have date field as below and calls  field, now i have to display the result as below,i want to show the one date and the count of calls as 20,can any one help on this.

Result:

Date                     Calls

1/1/2014                   20

Date                       Calls

1/1/2014                   5

1/1/2014                   5

1/1/2014                   5

1/1/2014                   5

Thanks & Regards,

Sivakumar

[MayilVahanan]

Hi

Try like this

Date as Dimension

Sum(calls) as expression

Edit:

In text box:

='Maximum Date' & Date(Max(Date)) & '---------' & 'No of calls' & Sum(Calls) 

hope it helps

[tresesco]

Text box:

='Date : ' &dateField& Sum(Calls)

Select a date to get the output.

[jagan]

Hi,

Try like this

='Date : ' & Only(Floor(Date)) & chr(10)  & 'Number of Calls : ' & Sum(Calls)

Hope this helps you.

Regards,

Jagan.

[#5]

kindly find attatch file this may help you

Regards

fahad

[Anonymous]

Hi All,

Thanks for all your help now in the below case how can i do .

Date                       Calls

1/1/2014                   5

1/1/2014                   5

1/1/2014                   5

1/1/2014                   5

1/2/2014                   5

1/2/2014                   5

Result Should be :

Date                        Calls

1/1/2014                 20

1/2/2014                 10

can  any one help on this.

Thanks &  Regards,

Sivakumar

[MayilVahanan]

HI

Try like this
Date as dimension

Sum(Calls) as expression.

[tresesco]

Straight table:

Dimension: Date

Expression:=Sum(Calls)

[jagan]

Hi,

Use Straight Table and try like this

Dimension:Date

Expression: Sum(Calls)

Regards,

Jagan.

[Anonymous]

Hi Tresesco,

Its possible to display through code in the text object?

Thanks & Regards,

Sivakumar