Friendly User
-
Posts
435 -
Joined
-
Last visited
-
Days Won
2
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 Friendly User
-
-
That would involve having a custom data source that would stitch together your JDBC result set and XLS spreadsheet resultset together and then feed it to report for filling. Out of the box there is no datasource like that.
-
I have tested two different versions on my side and it works same for me - I drag the field to the filter pane and a new EQUALS filter is created with first value selected but not applied. If you want to select other values you click on the value and start searching. List type of filter only appears for IS ONE OF type of filters.
Do you consider drop down for equals not appearing immediately after you drag the field to the filter a bug?
-
This will require you to create a completely new role and then define where users with the role can navigate to in the actionModel-navigation.xml. The actions that user with the role can take in the repository is defined in actionModel-search.xml. Both XML files can be found in {JRS-WAR}/WEB-INF/.
For more information on this refer to chapter "Customizing Menus" of the JasperReports Server Ultimate Guide.
-
You will need to use two separate report objects in the band (summary band I guess) - table and crosstab. Both can use same data set or you can use different data sets. When exporting to Excel though I'd recommend to put them both on different sheets as crosstab columns and table columns can have different size and that can cause the exporter to merge a lot of cells and generally give you a messy output. To force a page break add a break element between Table and Crosstab elements. To force Excel exporter to print each page on it's own sheet use this property in the report:
-
You can create a domain based on tables from data source connection and not stored procedure. You can use stored procedure in an ad hoc topic to return fields you want and then build ad hoc view based on the topic. To create a topic simply create a JRXML with a stored procedure call and then upload that JRXML to the server /ad hoc components/topics location.
If you're a licensed user and your implementation is stalled you probably should contact support instead.
-
The multiselect input control is passing the value into the report as a collection. That collection is then used in an $X{IN} statement in the query as I would imagine. The IN statement in SQL translates in exactly what you see in your situation. It shows all the records that contain any of the items from the array. What you would need is probably a different $X{} operation or different query all together but that would depend on how your data is stored in the database.
-
1. Not domain. If you want to use stored procedure for ad hoc you'll need to use a regular topic. Upload a JRXML that calls your stored procedure as a query to the /adhoc components/topics folder and then you can select it when creating a view. You can add parameters to the report and then use these parameters in the query and build input controls on these parameters on the server. When in ad hoc editor you can press a button to bring up the parameter window and pass parameters to the topic.
2. See 1.
3. You can use Visualize.js to embed the dashboard. Visualize.js is a javascript library that allows you to embed content from JasperServer into your own applications. See visualize.js guide for more info on that.
-
Unfortunately it's not possible to make one input control to be dependent on another input control like that unless they are query based. Cascading input controls operate in a sense that selection from one input control automatically is passed to the query of a dependent input control. So if your date ranges are returned by a query then it's possible but I doubt they are. You may want to allow users just to enter both and have an auxilliary parameter in the report that has a default value expression based on the other parameter values and do the calculations in that expression.
-
When you create a domain you specify the domain repository object details first and then click on Edit with Designer hyperlink-like button on the lower part and then go to domain designer. In domain designer select the tables, define joins, derived tables, etc., then go to Display tab and put some objects to be visible.
Once you have a domain designed in the designer and have the save location - your domain will be saveable.
-
Detail band prints as many times as you have rows in the result set. Putting chart to a detail band is not a good solution, The report should add more pages if the summary band stretches beyond the report page size. One thing you can try is Subreports and put the charts in a subreport and subreports in the summary band.
-
The input types on the server need also to be correct. Should be date/time for the date input controls. I guess you already have that. The displayed date for the fields is based on the pattern masks you choose for the text fields. Do you only see this problem for the display or you get actual incorrect time value passed to the calculations?
-
You can only have one summary band in the report.
The reason why your first page is blank is probably because the data is to large to be fit on the page and the Split Type for the Detail band is set to Prevent. You may want to try Stretch instead.
-
JasperServer starting from version 6 has an option to use profile attributes in the data source definitions. Take a look at the chapter 4.1 "Profile attributes in data source definitions" in the JasperServer Admin Guide for more information on the feature.
Another thing you can do to restrict the data based on the user logged in is to use domain data security. For that feature take a look at Chapter 5 in JasperServer Security Guide.
-
One more thing to add to the poster above is that NULL string is different from "" string which is an empty string. Make sure you actually do have nulls when testing that.
-
It looks as if the web client cannot establish connection to the server and does not get back the response with server information from the connection attempt. What exactly is the remote server in this case? Is your server behind a proxy? Are you able to do Test Connection successfully in the server properties? Can you try to do Advanced Settings -> Use SOAP Only to see if you get a more meaningful error than this one?
-
Depending on how you installed the server, your server might be looking for license in an incorrect folder/location. If you used installer, it'll look in the root folder of the installed package. Find the jasperserver.license file there and replace it. Otherwise the server will look for license in the user home folder.
Check out the installation guide for information about how to apply the license and how to troubleshoot issues like this.
-
The description of the input control repository item might be obtained through the /rest_v2/resources service. It will return the generic information about the element. The /inputControls/values request returns all the values that input control allows to have and information about which values are selected. It is an expected result for /values request.
-
This question is a bit confusing, You don't really name objects in iReport / report, when you use expressions you also don't create objects that persist and have to be named. You can give keys to the report elements but that's quite different.
-
If you remove FALSE() from the report design, does it work properly? If yes, you might want to get a false value in a different way instead like java.lang.Boolean.FALSE or just false.
-
1. Make sure in your data adapter you have a proper mask for the date/time fields.
2. Make sure the Java type of the field is appropriate as well, something like java.util.Date.
-
There are no custom validators for the input control elements themselves. You'll probably need to customize the input control JSP or do validation on a report level and run some different version of a report it if the input is not what you expect.
-
Subreports inherit the properties from the main report. You will need to define the properties on the main report level.
-
Remove the extra bands from your report design like ColumnFooter, PageFooter, Summary, etc. Also make sure your detail band does not contain any empty space itself.
-
For the location of the file the JasperServer plugin is looking at the following properties:
<property name="ireport.jasperserver.url" value="http://somewhere:8080/jasperserver-pro/"/>
<property name="ireport.jasperserver.user" value="superuser"/>
<property name="ireport.jasperserver.report.resource" value="/public/report1_files/main_jrxml"/>
<property name="ireport.jasperserver.reportUnit" value="/public/report1"/>Do you have them set in your JRXML? If not, you may want to specify them manually. If yes, are they set correctly?
As for problem #2 try to either re-create the connection to the JasperServer or take a look at existing connection -> advanced settings. There is a property named "workspace folder". It may point to a folder that doesn't exist in your current workspace. Might be worth specifying a concrete folder if none is specified.
Another thing is to try to run JasperSoft Studio with -clean flag to clear your workspace (add the -clean to the .ini file or shortcut target)
Report Generation with Single row when SQL Query is returning Multiple Records.
in Products
Posted
Hello Naresh,
sounds like you need a crosstab with count calculation on the bucket. You can create a crosstab using a crosstab element. Set your company name as row group and your bucket as column group and your bucket as measure. Set the calculation to count.