Data from two data sets for a report (.rdlc)

Question

0.00/5 (No votes)

See more:

, +

Hi,
Is there any way to use data from two datasets without innerjoin?
Can we use kind of aggregate expression for it? Could you explain with code example?

Thanks
Furqan

Posted 10-Mar-11 6:16am

Furqan Sehgal

Add a Solution

Comments

milenalukic 10-Mar-11 19:38pm

It would help if you explain better what you would like to do.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Sandeep Mewara · Accepted Answer · 2011-03-10T18:35:00

Is there any way to use data from two datasets without innerjoin?
Why do you need this?

You can define multiple dataset in one report.

Just in case, for a scenario you want to club result set of two dataset then you need to use Inner Join. Or you can also try to use Subreport if it fits in the scenario.

Can we use kind of aggregate expression for it?
I doubt this for a field in table/matrix/list as they have a defined one dataset. Maximum you will be able to use First value of any other dataset, but I am sure that would not be of much use.