Customizing the Calculation Dialog

rbuser

The current Calculation dialog ( daQueryWizardCalcDlg ) only shows aggregate
functions such as Avg, Min, Max, etc. and only works with numeric fields.

Where would I find the functions and fields that are passed to this dialog
so that we can add additional string functions and show string fields?

I am looking in the daQueryDesigner but have not found yet.

Thanks.
Bill Brittain

nicocizik

Hi Bill,

If you take a look at the TdaCalcPage class located in the
daQueryDesigner.pas file you will see how calculations are made. All the
available calculations are defined as an enumerated type TdaCalcType defined
in daSQL.pas. This is where the calc types are processed and SQL code is
generated. The easiest way to use a function that is not included is to use
the Expression option.

--
Regards,

Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com

rbuser

The Expressions area may work.

Is it possible to add to the CalcType list of functions as an ExpressionType
so that we could add in custom functions to this area?

Bill Brittain

nicocizik

Hi Bill,

Yes, it is possible however as I mentioned before, all the logic for
handling these calculations is inside the TdaSQL class so you would be
forced to either decend from that class or alter the source code which is
not recommended. Which specific functionality would you like to add? I
will be more than happy to add them to our possible enhancements list for a
later release of ReportBuilder.

--
Regards,

Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com