Skip Page

rbuser

Hi,

We are using Report Builder Enterprise Edition Version 10.04

The objective of the report is to print customer statements at the end of
the month with a list of all the account transactions. The report is
grouped by customer account and has a page break after each customer
account.

We need to build in a filter so the statement prints only for those account
that meet specific criteria. So far we have built a filter as follows:

begin

if Account['AccountTerms'] <> 1 then

begin

GroupHeaderAccount.Visible := False;

Detail.Visible := False;

Footer.Visible := False;

end

else

begin

GroupHeaderAccount.Visible := True;

Detail.Visible := True;

Footer.Visible := True;

end;

end;



This filter is hiding the information that is not required but it still
leaves a blank page for those accounts that are not required. Is it
possible to build in a filter that skips the page if Account['AccountTerms']
<> 1 then therefore the code has to be that if the Account['AccountTerms']
<> 1 then skip page. How can we achive this?



Thanks



Shirley

nicocizik

Hi Shirley,

The easiest way to do this would be to add a search condition to your SQL
code accessing your dataset...

WHERE
AccountTerms <> 1

This will prevent the data from ever being traversed and therfore the
bands/components will never be created. You can do this manually in
DADE/Delphi or in code using the TdaSQLBuilder object in RAP or Delphi.

--
Regards,

Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com

rbuser

Thanks for your reply Nico.

The problem is that I am using Report Builder as a tool with an 'off the
shelf' accounting package and I cannot modfiy the SQL code and datapipelines
in the reports available therefore I was hoping to skip the page by applying
code in one of the events of the report.

Any ideas?

Thanks for your help

Shirley

nicocizik

Try toggling the Group.NewPage property as well.

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

rbuser

Thanks Nico

The NewPage property did the trick.

Thanks for your help.