george_17

hi all I had problems with a report i was testing which selects data based on from to dates entered by user... the query expects the database data in a format dd/mm/yy the report built in studio works fine, but when published to server produces nothing the one thing i noticed is that the dates entered on the server are displated as yyyy-mm-dd so i changed the properties.config file to dd/mm/yy and now the report wont run it gives the following i get access denied .... then dialog message The system was unable to complete you request. Your conversation may have ended, expired, or been invalidated so changing the four date field seems to have screwed up the server any help would be gratefully received many thanks george

ok there are two sets of dates to change now its formatting ok but.... still get no output from report and now .... fter successfully entering dates runnig reports ... ive published same report different location and name... and now the error has come back on all the reports..... what is going on????? i get access denied .... then dialog message The system was unable to complete you request. Your conversation may have ended, expired, or been invalidated

weird.... made no difference

ok found it jaspersoftproperties.config...

so far thiis is what i have had to do... ive created the input controls and tested the datasource.. i actually published to my server nust because i am hoping to prove all the bits work on my server... nothing was extracted on the server for a date range which works on jasper studio... so i added the query from studio but still nothing.... then i noticed the date paras.... in studio they are dd/mm/yy in server its yyyy-mm-dd how do i change server format for dates....?????? george

i have tried to add this again and then tried running it i get access denied .... then dialog message The system was unable to complete you request. Your conversation may have ended, expired, or been invalidated. any ideas??? george

i just reread your helpful post... i did add the jrxml file and ran the report but nothing was produced... i think your last few words explains what i am missing... the report runs against two input dates.... but the report never asked for any dates... my question is how do i know what are the date controls are called and how do i add them?? thanks george

you missed my question.... i do that on my dev pc and have no problem with it i have installed jaspersoft server on the client pc which is nowhere near me... i assume i can just copy some files onto a usb stick take it to the client site and install on the server... how do i do that FROM A USB STICK

ok sussed this... jasper default had this as bigsomething... you need to select the field then properties set to double

hi i have created a report in studio now i need to deploy it into j server on a client site what do i need to copy onto my usb stick and how do i insall it on thecustomer j server thanks george

Hi I have a database field which is a price but when i add the field and run the report i get a format like 99.0000 ... how do i restrict the decimal places to two? thanks

the last question.... set property of group header band to start a new page

forget the column header question.... the answer is simple.... i am so stupid.... the column header is static text and should be the last row in the group header

