SSRS report parameter display order

(0) Share

Report

Posted on by Hariharans87

Hi All,

I have created three parameters (Sort by, From date, To date) on the SSRS report. Three parameters are coming correct on the AX report dialog box. The problem is the parameters displaying order is not coming correctly. Coming in this order (Fromdate, Sort by and To date).

If i run this report through internet explorer in the reporting service url, the parameter order is coming correctly.

Any idea to fix this issue?

Thanks,

Hari

*This post is locked for comments

I have the same question (0)

All responses (7)

Answers (1)

Pir_Rana 836 on at

Like (0)

Report

Check in SSRS report designer (Visual Studio), the order that you want is correct or not.

sometime this issue occur due to this.

Was this reply helpful? Yes No
Hariharans87 3 on at

Like (0)

Report

Thanks for your reply.

The order (one by one) is correct in the report parameter section and report designer report data window parameter section also. Is there any property for order the parameter?

Was this reply helpful? Yes No
Pir_Rana 836 on at

Like (0)

Report

Have you use RDP class to make SSRS? if yes the you can give parameter order in contract class.

Was this reply helpful? Yes No
Suggested answer

Darsh 615 on at

Like (2)

Report

If you are using Report Data provider then add below code to you contract class on parameter

SysOperationDisplayOrderAttribute("2")

Was this reply helpful? Yes No
Hariharans87 3 on at

Like (0)

Report

Thanks guys.

I am not using RDP class. Directly calling AOT query as datasource on the SSRS report.

Was this reply helpful? Yes No
Verified answer

Hariharans87 3 on at

Like (0)

Report

Hi All,

Finally, i found the solution.

I have change the parameter name by order like below

1. TES_1_SortBy

2. TES_2_FromDate

3. TES_3_ToDate

It is working fine now.

Thanks,

Hari

Was this reply helpful? Yes No
AxaptaAmarSingh 40 on at

Like (0)

Report

Thanks , that worked for me

Was this reply helpful? Yes No