UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Subreports Not Displaying, Access 2013    
 
   
everettmiller
post Aug 9 2018, 10:04 AM
Post#1



Posts: 170
Joined: 9-May 11
From: Columbus, GA USA


Hey forum!
This is probably going to be the dumbest question you will have received in a very long time. However, I'm stumped so here goes...

My report displays employee information (name, title, dept, etc) and contains two sub-reports. The first sub-report displays a list of training the employee has scheduled. The second displays a list of training the employee has completed. The two sub-reports are linked to the main report using the employee id (EMP_ID) field.

If the employee has training scheduled then that particular sub-report displays properly on the main report. The same is true for the completed sub-report when training has been completed. The problem occurs if there is no training scheduled or no training completed. In these cases, the sub-report does not appear at all in the main report, just a blank space. While these are valid scenarios, I still need the sub-report(s) to display.

Any thoughts and/or advice is appreciated more than you can know!

Everett
Go to the top of the page
 
RJD
post Aug 9 2018, 10:20 AM
Post#2


UtterAccess VIP
Posts: 9,238
Joined: 25-October 10
From: Gulf South USA


Hi Everett: One way to do this (that I have used in the past) is to use a UNION query as the source for the subreport. The first part is what you have now. The second part inserts a dummy record that has, say, "No training scheduled." in one of the fields and Nulls in the rest if the count in the first part is 0 (WHERE and a DCount looking where the first part looks).

Without any details on your db this is just an idea, but you might want to try this approach. The purpose of the dummy record, of course, is to force the subreport to display.

Others may have other approaches, but I have used this approach successfully in the past.

HTH
Joe
Go to the top of the page
 


Custom Search


RSSSearch   Top   Lo-Fi    10th December 2018 - 11:59 PM