martin.clarke

Hi I'd like to group and subtotal a report by sort parameters. Does this, from 6 years ago, still apply? http://community.jaspersoft.com/questions/527233/how-set-field-used-group-parameter Or is there an updated ijit's guide somewhere? Best regards - Martin

Hi My StartDate parameter, class java.util.Date, default is TODAY( ) When previewed the current time is specified: hh:mi:ss I need that to be 00:00:00, or, I imagine, TODAY( ) - 1, in pseudocode, with a time of 23:59:59 I am unbelievably old and dim before I was, any painfully explicit help would be greatly appreciated. Best regards - Martin

I started to read the first answer and I KNEW this was you Carl : )

Hi, 6 years on, does this apply to Studio?

Well, I worked round it by adding a pair of Start, End Date parameters, which is more rational: more flexible.

Whatever I do the new list parameter input control is not displayed and inhibits the display of any other.

Joy. Following the Cascading Input Controls gets Access Denied, You are not authorized to access this page. What is that about? I am getting so discouraged by Jasper.

If this is ever resolved - with Cascade?! - I need to enter a start and end YYYY DD range. The 3rd parameter I'm adding is a list one of all YYYY DDs, which will become unmanageable I realise. The report displays a date select column as YYYY DD in it's first column, I'm just trying to build up this functionality one step at a time. It has occurred to me that the very nature of the input control is preventing its display under Options AND the the other two input controls. I'll experiment with removing one of those to see if that affects Options display. The report won't be usable of course, due to the removed input control for a start. So, is the work-around Cascade? If it is impossible to display 3 input controls if they are lists?

I have a report with 3 multi-select query, parameter input controls. If I add and submit the 3rd input control on the web server in IE, Firefox or Chrome, none of the 3 input controls appears under Options, the Apply and Reset buttons are available. Apply just hangs with Please Wait, Loading.

In Reports I have a FOLDER DrctWrkLogRep_FATCA_dev_1x and a Report - DrctWrkLogRep_FATCA_dev_1 that share the same files in Project Explorer How do I get rid of the erroneous folder in Reports please?

Done. The only issue now is that numbers are exported to the spreadsheet as text.

Thanks hozawa. I've no idea. I'll have to Google that! ... well, I've followed this and am none the wiser: http://community.jaspersoft.com/wiki/how-check-jasperreports-server-version-command-line I imagine I'll have to live with it, the alternative is to export everything else and rebuild the server I imagine further. Is this a Jira DATABASE issue?! Is THAT corrupt?! No, it can't be that, surely?