it would help if i got the terminology correct: sorry about that... what imeant is the column header is ABOVE the group header... so the sequence of bands is title, column header, group header, detail, group footer, column footer, page footer, summary the version btw is same as yours 6.4 source below btw ... there is no sequencing in the cource how does it know where to layout the bands?? <?xml version="1.0" encoding="UTF-8"?> <!-- Created with Jaspersoft Studio version 6.4.0.final using JasperReports Library version 6.4.1 --> <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="ms12" pageWidth="842" pageHeight="595" orientation="Landscape" columnWidth="802" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="13aff3d2-91fc-477a-ae9d-190befded16c"> <property name="com.jaspersoft.studio.data.sql.tables" value=""/> <property name="com.jaspersoft.studio.data.defaultdataadapter" value="New Data Adapter (12)"/> <property name="net.sf.jasperreports.data.adapter" value="DataAdapter.xml"/> <property name="ireport.jasperserver.url" value="http://localhost:8080/jasperserver/"/> <property name="ireport.jasperserver.user" value="jasperadmin"/> <property name="ireport.jasperserver.report.resource" value="/datasources/reports/ms14_files/main_jrxml"/> <property name="ireport.jasperserver.reportUnit" value="/datasources/reports/ms14"/> <parameter name="From Date" class="java.sql.Date"/> <parameter name="To Date" class="java.sql.Date"/> <queryString language="SQL"> <![CDATA[select concat( a.firstname, ' ', a.lastname) as Customer , a.payment_address_1 as Address , a.payment_city as City, a.payment_postcode as Postcode, a.payment_zone as County, a.telephone as Phone, a.email as Email, a.order_id as OrderNo, a.invoice_no as Invoice, a.invoice_prefix, a.comment as CollectionDate, a.total, a.date_added, c.name as Product, c.quantity as QtyorWeight, c.price as Price, c.total as Total from oc_order as a, oc_order_product as c where a.order_id = c.order_id and ((STR_TO_DATE(a.comment, '%d/%m/%y') >= cast($P{From Date} as date)) and (STR_TO_DATE(a.comment, '%d/%m/%y') <= cast($P{To Date} as date)) or (STR_TO_DATE(a.comment, '%d/%m/%Y') >= cast($P{From Date} as date)) and (STR_TO_DATE(a.comment, '%d/%m/%Y') <= cast($P{To Date} as date))) group by a.order_id order by a.comment desc]]> </queryString> <field name="Customer" class="java.lang.String"/> <field name="Address" class="java.lang.String"/> <field name="City" class="java.lang.String"/> <field name="Postcode" class="java.lang.String"/> <field name="County" class="java.lang.String"/> <field name="Phone" class="java.lang.String"/> <field name="Email" class="java.lang.String"/> <field name="OrderNo" class="java.lang.Integer"/> <field name="Invoice" class="java.lang.Integer"/> <field name="invoice_prefix" class="java.lang.String"/> <field name="CollectionDate" class="java.lang.String"/> <field name="total" class="java.math.BigDecimal"/> <field name="date_added" class="java.sql.Timestamp"/> <field name="Product" class="java.lang.String"/> <field name="QtyorWeight" class="java.lang.Integer"/> <field name="Price" class="java.math.BigDecimal"/> <field name="Total" class="java.math.BigDecimal"/> <group name="OrderID"> <groupExpression><![CDATA[$F{OrderNo}]]></groupExpression> <groupHeader> <band height="114"> <textField> <reportElement x="189" y="38" width="60" height="16" uuid="321b2c8d-c501-4655-907a-e40e6d9149fb"/> <textFieldExpression><![CDATA[$F{OrderNo}]]></textFieldExpression> </textField> <staticText> <reportElement x="14" y="16" width="56" height="16" uuid="6a73e54f-11a4-40bf-b1a6-c1bc9e678995"/> <text><![CDATA[invoice No]]></text> </staticText> <staticText> <reportElement x="97" y="16" width="62" height="20" uuid="080f7d57-06e3-4292-967c-bc20f9a7bdde"> <property name="com.jaspersoft.studio.unit.y" value="pixel"/> </reportElement> <text><![CDATA[invoice Date]]></text> </staticText> <staticText> <reportElement x="189" y="16" width="64" height="16" uuid="6b5aa02f-8816-410f-828b-0b797ff86526"> <property name="com.jaspersoft.studio.unit.y" value="pixel"/> <property name="com.jaspersoft.studio.unit.x" value="pixel"/> </reportElement> <text><![CDATA[Order No]]></text> </staticText> <textField> <reportElement x="14" y="38" width="56" height="16" uuid="7b763b99-79b0-4af0-bfbd-a668587bcf90"> <property name="com.jaspersoft.studio.unit.x" value="pixel"/> <property name="com.jaspersoft.studio.unit.y" value="pixel"/> </reportElement> <textFieldExpression><![CDATA[$F{Invoice}]]></textFieldExpression> </textField> <textField> <reportElement x="97" y="38" width="42" height="16" uuid="e410fb4c-7e30-4cf5-b7bd-7eb8248e322b"> <property name="com.jaspersoft.studio.unit.x" value="pixel"/> <property name="com.jaspersoft.studio.unit.y" value="pixel"/> </reportElement> <textFieldExpression><![CDATA[$F{date_added}]]></textFieldExpression> </textField> <staticText> <reportElement x="308" y="16" width="52" height="14" uuid="e2c0fb16-edfc-424f-83a2-774f213b7207"> <property name="com.jaspersoft.studio.unit.y" value="pixel"/> </reportElement> <text><![CDATA[Customer]]></text> </staticText> <staticText> <reportElement x="460" y="16" width="70" height="16" uuid="e5ebb5a0-692d-4564-bd5c-d5fe0b9693e1"> <property name="com.jaspersoft.studio.unit.y" value="pixel"/> </reportElement> <text><![CDATA[Phone No]]></text> </staticText> <textField> <reportElement x="308" y="38" width="128" height="16" uuid="e5f97d25-5c91-4020-a083-1d07dc04f49f"> <property name="com.jaspersoft.studio.unit.x" value="pixel"/> <property name="com.jaspersoft.studio.unit.y" value="pixel"/> </reportElement> <textFieldExpression><![CDATA[$F{Customer}]]></textFieldExpression> </textField> <textField> <reportElement x="460" y="38" width="100" height="16" uuid="008d8ea3-d0bd-46db-82fb-ff8088c06d6e"> <property name="com.jaspersoft.studio.unit.x" value="pixel"/> <property name="com.jaspersoft.studio.unit.y" value="pixel"/> </reportElement> <textFieldExpression><![CDATA[$F{Phone}]]></textFieldExpression> </textField> <staticText> <reportElement key="" x="360" y="82" width="82" height="18" uuid="4cd011d1-7bac-4b99-9804-10ac7ee780a3"> <property name="com.jaspersoft.studio.unit.width" value="pixel"/> </reportElement> <text><![CDATA[Collection Date: ]]></text> </staticText> <textField> <reportElement x="460" y="82" width="100" height="18" uuid="e9269e33-03d5-4fa7-b3a3-e59bea4a7973"> <property name="com.jaspersoft.studio.unit.y" value="pixel"/> <property name="com.jaspersoft.studio.unit.x" value="pixel"/> </reportElement> <textFieldExpression><![CDATA[$F{CollectionDate}]]></textFieldExpression> </textField> </band> </groupHeader> <groupFooter> <band height="39"> <staticText> <reportElement x="490" y="19" width="89" height="20" uuid="411af0e1-170f-4d7e-bfdd-d40c51247bfa"/> <text><![CDATA[invoice Total]]></text> </staticText> </band> </groupFooter> </group> <background> <band splitType="Stretch"/> </background> <title> <band height="79" splitType="Stretch"> <staticText> <reportElement x="280" y="10" width="217" height="15" uuid="cbfc33da-1dc6-4ff2-b977-e2fb7845c301"/> <text><![CDATA[The MeatShack Picking Report for Date Range: ]]></text> </staticText> <textField pattern="MMMMM dd, yyyy"> <reportElement x="674" y="12" width="100" height="18" uuid="e9dda100-c465-4637-bcc6-3f5d2ea9cde4"/> <textFieldExpression><![CDATA[new java.util.Date()]]></textFieldExpression> </textField> <textField> <reportElement x="280" y="25" width="50" height="15" uuid="9f9755f1-251c-4e2b-a1d4-21c43ae6e65b"/> <textFieldExpression><![CDATA[$P{From Date}]]></textFieldExpression> </textField> <textField> <reportElement x="437" y="25" width="53" height="13" uuid="9c40830d-c75f-4bfc-bd36-83d95aeabf14"/> <textFieldExpression><![CDATA[$P{To Date}]]></textFieldExpression> </textField> <staticText> <reportElement x="374" y="25" width="30" height="37" uuid="c29f7e49-de0f-475f-949c-593be214c0e3"/> <text><![CDATA[to]]></text> </staticText> </band> </title> <pageHeader> <band height="5" splitType="Stretch"/> </pageHeader> <columnHeader> <band height="48" splitType="Stretch"> <staticText> <reportElement x="14" y="6" width="100" height="30" uuid="f5166e73-dc43-4ff8-bc5a-fb6206b4d5d5"/> <text><![CDATA[Product]]></text> </staticText> <staticText> <reportElement x="242" y="6" width="100" height="30" uuid="eaf4d027-0517-430c-8410-8af64112fd56"/> <text><![CDATA[Quantity]]></text> </staticText> <staticText> <reportElement x="355" y="6" width="100" height="30" uuid="cf90a4d4-7971-478a-bb29-45f5a2bd2fb8"/> <text><![CDATA[Price]]></text> </staticText> <staticText> <reportElement x="612" y="6" width="100" height="30" uuid="7e674e89-33fd-4933-98d0-7e84eadf80cc"/> <text><![CDATA[Total]]></text> </staticText> </band> </columnHeader> <detail> <band height="125" splitType="Stretch"> <textField> <reportElement x="14" y="21" width="206" height="30" uuid="0b7017e4-2d7e-41ad-8e9d-a43b99d288ea"/> <textFieldExpression><![CDATA[$F{Product}]]></textFieldExpression> </textField> <textField> <reportElement x="242" y="21" width="66" height="30" uuid="6a9171cc-31aa-4e4e-a1e7-0abd25fce967"/> <textFieldExpression><![CDATA[$F{QtyorWeight}]]></textFieldExpression> </textField> <textField> <reportElement x="355" y="27" width="82" height="24" uuid="10eb5948-f3cf-4983-bcca-1cd7fadbb8fc"/> <textFieldExpression><![CDATA[$F{Price}]]></textFieldExpression> </textField> <textField> <reportElement x="612" y="27" width="100" height="30" uuid="0dd6ac8c-09d2-4140-8df9-6b01b75327ff"/> <textFieldExpression><![CDATA[$F{total}]]></textFieldExpression> </textField> </band> </detail> <columnFooter> <band height="45" splitType="Stretch"/> </columnFooter> <pageFooter> <band height="54" splitType="Stretch"/> </pageFooter> <summary> <band height="50" splitType="Stretch"> <staticText> <reportElement x="374" y="20" width="100" height="30" uuid="e2a3e9bc-03f4-4d9a-a730-0f8c6c081cc4"/> <text><![CDATA[End of Report]]></text> </staticText> </band> </summary> </jasperReport>

