locked
drill down on Row and Header, with Freeze Header RRS feed

  • Question

  • Hi,

    I am looking to do the following in Silverlight:

    - Freeze Column's Header
    - Freeze Column(s)
    - Drill down on Column Header
    - Drill down on Row

    I know there are 3rd party tools that have a Reporting Viewer, however it does not support Freezing on header. So I cannot choose this option.

    Also the DataGrid does not support drill on the header.

    I am thinking I may need to build myself a customer control, but I have no idea what to do, i.e. many textblocks and canvas etc.

    An attached example of the report is here:
    http://www.telerik.com/ClientsFiles/255701_DrillExample.png

    Any help is appreciated and please let me know any idea if its possible to do so.

    Many thanks.

    Monday, March 14, 2011 4:32 AM

Answers

All replies

  • Hi,

    Silverlight DataGrid meets your first, sencond and forth requirements.

    1 it is implemeneted by default.

    2 You can set FrozenColumnCount

    4 Bind DataGrid to a PagedCollectionView

    As for the third one, you may consider to add some buttons or Rectangles at top of DataGrid. Calculate the width and span column number of different level header. Then add them at run time.

     

    Hope this helps

    Friday, March 18, 2011 4:37 AM
  • Thanks for your reply.

    As shown in the example of the report (the .png url).
    I have both QTY and AMT as rows.

    I need too calculate the subtotal for each grouped row, i.e subtotal for QTY and AMT for Region (in the example).

    How will you handle this case?

    Many thanks.

    Monday, March 21, 2011 3:55 AM
  • Hi,

    You can try to customize the RowGroupHeadersStyle of DataGrid and add an extra column there.

    Calculate the subtotal for each group and stored in for example viewmodel, then bind it in xaml.

    http://forums.silverlight.net/forums/t/119135.aspx

     

    Hope this helps

    Thursday, March 24, 2011 4:59 AM