You’re offline. This is a read only version of the page.
1,534
hi dear , i have very basic query regarding sorting of ssrs report, i want to sort out report data at date wise, for this i just sort date column ,but it show me the result like that,first it show me sorting of invoiced, and then opening, but i want to sort out the record date wise either it is invoiced or open.so how to achive this?
thanks in advance.!
*This post is locked for comments
if you want to remove grouping its your decision
you can modify queries from the class which I mentioned earlier.
remove all groupings etc. also remove any grouping if there is any on SSRS design level.
but overall it will destroy the purpose of external account statement, you better go for a customized report in this case. up to your choice.
of course, this is because of BUSINESS Reason
Customer External Account statement means a statement which you are going to present to customer, which you are going to send externally.
so if you are giving me statement of April-2015, you should also show me 'Balance brought forward' from March-2015 and then show me transactions from April
you may have a look to figure it out from createBaseCustTransQuery(method) of CustAccountStatementExtController(class)
you may also have to fix sorting in some other query build methods, which are available in same class (CustAccountStatementExtController)
If the field is not in the date format then sorting won't work. Please use expression in the soring field like "=Format(Now(), "MM/dd/yyyy")"
Go to group properties and add the date field in the sorting section. You can also remove already added fields in the sorting section if you need.
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...
291,240
Super User 2024 Season 2
#2
Martin Dráb
230,149
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (