[Group by sort parameter(s)]

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

 

[StartDate parameter default time needed]

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

[Advanced Grouping]

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

[How to set the field used for a group by parameter]

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

[If I add a 3rd list parameter in Jasper Server, I see none.]

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

[If I add a 3rd list parameter in Jasper Server, I see none.]

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

[If I add a 3rd list parameter in Jasper Server, I see none.]

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 I add a 3rd list parameter in Jasper Server, I see none.]

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?

[If I add a 3rd list parameter in Jasper Server, I see none.]

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.

[Cannot drop server report]

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?

[I need to be able to create a report in Studio that displays as a grid in the Server]

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

[Cannot drop server report]

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?

[Cannot drop server report]

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)

[I need to be able to create a report in Studio that displays as a grid in the Server]

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

 

[I need to be able to create a report in Studio that displays as a grid in the Server]

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.

[All I want is a published, Studio generated report, with a pull down list parameter for all, many or one list items]

The answer is here if anyone is out there:

http://community.jaspersoft.com/questions/542182/selecting-parameter-values-sql-query#comment-816926

[Selecting parameter from values of a SQL Query]

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

[All I want is a published, Studio generated report, with a pull down list parameter for all, many or one list items]

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 $

[Selecting parameter from values of a SQL Query]

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

[SQL queryString arithmetic operations and functions]

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.

[SQL queryString arithmetic operations and functions]

WAH-HOO

I can see the Expression Editor!

The trick is now ... how do I use it to format ANYTHING?!

[textAlignment="Right" has no effect]

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

[textAlignment="Right" has no effect]

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

 

[textAlignment="Right" has no effect]

Thank you very much peter.w - I'll soldier on!

I'll be back soon with other dumb questions.

Regards

Martin

[textAlignment="Right" has no effect]

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]