Combined Reports

[baum12]

I need to create a report that has for example: Name appears once at the top. Then I use a query to run the Grants Awarded and Grants Pending. That report looks great.

Now, I have another report that shows Papers Published, BUT, they want it all to be on one report. I know how to use the grouping to get the name to appear at the top but when I try to add the fields from the 2nd report to the first, it duplicates a bunch of data from the first query and is just making a mess of totals and other info from that first query.

My question is, can you add 2 reports together or should they stay separate?

[June7]

Try making Papers Published a subreport on the Grants report.