Crystal report won't print

Hi,
Â
In the report style, please check your report location. Make sure the reports listed there have ".rpt" at the end.
Â
-Prabin Maharjan



________________________________
From: "nbuckman@..." <nbuckman@...>
To: vantage@yahoogroups.com
Sent: Wednesday, October 24, 2012 8:23 PM
Subject: [Vantage] Crystal report won't print


Â

Hello,

I have a Crystal Report for Master Pack Slip that will not print. The standard version does, but when I print or preview mine, the XML is created and no errors are notified. The System monitor says "success".

If I open the report in Crystal Report and open the XML it is all fine - no errors and I can manually print from Crystal. But if I run it from Epicor (9.05.700C) I get neither report (print or preview) and no errors.

Any suggestions?

- Neil




[Non-text portions of this message have been removed]
Hello,

I have a Crystal Report for Master Pack Slip that will not print. The standard version does, but when I print or preview mine, the XML is created and no errors are notified. The System monitor says "success".

If I open the report in Crystal Report and open the XML it is all fine - no errors and I can manually print from Crystal. But if I run it from Epicor (9.05.700C) I get neither report (print or preview) and no errors.

Any suggestions?

- Neil
WOW - Mr. Neal: That's a tough one. Are you using Crystal XI? or 2008?

Is your Crystal Runtime up to date?

I have seen in the past where the Crystal Auto Linking can mess up the table joins.

It is difficult to say without knowing what you did to the form. Did you add any tables? or were your changes more cosmetic.

You may want to try a divide and conquer "thing". I would make a copy of my crystal file and then go about trimming down your Crytal file.

By trimming I mean that I would eliminate all groups a subreports to see if using data from just one table works. If it does restore your copy and then try eliminating all tables and subreports execpt this time leave two tables joined and so on.

I know - tedious but it would work.

Maybe someone else out there has some better advise. I just happen to be logged on late and saw your entry.

Good luck,

DaveO

--- In vantage@yahoogroups.com, "nbuckman@..." <nbuckman@...> wrote:
>
> Hello,
>
> I have a Crystal Report for Master Pack Slip that will not print. The standard version does, but when I print or preview mine, the XML is created and no errors are notified. The System monitor says "success".
>
> If I open the report in Crystal Report and open the XML it is all fine - no errors and I can manually print from Crystal. But if I run it from Epicor (9.05.700C) I get neither report (print or preview) and no errors.
>
> Any suggestions?
>
> - Neil
>
Thanks Dave,

1 pm here in Sydney...

There are no new tables or fields. Just changes to the layout etc. The Crystal report is 3mb, but others that size are OK. I am using Crystal 2011, not Crystal XI or 2008. I have had no issues to date with other reports.

The Crystal Runtime is as installed last year, 2008 SP3.

I already did some scale back, as you suggested, but to no avail, but I shall try more. It is probably the only way to go.

Sleep well, and thanks again for the response...

- Neil


From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of DaveO
Sent: Thursday, 25 October 2012 12:59 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Crystal report won't print



WOW - Mr. Neal: That's a tough one. Are you using Crystal XI? or 2008?

Is your Crystal Runtime up to date?

I have seen in the past where the Crystal Auto Linking can mess up the table joins.

It is difficult to say without knowing what you did to the form. Did you add any tables? or were your changes more cosmetic.

You may want to try a divide and conquer "thing". I would make a copy of my crystal file and then go about trimming down your Crytal file.

By trimming I mean that I would eliminate all groups a subreports to see if using data from just one table works. If it does restore your copy and then try eliminating all tables and subreports execpt this time leave two tables joined and so on.

I know - tedious but it would work.

Maybe someone else out there has some better advise. I just happen to be logged on late and saw your entry.

Good luck,

DaveO

--- In vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>, "nbuckman@...<mailto:nbuckman@...>" <nbuckman@...<mailto:nbuckman@...>> wrote:
>
> Hello,
>
> I have a Crystal Report for Master Pack Slip that will not print. The standard version does, but when I print or preview mine, the XML is created and no errors are notified. The System monitor says "success".
>
> If I open the report in Crystal Report and open the XML it is all fine - no errors and I can manually print from Crystal. But if I run it from Epicor (9.05.700C) I get neither report (print or preview) and no errors.
>
> Any suggestions?
>
> - Neil
>



