Jump to content
We've recently updated our Privacy Statement, available here ×

rmjrao

Members
  • Posts

    12
  • Joined

  • Last visited

 Content Type 

Profiles

Forum

Events

Featured Visualizations

Knowledge Base

Documentation (PDF Downloads)

Blog

Documentation (Test Area)

Documentation

Dr. Jaspersoft Webinar Series

Downloads

Posts posted by rmjrao

  1. I have a report with 4 different charts. all the charts refer to one table of different columns, For example,
    Table: Employee
    columns: id, name, workingdays, leaves, performance,  salary, .....
    chart1 refers 'workingdays' column
    chart2 refers 'leaves' column
    chart3 refers 'performance' column
    chart4 refers 'salary' column

    Scenario1: Created 4 datasets and each data set refer to one chart.
    Scenario2: Created 1 dataset by selecting all columns and use same dataset for all charts

    Questing: which scenario will give best perforamance?

    is Jaspersoft cache the dataset results and apply for all charts(query executes only one time) or execute the Query before rendring the each chart(Query executes 4times)?

    Currently i am doing this test and will post the results soon.  But if any one knows execution plan that will help me to understand better.

     

    Thanks,

    Rmjrao.

  2. I have a requirement to generate a employees perforamnce report using ireportdesigner.

    For example, i have an employees table and want to generate pie chart for defects(sev1,sev2,sev3) that he/she fixed in a quarter for each employee.

    something like below,

      Query1=  select employeeId from employees;

     Query2 = select employeeId, count(sev1),count(sev2),count(sev3) from employeedetail where employeeid= {employeeid from query1}  group by employeeid;

    for each employee {

          generate pie chart;

    }

    Finally my report should have : employee1 name and pie chart, employee2 name and pie chart,employee2 name and pie chart .......................

    Any suggestions?

    Thanks,

    Rmjrao.

  3. ok cool. Thanks for quick response. If this is the case then i need to set y-axis data range same for both the charts. What i mean is if chart one shows y-axis data like 1-100-200-300..... and other chart shows 1-5-10-15-..., if i hide the second chart y-axis then graph will not convey the what we want.

    Is there any way to set the same data points for both the charts?

     

    Thanks,

    Rmjrao.

  4. I am creating multi Axis chart with Stackedarea chart and Line chart in iReportDesigner. I am able to generate the report by setting appropriate properties.

    Now i want to display only one y-Axis for both the charts instead of two y-Axis. how can i do this?

    I appriciate any help.

    Thanks,

    Rmjrao

     

×
×
  • Create New...