lori.stopka

Thanks for the response. We do know that adding any pattern to the field in Studio resolves the issue or as you suggest, formatting the field itself, but that requires touching each report. We are trying to determine why the issue even exists. If no pattern is provided you would expect the format of the field to be as defined in the config file on the server but it is not. We have hundreds of reports and no way to identify which ones have date fields without patterns. We are fixing them (providing a pattern) as they present themselves. Existing reports were working as expected for years so we suspect something changed on the server but we don't know what that something is.

Running Jaspersoft Server 7.1.0 jasperserver_config.properties contains the following:# Used for parsing and formatting dates by server date.format=MM/dd/yyyy datetime.format=MM/dd/yyyy HH:mm:ss# Used for parsing and formatting dates by calendar component (UI). calendar.date.format=mm/dd/yy calendar.datetime.format=mm/dd/yy HH:mm:ss For fields in a report with the class of java.sql.Timestamp, when no pattern is provided in the report, the format on the desktop displays correct When report is run on server the format seems to be mixing up the minute and the month. Any suggestions / thoughts appreciated.

I seem to recall that when I opened a file from the repostory it displayed the full file name with file extension in the tab. Then when I did a "Save As" that file extension was retained. Now it appears when opening a file of type JRXML the file extension is not in the tab and subsequent saves of the file to my local PC save the file without a file extension. This causes problems when attempting to re-open the file as it opens in XML format which is not what I want. I now have to type the .jrxml extension when saving the file. If I can't get the file name plus extension in the save as dialog then it would be great if I could browse the directory and pick the .jrxml file I want to overlay with this new versions. Is this a workspace setting that I can modify?

We have a software package written in oracle forms. It prints purchase orders by calling an oracle stored procedure. The stored procedure writes out a flat file on the server which is picked up by a separate process and printed. This "separate process" is being obsoleted. We would like to modify the oracle stored procedure to launch the jasper report passing in the necessary parameters so the browser is opened, the report displayed and the user can print it. We do have forms that are opening jasper reports directly which just call a URL stored in a table but we don't know what the form is doing for those but it is working fine. In this case the form calls the procedure and we can't modify the form. We just want to change what the procedure does (eg: launch browser and open jasper report URL). I have been researching utl_http but not sure that will do it for us. Any suggestions appreciated. Thanks Lori

I have noticed a difference between a report publshed via Studio and one that was published using the browser interface on the server. If I publish a brand new report from Studio the ireport.jasperserver.report.resource property is set and the value represents a path to the report which ends in main_jrxml. If I use Studio to open the report in the repository it opens a file named main_jrxml.jrxml. But, if I publish the report on the server the ireport.jasperserver.report.resource property is set to the Resource ID when I first set up the report. For example "Welcom_To_Jasper". If I use Studio to open the report in the repository it opens a file named Welcome_To_Jasper_.jrxml. The upside to publshing the very first time via Studio is the process defines all the input controls for you in the repository automatcially. The downside is the generic name main_jrxml. The upside to publishing via the web the first time is that we get a unique name but we have to manually define each input control. Our dilemma is we want to version control our reports and having every report file named main_jrxml.jrxml makes that difficult. We have resorted to doing all our "first time" report publishing via the web so we get a unique report but we have a handful of reports that were published via Studio and we would like to change the resource name on those. Note that the resource id on these reports is not main_jrxml, it is actuallly the name of the report. I have tried modifhying the source to change the resource name and publishing via studio but the main_jrxml still sticks. I tried taking that same source file and uploading to the respository via the browser but it won't take the new name, it sticks with main_jrxml. I am trying to avoid having to redefine all the reports with all their input controls directly in the repository. Any suggestions would be appreciated. Thanks Lori

Thanks for response but I don't see how dynamic queries will solve my issue. I don't want the user to run the report. I want the user to be told prior to running the report that they need to choose "Yes" in at least one of the two drop downs. Example: In our previous reporting tool (Hyperion SQR), the SQR contains the code below. Assigned and Occupied are two dropdown input parameters. if $assigned='Yes' or $occupied='Yes' Do Main !OK to Run Report else Print 'ERROR: Either Assigned or Occupied must be set to "Yes"' () !Display Error to User end-if

I am searching for a way to compare two input parameters prior to report execution. I have two drop down selections, each containing values (Yes, No, Either Yes or No). In our previous reporting tool we were able to interogate the values chosen by the user and stop them from running the report if they hadn't chosen "Yes" in at least one of the drop downs. Not sure Cascading Input Parameters can help here. Any help appreciated. Lori

Thanks very much for the explanation.

