T O P I C R E V I E W |
SvKN |
Posted - 08/18/2015 : 01:10:03 Hi I facing a problem in the SQL report. If I press to some field name it causes an error. "Order by" was changed in the middle of the script... How to fix it? To reproduce this issue I wrote this little sql (just press to "rn"): select ROW_NUMBER () OVER (ORDER BY field ASC) rn from ( select 1 as field union all select 2 ) as x
And one more question. How to reset ordering that was applied by pressing to the field? |
6 L A T E S T R E P L I E S (Newest First) |
admin |
Posted - 08/19/2015 : 01:12:18 Only if you have an active maintenance agreement.
As a workaround, you can disable sorting by enabling "Multi Result" option. |
SvKN |
Posted - 08/18/2015 : 22:43:48 Thank you for this fix. But I'm on 188 build Net4 yet. Is it possible to generate it for 188? |
admin |
Posted - 08/18/2015 : 21:35:02 Thank you for finding this bug. Please try this fix for build 190:
1. Download and unzip: http://www.reportportal.com/download/rp_190_dll_sql_order_by.zip (for .net 2.0) http://www.reportportal.com/download/rp_190_net4_dll_sql_order_by.zip (for .net 4.0)
2. Copy the unzipped file to: "C:\inetpub\wwwroot\ReportPortal(_190)\bin\ReportPortal.dll" |
SvKN |
Posted - 08/18/2015 : 03:48:09 It is impossible to press on the field because there are no fields. Report is failed. I see error message only: "Incorrect syntax near 'ASC'..." I found only one way to overwrite ordering. Edit and Save report.
Suppress does not helps.
You can see this on your portal: http://www.reportportal.us/reportportal/Proxy.aspx?reportId=1469
One more thing... I press the field and it cause the crush . It affects not only me but all users |
admin |
Posted - 08/18/2015 : 01:20:58 You can reset ordering by clicking on the column again. The column order toggles between: descending, ascending, none. |
admin |
Posted - 08/18/2015 : 01:19:22 Please try to suppress the modification of the ORDER BY clause by putting a comment in front of the SQL like:
/*My Comment*/ select ROW_NUMBER () OVER (ORDER BY field ASC) rn from ( select 1 as field union all select 2 ) as x
|