am0rales

I think you can resolve this issue by addding a UNION with the value of your measure to 0 to your query and aggregating then the result of that UNION. Then you have all the combinations of your quarters, even if you have no data for them. Example for your query: SELECT C_DATE, c_TRIM, C_PRODUCTS, SUM(NB_VENTE) AS NB_VENTEFROM((SELECT SUBSTRING(RI_DATE_INSCRIPTION,1,4)) AS C_DATE, QUARTER(RI_DATE_INSCRIPTION) AS C_TRIM, C_PRODUCTS, COUNT(C_ID) AS NB_VENTE FROM CARNET GROUP BY C_DATE, C_TRIM, C_PRODUCTS HAVING CATEGORY IS NOT NULL) UNION (SELECT SUBSTRING(RI_DATE_INSCRIPTION,1,4)) AS C_DATE, QUARTER(RI_DATE_INSCRIPTION) AS C_TRIM, C_PRODUCTS, 0 AS NB_VENTE FROM CARNET GROUP BY C_DATE, C_TRIM, C_PRODUCTS HAVING CATEGORY IS NOT NULL ) TUNION GROUP BY C_DATE, c_TRIM, C_PRODUCTSORDER BY D_RANDO ASC;

Hello. Same issue here and not working the solution metioned by shankarpanda003 I have a main report that links to other report and I want to hide that subreport. The Folder structure is like: - MAIN FOLDER (Only read permission) Report that have the hiperlink (in the same folder) - SUBREPORT FOLDER (only execute permission) Sub Report Any idea? My work envirnment: JasperServer 5.0 and Ireport 5

Hello. Have yoy dragged the new measures to the crosstab design? For adding new measures you need to add to the crosstab (1st step) and the drag to the crosstab window in the report (2nd step). Check this video: http://www.youtube.com/watch?v=pxpk_PncU24

Domains are only available for Jasper Professional Edition. If you are trying to pass the id of the user to the report you can do this by the username. There are builds parameters for that purpose like $P{LoggedInUsername} See http://community.jaspersoft.com/wiki/built-parameters-logged-user