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
 KPI with SQL Report
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

rbarrientos

El Salvador
29 Posts

Posted - 10/29/2007 :  10:46:46  Show Profile  Reply with Quote
I have some SQL Reports from my Production Server, they are some indicators from KEY Entry task, I want show it from KPI, I'm sure that I have DATA in this Reports but the KPI DON'T SHOW nothing.
With OLAP Report this work all OK. Some Help..

Informar significa descubrir necesidades y crear oportunidades para El Salvador

admin

1635 Posts

Posted - 10/30/2007 :  09:26:44  Show Profile  Reply with Quote
KPI Report treats SQL reports differently form OLAP reports. For an OLAP report, the column position is the position for the cell data. For the SQL report, the column position relative to the entire grid. The reason for this is that SQL report does not have a row header. Please try to change the column position and try again.

If you still have the problem, please send details to support@ReportPortal.com
Go to Top of Page

WildCard

89 Posts

Posted - 04/13/2016 :  04:27:54  Show Profile  Reply with Quote
I'm having the same issue. How can I identify the number of the target column in the sql report?
Go to Top of Page

admin

1635 Posts

Posted - 04/13/2016 :  19:43:01  Show Profile  Reply with Quote
Suppose you have a table with data like:

















Emp_id Name Age
1 Kevin 37
2 Mary 23


Row: 1, Column: 3 will give you 37 and Row: 2, Column: 3 will give you 23.


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