Discussion:
Is it possible to include calculated fields with a Report Wizard?
(too old to reply)
Android
2010-02-16 03:24:01 UTC
Permalink
In my CRM database I have a Date of Birth field and a First Meeting
Date. I wast to do a report which lets tells me # of clients under
and over 25.

Is there a way to use a temporary calculated field (in this case Age =
First Meeting Date - Date of Birth) as part of a report created with
the Report Wizard?

Regards....
Neil Benson
2010-02-17 09:13:01 UTC
Permalink
Hello, the Report Wizard supports only very simple calculations on a column
of data. For example, count, sum, average, etc.

It doesn't support anything more complex such as 'count records meeting
certain criteria'. You would need to export the report as an RDL file and
enhance it using Visual Studio in order to do this.

Regards,
--
Neil Benson, Customery -- UK online community for CRM customers and partners
http://www.customery.co.uk
http://twitter.com/neilabenson
http://uk.linkedin.com/in/neilbenson
Post by Android
In my CRM database I have a Date of Birth field and a First Meeting
Date. I wast to do a report which lets tells me # of clients under
and over 25.
Is there a way to use a temporary calculated field (in this case Age =
First Meeting Date - Date of Birth) as part of a report created with
the Report Wizard?
Regards....
.
Loading...