Lookup column / combining two datasets

I need to display a values from the another dataset. E.g. I have a SQL
database with employees details and that is dataset 1; but employees salaries
are stored in Excel spreadsheet and that is dataset 2.
The question is how can I display a list of employees along with their
slaries?
Thanks
JacekIf it were me, I'd work to get that Excel spreadsheet data converted
into a SQL table (I'd use DTS or SSIS to move the data). Once that's
done you can write a query that joins your detail table to your new
salary table. You would then use the results of that query for your
dataset.
HTH
toolman
Jacek wrote:
> I need to display a values from the another dataset. E.g. I have a SQL
> database with employees details and that is dataset 1; but employees salaries
> are stored in Excel spreadsheet and that is dataset 2.
> The question is how can I display a list of employees along with their
> slaries?
> Thanks
> Jacek|||And that's exactly what I had to do.
But in general: is there a way to join two datasets in SSRS? It does not
seem so ...
"toolman" wrote:
> If it were me, I'd work to get that Excel spreadsheet data converted
> into a SQL table (I'd use DTS or SSIS to move the data). Once that's
> done you can write a query that joins your detail table to your new
> salary table. You would then use the results of that query for your
> dataset.
> HTH
> toolman|||Not within a single data region like a table or matrix, etc. It's not
proven to be much of a problem for us because we always try to do as
much in SQL as we can before starting report development. Our ideal
situation is to create a single dataset with a SQL stored proc and then
simply drag and drop fields into a table.
Hang in there
toolman
Jacek wrote:
> And that's exactly what I had to do.
> But in general: is there a way to join two datasets in SSRS? It does not
> seem so ...
> "toolman" wrote:
> > If it were me, I'd work to get that Excel spreadsheet data converted
> > into a SQL table (I'd use DTS or SSIS to move the data). Once that's
> > done you can write a query that joins your detail table to your new
> > salary table. You would then use the results of that query for your
> > dataset.
> > HTH
> > toolman