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 charts with multiple dimensions
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

WildCard

89 Posts

Posted - 03/08/2017 :  07:18:49  Show Profile  Reply with Quote
Hi,

how can I create a line chart in SQL reports that has for instance years on X-axis with a measure like 'number of orders' on Y-axis and separate lines for the members of a second dimension like suppliers? In OLAP reports I can do that by simply dragging the suppliers in the lines, the years in the columns and number of orders in the measures. But is there a way to achieve that in SQL reports?

admin

1635 Posts

Posted - 03/08/2017 :  11:57:58  Show Profile  Reply with Quote
Which database do you use (SQL Server, Oracle, MySQL)?

In SQL Server you can use the PIVOT function to transform the data from rows to columns:
http://stackoverflow.com/questions/15745042/efficiently-convert-rows-to-columns-in-sql-server
http://stackoverflow.com/questions/2421721/pivoting-on-a-column-without-knowing-the-entire-list-of-values

You can also try using the ROLAP report.
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