Excel Sub Report won't print for users

[Former Member]

Hi all,

I have a report which has multiple sub reports. I have recently learnt how to link excel sheets to Crystal Reports, which is great.

One of my sub reports is an excel sheet and, when I load this on Crystal, it shows and works properly.

When I auto schedule this report to send to colleagues, it sends an email with no attachment. If I take the excel report off, it sends fine with no issues.

Does anybody have any idea how to make this work correctly?

Hope I make sense, but if not then feel free to ask questions!

Matt

[former_member11696]

Did you set the log on info for the subreports data source? If it's not set or not available that would stop it from running.

Don

[Former Member]

Hi Don,

Thanks for your reply.

The company I work for hire out plant equipment, so our schedules are done through our hiring system (Insphire).

I don't believe the firewall is the issue (although I really am no expert), as this scheduled email does send when I don't have this excel sub report. (The main report has multiple sub reports, all of which work fine - until I add the excel report).

It is just this sub report that stops the scheduler from working.

Any further info would be greatly appreciated.

Matt

[former_member11696]

Hi Matt,

I assume you are using BOE to schedule and send the reports out?

Attachments are being removed by your AV or Firewall software. I believe you need to add them as safe attachments.

Don