How to set SubReport to not display when there is no data
Hello,
I am using ReportBuilder Professional Edition 6.03, which comes bundled with
our main operating software, Nexus Business Financials by E-Technique.
I am designing a form that we use for printing our company's sales orders
and I am encountering an issue with using 2 sub-reports at the same time. A
screencap of the affected report can be viewed at
http://i870.photobucket.com/albums/ab263/travis_bd/report.jpg
It probably won't help much, but the layout for the subreport screencap can
be viewed here:
http://i870.photobucket.com/albums/ab263/travis_bd/ReportTemp.jpg
Subreport #1 is set to print additional details of a stock code, which is
shown on item #1 on the sales order in italics. This uses the SoOrdDetails
data pipeline. Subreport #2 is supposed to display batch/serial numbers of
applicable items. This uses the SoOrdBatches data pipeline. This report is
set to ShiftRelative to Subreport 1 when there is no info in Subreport 1, so
that Subreport 1 also doesn't display an empty line when there is no data in
SubReport1.
The problem I seem to have is that Subreport #2 displays regardless of
whether there is any information in the batch/serial records. Items #2-3
have no batch/serial information applicable, but Item #4 has the
batch/serial information included.
According to E-Technique, they say it is a limitation of the ReportBuilder
program. I do see that we are several versions behind, but I've tried almost
everything that I can see in ReportBuilder to try and stop this from
happening.
Do you have any information or tips that can help me with this?
Many thanks,
Travis Simons
I am using ReportBuilder Professional Edition 6.03, which comes bundled with
our main operating software, Nexus Business Financials by E-Technique.
I am designing a form that we use for printing our company's sales orders
and I am encountering an issue with using 2 sub-reports at the same time. A
screencap of the affected report can be viewed at
http://i870.photobucket.com/albums/ab263/travis_bd/report.jpg
It probably won't help much, but the layout for the subreport screencap can
be viewed here:
http://i870.photobucket.com/albums/ab263/travis_bd/ReportTemp.jpg
Subreport #1 is set to print additional details of a stock code, which is
shown on item #1 on the sales order in italics. This uses the SoOrdDetails
data pipeline. Subreport #2 is supposed to display batch/serial numbers of
applicable items. This uses the SoOrdBatches data pipeline. This report is
set to ShiftRelative to Subreport 1 when there is no info in Subreport 1, so
that Subreport 1 also doesn't display an empty line when there is no data in
SubReport1.
The problem I seem to have is that Subreport #2 displays regardless of
whether there is any information in the batch/serial records. Items #2-3
have no batch/serial information applicable, but Item #4 has the
batch/serial information included.
According to E-Technique, they say it is a limitation of the ReportBuilder
program. I do see that we are several versions behind, but I've tried almost
everything that I can see in ReportBuilder to try and stop this from
happening.
Do you have any information or tips that can help me with this?
Many thanks,
Travis Simons
This discussion has been closed.
Comments
You are using a very old version of ReportBuilder. I believe we made some
fixes that relate to the issue you are having however you will need to
contact the company that provided you with the software you are using to
test the new version.
-----------------------------------------
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
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com