Topic: 2 separate report into 1 Posted: 03 Mar 2010 at 4:45pm
Our sales want 2 separate reports, one is sales and the other is product enquiry combine into 1 report. However, the tables are different and no direct relatonship. Is it possible to show the 1st report and then the 2nd report toghether.
Joined: 09 Nov 2009
Location: United Kingdom
Online Status: Offline
Posts: 12
Posted: 04 Mar 2010 at 3:39am
Hi,
Yes you can, just add the second report as an unlinked sub report and stick it in the report footer, you can then supress the sections in the main report you dont need to see.
In design view...
1) click 'Insert Subreport' icon 2) Select 'Existing Report' 3) place the report onto the 'Report Footer' 4) Supress any sections you don't need 5) preview the report
You may need to tidy it up a bit. You also need to remember, the conditions in the select experts of each report need to be set seperately (if used).
Hi, I have a similar issue here, but awear01's solution will not work for my purposes. I actually need to have 2 reports combined into 1, not just visually.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum
IP Logged
