How to display multiple result set in Crystal Report

Posted on 2006-04-27
Last Modified: 2008-03-10
I'm running report in Crsytal report ( through stored procedure)
My stored procedure returns two result set ( two different set of data by means of diff select  query)

How do i capture and display two result set in my report.

Please note that two result set doesn't have same number of columns ( otherwise i could have use union )

Please respond , if you any idea to implement this.

Shakir Jamali
Question by:shakir77
    LVL 100

    Accepted Solution

    What version of Crystal?

    Most versions canot handle a stored procedure like that.  They expect a single result set.

    LVL 2

    Author Comment

    Yes, got to know that , its not going to work with multiple result set.
    Break down my multiple selects in different sprocs.

    Shakir Jamali

    Featured Post

    Maximize Your Threat Intelligence Reporting

    Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

    Join & Write a Comment

    Suggested Solutions

    1. Set up your parameter at the report level as usual, check the box Multi-value, and set the Data Type to String 2. Set the Stored Procedure Parameter to varchar(max)  --<---- This part here is the key to it's success Example:    @cst_key var…
    Hello, In my precious Article  ( saw the Configuration part for Microstrategy which included Metadata Creation and DataSource Preparation as …
    In this sixth video of the Xpdf series, we discuss and demonstrate the PDFtoPNG utility, which converts a multi-page PDF file to separate color, grayscale, or monochrome PNG files, creating one PNG file for each page in the PDF. It does this via a c…
    This video discusses moving either the default database or any database to a new volume.

    745 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

    15 Experts available now in Live!

    Get 1:1 Help Now