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 . Tried to get only column with Name (no html), but result is the same |
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?
|