Sending multiple datasets to a report?

Posted on 2008-10-31
Last Modified: 2010-05-18
I have a report with multiple datasets and I want to know how to send multiple datasets to that report through c# syntax. In earlier versions of Crystal Reports with multiple datasets, you could send one dataset with all the tables from all the datasets and it would work just fine, in VS2008 it doesn't work, he wants me to specify all datasets, but I don't know how to send multiple datasets!?
Question by:HOVE
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
LVL 70

Expert Comment

by:Éric Moreau
ID: 22849671
>>In earlier versions of Crystal Reports with multiple datasets, you could send one dataset with all the tables from all the datasets and it would work just fine, in VS2008 it doesn't work

It is still working for me! Can you show us your code?

And you said that "he wants me to specify...". What tells you that? Any error?

Author Comment

ID: 22849766
It asks for database login information. I am talking about reports converted from VS2003 to VS2008.

Author Comment

ID: 22849982
Reports are using project designed datasets. When I copy all tables from all datasets to just one dataset, it works fine. I don't want to do that, there must be another way, there must be a way to send more datasets to report.

I tried to send "DataSet[] ds" to "CrystalDecisions.CrystalReports.Engine.ReportDocument.SetDataSource(IEnumerable enumerable)" with no results, he won't bind send datasets to corresponding datasets on report, he always asks for database login credentials.
Online Training Solution

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.

LVL 70

Expert Comment

by:Éric Moreau
ID: 22850028
I never tried to send more then one dataset, and never found anything in the SetDataSource that let me thinks that you can send more then one.

Author Comment

ID: 22850059
But why does Crystal Report then lets you specify more than one DataSet on the report?
LVL 70

Accepted Solution

Éric Moreau earned 250 total points
ID: 22850086
A quick googling convinced me that a report can only have a single source of data.

But if you have sub-reports, each one can have its own datasource has explained in
LVL 100

Assisted Solution

mlmcc earned 250 total points
ID: 22851436
Agree.  Crystal is designed to use a single data source for a report.  There are instances where it will work but Crystal doesn't support it.

I am surprised since the VS2003 and VS2008 versions of Crystal are based on CR10 that if it worked before that it still doesn't work.


Featured Post

Salesforce Made Easy to Use

On-screen guidance at the moment of need enables you & your employees to focus on the core, you can now boost your adoption rates swiftly and simply with one easy tool.

Question has a verified solution.

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

Suggested Solutions

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…
It was really hard time for me to get the understanding of Delegates in C#. I went through many websites and articles but I found them very clumsy. After going through those sites, I noted down the points in a easy way so here I am sharing that unde…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an antispam), the admini…

734 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