Thanks very much for the response. Initially I was going to respond that it didn't work because I had taken your expression and pasted it into my VARIABLE Expression and got the exact same result. I then noticed that you had specfied a TEXT Expression so I used a text field instead and it worked. I then went back to my original SUM and put that in a text field and it worked as well. I took a look at the source code and found my original source contained the following: <variable name="TOTCOST" class="java.math.BigDecimal"> <variableExpression><![CDATA[sUM(($V{TOTRECEIPTS} == null ? BigDecimal.valueOf(0) : $V{TOTRECEIPTS}), ($V{TOTISSUES} == null ? BigDecimal.valueOf(0) : ($V{TOTISSUES}*-1)), ($V{TOTXI} == null ? BigDecimal.valueOf(0) : $V{TOTXI}), ($V{TOTXO} == null ? BigDecimal.valueOf(0) : ($V{TOTXO})*-1), ($V{TOTADJQ} == null ? BigDecimal.valueOf(0) : $V{TOTADJQ}), ($V{TOTADJP} == null ? BigDecimal.valueOf(0) : $V{TOTADJP}) )]]></variableExpression> After dragging a text box into the report and defining it with the same SUM expression, the source code shows: <textFieldExpression><![CDATA[sUM(($V{TOTRECEIPTS} == null ? BigDecimal.valueOf(0) : $V{TOTRECEIPTS}), ($V{TOTISSUES} == null ? BigDecimal.valueOf(0) : ($V{TOTISSUES}*-1)), ($V{TOTXI} == null ? BigDecimal.valueOf(0) : $V{TOTXI}), ($V{TOTXO} == null ? BigDecimal.valueOf(0) : ($V{TOTXO})*-1), ($V{TOTADJQ} == null ? BigDecimal.valueOf(0) : $V{TOTADJQ}), ($V{TOTADJP} == null ? BigDecimal.valueOf(0) : $V{TOTADJP}) )]]></textFieldExpression> Do you have an explanation as to why the variableExpression gave the wrong results when zeros and/or negative values are involved?

I am utterly stumped. I apologize for the very long explanation but I could think of no easy way to describe what is happening. I have several sub-reports in my main report. Each sub-report has a return value all of which I want to summarize and print in a group footer on the master report. The variables in the master and sub reports are defined as java.math.BigDecimal. The variables in the sub-reports all have an Initial Value Expression is set to BigDecimal.valueOf(0). I set the initial value thinking the sub report would return 0 rather than null when no data was found. I am successfully able to return the values and display the variables individually in the group footer. Zeroes display for the sub-reports that don't return any data. I created a new variable in my main report and used the SUM function to add them together (see example below). IF all the variables return values from the sub-reports, the SUM works perfectly, even when one of the values returned is negative. If any of the sub reports return 0 (eg null), things go south from there. A=10, B=10, C=10, D=10, E=10, F=-10 all add up correctly to 40. Note the negative value for F BUT A=10, B=10, C=0, D=10, E=-10, F=0 my sum is 30. A, B and D are added together and the negative value in E is ignored. Note I do need to “reverse the sign” on two of the incoming values but that does not seem to affect the end result. SUM (($V{A} == null ? BigDecimal.valueOf(0) : $V{A}), ($V{B} == null ? BigDecimal.valueOf(0) : ($V{B}*-1)), ($V{C} == null ? BigDecimal.valueOf(0) : $V{C}), ($V{D} == null ? BigDecimal.valueOf(0) : ($V{D}*-1)), ($V{E} == null ? BigDecimal.valueOf(0) : $V{E}), ($V{F} == null ? BigDecimal.valueOf(0) : $V{F}) ) To troubleshoot the issue with the SUM function, I define some additional variables to see what would happen if I put the value of the return variable into a second variable without any manipulation. These new variables are also defined as java.math.BigDecimal. $V{ATEST} expression is $V{A} $V{BTEST} expression is $V{B} $V{CTEST} expression is $V{C} $V{DTEST} expression is $V{D} $V{ETEST} expression is $V{E} $V{FTEST} expression is $V{F} This resulted in some unexpected behavior. I printed the initial return values as well as the second set of variables on the report in the same band and got different results. Displaying $V{A} through $V{F} in group band: A=10, B=10, C=0, D=10, E=-10, F=0 (perfect, exactly what I expected) ATEST=10, BTEST=10, CTEST=0, DTEST=10, ETEST=null, FTEST=null It seems the negative value in $V{E} is not being carried over into $V{ETEST} resulting in null AND mysteriously affecting the value in $V{FTEST}. If all the variables return values, the variable with the negative variable $V{ETEST) still displays null as does $V{FTEST) BUT the sum works and correctly adds all the values. I am beginning to believe I have stumbled on a bug. Any suggestions would be greatly appreciated. Lori

I agree that it is a permissions issue. I am running windows 7 and have full admin rights on my PC. I gave up trying to "update" JSS and just installed 6.0.3 on its own and then uninstalled 5.5.0. A co-worker still as 5.5.0 and as you suggested, he ran JSS "As Administrator" and the update could then be applied.

I have version 5.5.0 of Jaspersoft Studio. When I click the Check for Updates menu option it tells me 6.0.3 is available but I have "Insufficient access privileges to apply this update." Why?

Thanks. This helps.

We just installed the community edition and we have developed a few basic reports with input controls. Our customers are asking if they can save their preferred input control settings so they don't have to keep entering them every time they want to run the report. The Save button is disabled in the repository. I reviewed the "Editions" page and found a reference to Save Interactive Viewing Changes Available in the PRO Edition. This appears to be what we want but it is not clear if the ability to save changes applies to any report that has an input control or is it limited to those specifically designed for sorting, formatting and column manipulation. I am trying to figure out if we would need to redesign our existing reports to take advantage of saving parameter settings. Thanks .