Print Crystal Report via Accpac Report - Not Responding

[Boris10]

Hi everyone, I am wondering if anyone has experienced this issue before. I am using the following code print a custom Crystal Report. The problem is from time to time, running the report ends up in a Not Responding State:

On Error GoTo ACCPACErrorHandler

Dim mDBLinkCmpRW As AccpacCOMAPI.AccpacDBLink
Set mDBLinkCmpRW = OpenDBLink(DBLINK_COMPANY, DBLINK_FLG_READWRITE)

Dim mDBLinkSysRW As AccpacCOMAPI.AccpacDBLink
Set mDBLinkSysRW = OpenDBLink(DBLINK_SYSTEM, DBLINK_FLG_READWRITE)

Dim rpt As AccpacCOMAPI.AccpacReport
Set rpt = ReportSelect(reportPath, "      ", "      ")
Dim rptPrintSetup As AccpacCOMAPI.AccpacPrintSetup
Set rptPrintSetup = GetPrintSetup("      ", "      ")
If rptPrintSetup.Destination = PD_PRINTER Then
    rptPrintSetup.query (0)
End If

rpt.PrinterSetup rptPrintSetup

rpt.SetParam "@SELECTION_CRITERIA", val
rpt.NumOfCopies = 1

rpt.PrintDir = ""
rpt.PrintReport

Set mDBLinkCmpRW = Nothing
Set mDBLinkSysRW = Nothing
Set rpt = Nothing
Set rptPrintSetup = Nothing

So basically most of the time the report is printed but sometimes it freezes in a Non Responding State.

Would anyone have an idea?

 

[Boris10]

Also I have just noticed that sometimes the report opens but its completely blank with nothing visible except for the "Cancel" Button

 

[ettienne]

Is it a complex report? Something that requires a lot of data processing? Check the server task manager utilisation.

 

[ettienne]

BTW you don't need a link to the system database, so you can drop:

Dim mDBLinkSysRW As AccpacCOMAPI.AccpacDBLink
Set mDBLinkSysRW = OpenDBLink(DBLINK_SYSTEM, DBLINK_FLG_READWRITE)

Set mDBLinkSysRW = Nothing

 

[Jay Converse]

And the company link can be READONLY

 

[Boris10]

Hi Ettienne, hi Tuba. Its a simple report that pulls data from 25 Column Table with about 5000 Rows. The report simply pulls all the data and filters it based on an ID number to display A Single Record.

There are no sub-reports, no complex formulas no diagrams or any other objects.

I checked the Task Manager on the server (I am not a Guru on CPU performance and networking) but it looks consistent.
The CPU is between 0 to 10% constantly and RAM at a constant 6GB (out of 15GB).

I am wondering if it can be the actual workstation having a problem to load the report and not the server?

Will try to remove the DBlinks!

 

[ettienne]

Maybe the workstation, try on another one.