Crystal Report 11 and Progress  4GL

Posted on 2009-04-22
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

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


    Author Comment

    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.
    LVL 4

    Accepted Solution

    Maybe you find this helpfull:



    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    IT, Stop Being Called Into Every Meeting

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Suggested Solutions

    Title # Comments Views Activity
    commonTwo  challenge 63 68
    Copy Oracle database from 11g ( to 12c ( 15 67
    MySQL 11 46
    SQL Update Query 23 64
    Entering time in Microsoft Access can be difficult. An input mask often bothers users more than helping them and won't catch all typing errors. This article shows how to create a textbox for 24-hour time input with full validation politely catching …
    Shadow IT is coming out of the shadows as more businesses are choosing cloud-based applications. It is now a multi-cloud world for most organizations. Simultaneously, most businesses have yet to consolidate with one cloud provider or define an offic…
    In this fifth video of the Xpdf series, we discuss and demonstrate the PDFdetach utility, which is able to list and, more importantly, extract attachments that are embedded in PDF files. It does this via a command line interface, making it suitable …
    In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…

    759 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

    Need Help in Real-Time?

    Connect with top rated Experts

    9 Experts available now in Live!

    Get 1:1 Help Now