preeti1987060 Posted October 28, 2013 Share Posted October 28, 2013 Hi,Requirement :Have a table and chart.Need to implement top 5 only on chart(here its chart pro and html5 charts) in ireport designerIs separate data set only way to implement or there is any other way ?If so kindly provide steps.Thanks in advance. Link to comment Share on other sites More sharing options...
ajinkya_c Posted October 28, 2013 Share Posted October 28, 2013 Hi,You can make a query which shows top 5 for the your measures by using functions like Rank in query.You can use both chart and table with same datasource but some time it may not in sync becouse table shows as is data fetch by query and chart grouped internally as per series and categary expression.So I prefer to use separate datasource for both chart and table.ThanksAjinkya Link to comment Share on other sites More sharing options...
preeti1987060 Posted October 28, 2013 Author Share Posted October 28, 2013 Tried the separate data set with rank in sql query but when a parameter is set on this chart and a value is passed from main report query to the chart it throws error Link to comment Share on other sites More sharing options...
ajinkya_c Posted October 30, 2013 Share Posted October 30, 2013 What is that error? Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now