scottmacpherson
-
Posts
23 -
Joined
-
Last visited
Content Type
Profiles
Forum
Events
Featured Visualizations
Knowledge Base
Documentation (PDF Downloads)
Blog
Documentation (Test Area)
Documentation
Dr. Jaspersoft Webinar Series
Downloads
Everything posted by scottmacpherson
-
Does string contain any of a list of values?
scottmacpherson replied to scottmacpherson's topic in Products
Cracked it: for some reason doing a .trim on the field solves everything. I have no idea why blank characters are being added to the field, and whether this is my database or iReports doing this, but problem solved. -
Hi all. I'm struggling this one. I want to find out if a field equals any of a list of values. Hard to explain, but I basically want to do an SQL IN type query, but in a report expression. I've tried using: Code:$F{Field}.matches("(bananas|apples|oranges)"«»)with no sucess. In the above example, I want TRUE to be returned if the Field contained either 'bananas', 'apples' or 'oranges', but not anything else. I also fiddled with the syntax of the above, but even something like: Code:[code]$F{Field}.matches("^(bananas|apples|oranges)$"«»)doesn't work. Any ideas on how to achieve this, or pointers as to where I'm going wrong with .matches? Thanks.
-
By resetting all properties, you would also reset the object's contents. This would therefor be the same as simply creating a new instance of the object, i.e. draw a new one!
-
This has kind of already been implemented: if you have the Element Properties Docking Pane open, certain properties have little flowery disk button things next to them. Hitting these buttons sets the properties back to default.
-
Anonymous access denied after 1.2.1>2.0.0
scottmacpherson replied to scottmacpherson's topic in Products
gvangeel wrote: I have set the security in the "filterInvocationInterceptor" bean, as described in the first posting of this thread. cfr.: /flow.html=ROLE_ANONYMOUS,ROLE_USER,ROLE_ADMINISTRATOR Did this solve your problem gvangeel? -
I have just updated our JasperServer instance from 1.2.1 to 2.0.0, and can no longer run reports anonymously from a URL. I used to be able to open a browser and go straight to something like: http://server:8080/jasperserver/flow.html?_flowId=viewReportFlow&reportUnit=report_name After changing the following line in applicationContext-security.xml: /flow.html=ROLE_ANONYMOUS,ROLE_USER,ROLE_ADMINISTRATOR I get "Access denied: You do not have permission to take the requested action" Help!
-
hingerl wrote: hi there, i miss "fields,variables,parameter" docking-panes. I have only "Page, Pagenumber, Total, Percentage" where is it gone?? :S These elements can now be found in the 'Document structure' docking pane, which can be viewed by going through the 'View > Docking panes' menu.
-
Have you discovered the 'lastPageFooter' band? Does exactly what it's title suggests: only prints on the very last page of the report.
-
I've been using it all day under Mac OS X and it certainly feels like the fastest release I've ever used, even with real-time validation enabled. I haven't personally found any new little things yet, but there's always something in new releases that makes me smile: I just haven't found it in 2.0.0 yet :)
-
I concur! I can't tell you how many times I've sat down in front of iReport and just smiled at the latest really neat trick I've discovered! Keep up the good work all!
-
It sounds like you just need to create a group in the report, with a condition something like Code:$F{Field1}+$F{Field2}+$F{Field3}+$F{Field4}Put those 4 fields in the group header, then put the remaining fields in the detail section. Jasper will then start a new group, and display fields 1-4 when any of them change, and list the broken-down data below the heading.
-
I'm having problems with leading zeros being excluded from reports which are exported to Excel, and having read all the threads in this forum on the subject I know I should consider fidding with the IS_DETECT_CELL_TYPE parameter. Problem is, I don't know where to set this parameter. I'm creating reports using iReport, and then placing them on a JasperServer server, which is then accessed by users using a web browser. It sounds like I need to change the export parameter on the JasperServer side of things, and not in the actual report JRXML. If I'm correct, can someone point me in the right direction? Many thanks.
-
ireport 1.3.2 work fine in linux, not in windows
scottmacpherson replied to dr_pompeii's topic in Products
This could be caused by slight variances in the fonts used in your reports between the two operating systems. JasperReports will not render text fields if the height of the text field is less than that of the height of the font selected, the field will appear empty. Try increasing the height of the problematic fields. -
I would say it's definitely worth it! I constantly find myself flicking to the iReport user guide to find something out. It's sometimes nice to have a description of what each element property does in front of you. I've picked up a lot of useful hints from them as well.
-
I've found that some pathnames don't work with this - nothing ever happens once iReport has run the "open" command. Doesn't seem to like spaces. Does anyone know of a way to bring more control to the "External Programs" settings? I'd like to be able to surround the command run in quotes, but there doesn't seem to be a way to determine where in the command iReports puts the filename. I'd like to be able to do (WITH the quotes): Code:"open %filename"
-
I've just started using iReport in OS X myself, and the solution is actually rediculously easy: In the iReports setting dialog, under "External Programs", simply put the command "open" (without the quote marks) in the viewer text box for each type of file you want to build and open. This command effectively tells OS X to open the file generated in whatever application it would be opened in if you double clicked it in Finder.
-
If you are exporting this report to Excel, then I'm willing to bet that Excel is the problem! Try outputting your report to another format, such as PDF, and have a look at the results. If the numbers are formatted as you originally specified, then the problem is Excel trying to be clever. The only solution I can find to this annoying behaviour is to export the report to CSV, and then import it into Excel, making sure it treats each column as text.
-
If you want to use a static title, ensure you've got double quotes around the text. For example: "Chart Title"
-
You're a star - thank you very much! I was afraid it was going to be a bit more complicated than that :)
-
Yep, that's exactly what I'm trying to do wbizzare, but I don't know how to format a parameter in the way required for the SQL statement. If I use the following in my SQL statement: Code:SELECT...WHERE column1 IN $P!{parameter}(where parameter stores the result of the multi-select), it is parsed as follows: Code:[code]SELECT...WHERE column1 IN ([A, B, C])What I want is for the parameter to be sorted out so that the final outcome is: Code:[code]SELECT...WHERE column1 IN ('A', 'B', 'C')It is this reformatting of the parameter value that I don't know how to do. I've got virtually no Java experience, which isn't helping my case!
-
I am trying to use a multi select query in one of my reports, but cannot get the results of the user input to pass to the report's SQL statement correctly. I understand that in order to achieve this I need to convert the java.util.Collection parameter into a string, and at the same time make this string SQL friendly (i.e. in the format "'A', 'B',...". There are several posts in this forum which almost answer my question, but not quite! Can anyone lead me in the right direction? Many thanks.
-
Have attached the full jrxml file for this one. Could it be something to do with the fact that the database field is a timestamp? I still don't understand why iReports works fine though. [file name=AbsencesBySPRBatch1.jrxml size=15579]http://www.jasperforge.org/components/com_joomlaboard/uploaded/files/AbsencesBySPRBatch1.jrxml[/file]
-
I am struggling to get a report with has a data input control working through JasperServer. The problem appears to be that the date entered by the user at runtime is sent to our data source in an incompatible format. The database is Oracle 9.2.8, and the JDBC driver is from the Oracle 10 instant client. The date is selected by the user using the calendar tool, ending up with something like "15-02-2007". However, by monitoring the output to the database, the date is sent as "Thu Feb 15 00:00:00 UTC 2007". This obviously causes an Oracle error. If we run the same jrxml file through iReport, it works perfectly. iReport seems to know how to handle the date correctly. Even more confusing is the fact that this was all working perfectly yesterday, but stopped today. We can't think of anything that could have changed!
