john.logia

Hello all, I am trying to create a jasper report with dynamic columns. I have a database table DAYTIMEAccountNum Value 1Num Value 2TextNum Value 3Num Value 4Num Value 501/01/2017105060ABC100563001/01/201710 200 01/01/201710 300 02/01/2017206734BED5008008703/01/201710133456ABC12323334503/01/201730122222GEF124331123I would like to create a report that will generate a dynamic column on the highlighted column attribute to a report like this DaytimeAccountNum Value 1Num Value 2TextNum Value 3Num Value 3Num Value 3Num Value 4Num Value 501/01/2017105060ABC100200300563002/01/2017206734BED500 8008703/01/201710133456ABC123 23334503/01/201730122222GEF124 331123Is this Possible in Jasper Reports?

Hello All, I am trying to insert a floating image (blue) into a excel document however the image creates extra rows and columns (highlighted in red). is there away to insert an image with creating these boxes?

Hi all, is it possible to create grouped cross tab headings as detailed below?

Hello All, I am trying to create a excel report in Jasper 5.9.0 where certain cells are wrapped while other cells are not. I have tried setting the value <property name="net.sf.jasperreports.export.xls.wrap.text" value="false"/> to allow wrapping, however this removes wrapping from the cells i want wrapped.

I am having problem where my excel rows are over flowing into the margins. When viewing the excel margin setting they are all defaulted to 0, is it possible to set the margins so when exporting to excel they do not default back to 0?

Hello all, I am trying to generate a report in jasperreports using parameters passed to jasper report engine, however when i run the tool throught the jasper 6.2.0 engine i get the following error: Caused by: java.sql.SQLDataException: ORA-01830: date format picture ends before converting entire input string. When i run the report in ireports 5.2.0 the report generates correctly. The parameters are defined <parameter name="DAYTIME" class="java.lang.String"/><parameter name="ENDDATE" class="java.lang.String"/><parameter name="SALE_NAME" class="java.lang.String"/><queryString><![CDATA[sELECTDAYTIME,SALE_ID,SALE_NAME,START_SALE_DATE,SALE_WINDOW_START,SALE_WINDOW_END,SALE_SHARE,DISCOUNT_SIZE,DS_DATE,ED_DATE,COMMENTS FROM "SALE_REPORT" SALE_REPORTWHERE DAYTIME BETWEEN (TO_DATE($P{DAYTIME},'YYYY-MM-DD"T"HH24:MI:SS')) AND (TO_DATE($P{ENDDATE},'YYYY-MM-DD"T"HH24:MI:SS')) AND SALE_NAME = $P{SALE_NAME}]]>[/code]