You’re offline. This is a read only version of the page.
169
Greetings to all of you.
A customer of mine , asked me if its possible to modify the report 321 ( Vendor - Balance-To-Date ) sorting , fro based on Entry No to based on Posting Date.
I created a new report of mine and copied the code of the standard report.
I did this to the rdlc layout as well ( basically i exported the report 321 layout and import back to my report 50010 ).
After that i went on the code, i searched for the word " Sorting " and changed the values from Entry No to Posting Date. However it doesn't seems to work.
Anyone knows why? Did i have to do something different?
Does the rdlc makes any difference on the report sorting ? Because if it does, i guess that copying the layout of the base report ( id 321 ) is a mistake from my side.
Thank you in advance for your time.
With respect,
Antonis
AntonisK I have used the same filter on details but is doing a wrong sorting. Do you know why ?
it seems that is sorting only the year.
Ok i found what it was. I needed to set the Filter on the Details Properties , not the Tablix Properties.
The filter i used was : CDate(Fields!PostDt_VendLedgEntry3.Value).ToString("yyyy-MMM-dd").
TeddyH Props to you for letting me know that i can sort the reports on the rdlc itself.
Thanks for your reply.
I got the report 321 layout exported, setup the sorting as below , and still it doesnt work. What am i doing wrong?
PrintScreen --> https://prnt.sc/pIPn5QcgUW7w
It's probably safer and easier to do this is on the rdlc side.
Use Custom Report Layouts to export the rdlc layout. Open the rdlc report, click on the table, and change the sorting. Reimport.
No need to do new report.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
290,900
Super User 2024 Season 2
#2
Martin Dráb
229,275
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (