How to display multiple result set in Crystal Report

Posted on 2006-04-27
Medium Priority
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 101

Accepted Solution

mlmcc earned 250 total points
ID: 16726489
What version of Crystal?

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


Author Comment

ID: 16746859
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

Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

Question has a verified solution.

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

Hi, I am very much excited today since I'm going to share something very exciting Tool used for Analytical Reporting and that's nothing but MICROSTRATEGY. Actually there are lot of other tools available in the market for Reporting Such as Co…
Jaspersoft Studio is a plugin for Eclipse that lets you create reports from a datasource.  In this article, we'll go over creating a report from a default template and setting up a datasource that connects to your database.
This Micro Tutorial will teach you how to add a cinematic look to any film or video out there. There are very few simple steps that you will follow to do so. This will be demonstrated using Adobe Premiere Pro CS6.
Are you ready to place your question in front of subject-matter experts for more timely responses? With the release of Priority Question, Premium Members, Team Accounts and Qualified Experts can now identify the emergent level of their issue, signal…
Suggested Courses

840 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