MS SQL Server Reporting Services - Does RS allow querying between tables?

Author

Does RS allow querying between tables?

DCount17

2005-03-31, 8:03 pm

I have a very complex query that needs to return monthly and year-to-date
data. I'm using one table (table A) to correctly return the monthly data. I
would now like to create another table and use a result from table A to
correctly filter and display the year-to-date data along side the monthly
data.

Does RS allow querying between tables?

Example of desired results
Account July 2004 Year-to-Date
Ace hardware $3000.00 $8452.21

--
DCount

Timm

2005-03-31, 8:03 pm

You can't really use table A to display results into a different table. But
what you may want to try is to use the same dataset used in table A to create
a new table B and then on table B goto the properties of the table and then
goto the filters entry there and apply the filters you want to the table.
That should get you the results you're looking for.

> I have a very complex query that needs to return monthly and year-to-date
> data. I'm using one table (table A) to correctly return the monthly data. I
> would now like to create another table and use a result from table A to
> correctly filter and display the year-to-date data along side the monthly
> data.
>
> Does RS allow querying between tables?
>
> Example of desired results
> Account July 2004 Year-to-Date
> Ace hardware $3000.00 $8452.21
>
>
> --
> DCount

Sponsored Links