surya.subodh

Hi All, I have a requirement of converting SSRS Reports into Jaspersoft reports.Some of the reports among these are Matrix reports with one row group and multiple column groups .I have used crosstab to create Matrix report in Jasper but I am not able to add multiple column groups side by side. If I create 2 column groups it is coming one group under the other.Can you pease let me know the solution /workaround for this. Thanks, Surya

Hi All, I have a requirement of creating Jasper report which shows the data for the previous quarter.I have created the report but not able to give the condition for the previous quarter dates in the Japser Report sql. I have given the below query in the where condition for retrieving the data for the previous quarter startdate and previous quarter end date but it is working in MYSQL but not working in Japser report sql. Previous Quarter End Date :-TIMESTAMPADD(Quarter, TIMESTAMPDIFF(Quarter,'1900-01-01 00:00:00.000',utc_timestamp()) -1 ,'1900-01-01 00:00:00.000') Previous Quarter Start Date :-TIMESTAMPADD(day,-1,TIMESTAMPADD(quarter, TIMESTAMPDIFF(quarter,'1900-01-01 00:00:00.000',utc_timestamp()),'1900-01-01 00:00:00.000')); Can you please let me know the condition for getting the previous quarter start and end dates in the Japser report sql. Thanks , Surya.

Hi All, I have a requirement of converting SSRS Reports into Jasper Reports along with the conversion of SQL Server to Maria DB . SQL Server is used as the source of SSRS .So while converting the SQL Server code to the Jaspersoft Report sql code, I am facing some issues.I am not able to use cte table or temp table in Jaspersoft Report sql.Temp table and cte table is not supported in Jaspersoft.So can any of you please let me know a solution for this. Thanks & Regards, Surya