Post reply

multiple data regions in one report

  • July 30, 2009 at 5:34 pm

    #203409

    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

    #1032809

    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

    #1034486

    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