| 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
|
Report Portal
