Report with sections and child reports

rbuser

Hello!

I'm new to report builder and I'm trying to create a company report with the
following structure:

Company details
Data data data
Child report
SUBREPORT 1: (Contact info [tel number, etc]) --> means of communication in
general (website, email, etc) (defined as child report under PrintBehavior
and relative to a memo)

New Section containing all the contacts from this company (People with phone
numbers)

SUBREPORT 2: The report in its first part seems to run ok, but when I try to
insert a new section subreport containing the info needed (defined as
Section under PrintBehavior) the first subreport goes to the last page to be
shown...

What am I missing?

Thanks in advance

Ricardo

nicocizik

Hi Ricardo,

Section subreports are mainly meant to be used to combine multiple reports
into a single report. Below are a couple of options you can try.

1. Set the ShiftRelativeTo property of the section subreport to the first
child subreport. This will ensure that the child subreport remains above
the section.

2. If you still have spacing issues, I would recommend creating a blank
report (detail band only) with two section subreports inside. The top
subreport will contain the company details, data, and subreport 1. The
bottom one will remain the same as your original report. This will
logically separate both sections of the report and should resolve any
spacing issues.

--
Regards,

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

rbuser

Hello

Thanks for the answer

I got the report running based on the second option.
Now I still have a problem based on the very first page. There I have three
subreports that are opening ok except that I have a blank page as the very
first page.
How can I have the report start displaying with the first subreport page? I
tried changing the visible property for the "launching" report but no luck
with that...

Further... I have on one of the subreports on report as follows:

Operation performed for Customer
infos about the operation
Child Report containing the follow-up contacts based on Company ID and
Operation Number
For my pont of view this is sort of master-detail report...
I tried linking fields under delphi using the dbPipeLine Components
associating the master table (operation) with the detail table (follow-up)
but I can't get the results displayed
Inside delphi I have these two tables related with queries that bring me the
result...
The master table shows all the correct infom but the detail table I'm not
getting it change the company id and operation number used as parameters at
the query

qHistoricoOperacoes.ParamByName('NR_OPERACAO').AsInteger:=qOperacoesEmpresaNR_OPERACAO.AsInteger;;
qHistoricoOperacoes.ParamByName('ID_EMPRESA').AsInteger:=EmpresaID_EMPRESA.AsInteger;

Some Operations don't have any follow-ups yet and I already managed not to
display infos when the data is blank or no results available but I can't
change these parameter values in the report...

How could I achieve the expected result?

thanks once again


Ricardo

nicocizik

Hi Ricardo,

1. What type of subreports are the three inside the first section
subreport? Be sure these are either child or fixed. Also, if you are
creating a master-detail report, you will need to place the detail subreport
inside the master. Please spend some time working through the Developer's
Guide located in the \RBuilder\Developer's Guilde\...directory especially
the sections on creating master-detail reports.

2. Rather than trying to manually set the Delphi parameters, try using
DataPipeline linking. As I mentioned above, take a look at the Developer's
Guide and see the Master-Detail demos located in the \RBuilder\Demos\1.
Reports\... directory for tutorials and demos of how this should be done.

--
Regards,

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

rbuser

Hello!

the types of subreports I'm using are section...
In fact I found the wikki at digital-methaphors.com:8080 and I'm going all
over I can imagine...
I also have the developers' guide and am taking a deeper look at it...

I'll check over the items you mentioned and as soon as I have any updates
I'll post back here then
Thanks once again

Ricardo

rbuser

Giving additional feedback.

When using fixed style report I get a complete blank report...child report
shows but all records are positioned all over each subreport creating a
total mess.
I tried using shiftRelative to the reports but results looked strange
althought resolved the blank page issue...

I rolled back to the section style as mentioned here
http://www.digital-metaphors.com:8080/Design/Features/Form_Emulation under
"multiple pages"...but still can't create the launching report style
mentioned in the article.

About the master/detail...I tried to connect the operation fields and
company id via pipeline but still no luck. I can't get the data shown

Ricardo

rbuser

Well, I tried all the options I could imagine for the detail band but no
luck

After going over all the examples I could join the fields (master-detail)
using only the DBpipeline component
Now I see only the record that has some details and not all
in fact I expected to see the operation info and when no data is available
as the followup I'd like just to inform that there's no follow-up for the
operation, ie

operation data band --> info about operation (code, date, user,
description)
follow-up details band -->
if no follow up, just write "no data available"
else show follow-up info (date, description, contact)

I also tried changing the info skiprecords, etc but I don't know anymore
where to look... I went through the whole examples in the dev guide pdf as
well as in the wikki...
What else can I try?

Ricardo

nicocizik

Hi Ricardo,

Are the examples functioning correctly on your machine? I would suggest
that you start from scratch with your application and mimic the design of
the examples provided.

Start simple, perhaps with only two datasets and a single subreport and get
that working before moving to more advanced designs.

1. Be sure the detail dataset is ordered on the same field the master
dataset is.
2. Take a look at the SkipWhenNoRecords property of the detail dataset. (RB
help).

--
Regards,

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