|
Jack,
Below you can find my yesterday's E-mail message to
you. It looks like you have not received it for some reason. So I am
posting this to forum. In case the message quoted below does not
help you to solve the problem, than I am ready to assist you by any
other way (including crossloop.com). Perhaps it will make sence
for you to prepare a sample app with your data&dictionary and
send it to me. I sure, I'll be able to make nesessary changes to get it working
and send the app back to you ASAP.
Thank you,
---
Jay,
Please, read carefully following text quoted from the
forum thread mentioned.
As you suspect, there is another way to get this report
without using such complicated VIEW record set. In this case you have to
retrieve child records on your own using embedded code.
I have
prepared appropriate example application to demonstrate all the details for
the both methods mentioned. You need Carion5 or higher and "Fomin Report
Builder" v.2.x template installed in order to open and compile supplied APP on
your own. Both application source (APP, DCT) and compiled executable (EXE)
file with sample datafiles (TPS) are included into this package. So, you can
run this example without recompilation.
Please, download
installation file with this example applicaton from
http://www.fomintools.com/frb_example2.exe
I recommend you to download this example and
investigate the embedded source code. This second approach can help
you to achieve good result when you are using more than two child files
(tables). This is another forum quote appropriate for
you.
The example application mentioned contains two
RunTimeReport procedures to demonstrate two different ways of solving this
problem. The RunTimeReport procedure with embedded code is the answer to your
question.
Hope this helps.
Thank you,
---
PS: I
don't like to install on my computer such a software provided
by CROSSLOOP.COM. Moreover, we have 9 hours time zone difference. I
sure, you'll be able to do the job with the hints provided above. Anyway,
feel free to keep me in touch by E-mail.
Hello Oleg,
Parent Header
Child1:Record1 Header ((Are you putting
Child1 fields here?)
Child2:Record1 Detail
(The Child 2 data seems be replicating itself multiple
times)
Child1:Record1 Footer (Are you
putting Child1 fields here? I am only able to get 1 record to
print)
Child1:Record2 Header
Child2:Record1
Detail
Child1:Record2 Footer (Are you putting Child1 fields here? I am only
able to get 1 record to print)
ParentFooter
I would really like to
learn how to do this using ReportBuilder. CAN YOU PROVIDE REAL-TIME ASSISTANCE
VIA CROSSLOOP.COM ON A FEE
BASIS?
Original Forum Post:
I would like to print a report with all of the records in each CHILD
grouped together, before printing the next CHILD RECORD GROUP. My File View HAS
1 PARENT (1 TO MANY) with 5 CHILD FILES
PARENT
|_ CHILD1
|_ CHILD2
|_ CHILD3
|_ CHILD4
|_ CHILD5
I attempted to do this with multiple details bands, but the result
seems to print 1 record in detail1 for Child1, then 1 record in detail2 for
child2, etc. through detail5. How should set up the TABLE VIEW and the FOMIN
REPORT format to achieve this result.
SORT 1 ON PARENT GROUP 1 PARENT SORT 2 SORT 3 SORT 4 SORT 5 SORT 6 DETAIL 1
(ALL RECORDS FOR CHILD 1) DETAIL 2 (ALL RECORDS FOR CHILD 2) DETAIL 3 (ALL
RECORDS FOR CHILD 3) DETAIL 4 (ALL RECORDS FOR CHILD 4) DETAIL 5 (ALL RECORDS
FOR CHILD 5) Please advise. Thanks,
--
:<{)
|