Solved

Getting Error using Crystal Reports Viewer 2008

Posted on 2014-04-24
12
316 Views
Last Modified: 2015-02-02
We have started getting an error when we try to open a successfully ran Crystal report, with sub reports.  The Crystal Reports Viewer is running via a Citrix Server. If i am signed into the CMC, I can open the results with no issues.

The error we are getting;

Unable to Continue Viewing Report, more data is required to continue viewing this report. This report does contain saved data, but it is not complete. Unfortunately this version of the Crystal Reports Viewer does not support fetching further data and viewing cannot continue.

We are using;
Crystal Reports Viewer 2008
Version: 12.2.209
Build r1094
0
Comment
Question by:mcsusan
12 Comments
 
LVL 100

Expert Comment

by:mlmcc
ID: 40021223
What report viewer are you using?

Is this the viewer that comes from Crystal?
If so it is for use with reports that have saved data.  It cannot refresh the data.

Have you tried opening the report in the Crystal designer and running it then saving it with the data?

mlmcc
0
 
LVL 8

Expert Comment

by:Lee Ingalls
ID: 40021230
Is your Crystal Viewer app published or via the Citrix desktop?

mlmcc, it looks like Crystal's Viewer
we are using Crystal Reports Viewer 2008
Version: 12.2.209
Build r1094
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 40021258
Crystal viewer cannot refresh reports.  It was built for displaying reports with saved data.   It is possible to save a report with data but not have allowed the query to run to completion.

Also if the subreports are ON DEMAND subreports, then they haven't been run at all.

mlmcc
0
What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

 

Author Comment

by:mcsusan
ID: 40021304
The report is actually being opened via Epic Hyperspace (our electronic medical record system).  Hyperspace is also a citrix launched app, so is the Crystal Report Viewer.  

The .rpt does have subreports, that are on demand, for drill down purposes.  We have other reports that are simular but are working ok. The only difference with this .rpt is that it was written via a Crystal Command.
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 40021443
Is the viewer part of the Epic application or is it the Crystal provider saved data viewer?

I doubt the Crystal viewer can handle on demand subreports since the data isn't saved with the report.

mlmcc
0
 

Author Comment

by:mcsusan
ID: 40021457
mlmcc - it launches the Crystal Report Viewer that is provided by Crystal.  I'll go back to the report writer who created this .rpt and ask about the on demand subreport.
0
 
LVL 26

Expert Comment

by:Kurt Reinhardt
ID: 40028789
For the sake of clarification, it's probably not the free, downloadable Crystal Reports Viewer from SAP.  Support for Crystal Reports is built directly into Epic (one of a couple of tools, the other being the Reporting  Workbench).  It's a custom viewer and the version of Crystal Reports used to write the report should match what's compatible with the version of Epic being used.  As an example, I had to upgrade a client to XI 3.1/Crystal Reports 2008 a couple of years ago because those were the versions recommended by Epic.

The viewer itself, however, may have issues with reports that use SQL Commands as data sources.  Even though Enterprise comes bundled with Epic and there's built in support for Crystal Reports, there may be limitations because it's a custom tool. I'm sure there are, in fact.  There are similar concerns with LBI with Lawson.

That being said, the report should be easily accessible through the BI Launchpad/Infoview, however.
0
 

Accepted Solution

by:
mcsusan earned 0 total points
ID: 40433357
Closing question.  There is an issue with the version of Epic (EMR) and BOE 3.1 that does not allow this.  We are in the process of upgrading BOE to 4.1 to resolve. Thanks for all your help and sorry for the delay in response.
0
 

Author Comment

by:mcsusan
ID: 40433359
Question, how do i close this question without a solution?
0

Featured Post

ScreenConnect 6.0 Free Trial

At ScreenConnect, partner feedback doesn't fall on deaf ears. We collected partner suggestions off of their virtual wish list and transformed them into one game-changing release: ScreenConnect 6.0. Explore all of the extras and enhancements for yourself!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
This tutorial gives a high-level tour of the interface of Marketo (a marketing automation tool to help businesses track and engage prospective customers and drive them to purchase). You will see the main areas including Marketing Activities, Design …
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

778 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question