Share
Reporthow to Custom sort by given parameter in ssrs query based report
I Want to add custom sorting in givent account number sequence
You’re offline. This is a read only version of the page.
40
how to Custom sort by given parameter in ssrs query based report
I Want to add custom sorting in givent account number sequence
It's not clear what problem you're dealing with, therefore let me give you a generic answer. Here is an introduction from AX documentation: How to: Use a Report Data Provider Class in a Report.
How different should it be? Why exactly did you reject the solution suggested above?
Yes logically its unsorted, but as per users entry it is sorted, as i already have a store procedure that meets the requirement but the report is non ax, as i want to make a report in ax ... I am copy sharing with you the the SP.
ALTER PROC [dbo].[LoyaltyCardPrint] @Cardno VARCHAR(MAX)
AS DECLARE @vCardno VARCHAR(MAX) = ISNULL(@Cardno,'')
SELECT PAR.NAME,LOC.ADDRESS
,cci.CARDNUMBER,
ISNULL(PH.LOCATOR,'') [Phone]
,ISNULL(EM.LOCATOR,'') Email,SPL.idx
, ct.ACCOUNTNUM SL_LOYALTYACCOUNTNUM
FROM CFZ_CUSTOMERCARDINFORMATION CCI
inner join CUSTTABLE CT
on CCI.ACCOUNTNUM = CT.ACCOUNTNUM
and CCI.DATAAREAID = ct.DATAAREAID
LEFT JOIN DIRPARTYTABLE PAR ON ct.PARTY = PAR.RECID
LEFT JOIN DIRPARTYPOSTALADDRESSVIEW LOC ON PAR.PRIMARYADDRESSLOCATION = LOC.LOCATION and LOC.VALIDTO >= '2154-12-31 23:59:59.000'
LEFT JOIN LOGISTICSELECTRONICADDRESS PH ON PAR.PRIMARYCONTACTPHONE = PH.RECID
LEFT JOIN LOGISTICSELECTRONICADDRESS EM ON PAR.PRIMARYCONTACTEMAIL = EM.RECID
LEFT JOIN dbo.fn_split(dbo.CleanAndTrim(@vCardno),',') SPL ON SPL.value = CCI.CARDNUMBER
WHERE cci.CARDNUMBER IN(SELECT VALUE FROM dbo.fn_split(dbo.CleanAndTrim(@vCardno),','))
ORDER BY SPL.idx
Therefore, As you can see here i am ordering it by user's input via storeprocedure.
SELECT VALUE FROM dbo.fn_split(dbo.CleanAndTrim(@vCardno),','))
ORDER BY SPL.idx
That doesn't look possible to me. The data is not sorted.
As a workaround, you can use an RDP class, put data into a temporary table and add extra field for the order. E.g. when you parse the input list and find that "6" is on the second position, you'll put 2 to the field. When running the report, you'll simply sort by this field.
What do you mean by "custom"?
If something defined as a customization, you can do it in the query definition.
If you mean sorting defined by users before running the report, there is a tab called "Sorting" in the query dialog (the dialog where you can set query ranges).
#1
André Arnaud de Cal...
294,157
Super User 2025 Season 1
#2
Martin Dráb
232,930
Most Valuable Professional
#3
nmaenpaa
101,158
Moderator
All responses (
Answers (
