display data on report

[mn12]

hi all,

i want to create reports that display indevidual details of employees. (i have to import the data from db (access)). i try to display details of children , but i get only the details of the first one.(first child for each employee).
how can i import details of all children for each worker?

 

[Sezzle4]

You can create a subreport containing solely the children details and link the subreport to your main report via an identical field relating the two table details. If you do not select the "On-demand" check box when creating the subreport the function will place the body of the subreport within the main report. However if you do selesct the "On-demand" check box it will create a link field that will take the user to the seperate subreport upon selection!

Make any sense?

SJ

 

[GJParker]

mn12 you need to give us a lot more information if you want a sensible reply to your question i.e.

how is the data held in your database i.e. 1 table or many tables.
If more than 1 table how are they joined.

what is the layout of your report does it contain groups.
in which section of the report is the data displayed.

Gary Parker
Systems Support Analyst

 

[mn12]

the data held in my db in 4 tables.(the tables are joined by primery keys).
the data is displayed in the header section of the report.
(i dont know, maybe i should display the children details in details section).

thank you very much

 

[lyanch]

The header will only show the first record. You will need to place the children in the detail to show all of them.

Lisa

 

[mn12]

i tried to do that,but the report shows the details of the first child 3 times or more , instead of show the details of all chidren.
how can i solve the problem?

 

[JEX]

Let's assume you are grouping on Employee and you are putting the children record fields in the Details section. Check you're links - are you using ODBC? Left outer join or equal? If you can't sort it via your linking - perhaps because of the data structure - then the subreport method above should work, providing you place the sub report in details section and link between the subreport and main report on employee field (same one you group on).

J