End-user calculation on multiple field - ppCalc ppVariable

rbuser

For the end-user, how to setup calculation with ppCalc and ppVariable in
designer at run time ?

In ppDesigner.ShowComponents, I put scCalc and scVariable, but there is only
a Calc object in designer component tab...

I know how to use ppdbCalc, but I want the end-user to setup multiple field
calculation.

Marc

nicocizik

Marc,

The ppVariable component can be accessed from the Standard Toolbar in the
Report Designer. Make sure that this toolbar is visible by right clicking
anywhere on the top panel and selecting the Standard Toobar option.

--

rbuser

OK but how to use it after inserting a such object in the report (by
end-user) ?
How to set the calculation to do ?
For example : DataPipeLine1.FloatField1 + DataPipeLine1.FloatField2

With ppdbCalc, I can set the calculation (sum, average, etc.). But it's only
on one field. I want to set a calculation on several fields.

--
Marc PLEYSIER - mp@solune.com
Service technique
Solune Informatique
www.solune.com

rbuser

Either establish a calculated field in the DADE or I can send you a custom
expression component that allows the enduser to specify a whole host of
calculations using variables and or datafields.
Andrew

rbuser

I'm very interested by this component ! Is it free ?
I want the end-user to be totaly independant. He got tables (dataPipelines)
and fields, and he will want to do all possible calculations.
I don't know if it is possible with DADE.


--
Marc PLEYSIER - mp@solune.com
Service technique
Solune Informatique
www.solune.com

nicocizik

Hi Marc,

DADE and RAP are features of ReportBuilder that are included with the
Professional (DADE) and Enterprise (DADE and RAP) editions. If you would
like your users to be completely independent, I would suggest you download a
trial version of ReportBuilder Enterprise 7.02 and see how DADE and RAP can
help you accomplish this. The article below explains the features a bit
further.


I. RB Standard features:
--------------------

1. ReportDesigner Easy to use, high quality, includes
report wizards and drag and drop tools
for quickly creating reports.

2. Delphi integration RB can be used within the Delphi IDE
and is very "Delphi like." You can code
event-handlers to control the report and
perform calcualtions etc.

4. Report templates Save report definitions to .rtm files or
to a database BLOB field. This enables
you to store the report layout definition
outside of the .exe and load the reports
as needed.

5. Subreports ReportBuilder's implementation of free
form subreports enable developers to
model complexity in an elegant
understandable manner. Once you learn
the fundamentals of Child, Section, and
Fixed style subreport you can combine
them in numerous ways. Check out our
demo projects for some examples.

Using free form subreports you can truly
break the boundaries of what is referred
to as simple banded reports and do things
like print forms and print multiple detail
listings side by side.

6. Regions A region is a container for other objects-
similar to a TPanel in Delphi.

7. Stretchables In ReportBuilder you can easily define
dynamic relationships amongst stretching
objects such as memos, richtext, subreports,
and regions by specifying a ShiftRelativeTo
property value.


8. TeeChart support Enable TeeChart to be used inside the Report
Designer.

9. DataPipeline Includes DBPipeline for use with any TDataSet
descendant, TextPipeline that can access data
stored in ASCII files, and JITPipeline for
custom event driven access. Create custom
datapipelines for accessing data in
proprietary formats.

10. Output Devices Extensible output format architecture.
Includes Screen, Printer, Archive,
TextFile, and Formatted Text.
Surf www.waler.com and www.pragnaan.com
for add on devices which support
HTML, RTF, PDF, Excel, etc.


11. Archiving Print reports to archive files (.raf).
Then use our ArchiveReader component
to print and preview from the archived files.

12. Developers Guide Over 400 pages containing conceptual
information for modeling reports and
step by step tutorials for building a
variety of reports.


13. Demos Extensive set of demo reports that
serve as examples.



II. RB Professional features:
--------------------------

Everything in ReportBuilder Standard plus:

Crosstab component Display calculated values in a
multi-dimensional format. Includes
a crosstab wizard and a drag-and-drop
editor. Define any number of row,
column, and value dimensions.

Data Access Environment (DADE) Adds a new 'Data' to the Report
Designer. Enables developers and
end-users to visually design and
preview SQL queries.

Ask at Runtime support Use the Query tools to define
AutoSearch parameters. RB Pro
will then display an
"Ask at Runtime" dialog
to the user.

End-User Report Designer Deploy an interface your users
already know.

Report Explorer Allow end-users to manage
reports and data with a Windows
Explorer style interface.

Report Wizard Create new reports with a
few clicks of the mouse.

Query Wizard Create new data with a
few clicks of the mouse.

Query Designer Create and modify complex queries.

Data Dictionary Use the Data Dictionary
component to display user
friendly table and field
aliases to your end-users.

Tutorials Step by step instructions for
putting it all together.



III. RB Enterprise features:
--------------------------
Everything in ReportBuilder Professional plus:

Run-time Pascal Environment Report Application Pascal (RAP)
is ReportBuidler's run-time Pascal
development environment! RAP
enables the entire report
definition (Data, Calculations,
and Layout) to be stored outside
of the application executable.
Using RAP, developers and
end-users can code calculations
and event-handlers without Delphi.
RAP is extensible - which means
developers can easily register
their own built-in functions
and objects to meet specific
requirements. (Source code to
RAP compiler is not included.)



--

rbuser

Hy Andrey,

what about the component you talked about ?


--
Marc PLEYSIER - mp@solune.com
Service technique
Solune Informatique
www.solune.com

rbuser

If you want total flexibility, RAP is the way to go. My component is just a
glorified expression parser, which gives more power than a calculated field
expression, but less than the scripting capabilities of RAP.
Andrew