SubReports

[Lauren36]

I have a main report with a one to many relationship with a subreport. I am having a terrible time desingning a report that shows one personnel record and then shows the many types of funding out front that one record. The tables are set up so that we have one personnel record in the employee table with three or four funding records in the employee funding table. Please help I know I am just not understanding a very simple concept here.

 

[hsitz]

Have you inserted the subreport into the detail section of the main report, and do you have it linked with the main report on the proper fields? Need a bit more info about what you've done that hasn't worked. -- Herb

 

[Lauren36]

My actual problem is that I have the Main report and the subreport working properly except I need the information in the subreport to be repeated across the line instead of the information going down in rows. For example I have employee xxx with funding a, funding b an funding c;
I need the information to look like this:
employee xxx funding a funding b funding c

and instead it now looks like this:
employee xxx funding a
funding b
funding c

the employee xxx information is in the main report and the funding information is in the subreport.
Please help! How do I fix this???

 

[DanC]

Do you determine funding a, funding b, funding c, etc based on some criteria in your table? Or is it just the first record, second record, third record, etc for that person? If it's based on criteria, you can just use text boxes and iif statement =iif(somefield='x',funding b,'') and so on.

Hope this helps, and my apologies if it doesn't.

-D

 

[DanC]

sorry, forgot to add this in...you should use those iif statements in your subreport before it's pulled into your main report.