jrechter

Hi all, I'm using v4.5. When I click on a column heading to sort, I continue to be prompted by the input control dialog box. Are there other settings that have to be made? Also, in the documentation, it says that if you right click on a column heading, you are given filtering options. Yet, when I right click on a column heading, nothing happens. How do I get access to the filtering feature? Thanks, Jay

Figured it out. Need to set the directory that I'm saving the report in to permission=read/write/delete

The 'Save' button is disabled when trying to save an Adhoc report to any folder. I log in as a specific user who has read-only permission rights to the Topic and the Domain. Thus, in the Adhoc designer, it allows me to create the report. But when I try to save it, any folder I select disables the 'Save' button. The directories selected have read-only permissions for this user. So why can't I save the adhoc report to these directories? I'm using JS 4.01.

The URL looks correct. The drilldown report is in the Reports/ZDrilldown/ directory. http://192.168.28.120:8080/jasperserver-pro/flow.html?_flowId=viewReportFlow&BNumber=bin1&BinID=1002&reportUnit=%2FReports%2FZDrilldown%2FPhysicalBinsDetail&_eventId_drillReport=&_flowExecutionKey=e4s2&reportLocale=en_US When I log in as JasperAdmin, the drilldown report runs properly from the hyperlink. It fails from the hyperlink when I log in as a user with read_only permissions. Because each report by themselves run properly when I log in as the user with read_only rights, I've assumed that I've set up permissions properly on all objects involved (ie: datasources, datatypes, images, jar files, input controls, etc.)

I've set up two reports, summary and drilldown. Each has a ROLE_INVENTORY permission with read_only access. Separately, when I log in as a user with ROLE_INVENTORY permission, they run fine. But when I set a Sefl-ReportExecution hyperlink from the summary to the drilldown report, I get a denied access error message. Seeing that I can run each separately, it seems I've set the permissions correctly. I'm concerned as to why the hyperlink doesn't see it the same way.

Is there a way to add a 'Refresh' button to the report screen that would simply refresh an existing report. There are times when I run a report, then add a transaction to the database, and have the need to run the report again to see the new data without changing any of the parameters. The only options are to select 'Options' which brings up the parameter dialog box (which I don't need), or 'Back', which takes me to the report list (which I don't want). I was able to do this is Version 3.5 by adding an image to the repository and altering some code in various jsps and javascript files. However, I'm not a programmer by trade and the process isn't as obvious in Jasper Version 4.0.2.

Thanks, the Regular Expression pattern worked, so that's a start.

I'm trying to create an Input Control, Single Value, DataType=text, with a pattern of 00:00:00 (Time in hours, minutes, seconds). When I run the report and type in 01:23:57 for this input control, it tells me my input does not match the pattern. I've put quotes around the pattern string ("00:00:00") but that didn't work. Does anyone know how to set up the pattern string so that the user is forced to enter in the pattern of "00:00:00"?

I have a summary report that list totals of various categories. It filters the data by two parameters, Start and End dates. I've added a Self-ReportExecution hyperlink on the total numbers that, when clicked, passes the Start and End dates, and points to a report that gives the detail data of the category that the total numbers represent. All works well. Once in the detail report, when I hit the BACK button on the browser to go back to the summary report, it then prompts me for the Start and End dates (with the default values - not the values that were originally passed into the detail report) before returning to the summary report. I'm now using JS4.01. Previously in JS3.71, it never prompted me, it just returned back to the summary report. I cannot turn the 'Prompt Always' flag off the summary report because of the Start and End date parameters are required. And I don't want to create a second summary report with a 'Prompt Always' flag turned off. Is there a way to return to the summary report without prompting me for the start and end dates?

I'm having a problem returning to the summary report after hyperlinking down to a drilldown/detail report. The summary report takes on a Start Date and End Date as parameters with the Always Prompt flag=true. In this report, there is a hyperlink (Self-ReportExecution) that passes the Start and End Date and generates a detail report of the selected hyperlink. The problem occurs when you try to go back to the summary report from the detail report. In version 3.71, hitting the Back arrow on the browser returns you directly to the summary report. In version 4.01, hitting the Back arrow brings up the prompts for the Start and End dates with default values (which often differs from selected values) before allowing you to get back to the Summary report. If I turn the Always Prompt flag off, the problem is eliminated, but in this case I can't do that because the summary report requires the Start and End Date parameters. Does anyone know a way to return to the summary report from the detail report without setting a Self/ReportExecution hyperlink in the detail report that points to a second version of the summary report where the only difference is that the Always Prompt flag is off?

