shk_1

Hi, I'm using Jasper studio 10, and have a table component in the Summary Band. In my SQL query, I have some GROUP BY and now groups are created in jasper studio. I've been able to display the data and group them by Month. Here are the data : Column Header => ------ Service Name --------| ------ Code -------- | ------ Price-------- Group Header => --------------------------------- Month -------------------------------------- Values => -------$F{service_name}----|-----$F{code}----|-----$F{Price}--------| I want to display something like that: Column Header => ------ Service Name --------| ------ Code -------- | ------ Price-------- Group Header => --------------------------------- January -------------------------------------- Values => -------$F{service_name}----|-----$F{code}----|-----$F{Price}--------| -------------------------------------------------------------------Subtotal: january_total_price Group Header => --------------------------------- February-------------------------------------- Values => -------$F{service_name}----|-----$F{code}----|-----$F{Price}--------| -------------------------------------------------------------------Subtotal: february_total_price ..... ect... than last line would be ----------------------------------------------------Total : total_year I was able to generate a Total variable put it at the end. But I cannot add a subtotal price for each month: When trying to set the reset type, I only have: Report, Page, Column, Master => No Group here! I have tried to add the variable on the Report level and Dataset level but from both side the result is same: no group reset type. If someone could help me..... I've added the jrxml file if it can help. thanks

Hi, I'm recently using Jaspersoft studio 6.9 to generate reports from PostgreSQL database. My query is quite simple to start: select * from [mytable]. I'm creating the report using Blank_A4_Landscape template, and use the query for init dataset. Then i'm dragging a Table component to the report, once again create a query to retreive the column name and then organize the table. The problem is with the result : The total row count of the query should be 205, but it's displaying 42230.... It's like query is run twice ?? So I tried removing the dataset from either the main or the one attached to the table component. Removing from the main will give me Document is empty. Removing from the table dataset will result in 205 records but nothing displayed. Maybe i'm not using the table component correctly, could someone help me ? Thank you.