Language Syntax

rbuser

I have been trying to use the calculations tab of RB. I am myself a
programmer, but I cannot use the Delphi environment in this case, since
the report generator is wrapped in a application. So, I am in a user role
rather than in a programmer role.

The problem is that I find only examples/tutorials of manipulating the RB
objects from Delphi, not from the RB events.

For example: for some reasons, I cannot link two specific datasets in the
data tab and I would like to link them "programatically". I tried the
following:

procedure ReportOnStartFirstPass;
begin
SubReport1.DataPipeline.MasterDataPipeline := Report.DataPipeline;
SubReport1.Datapipeline.MasterFieldLinks := 'LINK_KEY';
END;

Although the first statement is accepted, the second one is rejected by
compiler, saying it was expecting '(' or '[', not 'MasterFieldLinks'.

Another example: I just cannot move a pipeline with a command
Report.DataPipeLine.Skip.

By the way, if somebody is interested, my problem is that I need to
produce a report that shows only records from table A which has at least
one other record with the same values in fields (A1,A2,A3). When such
repetition of fields is found, I need to show the count and some other
(non-repeating) fields of the (A1,A2,A3)-repeated records.

I accomplished that in a test using two linked datasets (one with the
counting and one with the details records), but the linking key was
unique. I could even do a drill-down report. The only problem is that I
had to make the records for which count=1 invisible rather than avoid
bringing them from database at all... but that's another problem.

When I have a composite key I cannot use the data tab to correctly link
the datasets, since RB always gets wrong direction (many-to-one, not
one-to-many). I tried to concatenate the fields to transform the composite
key into a single field, but it also didn't allow for joining based on
the calculated field. I suppose I can circumvent this problem if I build
the links in the calculation tab.

Thank you in anticipation for any hints!

Ismar

--- posted by geoForum on http://delphi.newswhat.com

nicocizik

Hi Ismar,

I would suggest working through the tutorials in the Learning To RAP
application from our website. Depending on which version of RB you have
embedded in your app, you may be able to use the SQLBuilder object to handle
your datasets.


-----------------------------------------
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
infomation.

--------------------------------
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

nardmoseley

For future reference, please post RAP questions to the RAP newsgroup.

----------------------------------------------
Tech Tip: List of Resources for RAP
----------------------------------------------

Here is a list of RAP resources.....

- The ReportBuilder Developers Guide contains detailed information on RAP -
including step by step tutorials for extending RAP with custom functions. It
is installed to RBuilder\Developers Guide\RBuilder.pdf

- The RAP help file is installed with RB and merged with the Delphi help
system.

- Demos and completed tutorials are installed to RBuilder\Demos\RAP

- Learning ReportBuilder RAP tutorial system that can be downloaded from our
web site.

- The RAP newsgroup contains a history of questions that developers have
asked in the past and our answers to those questions.

- The Tech Tips newsgroup contains a RAP thread with some useful articles.




--
Nard Moseley
Digital Metaphors
www.digital-metaphors.com