Master Detail Report

[Stephan1]

Hi,

i got a question about creating Reports with Master Report (Order) and also Detail like products etc.

Here is how it should look. It's a kind of creating a Invoice for a Company.

There are 3 Datasources.

1. Order ( Where Name. Adresse) etc is stored. id field is ORDERID
2. Products (all products off this invoice are here). ID Field is ID and also got a Field ORDERID in it for relation to ORDER
3. Paying conditions (how to pay, etc). Also a ID field called ORDERID to make relation to ORDER

ok so far so good.

how can i connect these 3 datasources ?. i cant get it to work with more then 1 relation.

if i use a Relation between order and Products it works fine. but i cant get it to work that i also can show the 3. datasource (paying condition) in the Report footer.

the report looks like this.

1 databand. Orders
2. Databand Products.
3. chiled databands etc.
4. Report footer
Data of paying etc...


At the end of report at "Report footer" i want to display the Paying conditions of this invoice. but when i create a relation in Paying conditions to ORDERS my products in databand 2 is empty.


I can't get it to work.

Thx for all your help here.


Stephan

[Guest]

You can set the property "Reset Data Source" of the Paying conditions band to "True".

Thank you.

[Stephan1]

To get the data of paying info etc. in the report footer do i have to put a container in the Report footer and then the Databand for paying info ?. Otherwise i cant add a databand in a report footer.

Also i tried to reset the datasource but same problem.

If i add a New Relation in the Payinginfo Datasource to ORDER the Databand 2 with order shows no info. If i delete the relation the data is printed exactly.

Is there a wizard for linking tables together ?.


I try to describe it a bit better.

It looks like:


Report title.

Company logo......


Adress of invoice recipient
Name
Street etc.




Pageheader
Art. Number... product name...... Price......... (only textfields)

Databand1 (Order)

Databand2 (products)
Product A product name Price
Product B product name price
....


Reportfooter
Container1
---- Databand3 (Paymentinfo)



The datasources look like the following

Datasource 1 (Order) ... Has no Relation

Datasource 2 (Products) ... has a relation to ORDER..

Datasource 3 (Paymentinfo) ... has a relation to Order


Then the report shows the paymentinfo in the Report footer / container / Databand 3
but in Databand 2. It shows no Products anymore.

Can i only connect to the master table, here ORDER with 1 other table like here Products ?.

i need few more tables all must be connected to the master with its id.

Like i said allready. Datasource 1 (Order) has ID field called ID.. Datasource 2 (Products) has a field calld ORDERID to link to Datasource 1.
Datasource 3 has also a field called ORDERID to connect to ORDER.

It is important to write the payment info at the end of the report. So i thought to put it in Reportfooter..

To make it clear. i mean i have 1 Master table with a ID field and about 3-4 other Tables (datasources) to connect to it with the ORDERID field, and print them
in the report footer or somewhere else. Did i have to use a subreport for that ? guess not or ?.

Thx again for you help here.

Stephan





Thx

Stephan

[Stephan1]

Any Tips for that Problem ?. i cant figure it out.

thx alot

[Edward]

Please see the report in the attachment. Please note that you need to download prerelease version 2007.2 for running this report.

The report from the attachment you can open in the Demo.exe sample application from the standard delivery.

If the questions still exist please feel free to contact us.

Thank you.

[Edward]

If you still have issues with creating such a kind of the report, please send your report and data for it to . We will help you in this case.

Thank you.