Kyle Abrahams, PMP
asked on
Citrix + Crystal Reports
Hi All,
Production:
Citrix -> Fat Client -> embedded crystal report
We're getting complaints that reports in our production environment are taking 10 to 15 minutes to complete regardless of the number of runs.
QA:
RDP -> Fat Client -> Embedded Crystal Report
When we run this in QA (local, on a server, but no citrix) same report with similiar data takes a few seconds.
Unfortunately being a developer I don't have access to production or inside knowledge about the citrix environment (handled by another team).
I'm looking for documentation that says this is expected behavior or a list of possible fixes that can be implemented to speed up production. Has anyone seen anything ilke this before or anything I can provide up the ladder to get this resolved?
Production:
Citrix -> Fat Client -> embedded crystal report
We're getting complaints that reports in our production environment are taking 10 to 15 minutes to complete regardless of the number of runs.
QA:
RDP -> Fat Client -> Embedded Crystal Report
When we run this in QA (local, on a server, but no citrix) same report with similiar data takes a few seconds.
Unfortunately being a developer I don't have access to production or inside knowledge about the citrix environment (handled by another team).
I'm looking for documentation that says this is expected behavior or a list of possible fixes that can be implemented to speed up production. Has anyone seen anything ilke this before or anything I can provide up the ladder to get this resolved?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
New info is it's one main report. We're doing deltas between that and a working report to see what's going on.
Slowness is consistent regardless of time of day or specific parameters used.
I'm playing telephone through a bunch of different levels but that's what I'm getting back so far.
Please keep the suggestions coming.
Slowness is consistent regardless of time of day or specific parameters used.
I'm playing telephone through a bunch of different levels but that's what I'm getting back so far.
Please keep the suggestions coming.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
>> Does the "slow" report have any subreports?
- None.
I was finally able to see this run in Citrix . . .
Our process is to build the data table outside of crystal . . . and handle crystal the dataset for formatting purposes.
We do this using a background worker so we can report progress as we go.
It's hanging here:
worker.ReportProgress(50)
rptDocument.SetDataSource( m_DataTabl e)
If worker.CancellationPending Then
e.Cancel = True
Exit Sub
End If
worker.ReportProgress(75)
Time to dive into the actual crystal report. Note the same process is used for the "working" report.
Noticeable difference so far is that the "slow" report has a number of formulas (10-20) some of them used some of them not. Does crystal calculate them all if they aren't being used?
Will keep reporting as I go, thanks for the suggestions and looking forward to more ideas.
- None.
I was finally able to see this run in Citrix . . .
Our process is to build the data table outside of crystal . . . and handle crystal the dataset for formatting purposes.
We do this using a background worker so we can report progress as we go.
It's hanging here:
worker.ReportProgress(50)
rptDocument.SetDataSource(
If worker.CancellationPending
e.Cancel = True
Exit Sub
End If
worker.ReportProgress(75)
Time to dive into the actual crystal report. Note the same process is used for the "working" report.
Noticeable difference so far is that the "slow" report has a number of formulas (10-20) some of them used some of them not. Does crystal calculate them all if they aren't being used?
Will keep reporting as I go, thanks for the suggestions and looking forward to more ideas.
ASKER
One other thing: We can run the program fine on the actual citrix server without issue. It's only when the presentation framework is working on the client that this becomes an issue.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Found the solution on my own, suggestions were valid though not accurate.
My Crystal Reports Viewer application has been running on many Citrix installations and I've never seen this problem.
Do you see this slow down with all reports? Always or only during certain times of the day?