Creating reports and dashboards | Stimulsoft community forum

Posted: **Tue Jul 03, 2012 8:03 am**

Hi,

One of my reports is buit like this:
-GroupHeaderBand
--DataBand
-GroupFooterBand

In the GroupFooterBand, I have summaries to have group averages of values from the databand.
On of my field is a DateDiff function:

Code: Select all

{DateDiff(data.date_pol,data.date_sowing).Days}

I'm trying to have the average of for this field, like this:

Code: Select all

{Avg(DateDiff(data.date_harvest,data.date_pol).Days)}

but I'm getting an error that reference of an object does not set to an instance of an object.

Where am I wrong? Is it possible to do what I want?

Thanks!

Posted: **Wed Jul 04, 2012 6:13 am**

Hello,

We couldn't reproduce this bug.
Can you please send us a sample report template with data, which reproduce the issue?

Thank you.

Posted: **Mon Jul 09, 2012 12:20 pm**

Hello,

Please find attached my report converted to accept data from csv file, and a data file.
You can see that the field in red color does not work (error is not the same than in the former report, but still).

Thanks for your help.

Posted: **Tue Jul 10, 2012 11:50 am**

Hello.

Jennypi wrote:Please find attached my report converted to accept data from csv file, and a data file.
You can see that the field in red color does not work (error is not the same than in the former report, but still).

Please, try to use next expression:

Code: Select all

{Totals.Avg(GroupHeaderBand1, DateDiff(data.date_harvest,data.date_pol).Days)}

Thank you.

Posted: **Tue Jul 10, 2012 12:50 pm**

Thanks, it's working perfectly

Posted: **Wed Jul 11, 2012 4:54 am**

Hello,

Great! Have a nice day!

Creating reports and dashboards | Stimulsoft community forum

Summary with DateDiff function

Summary with DateDiff function

Re: Summary with DateDiff function

Re: Summary with DateDiff function

Re: Summary with DateDiff function

Re: Summary with DateDiff function

Re: Summary with DateDiff function