ReportPortal: Zero-footprint OLAP client for Microsoft Analysis Services

ReportPortal

All Forums

ReportPortal General Forum

Report Portal General Issues

SQL report. Empty result

Note: You must be registered in order to post a reply.
To register, click here. Registration is FREE!

Screensize:

UserName:

Password:

Anti-Spam Code:

Message:

* HTML is ON
* Forum Code is OFF

Smilies

Check here to include your profile signature.
Check here to subscribe to this topic.

. Tried to get only column with Name (no html), but result is the same

T O P I C R E V I E W
SvKN	Posted - 06/25/2015 : 00:08:16 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
8 L A T E S T R E P L I E S (Newest First)
SvKN	Posted - 06/26/2015 : 02:29:26 wow "No Paging" works! thanks! =)
SvKN	Posted - 06/26/2015 : 02:21:36 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.
admin	Posted - 06/26/2015 : 02:16:24 Please try to reset paging. In SQL report design mode click the paging toolbar button and press "No Paging" button.
SvKN	Posted - 06/26/2015 : 01:57:23 Data is not retrieved (tbody)(/tbody). Tried to get only column with Name (no html), but result is the same
SvKN	Posted - 06/26/2015 : 01:54:20 Data is not retrieved
admin	Posted - 06/26/2015 : 00:20:50 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?
SvKN	Posted - 06/25/2015 : 23:17:48 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
admin	Posted - 06/25/2015 : 21:25:35 Please go to Admin > Connections and select the connection used by the SQL report. What it the Type, Database Type and Connections String?

ReportPortal