Hi,As a Beginner of birt report .i dont have much knowledge to do report so i have attached a image for u r reference i.e in top i have parameter with check-box to compare year by clicking each option..
if i click over All of checkbox it have to display line by comparing a year for all data
if i click over classic car of checkbox it have to display line by comparing a year and it have to differentiate year by color too
like wise for all checkbox..
kindly help by providing a sample db its useful to do my report
One way would be to create all of the combinations of charts and hide/show the appropriate one based on the check boxes. You could also use SVG charts to achieve something like that or a drill through to the report to create the correct chart.
i have attached a report for u r reference which i had tried today....but in some case am struggling a lot...
am having two requirement:
1)one is by general report parameter to show line chart
2)and other one is when button click
for instance a if i click button (trend)it show a three checkbox
from this we can select by any combination
if i click a classic car it show by a line chart by two series(like 2003,2004)
if i click a Train it show by a line chart by two series(like 2003,2004)
and legend label is too change by checkbox...
which i have post previous image ..
kindly provide sample db...
thank in advance....
first of all very very thank for u r effort....its near by my need.i have attached a report and image for u r reference .again..which i edited slightly for my need
i will explain u clear the one function is missing in that only am struggled alot
am having a two condition like: 1)In this report while i select of year parameter it will show a data between a year by line chart 2)other thing is with in report html button is show three check box
when click on check box of classic car it have to display a two Y-SERIES LIKE if i select year (2003-2004)the chart must be like (2003) is in light clour and (2004) is in dark color(dont confuse this report is like a compare year by line chart when click of check box only) again if click of plane check box it have to display a two Y-SERIES LIKE (2003) and (2004) and then legend name to be change of clicking of check box like classic car (2003 is in dark color),classic car (2004 is in dark color)
kindly provide sample db
thank u in advance
Hopefully this is closer. I'm not sure I'm understanding your image since you're talking about fiscal years. This shows each year of the fiscal year broken into different colors. Let me know if I'm not understanding still.
Thank ...yes u r correct Michael Williams.... if u look at a screenshot they had a some bill,sale,aspd,.and checkbox .etc...according to that it have to drop so if we drop by that legend and tool tips also have to change by that....kindly include a tool tip and legend change according to it....kindly provide sample db
With all of these variations, you'll end up with lots of different charts to show/hide. Is doing a drill through okay with you? It will re-run the report each time, but you won't have to create a million different charts. Let me know.
You can still have the output like what is shown in your image, you would just reload the report each time vs creating multiple charts and hiding/showing the appropriate one. Let me know if re-loading the report when new choices are made will work or not.
Is it possible to proivide sample db....and one thing is actually we already spoke about fiscal year...its not a fiscal year.its normal year ..it mean that our financial year start up at (APRIL-2011) and end Up by (MARCH-2012) calculating for one year so if we select (2011-2012) it have to compare a year of (2010-2011) according to screeshot...and then legend have to change by drop parameter(SHOWBY) like Classic Car of BUY-last year and Classic Car of BUY-this year..and tooltip also present...if u seen screenshot u wil understood clearly....
i have attached report which i have tried kindly correct the report..
I know we already talked about the fiscal year. I understand that part. I showed you how you can hide/show different charts based on client-side script. Adding another set of check boxes for a different feature doesn't change how this is done, it just adds more charts. Here is a design where the year is done how you're expecting. If you do a drill through, you'll just need to pass the selected check box values back to the report via url to report parameters and use them to create the appropriate chart. If you'd like a drill through example, let me know.
Thank for reply and effort.its helpful but tooltip is missing over on it..Yes it contain many chart.so if u consider a drill through is easy approach.for this report i wil follow that way..kindly provide ..i will look and work on it...
once again thank for a u r effort and patience
Try this report. In the text box at the top of the report, you'll need to switch out the "baseURL" to whatever the base URL is when you first run the report. The current value is what it is when I run the report from my designer. Hope this helps.
Sir i have issue with performance while running the report......i will send u the link by mail.(email@example.com,firstname.lastname@example.org).. u just look on country,zone,state all are cascading parameter...its loading for a long time.......i dono ..wt happens...kindly look on it...report too........i have index the query but also it take a long time...is there possible to debug the report by printing some message ...