Solved

Sending multiple datasets to a report?

Posted on 2008-10-31
7
1,297 Views
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!?
0
Comment
Question by:HOVE
  • 3
  • 3
7 Comments
 
LVL 69

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?
0
 

Author Comment

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

Author Comment

by:HOVE
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.
0
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 
LVL 69

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.
0
 

Author Comment

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

Accepted Solution

by:
É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 http://www.c-sharpcorner.com/UploadFile/mahesh/MultipleDataSourceReport08232006225431PM/MultipleDataSourceReport.aspx
0
 
LVL 100

Assisted Solution

by:mlmcc
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.

mlmcc
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
C# TextBox 11 30
Resolve Dependency Issues 4 47
Angular JS Route 3 54
Finally almost got it 5 23
I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
Introduction Although it is an old technology, serial ports are still being used by many hardware manufacturers. If you develop applications in C#, Microsoft .NET framework has SerialPort class to communicate with the serial ports.  I needed to…
Along with being a a promotional video for my three-day Annielytics Dashboard Seminor, this Micro Tutorial is an intro to Google Analytics API data.
Windows 10 is mostly good. However the one thing that annoys me is how many clicks you have to do to dial a VPN connection. You have to go to settings from the start menu, (2 clicks), Network and Internet (1 click), Click VPN (another click) then fi…

867 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

22 Experts available now in Live!

Get 1:1 Help Now