rdp9090

So far, I've managed to do a proper drilldown that takes the text fields representing each section of the bars and clicking on those hyperlinks would display the proper tasks. However, I tried doing the same thing on the chart and no matter where I click on the chart, it only displays the 4 tasks in the last project (streamlining). What am I doing wrong with this? How do I make each section of the chart a separate link?

I'm having trouble displaying the correct dates on the variable expression I set. On 1 variable, I have the expression which correctly displays the current date, and on another variable, which correctly displays the date 7 days ago. However, when I try The date goes up into 07/19, which is 20 days forward rather than 30 days backwards. Could anyone explain why this occurs, and how I could get the correct date out of this?

My report currently generates a stacked bar graph, where it lists every project in the database (each associated with a project_type), and the bars represent the number of tasks for the project in each status (To Verify, To Do, In Progress). I would like to add a function for users in Jasperreports Server to filter which projects they want to see using a checkbox or list to select the project_type for which they want to see data for. I tried using a multi select query input control as I searched online, but the examples used simpler queries and I was unable to apply the same concept to my own report. My query for the report currently looks like How should the query for the input control and the parameter be set up in this case?