Interactive Sorting in Report 121
johanna
Member Posts: 369
Dear all,
I have tried to make interactive sorting for Document No in report 121 and failed.
Could you help me ?
Thank you.
I have tried to make interactive sorting for Document No in report 121 and failed.
Could you help me ?
Thank you.
Best regards,
Johanna
Johanna
0
Answers
-
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ømClaus 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 :-)0 -
Dear clausl,
Wow thanks a lot !!
But, Final Total like below is disappeared in your report
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.25Best regards,
Johanna0 -
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ømClaus 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 :-)0 -
Dear clausl,
You are so great :thumbsup: =D>
Thank you so much for your help..
I am really appreciate it.. Problem is Solved
Best regards,
Johanna0 -
You are welcome

/Claus LundstrømClaus 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 :-)0
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.7K Microsoft Dynamics NAV
- 18.8K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 333 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions