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.