java.lang.Exception: The Server has returned an error with code 1 and with the message could not delete: [com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.persistent.RepoFileResource#11767]; SQL [delete from JIFileResource where id=?]; constraint [fk98818b778c8df21b]; nested exception is org.hibernate.exception.ConstraintViolationException: could not delete: [com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.persistent.RepoFileResource#11767] at com.jaspersoft.ireport.jasperserver.ws.WSClient.delete(WSClient.java:232) at com.jaspersoft.ireport.jasperserver.ws.WSClient.delete(WSClient.java:203) at com.jaspersoft.studio.server.protocol.soap.SoapConnection.delete(SoapConnection.java:315) at com.jaspersoft.studio.server.protocol.ProxyConnection.delete(ProxyConnection.java:355) at com.jaspersoft.studio.server.WSClientHelper.deleteResource(WSClientHelper.java:414) at com.jaspersoft.studio.server.action.resource.DeleteResourceAction$1.deleteResource(DeleteResourceAction.java:145) at com.jaspersoft.studio.server.action.resource.DeleteResourceAction$1.run(DeleteResourceAction.java:94) at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:121)

Appears to be part of the answer, but it doesn't address the issue of a design template that would generate a report to screen that looks like a spreadsheet prior to export. Month Author Date Project Log ref Description Hours Estimated effort May-15 Zippity.Doodah 7-May FATCAT FAT-3100 Code Merging 4 25

People have been asking this for 10 years I see. After answering my own last question 5 days ago, on selecting multiple drop down parameters, by ever more efficient Googlin' (I discovered the awesome Carl Barlow), I s'pose I'd better start going through that decade of incoherence. When I work out the answer, I will post it here.

The answer is here if anyone is out there: http://community.jaspersoft.com/questions/542182/selecting-parameter-values-sql-query#comment-816926

That did it Carl. Multi Select Query. Are you a single-malt or Cohiba man?

I'm running a parameterized report in JasperReports Server. It has two parameters, one is a java.lang.String and works fine in versions of the report with just that. The other is a java.util.List pull down list. This errors with: net.sf.jasperreports.engine.JRRuntimeException: Invalid type java.lang.String for parameter CustomerOrganisationList used in an IN clause; the value must be an array or a collection. I take it the 'value' being referred to is that being selected from the pull down list. Where that is defined as a java.lang.String I haven't the faintest idea. UNLESS the error is saying that the parameter CustomerOrganisationList is a java.lang.String. It isn't. In Studio it's a java.util.List as mentioned above. Convert the CustomerOrganisationList java.lang.String to an java.sql.Array or java.util.Collection OR the 'value' needs defining as an array or a collection. How please? I have adapted the excellent Carl Barlow's response in http://community.jaspersoft.com/questions/542182/selecting-parameter-values-sql-query from iReport to Studio. I can run the report in the painful Studio Preview mode. Is there a how-to on this anywhere please? I've tried this: http://community.jaspersoft.com/documentation/jasperreports-server-administration-guide/v550/query-based-input-controls It's such a simple requirement, I'm astounded that there isn't a single worked example anywhere. I've spent six days on this so far. I'm old and dumb, but I am stubborn. Martin $ martinpeterclarke@hotmail.co.uk $ 24/7 $

Carl, I WAS going to nominate you for a Nobel. I faithfully adapted your iReport instructions for Studio, it only took a day (I'm OLLLD), I could see the banks of the Jordan after a bipolar week with Jasper to this point, pulled down the list on the server, could only choose one item (DANGER! Danger Will Robinson), but knew I'd conquered such insurmountable obstacles before, then: net.sf.jasperreports.engine.JRRuntimeException: Invalid type java.lang.String for parameter CustomerOrganisationList used in an IN clause; the value must be an array or a collection. Is the 'value' referred to the single one only I can select in the server parameter pull-down list and that is of the type java.lang.String? That isn't in the Studio Design or Source? Studio Parameter CustomerOrganisationList is of class java.util.List, as per your instructions. Best regards Martin martin.clarke@dionglobal.com

Thank you Marianol. I have been busy with other things! I've just caught up and truly appreciate your excellent response, which I've been able to follow.

WAH-HOO I can see the Expression Editor! The trick is now ... how do I use it to format ANYTHING?!

As I say on my next Comment above Peter, WAH-HOO!

Stroll on Peter. Hope against experience said try to progress the thread with an Answer or Edit, but it has to be a Comment again: WHA HOO! Not only must one do it for the column detail, one must do it for the column header: <columnHeader> <band height="26" splitType="Stretch">... <staticText> <reportElement style="Column header" x="333" y="7" width="111" height="18" forecolor="#000000" uuid="c403ee30-44b8-44fb-8775-fd9be9db62d0"/> <textElement textAlignment="Right"> <----- <font isBold="false"/> </textElement> <text><![CDATA[Hours Worked]]></text> </staticText>... </band> </columnHeader> <detail> <band height="18" splitType="Stretch"> <frame>... <textField isStretchWithOverflow="true"> <reportElement style="Detail" positionType="Float" x="333" y="0" width="111" height="18" uuid="8dd14df6-2cf5-4bd2-b126-886246c57f8b"/> <textElement textAlignment="Right"> <----- <font size="14"/> </textElement> <textFieldExpression><![CDATA[$F{timeworked}]]></textFieldExpression> </textField>... </frame> </band> </detail> [/code]Now we know peter! You probably did anyway and assumed I wasn't a TOTAL noob! : ) Thanks again for being part of the process. Regards Martin

Thank you very much peter.w - I'll soldier on! I'll be back soon with other dumb questions. Regards Martin

Thanks peter.w This is SO frustrating. I just posted a detailed reply and there's no sign of it. This works but aligns left. If I incorporate your suggestion naively it errors. If I implement it slightly more intelligently, it doesn't error, but doesn't work. This is a diabolical interface. I posted this twice as an Answer and it failed. <textField isStretchWithOverflow="true"> <reportElement style="Detail" positionType="Float" x="333" y="0" width="111" height="18" uuid="8dd14df6-2cf5-4bd2-b126-886246c57f8b"/> <textElement> <font size="14"/> </textElement> <textElement textAlignment="Right"> <----- </textElement> <----- <textFieldExpression><![CDATA[$F{timeworked}]]></textFieldExpression></textField><textField isStretchWithOverflow="true"> <reportElement style="Detail" positionType="Float" x="333" y="0" width="111" height="18" uuid="8dd14df6-2cf5-4bd2-b126-886246c57f8b"/> <textElement textAlignment="Right"> <----- <font size="14"/> </textElement> <----- <textFieldExpression><![CDATA[$F{timeworked}]]></textFieldExpression></textField>[/code]