Interactive Sorting in Report 121

johannajohanna Member Posts: 369
edited 2013-06-11 in NAV Three Tier
Dear all,

I have tried to make interactive sorting for Document No in report 121 and failed.
Could you help me ?
Thank you.
Best regards,

Johanna

Answers

  • clauslclausl Member Posts: 455
    Report 121 has to be modified slightly for Interactive Sorting to work in this report.

    To help you out I have added Interactive Sorting to the columns OriginalAmt and EntryNo in this report.

    You can find the modified report 121 here at my SkyDrive: http://sdrv.ms/11PukL1.

    1. I have moved 5 rows down to an adjacent Group1 below from above Table1_Details_Group, so these rows does not also sort when I interactively change sorting.
    2. And then I have added Interactive Sorting on Text box: OriginalAmtCaption and Text box: CustLedgEntry3EntryNoCaption

    /Claus Lundstrøm
    Claus Lundstrøm | MVP | Senior Product Manager | Continia.com
    I'm blogging here:http://mibuso.com/blogs/clausl and used to blog here: http://blogs.msdn.com/nav
    I'm also offering RDLC Report Training, ping me if you are interested. Thanks to the 700 NAV developers that have now already been at my training. You know you can always call if you have any RDLC report issues :-)
  • johannajohanna Member Posts: 369
    Dear clausl,

    Wow thanks a lot !!
    But, Final Total like below is disappeared in your report :D
    Total CZK 68,066.58
    Total EUR 22,565.77
    Total ISK 334,624.04
    Total NOK 134,945.03
    Total SEK 9,123.91
    Total USD 401,291.25
    Best regards,

    Johanna
  • clauslclausl Member Posts: 455
    Solved, I removed the grouping on the new Group1 to get the rows to behave as details again.

    New version "REP 121 modified with Interactive Sorting v.1.01" found at my SkyDrive: http://sdrv.ms/11PukL1

    Notice that I only did the Interactive Sorting on the top Tablix, so you will need to work a little your self to get this working in the bottom Tablix, but it should be close to copy and paste :)

    If you belive the Interactive Sorting is solved I suggest to mark this tread solved.

    /Claus Lundstrøm
    Claus Lundstrøm | MVP | Senior Product Manager | Continia.com
    I'm blogging here:http://mibuso.com/blogs/clausl and used to blog here: http://blogs.msdn.com/nav
    I'm also offering RDLC Report Training, ping me if you are interested. Thanks to the 700 NAV developers that have now already been at my training. You know you can always call if you have any RDLC report issues :-)
  • johannajohanna Member Posts: 369
    Dear clausl,

    You are so great :thumbsup: =D>
    Thank you so much for your help..
    I am really appreciate it.. Problem is Solved :D
    Best regards,

    Johanna
  • clauslclausl Member Posts: 455
    You are welcome :D

    /Claus Lundstrøm
    Claus Lundstrøm | MVP | Senior Product Manager | Continia.com
    I'm blogging here:http://mibuso.com/blogs/clausl and used to blog here: http://blogs.msdn.com/nav
    I'm also offering RDLC Report Training, ping me if you are interested. Thanks to the 700 NAV developers that have now already been at my training. You know you can always call if you have any RDLC report issues :-)
Sign In or Register to comment.