Is it possible for an end user (program uses Delphi5 and Report Builder Professional 6.03), to actually create a new currency field which could then be used with a separate calculation and then used in a report ?
In our Enterprise Edition, the end user can code a calculation in RAP. Using the Professional Edition, you could use the TppDBCalc for the calculation or create a custom component which preforms the custom calculation for them after they choose the currency data field from the dataview they created in DADE. There is an example of creating a custom component in the RBuilder\Demos\RCL directory.
I see, but what if there is not (at present) the currency field which they require. Would they be able to create a currency field on the fly ? This could then be used as part of another calculation. The thing is... I have a quotation screen with Report Designer capabilities. Some users are asking for extra fields (and i wondered if i could get away with showing them that could do it with the Report Builder). I think you're previous response was taking for granted that the fields wanted for calculation purposes were already part of the source dataset.
Yes, the user can use DADE to add a new field to the dataview. This is only if that field is available in their database before launching the report designer. Let's say they are using Access 2000 as their database. Then they can use Access to add a new field to the database, populate it with data. Then launch the report designer, go into the Data tab (DADE) and define a new field on the dataview. In the design workspace they can then add a dbText connected to that new field in the dataview they just created.
Comments
the Professional Edition, you could use the TppDBCalc for the calculation or
create a custom component which preforms the custom calculation for them
after they choose the currency data field from the dataview they created in
DADE. There is an example of creating a custom component in the
RBuilder\Demos\RCL directory.
Cheers,
Jim Bennett
Digital Metaphors
http://www.digital-metaphors.com
info@digital-metaphors.com
require.
Would they be able to create a currency field on the fly ? This could then
be used as part of another calculation.
The thing is...
I have a quotation screen with Report Designer capabilities.
Some users are asking for extra fields (and i wondered if i could get away
with showing them that could do it with the Report Builder).
I think you're previous response was taking for granted that the fields
wanted for calculation purposes were already part of the source dataset.
if that field is available in their database before launching the report
designer. Let's say they are using Access 2000 as their database. Then they
can use Access to add a new field to the database, populate it with data.
Then launch the report designer, go into the Data tab (DADE) and define a
new field on the dataview. In the design workspace they can then add a
dbText connected to that new field in the dataview they just created.
Cheers,
Jim Bennett
Digital Metaphors
http://www.digital-metaphors.com
info@digital-metaphors.com