gert_1
-
Posts
75 -
Joined
-
Last visited
Content Type
Forum
Downloads
Featured Visualizations
Knowledge Base
Documentation (PDF Downloads)
Blog
Documentation (Test Area)
Documentation
Dr. Jaspersoft Webinar Series
Security Advisories
Events
Profiles
Posts posted by gert_1
-
-
Hi Guys,
Have a questions regarding page numbering in a report book. Point is: I have a client that does name-giving of page numbers like this:
- Chapter 1, page 6 (4th page that chapter) = 1-4
- Chapter 2, page 12 (3th page that chapter) = 2-3
- etc.
Now, it's possible to make it happen with al different reports in the Content-section, but How do I display this pages/properties in the table of contents?
The report book supports some method that gives that bookmark-names back, but uses the $V{MASTER_CURRENT_PAGE} to print the page number. How could I show the page-numbers that are actually beneath the pages of the bookmark?
Please let me know, struggle with this one.
Regards, Gert
-
HI Guys,
Every now and then in a table something strange happens. After copy + paste or editing a static text a sort of box goes ariound it (see screenshot, the box is around static text with '28' in it) and makes in impossible to edit.
Fixes are:
- Deletnig the element
- Convert to text field and Convert back to static text
- Restart Jaspersoft Studio.
Of course those are workarounds, what do I do wrong? Or anyone understands what goes wrong?
Regards,
Gert
-
If you go to the expression editor and then go to 'Build-in Functions' you see al the functions and what they return. If you doubleclick on a function it shows you what type of arguments it needs. For example:
Add 'AND( ) ' in the expression editor, and you click between the brackets '( )', it tells you it can have arguments (1-7) and if you hover over the asterix, it tells you that it needs 'a boolean expression or value'
Also this link helps: http://jasperreports.sourceforge.net/sample.reference/functions/FunctionsReport.pdf -
Hozawa is right, I use Git which is a good alternative to SVN and also integrated in Eclipse.
-
Yes this can be done with JasperReport with 1 page and the help of 1 table and 1 subreport.
Main query (dataset):
Here you should make a query and GROUP BY Customer. This way it returns X (is amount of customers) record, and the whole report is repeated X times.
Table on first page:
You have to define table on the first page. As parameter you should send the 'Customer' and then make a query for that tables that returns all the invoices of that parameter (Customer).
If you preview now, you'll see page 1 and page 4 (from your example)
Subreport on second page
Now you place a subreport on the second page. As parameter you give it 'Customer' as well, and you could use the same query: it returns the report as many times as there are records in teh result.
Good luck with it
-
Hi Guys,
Where can I find a complete overview of all available properties of Jasperserver/JSS? I know this site : http://jasperreports.sourceforge.net/config.reference.html but it lacks the 'net.sf.jasperreports.json.source ' as example.
And of some properties it's not clear how to use them. As example this one (http://jasperreports.sourceforge.net/config.reference.html#net.sf.jasperreports.file.repository.resolve.absolute.path) that makes me believe that it's possible to give an alternative path to an image or source (super handy when switching between JSS and server). But it sais: NOTE: By default, this property is not read from the report context. This FAQ shows the additional steps to follow in order to set it on and get it from the report context.
-
Good to hear! Can you mark answer as fixed ? :)
-
It probably does not let you pcik the data source from repository (how to fix: put your XML/A connection in the 'right' folder on server: 'Root-> Analysis Component -> Analysis Connections' then it shows up.
You can always add it afterwards like this; Go to report unit -> Edit -> Datasources ->Select your XML/A connection -> Save
-
Don't know if you tried this, but maybe you'haven't enabled page footer on summary page?
Enable like this:
- Report -.> Properties
- Go to tab 'Report'
- Enable 'Summary With Page Header And Footer'
Hope this does the trick..
-
Hi all,
Recently I discovered this problem, that occurs when you have a report that has an image as background and try to export it to Word. If you put some text in a detail that overlays the image, the image is not shown at all. Can someone tell me what to do to show the image (or text probably like 'SAMPLE' in background) even if the document itself contains text (which is pretty much purpose of Jasper). Replicate by
- Adding background
- Put image in it
- Add text in some detail (lot of text that fills the page)
- Preview (does work in Java preview)
- Export to word: Image is gone
Is already asked before but I couldn't find an answer (https://community.jaspersoft.com/questions/537027/word-report-generation-background-image-using-jasper-reports-or-word-report)
-
Solved it, reference to: https://community.jaspersoft.com/questions/800720/how-access-property-expressions
Request a report propertie with following expression: $P{JASPER_REPORT}.getProperty("ireport.jasperserver.report.resource")
Then some concatenating to do but that's no showstopper.
I am wondering though, where I can find all properties of the aJasper Report (ireport.jasperserver.xx.xx etc.)
-
You should 'register' functions in both jasperreports_extension.properties file and the jasperreports_messages.properties file that can be located in your custom function folder.
You'll need version 6.0.3 btw as well, before that version there was some trouble with those functions see http://community.jaspersoft.com/jaspersoft-studio/issues/3972
Rebooting sometimes fixes the problem in older versions. If it doesn't work, you can try to manipulate the excisting functions (change content etc. so it does what you want and then change is step by step; did help/learn me a lot ).
Good luck!
-
Is there a parameter which I can use in my report that returns me the parent-folders / directory of the location on the server?
I need this so that my report does a request based on the location of the report.
Example:
- (server location report1)
- reports
- acc
- report_unit1 (report-unit)
- report1.jrxml
- report_unit1 (report-unit)
- acc
- Should have a textfield like (www.acc-website.com/picture.png)
- reports
And:
- (server location report1)
- reports
- live
- report_unit1 (report-unit)
- report1.jrxml
- report_unit1 (report-unit)
- live
- Should have a textfield like ((www.live-website.com/picture.png)
- reports
- (server location report1)
-
I don't know. Could it be you didn't add the parameter up front?
-
what is your exact problem and do you have example code?
-
Not sure what you mean, do you mean 'hide the footer of the subreport' or do you mean 'hide the footer of/in the main report on the places where that subreport is printed'?
-
Had this problem as wel, I believe the problem was that I executed my SQL query (Select * (.....) ) accidently on the 'Sample Database' of 'Empty database' instead of the realy Database that actually contained the right records..
Could that be your problem?
-
This is possible with Jasper as well I think (as I learned a week ago), but I think it isn't possible with tables: you should use Crosstables.
They are a little harder to understand and are a little buggy sometimes, but they work really good. You can:
- Sort rows on one specific column
- Fetch the result if it's integer (/number) as 'Sum' 'Count' 'Avarage' etc.
And you can use 'Totals' as well (so total value of A + B + C on 1 row a.e.).
I think/hope this is an answer to your question. Let me know!
-
I think you are using iReport, when you upgrade to Jasper Studio (eclipse based) it's a drag&drop principle (with a little tutorial as well on static vs dynamic images). That's all the advice I can give, good luck!
-
I think rick has a point, maybe better to use 2 different textfields, but that can be a pain as well if you want mulptiple different sizes in 1 line. It can be done like this:
- Go to Text Field properteis -> Tab 'Text Field'
- Set 'Markup' (beneath 'Font') to 'html'
Now you can use HTML expressions in your text field to change font size like:
- "This is normal text <font size='5'>This is a different size text!</font>"
-
Can you upload the jrxml file (or a part of it)? Don't get your exact problem.
-
Do you use a SQL-query dataset? In that case you could use GROUP BY in your expression:
SELECT *
FROM Table
GROUP BY Field1 -
I don't know how to put glow around it, but would a black/grey border help you out?
-
Good to hear this solved your problem. Somewhere on this forum I read that OS X Maverick caused some problems as well (but if that's the cause, it's strange that downgrading worked). Good luck with Jasper Reports, using it for a while and it's a great tool for us:)
Instead of subreport, the list of dataset is giving Infinite loop creating new page due to page content overflow
in Products
Posted
Yeh, first of all since your new try to work with Jaspersoft Studio (iReport won't be supported for long).
And I think you are right, ad new band is better for a List item, since the page header is meant for showing info on top of each page in your report, I would try to make a new band for the List so that it'll show properly