Email PDF

[cktcPeterson]

I have a report that I want to email as a pdf. The report looks great, however when I go to email it via pdf or print the 3 subreports are not being included.

I have had reports work prior, and I added 1 more subreport to it and now it does not work.

 

[theDBguy]

You may have to post a sample db for someone to take a look.

 

[cktcPeterson]

I think I need to use the NZ option. I am not sure how to do it.

In one of my subreports, I have the field [Award Amount] and then in another field =Sum([Award Amount])

When I have a value in there it shows up on the report. When it is null, the subreport is blank.

 

[June7]

So why would the Sum be Null? I just did a test and even if report does not have records, the Sum calc shows 0. And things like labels and the Sum textbox still show.

I also think you need to provide db for analysis. Follow instructions at bottom of my post.