Hi I really am pleased with Jasperreports and studio is awesome... I have a report and then realized a bit late that i needed to modify it to group ... so created a group band (after i modified the sql statement)However However, the group header report band i have inserted i have just noticed is AFTER the detail header band I have tried to drag this down in the report outline to be with the detail band but it wont move... anyone know how to move it? Also... is there anyway i can change the point size of the fields on the report... its a bit small and can i have individual fields bold and slightly bigger and finally... how do i start on a new page after each group... thanks if you can help george

i think i was panicing... the solution i think is to use group by and then put all the standing information order no customer address etc etc in the group header band and only the product details bought in the detail section.... at least i hope that is it....

hi my sql is fairly simple select concat(a.invoice_prefix, a.invoice_no) as Invoice, a.order_id as OrderNo, a.email as Email, a.date_added as DateAdded, a.telephone as Phone, a.payment_method as PaymentMethod, concat( a.firstname, ' ', a.lastname) as Customer , a.payment_address_1 as Address , concat(a.payment_city, a.payment_postcode) as City, a.comment as CollectionDate, c.name as Product, c.quantity as QtyorWeight, c.price as Price, c.total as Total from oc_order as a, oc_order_product as c where a.order_id = c.order_id and STR_TO_DATE(a.comment, '%d/%m/%y') = cast($P{CollectionDate} as date) i had included group by order_id whn creating this sql in the wizard but it seems to have missed this... i am testing an order with 3 items ... but it seems only to have printed one item... can someone explain how i get all the data for one order on one page but at the bottom of the page individual items listed one after another... thanks george

