Skip to Content
avatar image
Former Member

Excel Sub Report won't print for users

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Mar 05 at 10:09 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 06 at 03:15 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Mar 06 at 06:45 PM

    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

    Add comment
    10|10000 characters needed characters exceeded