Pipeline Calculation with other than 1st Record
Hello,
Very new user with Report Builder, we had Report Builder bundled with
another piece of software we are using.
What I am looking to do seems fairly simple, but I haven't been able to
figure out how to do it yet:
We have data from our pipeline coming out in this form inside report
builder, two example data pieces: JITData['ID Column'] and JITData['Values']
Say records 1 through 6 display and read fine in table form etc,. what we
need to do in the report however is a calculation where the 2nd value would
be added to the 4th value, disregarding all other data - I assume this can
be done in a variable, and would like it sitting on the same page as the
report.
Is this possible or am I wasting my time? I've read through a lot of the
documentation I could find so far and it seems like ranges may be able to
help, but I've only seen code that refers to current record, I've also been
able to make calculations but only with the first record set, I haven't been
able to isolate to the 2nd or 4th record, but I'm fairly novice with any
type of code besides SQL and would appreciate any help.
Very new user with Report Builder, we had Report Builder bundled with
another piece of software we are using.
What I am looking to do seems fairly simple, but I haven't been able to
figure out how to do it yet:
We have data from our pipeline coming out in this form inside report
builder, two example data pieces: JITData['ID Column'] and JITData['Values']
Say records 1 through 6 display and read fine in table form etc,. what we
need to do in the report however is a calculation where the 2nd value would
be added to the 4th value, disregarding all other data - I assume this can
be done in a variable, and would like it sitting on the same page as the
report.
Is this possible or am I wasting my time? I've read through a lot of the
documentation I could find so far and it seems like ranges may be able to
help, but I've only seen code that refers to current record, I've also been
able to make calculations but only with the first record set, I haven't been
able to isolate to the 2nd or 4th record, but I'm fairly novice with any
type of code besides SQL and would appreciate any help.
This discussion has been closed.
Comments
Yes, this should be possible using a TppVariable component and RAP code.
Simply update the value of the variable as each relevant record is
traversed.
-----------------------------------------
Article: End-User Tech Support
-----------------------------------------
Please understand that Digital Metaphors can only provide tech support to
the Delphi developers that purchase ReportBuilder. Digital Metaphors
receives no distribution royalties from Delphi developers that embed
end-user reporting solutions in their applications. It is the responsibility
of the software publishers that sold you the product to provide you with
tech support.
There is an end-user tutorial called Learning ReportBuilder that can be
downloaded from our web site for free. See the following article for more
information.
--------------------------------
Article: Learning ReportBuilder
--------------------------------
Learning ReportBuilder is a complete learning system designed to teach end
users how to build a range of reports. This system includes a 125-page PDF
file, a stand-alone application complete with a database, and a help file.
The PDF file is comprised of a series of tutorials that step end users
through the process of building reports as simple as a table listing and as
complex as crosstabs. The tutorials also introduce conceptual aspects of
report building along the way. The application is used in conjunction with
the tutorials so that the learning experience is interactive. The end user
just prints out the PDF file, runs the application, and learns
ReportBuilder. The help file is accessible from the application, so all
three tools work together to provide a seamless learning environment.
Learning ReportBuilder installs into C:\Program Files\LearnReportBuilder.
When the system has successfully installed, a complete set of instructions
appears in the form of a 'ReadMe' doc, so the end user knows just what to do
upon installation.
- Download Learning ReportBuilder
http://www.digital-metaphors.com/LearnRB/LearnRB.exe
--
Regards,
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com