thanks reportdev... i am amazed that this wasn't included in jasperreports server or studio... its been over 50 years since i last cut any code ... don't think java had been invented then... i assume the code in your link can be saved as some type of resource bundle but how would you execute that from javareports server... are there any how do i tutorials to guide me ??

hi all Ive created a report in Jasperreports studio and published it to jasperreports server... all brilliant the report runs and is displayed ... i can see the option to export to pdf and from there i could print but.... is there a way i can output direct to printer??? thanks george

Mariano {} .... SUPERB ... PERFECT thank you sooooo much !!! george

Two excellent responces guys. I am grateful for the real clarification and the suggestions. excellent, superbly supportive. thanks george

Hi all in sheer frustration i stripped my query into simple terms... steps i created the report initially without the where statement just to make sure all data was generated... then i created a Parameter renamed it as Message and set datatype to java.sql.Date the date_added field on the database is datetime the content looks like 22/08/17 10:30 but this sql select order_id, comment, date_added from oc_order where cast($P(Message) as datetime) > date_added asks me to select a date from thecalendar 01/08/17 but pressing the run button i get error generating report and in the error log i get exception error executing sql statement for 1. I am hoping someone can make some suggestions as to what i am doing wrong.... thanks very much george

hi all created a report in jasperreports studio... previewed it... looks fine... i published to jasperreports server... but i dont understand why it asks for the datasource when i publish when ive already included it and if i need to add it again where do i enter all the parameters again?? any help would be appreciated... thanks george

hi all I created a report in studio, tested by running a preview... its fine... so saved it onto my pc by using the save as jasperreport... in jasperreports server i selected the repository then reports rightclick add resource>jasperreport setup is displayed and when i select the local file and submit it says it cannot parse the file i notice though that the extent is a jrprint not jrxml... what is the jrprin used for and how do i create the jrxml file thanks george

of course... how could i forget.... thanks very much An additional question if i may: I just tested this and managed to ad a random report.. during the process i was asked whether to add a datasource too the server.. My client will have a dedicated pc for his reports in the back office. the reports will need to access a mysql database on the hosting server ie not locally the report i create on jasperreports studio will contain the datsource to connect to the hosted database since my instance of studio cannot connect to his backoffice pc how do i save the studio report and where is it saved? does the saved file contain all the resources? how do i istall that on the client site? thanks george