Click here to Skip to main content
13,147,344 members (28,628 online)
Rate this:
 
Please Sign up or sign in to vote.
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
Comments
milenalukic 10-Mar-11 19:38pm
   
It would help if you explain better what you would like to do.

1 solution

Rate this: bad
 
good
Please Sign up or sign in to vote.

Solution 1

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

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

  Print Answers RSS
Top Experts
Last 24hrsThis month


Advertise | Privacy |
Web01 | 2.8.170915.1 | Last Updated 11 Mar 2011
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100