Notice:This e-mail and any attachments are confidential and are only for the use of the person to whom they are addressed. If you are not the intended recipient please advise the sender by return e-mail and delete the message and any attachments. Any use, interference with, disclosure or copying of this message or any attachments is unauthorised and prohibited. The sender does not warrant that the information is free of a virus or any other defect or error, and any views expressed herein, unless specifically indicated otherwise, are those of the individual sender.

The DH Gibson Group of Companies - http://www.gibsonshopfitters.com.au

P Please consider our shared environment before printing this communication.



[Non-text portions of this message have been removed]
Too easy.

I had the Report Type set as "Base Definition" in the Report Style instead of "Crystal"...

Sigh, I thought it gave an error if you did that...

- Neil


From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Neil Buckman
Sent: Thursday, 25 October 2012 1:08 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Crystal report won't print



Thanks Dave,

1 pm here in Sydney...

There are no new tables or fields. Just changes to the layout etc. The Crystal report is 3mb, but others that size are OK. I am using Crystal 2011, not Crystal XI or 2008. I have had no issues to date with other reports.

The Crystal Runtime is as installed last year, 2008 SP3.

I already did some scale back, as you suggested, but to no avail, but I shall try more. It is probably the only way to go.

Sleep well, and thanks again for the response...

- Neil

From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf Of DaveO
Sent: Thursday, 25 October 2012 12:59 PM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Re: Crystal report won't print

WOW - Mr. Neal: That's a tough one. Are you using Crystal XI? or 2008?

Is your Crystal Runtime up to date?

I have seen in the past where the Crystal Auto Linking can mess up the table joins.

It is difficult to say without knowing what you did to the form. Did you add any tables? or were your changes more cosmetic.

You may want to try a divide and conquer "thing". I would make a copy of my crystal file and then go about trimming down your Crytal file.

By trimming I mean that I would eliminate all groups a subreports to see if using data from just one table works. If it does restore your copy and then try eliminating all tables and subreports execpt this time leave two tables joined and so on.

I know - tedious but it would work.

Maybe someone else out there has some better advise. I just happen to be logged on late and saw your entry.

Good luck,

DaveO

--- In vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>, "nbuckman@...<mailto:nbuckman@...><mailto:nbuckman@...%3cmailto:nbuckman@...%3e>" <nbuckman@...<mailto:nbuckman@...<mailto:nbuckman@...%3cmailto:nbuckman@...>>> wrote:
>
> Hello,
>
> I have a Crystal Report for Master Pack Slip that will not print. The standard version does, but when I print or preview mine, the XML is created and no errors are notified. The System monitor says "success".
>
> If I open the report in Crystal Report and open the XML it is all fine - no errors and I can manually print from Crystal. But if I run it from Epicor (9.05.700C) I get neither report (print or preview) and no errors.
>
> Any suggestions?
>
> - Neil
>

Notice:This e-mail and any attachments are confidential and are only for the use of the person to whom they are addressed. If you are not the intended recipient please advise the sender by return e-mail and delete the message and any attachments. Any use, interference with, disclosure or copying of this message or any attachments is unauthorised and prohibited. The sender does not warrant that the information is free of a virus or any other defect or error, and any views expressed herein, unless specifically indicated otherwise, are those of the individual sender.

The DH Gibson Group of Companies - http://www.gibsonshopfitters.com.au

P Please consider our shared environment before printing this communication.

[Non-text portions of this message have been removed]



[Non-text portions of this message have been removed]
That was too easy - congrats on the quick solve.

Take care,

DaveO

