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
 SQL report. Empty result		  New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

SvKN

9 Posts
Posted - 06/25/2015 :  00:08:16  Show Profile  Reply with Quote
Hi
I have a view on the SQL server. I get two records on the "SQL server management studio" by "select * from view" and get nothing on the Report portal using the same script. There are no any errors.
I'm confused...
Please help. Thx

admin

1637 Posts
Posted - 06/25/2015 :  21:25:35  Show Profile  Reply with Quote
Please go to Admin > Connections and select the connection used by the SQL report. What it the Type, Database Type and Connections String?
Go to Top of Page

SvKN

9 Posts
Posted - 06/25/2015 :  23:17:48  Show Profile  Reply with Quote
This is the standart connection that used by 20 reports already without any problem. This is the MS SQL server 2012 DB running on the same instance as ReportPortal DB. Settings were: Type-SQL OLEDB, DB_Type-SQL server 2000. I changed it to: Type - SQL Server, DB_Type-SQL Server 2005 and up, but no luck... The connection string generated automatically: Data Source=bla-bla\bla-bla;Initial Catalog=Dashboard;User ID=svc_dashboard;Password=********;
any suggestions
Go to Top of Page

admin

1637 Posts
Posted - 06/26/2015 :  00:20:50  Show Profile  Reply with Quote
One possibility is that one of the fields returns HTML that breaks the result table HTML. Can see the results when selecting one column like "select NumberCol1 from view"?

Please right click to where the result table should be and select "view frame source" or "view source: (in IE). What is the HTML?
Go to Top of Page

SvKN

9 Posts

 . Tried to get only column with Name (no html), but result is the same
Posted - 06/26/2015 :  01:54:20  Show Profile  Reply with Quote
Data is not retrieved
Go to Top of Page

SvKN

9 Posts
Posted - 06/26/2015 :  01:57:23  Show Profile  Reply with Quote
Data is not retrieved (tbody)(/tbody). Tried to get only column with Name (no html), but result is the same
Go to Top of Page

admin

1637 Posts
Posted - 06/26/2015 :  02:16:24  Show Profile  Reply with Quote
Please try to reset paging. In SQL report design mode click the paging toolbar button and press "No Paging" button.
Go to Top of Page

SvKN

9 Posts
Posted - 06/26/2015 :  02:21:36  Show Profile  Reply with Quote
And one additional super strangest thing. If I create new SQL report and press the test button before save it works fine! But after save I press the test button again and get nothing.
Go to Top of Page

SvKN

9 Posts
Posted - 06/26/2015 :  02:29:26  Show Profile  Reply with Quote
wow "No Paging" works! thanks! =)
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