Report Portal

ReportPortal
ReportPortal
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
 Password:
Save Password
Forgot your Password?

 All Forums
 ReportPortal General Forum
 Report Portal General Issues
 Order by field issue		  New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

SvKN

9 Posts
Posted - 08/18/2015 :  01:10:03  Show Profile  Reply with Quote
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?

admin

1635 Posts
Posted - 08/18/2015 :  01:19:22  Show Profile  Reply with Quote
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
Go to Top of Page

admin

1635 Posts
Posted - 08/18/2015 :  01:20:58  Show Profile  Reply with Quote
You can reset ordering by clicking on the column again. The column order toggles between: descending, ascending, none.
Go to Top of Page

SvKN

9 Posts
Posted - 08/18/2015 :  03:48:09  Show Profile  Reply with Quote

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
Go to Top of Page

admin

1635 Posts
Posted - 08/18/2015 :  21:35:02  Show Profile  Reply with Quote
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"
Go to Top of Page

SvKN

9 Posts
Posted - 08/18/2015 :  22:43:48  Show Profile  Reply with Quote
Thank you for this fix.
But I'm on 188 build Net4 yet. Is it possible to generate it for 188?
Go to Top of Page

admin

1635 Posts
Posted - 08/19/2015 :  01:12:18  Show Profile  Reply with Quote
Only if you have an active maintenance agreement.

As a workaround, you can disable sorting by enabling "Multi Result" option.
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
ReportPortal © 2000-2002 Snitz Communications Go To Top Of Page