Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


Crystal Report 11 and Progress  4GL

Posted on 2009-04-22
Medium Priority
Last Modified: 2013-12-20
I am going to re-phrase the question.
Rephrased question:

How can I run a Crystal Reports Version 11 report from within the Progress 4GL code using CRViewer?
Question by:armsha
LVL 17

Expert Comment

ID: 24348967
not clear on what you are meaning...please explain a little more in detail..


Author Comment

ID: 24364720
To CRLuser2005:
Thanks so much for your interest in helping.
I develop using the Progress 4GL in a windows environment.
I will write a report application in Progress with a GUI interface that accepts parameters such as a date range and whatever else is required to generate a data set for the report.
There is a Print button to execute the report.
When the user mouse clicks the Print button, the Progress 4GL logic will accept the input parameters, apply the report logic to produce a data set which is written to a generic report table. i.e. Used for all reports.
The index on the report table is the user login code and the report name. Any previous data is deleted for the user login code running this particular report and the new report data is written to the table.
This works well for complex reports where there is a lot of 'data manipulation' required to generate the report data.
It is at this point I want a Progress 4GL code segment to invoke the Crystal Reports CRViewer and run a pre-defined report. This report has already been designed to read the database generic report table that the application populated. In calling the CRViewer to display the pre-defined report, two parameters need to be passed to successfully extract the correct records from the generic report, the user login code and the report name.
Does this help at all?
PS: This process worked well with Report Builder; it was easy to run the Report Builder viewer from within the Progress 4GL code and pass a number of parameters to the virewer. As I recall I believe there were 9 parameters that could be passed, including the report name and a query string to extract the records from the generic report table for the user login code/report name combination.

Accepted Solution

progressor earned 1000 total points
ID: 24405380
Maybe you find this helpfull:



Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Question has a verified solution.

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

Blockchain technology enhances society similar to the Internet. Its effects are broad, disruptive, and will boost global productivity.
If you try to migrate from Elastix to Issabel, you will face a lot of issues. These problems are inevitable but fortunately, you can fix them. In the guide below, I will explain how I performed the migration while keeping all data and successfully t…
Starting up a Project
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB. How Percona can help Percona can help you determine if Percona Server for MongoDB is the right solution for …

571 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