kheaps
-
Posts
11 -
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 kheaps
-
Not sure if this is a bug.... I have a report with multiple sub reports. The report has the following csv-related properties set. <property name="net.sf.jasperreports.export.csv.exclude.origin.band.1" value="columnHeader"/><property name="net.sf.jasperreports.export.csv.exclude.origin.report.1" value="*"/><property name="net.sf.jasperreports.export.csv.exclude.origin.keep.first.band.2" value="columnHeader"/><property name="net.sf.jasperreports.export.csv.exclude.origin.keep.first.report.2" value="*"/><property name="net.sf.jasperreports.export.csv.exclude.origin.band.3" value="pageFooter"/><property name="net.sf.jasperreports.export.csv.exclude.origin.report.3" value="*"/><property name="net.sf.jasperreports.export.csv.exclude.key.SpaceForNotes" value="SpaceForNotes"/><property name="net.sf.jasperreports.export.csv.exclude.key.Logo" value="Logo"/><property name="net.sf.jasperreports.export.csv.exclude.key.TitleArea" value="TitleArea"/>[/code]Columns from the subreports align properly with each other initially. However, after the spot where a page break would otherwise occur, the columns are all shifting left by one spot (although in other revisions of the report, this # was more at times). Is there a solution to this? Not super important, but would like the CSV to work properly if it's going to be available (and I don't want to more-generally turn off the CSV exporter at the server level).
-
An imperfect solution, for now - sum and divide by two: <propertyExpression name="net.sf.jasperreports.export.xls.formula"><![CDATA["SUM(OFFSET(INDIRECT(ADDRESS(1,COLUMN())),0,0,ROW()-1))/2"]]></propertyExpression>[/code]
-
I have a report in which each band is comprised of a handful of other subreports. Each subreport has a total at the bottom, in the same column as the numbers being totaled. I'm able to get a total at the bottom of the band through passing variables to/from the subreports, but I cannot figure how to write an excel formula that would count the correct number of cells and ingore the subtotals. (I'd like to write a formula in case the end user decides to change rows which cannot currently be populated from the database.) The best I can think of would be to "name" the subtotal cells, and then reference them by name, but I also cannot figure out how name cells using the jrxml.
-
I know the exporters can be broadly turned on and off, and that you could modify templates to be aware of user roles, but is there a way to turn on/off individual formats for an individual report? Ideally, something that could be put into the jrxml like <property name="net.sf.jasperreports.export.csv.enabled" value="false"/>.
-
I know from here that it's possible to set certain properties at the report-level in the JRXML, and it is possible to do so at the application level by modifying webapp/WEB-INF/classes/jasperreports.properties (or any properties file in/below that folder), but is there a way to define an external resource in the JasperReports Server repository that would contain properties shared among a number of reports but not all reports? I'm looking to do something similar to how you can define styles in a .jrtx and then use that file repeatedly. Thanks for your help!
-
There is a button in the ad hoc editor that can be enabled (it is disabled by default) (you must be the super user to enable it) that allows you to view the query that is being sent to the database. In the JasperReports Server 5.5 Admin Guide it's described in section 7.8 Configuring Ad Hoc, 7.8.1 Ad Hoc Query Settings. Not sure where it is in the 4.5 guide, but I'd image it is similar.
-
That is how I understand it. It might process the sum on the java side, though. If you turn on the button that allows you to see the query being sent, you could confirm.
-
per @bobtins above, I can verify that simply sum(a/b) is translated to sum(a) / sum(b), at least in version 5.5 - not sure if that is true in 4.5, but you might want to try it.
-
Interesting... did not realize that it differentiated and did something else for a/b than for 1-(a/b). Using that info, I was able to get around this by creating an intermediary calculated field for retail - discounted (call it dscntdol), then divide dscntdol by retail. I then get the answer I seek, calculated at the last possible moment.
-
Is it possible to create a field that calculates based off the sums of two other fields (i.e., after aggregation)? I have retail prices and discounted prices, and want to create a weighted average discount, which is the sum of all discounted prices over the sum of all retail prices. This is a fundamentally different # than taking the discount rate on a row by row basis and then averaging those numbers. I can figure out how to do the latter (unweighted) calculation in domain designer, and how to calculate something simple like dividing the sum of discounted prices by the total for the column in the adhoc view creator, but not to do a division of two fields post aggregation. Example data: ITEM IDRETAILDSCNTEDDSCNT PCT1108.202105.5032020.00410095.05510095.056104.60TOTAL250227.092 weighted (this row discount/retail) .233 unweighted (average of column)
-
Is anyone aware of whether it is possible to add hyperlinks inside an adhoc view (esp a table)? This would be helpful for drill-down purposes, either by linking within JasperServer or to our production applications.
