Create Master Detail Report

  • User reqirement is

    like

    groupfieldval1

    field1 field2

    val1 val2

    groupfieldval2

    field1 field2

    val1 val2

    This is possible in business object reporting tool but i don't know it is possible in SSRS2008. I have tried but could not achive this since am getting field name single time before group field.

    please help me any one done the same in SSRS2008.

  • If you expect an answer, you should do better than that Mr Raja.

    - Arjun

    https://sqlroadie.com/

  • Ok I will try to give the example

    I have a data like below

    Pcategory Productname unitprice

    xxxx pppp 10

    yyyy qqqq 20

    xxxx pppp 30

    xxxx zzzz 10

    my report should be like below

    xxxx

    Productname unitprice

    pppp 50

    zzzz 10

    yyyy

    Productname unitprice

    qqqq 20

  • Do you need this row-wise?

    By 'this' I mean

    xxxx

    Productname unitprice

    pppp 50

    zzzz 10

    yyyy

    Productname unitprice

    qqqq 20

    If you need it column-wise, you can simply add a group by in your table or matrix. And it will be rendered as expandable/collapsible groups.

    - arjun

    https://sqlroadie.com/

  • Arjun,

    I understand, adding group in my table but in SSRS, In this exampl if you add group based on category then you will get the output like below

    ProductName Price

    xxxx

    pppp 50

    zzzz 10

    yyyy

    qqqq 20

    but I need to display like

    xxxx

    ProductName Price

    pppp 50

    zzzz 10

    yyyy

    ProductName Price

    zzzz 20

  • Ok, i see. Let me check around. But i think it won't be possible straightaway.

    - arjun

    https://sqlroadie.com/

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply