beard9982

so if I have server ce 7.2 what version of studio should I be using and what Library will that have?

a list should grow by default as more data is added. you may need to put it in its own band do it can grow and the item below it can move down in a different band

Only way you could do this is det the default to be "" if it is a straing in the parameter, but you will also need to test for "" rather than a null

I have the same issue in 6.9 did you manage to fix this?

when I save a report in Studio 6.13 it now asks for the report to iverwrite. is this a setting or a bug. before if I had published a report the system would re member and overwrite on save, now I have to select the report each time as if I was publishing a new report

I have V6 studio 6.13 installed and a comunity version of server 7.2. I cannot find a studio comunity version of 7 . how can I publish reports etc

I have done this by Editing the source pageWidth, its at the top of the source <jasperReport xmlns="http://jasperreports.sourceforge.net/jasperreports" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports http://jasperreports.sourceforge.net/xsd/jasperreport.xsd" name="SalesDashboardMain" language="groovy" pageWidth="750" pageHeight="620" orientation="Landscape" whenNoDataType="AllSectionsNoDetail" columnWidth="750" leftMargin="0" rightMargin="0" topMargin="0" bottomMargin="0" uuid="99961451-9d1e-49c1-af39-6b7c30ff4836">

I have done this by Editing the source pageWidth, its at the top of the source <jasperReport xmlns="http://jasperreports.sourceforge.net/jasperreports" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports http://jasperreports.sourceforge.net/xsd/jasperreport.xsd" name="SalesDashboardMain" language="groovy" pageWidth="750" pageHeight="620" orientation="Landscape" whenNoDataType="AllSectionsNoDetail" columnWidth="750" leftMargin="0" rightMargin="0" topMargin="0" bottomMargin="0" uuid="99961451-9d1e-49c1-af39-6b7c30ff4836">

I have modified validation.properties Validator.ValidSQL=(?is)^\s*(select|with)\s+[^;]+;?\s*$ however, I still get validation errors where there is a within the SQL below is the sql WITH coil as( SELECT stock_items.id, products.description as prd_desc, products.size_description as prd_size_desc, production_jobs."number" AS jobs_number, production_jobs.description as job_description, production_jobs.scheduled_date, COALESCE(supplier.name,'') as supplier, COALESCE(mills.name,'') as mill, COALESCE(stock_casts.cast_number,'') as cast_number , stock_items.other_number as coil_number, stock_items.specification_value1 as grade, (select description from stock_specification_values where code = stock_items.specification_value1 and specification_id = 1 ) as spec, stock_items.physical_pieces as physical_pieces, stock_items.physical_pieces - stock_allocations.pieces as return_pieces, stock_allocations.weight as allocated_weight, stock_allocations.pieces as allocated_pieces, case when stock_items.dim3 > 0 then replace( round(stock_items.dim1,2) ||' x ' || round(stock_items.dim2,1)||' x ' || round(stock_items.dim3,1),'.',',') else replace(round(stock_items.dim1,2) ||' x ' || round(stock_items.dim2,1),'.',',') end as coil_size, stock_items.advice_note_reference, stock_items.number as stock_item, case when coil_owner.name is null then 'SSC' else coil_owner.name end as coil_owner, stock_items.physical_weight as coil_weight, sales_headers.number || '-' || sales_items.item_number as sales_item, sales_headers.customer_order_number, replace(stock_status_codes.description,'Stock Production','Prime') as finished_status, stock_items_produced.location as finished_location, stock_items_produced.number as finished_number, round(stock_items_produced.dim1,2) as dim1, round(stock_items_produced.dim2,0) as dim2, round(stock_items_produced.dim3,0) as dim3, case when part_number_specifications.id is not null then part_number_specifications.name else replace(round(stock_items_produced.dim1,2) ||' x ' || round(stock_items_produced.dim2,0)||' x ' || round(stock_items_produced.dim3,0),'.',',') end as finished_size, case when original_stock_items.id is null then stock_items.physical_weight else original_stock_items.physical_weight end as coil_weight, sales_items.production_notes as sales_production_notes, stock_items_produced.physical_pieces as produced_pieces, stock_items_produced.physical_weight as produced_weight, case when stock_items_produced.physical_pieces > 0 then round(stock_items_produced.physical_weight / stock_items_produced.physical_pieces,2) else stock_items_produced.physical_weight / 1 end as weight_per_piece, case when customer.code is null then 'Int' else customer.code end as account, (case when customer.name is null then 'Stock' else customer.name end)::varchar(12) as customer, case when original_stock_items.id is null then (select coalesce(sum(weight),0.0) as reciept_weight from stock_transaction_items sti join stock_transactions st on sti.transaction_id = st.id where st.type in ('RCT','IMP','GIA') and sti.stock_item_id = stock_items.id ) else (select coalesce(sum(weight),0.0) as reciept_weight from stock_transaction_items sti join stock_transactions st on sti.transaction_id = st.id where st.type in ('RCT','IMP','GIA') and sti.stock_item_id = original_stock_items.id ) end as reciept_weight, initcap(personnel.name) as creator, production_jobs.cdate::date as created_date, work_centres.description as work_centre FROM production_jobs LEFT OUTER JOIN production_job_consumption ON production_jobs.id = production_job_consumption.production_job_id left join stock_allocations on stock_allocations.job_consumption_id = production_job_consumption.id left outer join stock_items on stock_items.id = stock_allocations.stock_item_id LEFT OUTER JOIN products ON stock_items.product_id = products.id LEFT OUTER JOIN companies supplier ON stock_items.supplier_id = supplier.id LEFT OUTER JOIN transient_costs ON production_job_consumption.id = transient_costs.transient_id left join sales_items on transient_costs.sales_item_id = sales_items.id left join sales_headers on sales_headers.id = sales_items.sales_header_id LEFT OUTER JOIN stock_items stock_items_produced ON transient_costs.stock_item_id = stock_items_produced.id LEFT OUTER JOIN products products_produced ON stock_items_produced.product_id = products_produced.id left outer join stock_status_codes on stock_items_produced.stock_status_id = stock_status_codes.id left outer join stock_items original_stock_items on original_stock_items.id = stock_items.original_parent_id LEFT OUTER JOIN companies customer ON sales_headers.customer_id = customer.id LEFT OUTER JOIN companies coil_owner on coil_owner.id = stock_items.customer_id LEFT OUTER JOIN stock_casts on stock_items.stock_cast_id = stock_casts.id LEFT OUTER JOIN mills on mills.id = stock_casts.mill_id left outer join personnel on production_jobs.cuser_id = personnel.id left join work_centres on production_jobs.work_centre_id = work_centres.id left join part_number_specifications on part_number_specifications.id = sales_items.part_specification_id WHERE production_jobs.number = $P{Job_Num} order by sales_item,finished_number ) select * , (select sum(c.produced_weight) from coil c where c.stock_item = coil.stock_item) as coil_used from coil

I have a cross tab, nice and simple Row Group Company Name Column Groups user_name Measures $F{conformance_tasks_estimated_hours} I also have a variable that is returning from a sub report $V{TotalHrsAvailable} I get a nice crosstab showing Per user the ammount of development hrs assigned to each company I would like to add a new column into the crosstab to show the number of hrs as a % against the $V{TotalHrsAvailable} ********************************************************************************************************************************************************************************** <summary> <band height="95" splitType="Stretch"> <crosstab> <reportElement x="0" y="0" width="595" height="95"/> <rowGroup name="companies_name" width="70" totalPosition="End"> <bucket class="java.lang.String"> <bucketExpression><![CDATA[$F{companies_name}]]></bucketExpression> </bucket> <crosstabRowHeader> <cellContents backcolor="#F0F8FF" mode="Opaque"> <box> <pen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/> </box> <textField> <reportElement style="Crosstab Data Text" x="0" y="0" width="70" height="25"/> <textElement/> <textFieldExpression><![CDATA[$V{companies_name}]]></textFieldExpression> </textField> </cellContents> </crosstabRowHeader> <crosstabTotalRowHeader> <cellContents backcolor="#BFE1FF" mode="Opaque"> <box> <pen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/> </box> <staticText> <reportElement x="0" y="0" width="70" height="25"/> <textElement textAlignment="Center" verticalAlignment="Middle"/> <text><![CDATA[Total companies_name]]></text> </staticText> </cellContents> </crosstabTotalRowHeader> </rowGroup> <columnGroup name="USER_NAME" height="30" totalPosition="End"> <bucket class="java.lang.String"> <bucketExpression><![CDATA[$V{USER_NAME}]]></bucketExpression> </bucket> <crosstabColumnHeader> <cellContents backcolor="#F0F8FF" mode="Opaque"> <box> <pen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/> </box> <textField> <reportElement style="Crosstab Data Text" x="0" y="0" width="50" height="30"/> <textElement/> <textFieldExpression><![CDATA[$V{USER_NAME}]]></textFieldExpression> </textField> </cellContents> </crosstabColumnHeader> <crosstabTotalColumnHeader> <cellContents backcolor="#BFE1FF" mode="Opaque"> <box> <pen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/> </box> <staticText> <reportElement x="0" y="0" width="50" height="30"/> <textElement textAlignment="Center" verticalAlignment="Middle"/> <text><![CDATA[Company T]]></text> </staticText> </cellContents> </crosstabTotalColumnHeader> </columnGroup> <measure name="conformance_tasks_estimated_hoursMeasure" class="java.math.BigDecimal" calculation="Sum"> <measureExpression><![CDATA[$F{conformance_tasks_estimated_hours}]]></measureExpression> </measure> <crosstabCell width="50" height="25"> <cellContents> <box> <pen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/> </box> <textField> <reportElement style="Crosstab Data Text" x="0" y="0" width="50" height="25"/> <textElement/> <textFieldExpression><![CDATA[$V{conformance_tasks_estimated_hoursMeasure}]]></textFieldExpression> </textField> </cellContents> </crosstabCell> <crosstabCell height="25" rowTotalGroup="companies_name"> <cellContents backcolor="#BFE1FF" mode="Opaque"> <box> <pen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/> </box> <textField> <reportElement style="Crosstab Data Text" x="0" y="0" width="50" height="25"/> <textElement/> <textFieldExpression><![CDATA[$V{conformance_tasks_estimated_hoursMeasure}]]></textFieldExpression> </textField> </cellContents> </crosstabCell> <crosstabCell width="50" columnTotalGroup="USER_NAME"> <cellContents backcolor="#BFE1FF" mode="Opaque"> <box> <pen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/> </box> <textField> <reportElement style="Crosstab Data Text" x="0" y="0" width="50" height="25"/> <textElement/> <textFieldExpression><![CDATA[$V{conformance_tasks_estimated_hoursMeasure}]]></textFieldExpression> </textField> </cellContents> </crosstabCell> <crosstabCell rowTotalGroup="companies_name" columnTotalGroup="USER_NAME"> <cellContents backcolor="#BFE1FF" mode="Opaque"> <box> <pen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/> </box> <textField> <reportElement style="Crosstab Data Text" x="0" y="0" width="50" height="25"/> <textElement/> <textFieldExpression><![CDATA[$V{conformance_tasks_estimated_hoursMeasure}]]></textFieldExpression> </textField> </cellContents> </crosstabCell> </crosstab> </band> </summary>