Sending multiple datasets to a report?

Posted on 2008-10-31
Medium Priority
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.

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

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 750 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 http://www.c-sharpcorner.com/UploadFile/mahesh/MultipleDataSourceReport08232006225431PM/MultipleDataSourceReport.aspx
LVL 101

Assisted Solution

mlmcc earned 750 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

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

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

We all know that functional code is the leg that any good program stands on when it comes right down to it, however, if your program lacks a good user interface your product may not have the appeal needed to keep your customers happy. This issue can…
Performance in games development is paramount: every microsecond counts to be able to do everything in less than 33ms (aiming at 16ms). C# foreach statement is one of the worst performance killers, and here I explain why.
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…
This is my first video review of Microsoft Bookings, I will be doing a part two with a bit more information, but wanted to get this out to you folks.
Suggested Courses
Course of the Month14 days, 20 hours left to enroll

770 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