-
Posts
129 -
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 Scott Andersen
-
Make the subreport position relative to the previous subreport, not relative to the top of the band.
-
Stap to geometry not working properly ? (6.20.3)
Scott Andersen replied to PC0101's topic in Products
I'm unable to reproduce. Do you have a jrxml sample that shows this? -
One copy of each of the three detail bands are generated for each row in the main query. To get a single occurrence of each sub report, put the subreport on the "Title" or "Summary" band. In your case I would put them on the "Summary" band.
-
The key is to create a query that returns the data so that a single row from the query result is a row in the table. If this is possible, you can then create the chart using either a Table component or just the detail band. If the query returns a separate row per cell, you may be able to use multiple columns in the report design. Set the # of columns in the page layout to reflect 31 columns.
-
Did you re-install the repository database or just the server? The "ilike" statement is postgres and would not work well with MySQL. This would happen if somehow the server thinks it is using postgres still. To move from Postgres to MySQL, I would recommend exporting the repository, do a clean from-scratch build using MySQL, and importing the repository. Since you are using a commercial product, have you reached out to Jaspersoft Production Support on this?
- 5 replies
-
- postgresql
- mssql
-
(and 1 more)
Tagged with:
-
At what point are you encountering the errors? When installing or when starting the server? The errors you are seeing - do they appear in which log file?
- 5 replies
-
- postgresql
- mssql
-
(and 1 more)
Tagged with:
-
Have you tried exporting using the UI?
-
Using the attributed data source feature you can include attributes from the user to make the data source point to different databases for each user. - You need to add the database name as an attribute to the user. (Chapter 2.4 in the admin guide linked below) - You need to have the attribute referenced in the data source. (Chapter 4.1 in the admin guide linked below) Check out the Administrator Guide (https://community.jaspersoft.com/documentation/v8-v80-v800/tibco-jasperreports-server-administrator-guide) for information on how to do this. Using token based security, this can be passed in via the URL. See the Authentication Cookbook (https://community.jaspersoft.com/documentation/v8-v80-v800/tibco-jasperreports-server-authentication-cookbook), Chapter 6, to see how to do this.
-
Add zone Time to my field date of type String
Scott Andersen replied to salma.aboumzrag's topic in Products
The "java.text.DateFormat.format()" method is used to format a Date into a specific formatted string. You seem to be trying to take a string field and translate it into a Date" object. This requires different java code. To format a date into a specific string format, use the "Pattern" or the "PatternExpression" property of the text field. -
Using Resources in n Adhoc template
Scott Andersen posted an entry in Best Practices
Scott Andersen posted an entry in Best Practices
Sometimes you want to vary text on a template that is being applied to an ad hoc report, based on the locale of the logged in user. This article reviews how this can be done. Create a resource file. You can do this using Jaspersoft Studio, which also facilitates translation of resources.Select “File”, “New”, “Other” Select “Messages Editor”, “Resource Bundle” Edit your locale bundle. Use Properties tab to add, remove propertiesUse language specific tab to edit valuesUse “New” tab to create new files for specific languages. Load the resource file(s) into JRS.“Add Resource”, “File”, “Resource Bundle”, Select the file, name the file (without the “properties” extension), Resource ID is the full file name. Edit your template in Jaspersoft Studio.Add a text field to the template, using the “$R{}” constructUpdate the “<jasperReport “ entry in the template jrxml source to include the following before the “uuid” property. resourceBundle="repo:/public/Templates/myTestBundle" whenResourceMissingType="Key"Publish the template as described in the Jaspersoft Studio Users Guide.Load any new resource files for additional languages in the same location in JRS.The template can now be used to apply locale bundle based resourcees to your ad hoc reports. -
In the Variable "Expression" are you putting the IF logic? Remember that the results of the expression needs to match the Variable field type. Post a jrxml file if possible.
- 4 replies
-
- jaspe report; jasper studio
- variables
-
(and 1 more)
Tagged with:
-
You can use the "jobs service" to trigger an immediate execution of the report and send the pdf to the server at a specific location. https://community.jaspersoft.com/documentation/tibco-jasperreports-server-rest-api-reference/v8/jobs-service#Creating_a_Job You may also upload the file to the location using the resource service. https://community.jaspersoft.com/documentation/tibco-jasperreports-server-rest-api-reference/v8/resources-service#Creating_a_Resource
-
Return value of variable is null inside report
Scott Andersen replied to mpolo91's topic in Products
A couple of things to check: - Make sure the Variable has an "Initial Value Expression" set, or that the Variable :var_x" is populated before the above expression is executed. - Check the "Evaluation Time" of when the variable is used. Confirm the other properties around the Variable. -
You can use a formatted "Text" component. The "Text" component has a "Mark up" property that allows you to put styles into the text field. You can then make your list. Valid values of Mark up included "Styled", "rtf", and "html".
-
To answer a question, log into the community and you should see a "Post Answer" link at the bottom of your question.
-
How to sum a row dynamically from different lists in json format
Scott Andersen replied to kliuvinis1's topic in Products
You can use a variable that adds up the individual fields and display it. You can then create a sum on the variable. -
Problem rendering data in a Sub Report powered by JSON
Scott Andersen replied to twin_resources's topic in Products
The Table components in the subreport need to each have a data source expression, similar to the table component in the main report. -
The records displayed in a report is driven by the query. I find that if duplicate records are being produced it is a result of a poorly formed query. I agree with mahadiosb that posting the jrxml (as well as the query) may help identify the issue.
-
How add background image from Oracle database?
Scott Andersen replied to Eyesmagicx's topic in Products
Check out this question/answer: https://community.jaspersoft.com/questions/1139756/print-image-blob-database-field -
The proper format is MM/dd/yy h:mm a the two hh gives you the 24 hr clock.
- 2 replies
-
- jaspersoft
- reports
-
(and 4 more)
Tagged with:
-
You can use Jaspersoft Studio to execute a query in a report. That query can be used in the report itself or can be published as a Topic" to the server. Check out the Jaspersoft Studio User Guide for more information; https://community.jaspersoft.com/documentation/tibco-jaspersoft-studio-user-guide/v8/creating-and-uploading-topic-ad-hoc-views
-
Answers in the community are on the basis of when a community member has an answer. If you look at the "Answers" page, most questions get viewed multiple times within a few hours. Answers depend on the skillset of the community members. As possible Jaspersoft employees will also look into responding to questions.