I can't seem to get this permission to work. I log in as User1 with Group1 permissions. Group1 has 'Read Only' permissions throughout the repository. I run the Account report and no problem, all works fine. I then log out, log in as Administrator, go to the Repository, right click on Input Controls, and set Group1 permissions to 'Execute Only'. I then log out, log back in as User1 (with Group1 permissions). When I try to run the Account report, I get the 'Access Denied' error. I thought that 'Execute Only' was similar to 'Read Only' rights with the benefit that it would be hidden from view in the repository. I don't want people in Group1 to see the Input Controls (or DataSources, or DataTypes, etc) when running reports from the repository.

That worked. It's back on the left. Thanks.

That didn't seem to work for me. But somehow I got it to dock outside the editor frame in its own frame below the editor. I just kept clicking and dragging here and there, and eventually, presto, it docked outside the editor. I couldn't tell you the steps that made it work. I still can't make it dock to the left side of the screen. I have added the issue as a bug. Thus far, QA has been unable to reproduce the problem. Thanks for taking time to help.

Attached is what I see. Either it's docking the inspector in the editor, revealing no attributes, or its undocking. It won't allow me to drag the inspector to any other place other than the editor frame.

In the new version of iReport 4.0.2, I can't seem to dock the report inspector on the left side of the screen, it only docks in the editor section. As a result, the only way to see the attributes of a report is to undock it. Any suggestions, or is this a bug.

For DB2, I added db2jcc.jar db2jcc_license_cisuz.jar db2jcc_license_cu.jar Don't know the jar files for MS SQL 2008. Do the files in your .../jasperserver-pro/WEB_INF/lib between 4.0 and 3.x differ?

I had the same problem. It may have to do with the bundled package not having the proper db drivers on the server. In our case, when I added the db2 drivers to the C:\Program Files\jasperreports-server-4.0\apache-tomcat\webapps\jasperserver-pro\WEB-INF\lib directory, I got the connection to work.

With Jasper 3.7.6 and a DB2 database, I have a hyperlink on a summary report drilling down to a detail report which passes a string parameter. Although the process worked fine in Jasper 3.5.1, in Jasper 3.7.6, I get a DB2 -302 error message which is 'The corresponding host variable or parameter marker used in the SQL statement is defined as string, but the input host variable contains a string that is too long' Setting Hyperlink Target=Self and Hyperlink Type= ReportExecution, when adding the link parameter, I set the link parameter name as the parameter in the drilldown report, the parameter class name as java.lang.String and the value expression as a string field in the summary report. It seems pretty straightforward but the error occurred when I clicked on the link on the summary report. This problem occurred once we upgraded to Jasper 3.7.6. Does anyone have any suggestions? I tried to .trim() the value expression but to no avail. Thanks

{PAGE_NUMBER} is an Integer Object. You need to get its intValue. Thus, your solution is: new Boolean($V{PAGE_NUMBER}.intValue() = = 1)

We are currently using the 3.5 version of JasperServer. In creating an Adhoc report, I set a criteria for one of our fields, Account Status (dropdown list) with a required value, and then checked the Prompt box. I would then expect that when I open up the Adhoc report, the parameter dialog box would appear (as if I selected 'Always Prompt' on a non Adhoc report). It does not. Instead, the report opens up with the defaulted value, which at that point, you can click on the input control icon and rerun the adhoc report with the desired parameter value. Is there a way to get an Adhoc report to always prompt an input control dialog box before producing a report? Our users don't have access to the repository, so they can't go in later to edit the Adhoc report and set the 'Always Prompt' flag.

I've gotten around this problem by adding a column to my query that calculates the total number of rows in the recordset, then divide by the number of rows on a typical page. This gives me a good estimate of the total number of pages. I then use this field ($V{total_pages} = $F{cnt}.intValue() / 25) in my 'print when expression' (ie: print such 'n such if total_pages >10) The query is similar to the following: with t2 as (SELECT count(acc.account_id) as cnt FROM account acc where amt>10000) Select id, name, cnt from t2, account where amt >10000

Is there any way to change the name of a report? I have a requirement to have a current report name changed to something else. Can I do this without recreating a new report with the required name?

I'm trying to hide a group header band when the total number of pages in the report is less than 5 by using PrintWhenExpression in the band properties. (new Boolean($V{PAGE_NUMBER}.intValue()>5) Seems I can't use $V{PAGE_NUMBER} as part of the expression it automatically sets the page number with Evaluation Time = 'Now' instead of 'Report' Is there a way to hide a group header based on the number of pages in the report?

In iReport, when I set text rotation to left in a static text box, the text fails to rotate in a browser. It works properly when exported to PDF and XLS. Are there any necessary settings to be made in iReport that would rotate text in a browser? Maybe through Custom Properties?

I am using one of my main reports as a subreport for another report, placing it in the report group footer band. This subreport contains custom properties that, for example, exclude page footer rows in an excel spreadsheet. As a standalone report, the excel spreadsheet does exclude these rows, but using it as a subreport placed in the report group footer band of another report, it does not exclude these rows in excel. How can I get the custom properties to work in a subreport? Thanks.