--- In vantage@yahoogroups.com, Neil Buckman <nbuckman@...> wrote:
>
> Too easy.
>
> I had the Report Type set as "Base Definition" in the Report Style instead of "Crystal"...
>
> Sigh, I thought it gave an error if you did that...
>
> - Neil
>
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Neil Buckman
> Sent: Thursday, 25 October 2012 1:08 PM
> To: vantage@yahoogroups.com
> Subject: RE: [Vantage] Re: Crystal report won't print
>
>
>
> Thanks Dave,
>
> 1 pm here in Sydney...
>
> There are no new tables or fields. Just changes to the layout etc. The Crystal report is 3mb, but others that size are OK. I am using Crystal 2011, not Crystal XI or 2008. I have had no issues to date with other reports.
>
> The Crystal Runtime is as installed last year, 2008 SP3.
>
> I already did some scale back, as you suggested, but to no avail, but I shall try more. It is probably the only way to go.
>
> Sleep well, and thanks again for the response...
>
> - Neil
>
> From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf Of DaveO
> Sent: Thursday, 25 October 2012 12:59 PM
> To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
> Subject: [Vantage] Re: Crystal report won't print
>
> WOW - Mr. Neal: That's a tough one. Are you using Crystal XI? or 2008?
>
> Is your Crystal Runtime up to date?
>
> I have seen in the past where the Crystal Auto Linking can mess up the table joins.
>
> It is difficult to say without knowing what you did to the form. Did you add any tables? or were your changes more cosmetic.
>
> You may want to try a divide and conquer "thing". I would make a copy of my crystal file and then go about trimming down your Crytal file.
>
> By trimming I mean that I would eliminate all groups a subreports to see if using data from just one table works. If it does restore your copy and then try eliminating all tables and subreports execpt this time leave two tables joined and so on.
>
> I know - tedious but it would work.
>
> Maybe someone else out there has some better advise. I just happen to be logged on late and saw your entry.
>
> Good luck,
>
> DaveO
>
> --- In vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>, "nbuckman@<mailto:nbuckman@><mailto:nbuckman@%3cmailto:nbuckman@%3e>" <nbuckman@<mailto:nbuckman@<mailto:nbuckman@%3cmailto:nbuckman@>>> wrote:
> >
> > Hello,
> >
> > I have a Crystal Report for Master Pack Slip that will not print. The standard version does, but when I print or preview mine, the XML is created and no errors are notified. The System monitor says "success".
> >
> > If I open the report in Crystal Report and open the XML it is all fine - no errors and I can manually print from Crystal. But if I run it from Epicor (9.05.700C) I get neither report (print or preview) and no errors.
> >
> > Any suggestions?
> >
> > - Neil
> >
>
> Notice:This e-mail and any attachments are confidential and are only for the use of the person to whom they are addressed. If you are not the intended recipient please advise the sender by return e-mail and delete the message and any attachments. Any use, interference with, disclosure or copying of this message or any attachments is unauthorised and prohibited. The sender does not warrant that the information is free of a virus or any other defect or error, and any views expressed herein, unless specifically indicated otherwise, are those of the individual sender.
>
> The DH Gibson Group of Companies - http://www.gibsonshopfitters.com.au
>
> P Please consider our shared environment before printing this communication.
>
> [Non-text portions of this message have been removed]
>
>
>
> [Non-text portions of this message have been removed]
>
HI -
There are 2 things you can try right off the bat.

First, Open the Epicor 9 System Monitor. Go to the Reports tab. Look for the report you ran based on date and time. You will see if there was a system error there. The error will tell you to Print Preview the report from the System Monitor to see the error (yes you can have an error even though on the history tab it says complete with no errors).

To preview in the System Monitor : Select the report, go to Actions/Preview. You will then get an error box (prompting you to continue, see details, or close). Choose See Details and that should explain the error.

The other thing you can try is going to the DataBase Expert and try making the links all Left Outter Joins. Sometimes if the joins are equi-joins and you dont have a record for that equi-join,Crystal will not print.

Hope this helps,

Marianne G
Estes Group Inc.
mgizzi@...

--- In vantage@yahoogroups.com, "nbuckman@..." <nbuckman@...> wrote:
>
> Hello,
>
> I have a Crystal Report for Master Pack Slip that will not print. The standard version does, but when I print or preview mine, the XML is created and no errors are notified. The System monitor says "success".
>
> If I open the report in Crystal Report and open the XML it is all fine - no errors and I can manually print from Crystal. But if I run it from Epicor (9.05.700C) I get neither report (print or preview) and no errors.
>
> Any suggestions?
>
> - Neil
>