July 30, 2009 at 5:34 pm
Hi All,
I have the following situation
i have to create a report using SSRS that looks something like this:
ProdName Price Quantity
P1 100 10
P2 90 11
P3 80 9
---------------------------------
ProdName Price Quantity
P1 90 11
P2 100 10
P3 80 9
On the top of the page, i have to see ProdName,Price,Quantity ordered by Price and in the bottom i
have to see this ordered by Quantity.
How can this be done in SSRS. All the data is coming from one datasource(table).
This is what i am currently doing.
I created two datasets, dset1 which will give ProdName,Price,Quantity ordered by Price
I used a table and simply used feilds from dset1.
Then i created dset2 which will give ProdName,Price,Quantity ordered by Quantity. Again used a table underneath the top table, but when i drag the fields from dset2 it's becoming
sum(feilds!feildname,"dset2"), and i get all the detail rows for second table with the same sum.
Please advice.
Thanks,
Sam
July 31, 2009 at 1:24 am
I'm not sure I fully understand, but if you're trying to use the same dataset in two different table only sorted differently can you not just open the properties dialog for each of your tables and specify the sorting of your dataset in there.
August 4, 2009 at 1:06 pm
yes that helps,
also i found out how to associate a data set to a data region
in other forum aswell.
Thankyou Paul
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply