Adding a Summary to my report

rbuser

I have a report which is grouped using a string field, I have summary data
in the group footer.
In addition to this I would like to add a summary to the entire report which
summarises the data (counts, sums, etc.) in terms of another field from the
same query. I have tried to do this by dropping a subreport in to the report
summary section which has the same pipeline as the main report. My idea was
to produce the summary data I need using this sub-report.
The problem I am having is that as the query is ordered by the string field
(to support the grouping of the main report), the subreport will not group
properly.
I did think about adding a separate query but I need to ensure that the data
returned by the second query is subject to the same search criteria as the
first query (I can't expect my users to enter the same search criteria twice
when running the report.

I would appreciate any advice you can offer me.
Thanks,



Nick White
FDS Advanced Systems
Tel: 01483 481024
Fax: 01483 486956

nardmoseley

Probably simplest to use two queries. For the main query define the
autosearch criteria. For the summary query, define a search criteria that is
not designated as autosearch.

Use the Report.OnGetAutoSearchValues event to apply the search expression
value entered by the user to the summary query.

Here is an example.....

www.digital-metaphors.com/tips/DadeOneAutoSearchToTwoDetail.zip




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

rbuser

Thanks for your reply Nard. I'm an end-user however rather than a developer
(Hence the group I posted in). I can understand the concept of the second
query using the search criteria entered by the user for the first query, but
it's not clear to me how to implement this in the report. Am I right in
thinking that the solution you've posted requires an understanding of Delphi
Code - which I don't have!

Thanks again,



Nick

--
Nick White
FDS Advanced Systems
Tel: 01483 481024
Fax: 01483 486956

nardmoseley

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



--
Tech Support mailto:support@digital-metaphors.com
Digital Metaphors http://www.digital-metaphors.com



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