cschnell

We're using Jasperserver 6.4.2 community version. I'm trying to give access to the anonymous user so that they can run a report from within another program on our server. I have followed the instructions from this question: https://community.jaspersoft.com/questions/847771/anonymous-access-jasperserver-601 Including the changes to the files mentioned in this article: https://community.jaspersoft.com/wiki/allow-anonymous-access-reports When I try to run the report using this URL, I get the below error. http://localserver:8080/jasperserver/flow.html?_flowId=viewReportFlow&_flowId=viewReportFlow&ParentFolderUri=/reports/Order_Sheet&reportUnit=/reports/Order_Sheet&standAlone=true&j_username=anonymousUser&j_password= Server ErrorError MessageThere was an error on the server. Try again or contact site administrators. Any help would be appreciated.

As helpful as that might be to others, it is not to my application, as I'm trying to recreate forms, not plot graphs, and my company is committed to Jaspersoft, so it would not be my call to make to change. Nor, through looking quickly at ggplot, do I see how it applies to my initial question.

In an effort to make this more clear: I'm trying to automate having a different field to trigger a condition in the current field, but the field names are related. In generic code, I would just do this: if fieldname_Changed ==1 then fieldname background = yellow. I have 100+ textfields I'm displaying in my report. Each of these have a change flag associated with them which are also brought in as indiviual fields in the query. Using the flags that the data had been changed I want to highlight the value in the textfield. I know this can be done with conditional styles and know how to do that on an individual field basis. But I don't want to create 100+ styles. Is there some way to tell the system to use the current expression to check another field? Or is there a way to create a variable for the condition to check the field name, and based on that use the field's flag to set the conditional expression? Basically I want a style's conditional expression something like this where $F{} is the current field's name. I tack on " Changed" to the end to make my flag's name and if that flag is equal to one then the style highlights. But I don't know what to put instead of $F{}. $F{CONCATENATE($F{}," Changed")}==1 So if the field I want to use the style on is $F{CUSTOMER} the expression would become $F{CUSTOMER Changed}==1. Then on the next field that uses the same style would be $F{ADDRESS} the expression would become $F{ADDRESS Changed} == 1 and so on times 100.

Perhaps my wording was wrong. I am trying to change which data source a single report is linking to. Inside the repository, editing the JRXML report, on the page called Link a Data Source to the Report, I have changed the data source (created as you mentioned) from the repository to my development data source and saved. (similar to this page https://community.jaspersoft.com/documentation/jasperreports-server-user-guide/defining-data-source ) While investigating this, however, I found that my input parameter was linked to the production data source. This is why the report didn't appear to be changing. I thought I had it linked to no data source. Once I changed it, it is now working properly. When I run the report, it still shows data from the previous data source.

In Jaspersoft Studio I can swap between my development and production databases easily by changing the data source when doing a preview. I use the same data sources on the server. Months ago I changed all my reports on the server from development to production datasources and they changed over fine. I am trying to change one back to the development data source now. Nothing I do seems to affect it, even changing to a sample data source. I don't get any errors, it simply is only showing me data from my production DB. I tried changing the data source through the repository and while publishing the report. I even restarted the jasperserver. i get the same results. Did I miss something when changing the data source?

Ah, I missed created a group inside the Dataset! Thanks for pointing me in the right direction.

Please elaborate, because as mentioned in my question, I tried using groups but it only put one of the notes per page. I need it at the begining of every new category. There may be ten different categories per page hence 10 notes. So is there a way to do this with groups in a normal table? I'm also not using any sort of total, just listing the values which are normally strings.

I have a table that lists fields from my database with their data and what category they're in. Each category has a note attached to it. I have a query that works fine combining these but I can't seem to get the note to show up for each category. I used column groups, but it only adds one per page, not at the begining of every category. Can this be done in a table? In theory it should look something like this: |Category1 | Note1 | |Category1 | Field1 | Value1 | |Category1 | Field2 | Value2 | |Category2 | Note2 | |Category2 | Field1 | Value1 | |Category2 | Field2 | Value2 | I understand I can use crosstabs to do this, but I can't find a tutorial for working with crosstabs in this mannor. All deal with totals and such. That is much more complex than I need, I just need a simple example of something like this. So how would I do this in a cross tab? Can someone point me to an example?

While I thought I had my parameters mapped, apparently you also need to have the below parameter in the "Parameters Map" expression. $P{REPORT_PARAMETERS_MAP} After I added this, it worked.

I have a table in a sub report. If I preview the subreport, it shows the data in the table. If I run the subreport on the server it does not show the data in the table, but all other data in the subreport is fine. Same if I run a preview of the Master Report. On the other hand, the same table was used straight in a master report and did not show the data. I only have one parameter I'm passing down and I must be passing it okay if the data does show in the one. So what else could be stopping the data from showing?

I'm trying to rebuild a report that used to be written manually in Word. That report had a table in the middle of page 1 that listed multiple orders and then had a break for other data and finally was continued on page 2. Some of the orders are single line some are multi line. So the first page may have 1 or 6 orders depending on how much room they take up. The rest basically overflow onto page 2. My task is to reproduce these reports exactly, but I don't see how to exactly do the "continued" portion of the table. I can basically "split" the tables through the query using limits and offsets. Similarly I can split the table based on the number of rows using an expression, but the extra lines don't go into the next group. However, both solutions are estremely limited because if the first table has one or two multi line entries the others get pushed under the data that is between these two tables and the second table, starting at a specific offset won't pickup those "hidden" entries. I think the biggest problem is because I need to use groups to split the pages to have the rest of the data other than the table. Group 1 Header 1 __________________________ |Table 1 | Order 1 |Price| | | Order 2 |Price| | | 2 Line 2| | | | Order 3 |Price| | | 3 Line 2| | | | Order 4 |Price| __________________________ Other field information half the page (hidden lines 5 and 6 behind these ) Group 2 Header 1 __________________________ |Table 2 | Order 7 |Price| | | Order 8 |Price| | | 8 Line 2| | | | Order 9 |Price| __________________________ Other field information half the page So is there any way to limit a table simply by its height. So basically Table 1 would only have 3 items and table 2 would have 6 in the above case. Or if the orders were only single line the first table would have six and the second only 3?

I have 20+ reports that have the same header with a bit of data from the DB. I created a subreport to handle any changes to that header. I added page numbers to it as well. The page numbers I managed to get working using the variable for MASTER_CURRENT_PAGE and MASTER_TOTAL_PAGES. Individually, these reports work great. For single page reports it shows Page 1 of 1, if the report goes beyond one page it shows Page 2 of 2, etc. I then created a book to collate all of these reports. Because I'm using MASTER_CURRENT_PAGE, I believe the (sub)subreport for the header is using the book's page numbering and not my individual report page numbering. As this isn't a true book and just a collation of reports, I don't want it to be Page 1 of 20, I want it to be Page 1 of 1. Is there some other way to do the page numbering in the header subreport without putting them in each report? I know some people had mixed luck with passing the pagecount between the report and subreport and it's not recommeneded. Better yet, is there a way to reset the master variables after each subreport?

Unfortunately, that's not an issue at this time, as these are new reports I'm still running them only as admin. It is a good point though, and I just double checked, but everything looks fine roles wise.

I have a subreport that I use in the header over multiple reports. It works fine, except, if I make a change to this subreport (the appearance not the data), compile and publish it, it does not update on any of the reports on the server. It works fine in Studio 6.4.3, the changes show up almost immediately, but they do not on the server. The only way I'm able to get them to appear on the server is to republish each report it belongs to and overwrite the resource. This kind of takes away from the point of using a subreport. I could make those changes on individual reports then. It's not just this subreport either, it's all of them I use throughout the reports. I'm currently using the expression "repo:Project Packet Sheet Header.jrxml" I've tried pointing to the .jasper and using a subdir parameter like $P{BASE_DIR} + "Project Packet Sheet Header.jasper". There is no difference. I also don't understand why jaspersoft insists on copying every resource into a sub directory for every report in the repository. This is what I'm thinking is the root cause as these don't seem to be updating properly. I've tried doing a refresh on the files in the Repository Explorer in Studio too and that doesn't seem to do anything. Why does it not just point to the place where the original resides in the repository instead of copying the file? I've searched and read about everything I could find on subreports and all imply this is the correct method and should work. But maybe there's still something wrong in my execution? Page header call to subreport: <pageHeader> <band height="122"> <property name="com.jaspersoft.studio.unit.height" value="inch" /> <frame> <reportElement key="" x="22" y="0" width="549" height="121" uuid="0365d8c0-8d9a-4e2b-b7af-be2a1270fc47" /> <staticText> <reportElement style="SimpleField" x="218" y="1" width="295" height="20" uuid="7fe79de1-f522-4b4f-9fd4-738dc91b311a"> <property name="com.jaspersoft.studio.unit.height" value="px" /> </reportElement> <box> <topPen lineWidth="0.0" /> <leftPen lineWidth="0.0" /> <bottomPen lineWidth="0.0" /> <rightPen lineWidth="0.0" /> </box> <textElement textAlignment="Right" verticalAlignment="Middle"> <font size="16" isBold="true" /> </textElement> <text><![CDATA[ENTIRE ORDER]]></text> </staticText> <subreport> <reportElement x="0" y="8" width="549" height="88" uuid="185cba3a-0013-489c-a6ce-8d148579ab8a" /> <subreportParameter name="Order_ID"> <subreportParameterExpression><![CDATA[$P{Order_ID}]]></subreportParameterExpression> </subreportParameter> <connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression> <subreportExpression><![CDATA["repo:Project Packet Sheet Header.jrxml"]]></subreportExpression> </subreport> </frame> </band></pageHeader>[/code] Subreport: <?xml version="1.0" encoding="UTF-8"?><!-- Created with Jaspersoft Studio version 6.4.3.final using JasperReports Library version 6.4.3 --><jasperReport xmlns="http://jasperreports.sourceforge.net/jasperreports" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports http://jasperreports.sourceforge.net/xsd/jasperreport.xsd" name="ProjectPacketSheetHeader" pageWidth="550" pageHeight="752" columnWidth="550" leftMargin="0" rightMargin="0" topMargin="0" bottomMargin="0" uuid="793253aa-7bb3-42ed-8b7a-0bf8a8625b29"> <property name="ireport.jasperserver.url" value="http://cpreport:8080/jasperserver/"/> <property name="ireport.jasperserver.user" value="jasperadmin"/> <property name="ireport.jasperserver.reportUnit" value="/reports/Project_Packet_Sheet_Header"/> <property name="com.jaspersoft.studio.data.defaultdataadapter" value="Order Log"/> <property name="com.jaspersoft.studio.data.sql.tables" value=""/> <property name="com.jaspersoft.studio.data.sql.SQLQueryDesigner.sash.w1" value="0"/> <property name="com.jaspersoft.studio.data.sql.SQLQueryDesigner.sash.w2" value="1000"/> <property name="com.jaspersoft.studio.unit." value="pixel"/> <property name="com.jaspersoft.studio.unit.pageHeight" value="inch"/> <property name="com.jaspersoft.studio.unit.pageWidth" value="inch"/> <property name="com.jaspersoft.studio.unit.topMargin" value="inch"/> <property name="com.jaspersoft.studio.unit.bottomMargin" value="inch"/> <property name="com.jaspersoft.studio.unit.leftMargin" value="inch"/> <property name="com.jaspersoft.studio.unit.rightMargin" value="inch"/> <property name="net.sf.jasperreports.print.create.bookmarks" value="true"/> <property name="com.jaspersoft.studio.report.description" value=""/> <property name="ireport.jasperserver.report.resource" value="/reports/Project_Packet_Sheet_Header_files/main_jrxml"/> <property name="com.jaspersoft.studio.unit.columnWidth" value="pixel"/> <property name="com.jaspersoft.studio.unit.columnSpacing" value="pixel"/> <template><![CDATA["repo:ProjectPacket.jrtx"]]></template> <subDataset name="Customer Orders" uuid="2f22f3a6-9ebc-4bff-8fa0-16d586a8b88c"> <property name="com.jaspersoft.studio.data.defaultdataadapter" value="Order Log"/> <property name="com.jaspersoft.studio.data.sql.tables" value=""/> <parameter name="Order_ID" class="java.lang.String"/> <queryString> <![CDATA[sELECT order_id,level FROM customer_orderswhere order_id = $P{Order_ID}]]> </queryString> <field name="order_id" class="java.lang.String"> <property name="com.jaspersoft.studio.field.label" value="order_id"/> <property name="com.jaspersoft.studio.field.tree.path" value="customer_orders"/> </field> <field name="level" class="java.lang.Integer"> <property name="com.jaspersoft.studio.field.label" value="level"/> <property name="com.jaspersoft.studio.field.tree.path" value="customer_orders"/> </field> </subDataset> <parameter name="Order_ID" class="java.lang.String"/> <queryString> <![CDATA[sELECT order_id,max( case when field_setup_id = 1634 then order_log_field_values else null end) as 'Job Info - PO Number',max( case when field_setup_id = 450 then order_log_field_values else null end) as 'Job Info - Quote Number',max( case when field_setup_id = 451 then order_log_field_values else null end) as 'Job Info - Sales Person',max( case when field_setup_id = 452 then order_log_field_values else null end) as 'Job Info - Sales Order Number',max( case when field_setup_id = 453 then order_log_field_values else null end) as 'Job Info - Serial Number',max( case when field_setup_id = 1799 then order_log_field_values else null end) as 'Job Info - Order Date',max( case when field_setup_id = 458 then order_log_field_values else null end) as 'Job Info - Duplicate/Similar' FROM order_log_field_setup where order_id = $P{Order_ID}]]> </queryString> <field name="order_id" class="java.lang.String"> <property name="com.jaspersoft.studio.field.label" value="order_id"/> <property name="com.jaspersoft.studio.field.tree.path" value="order_log_field_setup"/> </field> <field name="Job Info - PO Number" class="java.lang.String"> <property name="com.jaspersoft.studio.field.label" value="Job Info - PO Number"/> </field> <field name="Job Info - Quote Number" class="java.lang.String"> <property name="com.jaspersoft.studio.field.label" value="Job Info - Quote Number"/> </field> <field name="Job Info - Sales Person" class="java.lang.String"> <property name="com.jaspersoft.studio.field.label" value="Job Info - Sales Person"/> </field> <field name="Job Info - Sales Order Number" class="java.lang.String"> <property name="com.jaspersoft.studio.field.label" value="Job Info - Sales Order Number"/> </field> <field name="Job Info - Serial Number" class="java.lang.String"> <property name="com.jaspersoft.studio.field.label" value="Job Info - Serial Number"/> </field> <field name="Job Info - Order Date" class="java.lang.String"> <property name="com.jaspersoft.studio.field.label" value="Job Info - Order Date"/> </field> <field name="Job Info - Duplicate/Similar" class="java.lang.String"> <property name="com.jaspersoft.studio.field.label" value="Job Info - Duplicate/Similar"/> </field> <group name="Group1"> <groupExpression><![CDATA[$F{order_id}]]></groupExpression> </group> <summary> <band height="90"> <componentElement> <reportElement x="51" y="53" width="18" height="18" uuid="07df2046-ce9e-4afd-adde-ad7bcb66e57e"/> <jr:list xmlns:jr="http://jasperreports.sourceforge.net/jasperreports/components" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports/components http://jasperreports.sourceforge.net/xsd/components.xsd" printOrder="Vertical"> <datasetRun subDataset="Customer Orders" uuid="2b4342a1-2caf-4210-9a2b-62326e97e256"> <datasetParameter name="Order_ID"> <datasetParameterExpression><![CDATA[$P{Order_ID}]]></datasetParameterExpression> </datasetParameter> <connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression> </datasetRun> <jr:listContents height="18" width="18"> <textField> <reportElement style="SimpleField" x="0" y="0" width="18" height="18" uuid="d7a1698b-8034-4fc2-96de-59724139eb13"/> <box> <topPen lineWidth="0.0"/> <leftPen lineWidth="0.0"/> <bottomPen lineWidth="0.0"/> <rightPen lineWidth="0.0"/> </box> <textElement textAlignment="Left"> <font size="12" isBold="true"/> </textElement> <textFieldExpression><![CDATA[$F{level}]]></textFieldExpression> </textField> </jr:listContents> </jr:list> </componentElement> <staticText> <reportElement style="SimpleField" x="14" y="53" width="39" height="18" uuid="a9809d8e-2670-4d47-9c84-abb5ceb2b848"> <property name="com.jaspersoft.studio.unit.width" value="inch"/> </reportElement> <box> <topPen lineWidth="0.0"/> <leftPen lineWidth="0.0"/> <bottomPen lineWidth="0.0"/> <rightPen lineWidth="0.0"/> </box> <textElement textAlignment="Left"> <font size="12" isBold="true"/> </textElement> <text><![CDATA[LEVEL]]></text> </staticText> <image bookmarkLevel="1"> <reportElement x="14" y="0" width="504" height="52" uuid="7e2c0e5d-f88e-48db-8fef-bdca264aeb64"> <property name="com.jaspersoft.studio.unit.width" value="inch"/> <property name="com.jaspersoft.studio.unit.height" value="inch"/> <property name="com.jaspersoft.studio.unit.y" value="inch"/> <property name="com.jaspersoft.studio.unit.x" value="inch"/> </reportElement> <imageExpression><![CDATA["repo:/images/CP_Logo_Header_Plain"]]></imageExpression> <anchorNameExpression><![CDATA["Order Sheet"]]></anchorNameExpression> </image> <textField evaluationTime="Master"> <reportElement style="SimpleField" x="444" y="32" width="69" height="15" uuid="3314d7b9-1f0d-4bfc-b42b-da435538fc16"> <property name="com.jaspersoft.studio.unit.width" value="px"/> </reportElement> <box> <topPen lineWidth="0.0"/> <leftPen lineWidth="0.0"/> <bottomPen lineWidth="0.0"/> <rightPen lineWidth="0.0"/> </box> <textElement textAlignment="Right" verticalAlignment="Bottom"/> <textFieldExpression><![CDATA["Page " + $V{MASTER_CURRENT_PAGE} + " of " + $V{MASTER_TOTAL_PAGES}]]></textFieldExpression> </textField> <staticText> <reportElement style="SalesLabel" mode="Opaque" x="388" y="53" width="63" height="18" backcolor="#F2F2F2" uuid="552f8414-73e0-411a-8e92-72617e8094ac"> <property name="com.jaspersoft.studio.unit.height" value="inch"/> <property name="com.jaspersoft.studio.unit.width" value="inch"/> <property name="com.jaspersoft.studio.unit.x" value="inch"/> <property name="com.jaspersoft.studio.unit.y" value="inch"/> </reportElement> <box> <topPen lineWidth="0.0"/> <leftPen lineWidth="0.0"/> <bottomPen lineWidth="0.0"/> <rightPen lineWidth="0.0"/> </box> <textElement textAlignment="Left" verticalAlignment="Middle"> <font size="12" isBold="true"/> </textElement> <text><![CDATA[REVISION:]]></text> </staticText> <staticText> <reportElement key="" style="SalesLabel" x="0" y="71" width="49" height="18" uuid="2f14731b-33b3-4fba-9e9b-85da8bd4789d"> <property name="com.jaspersoft.studio.unit.height" value="inch"/> <property name="com.jaspersoft.studio.unit.width" value="inch"/> <property name="com.jaspersoft.studio.unit.x" value="inch"/> <property name="com.jaspersoft.studio.unit.y" value="inch"/> </reportElement> <box> <topPen lineWidth="1.5"/> <leftPen lineWidth="1.5"/> <bottomPen lineWidth="1.5"/> </box> <text><![CDATA

It looks like my comment about using raw SQL in the parameter was key. I reread the article I linked and looked for more specfic articles and found it was as simple as putting "@rn1 := if(@pk1=A.order_id, @rn1+1,1) as rowNumber," into the Default Expression of my parameter rn1 and using $P!{rn1} in its place. I kind of wish the documentation on this was a little clearer, but it worked.

The query is creating unique row numbers, the variables in the MySQL, other than being set before the query are only used and updated within this query. I set the parameters in jaspersoft with the default values same as I did with the MySQL set command. This is a self contained table query. The variables/parameters are updated within this query and nowhere else. I did try adding them to the main report, which didn't seem to make a difference. I saw this article which mentions using raw SQL, but I haven't been able to find any examples anywhere and so have no idea if that feature can be used to do what I need.

Thanks, I guess I didn't mention I had created the dataset parameters, but by mapping you mean I have to have them in the main report as well, even if only the table uses them?

I have the following query working fine in MySQL which creates unique row numbers for my query so I can join it with another query. The problem is Jaspersoft Studio of course won't accept variables in the table dataset I'm trying to add it to. I've tried to replace the variables with parameters $P{pk1} and $P{rn1}. I've set the default values to new String() and new Integer(1) respectively. Obviously, I'm missing something because when I run it pk1=1 and rn1=0 for all rows. I'm still not sure if I should be using $P! or $X. I've tried them in various ways and received errors. MySQL: SELECT Quantity.order_id, Quantity.Value as QTY, Quantity.Price as NetEA, Tot.Price as TotalNet FROM( SELECT A.order_id as order_id, A.Value as Value, A.Price as Price, @rn1 := if(@pk1=A.order_id, @rn1+1,1) as rowNumber, @pk1 := A.order_id FROM (SELECT o.order_id, o.order_log_field_values as Value, o.order_log_price as Price FROM order_log_field_setup oORDER BY o.order_id ) A) Quantity[/code] Dataset Query: SELECT Quantity.order_id, Quantity.Value as QTY, Descrip.Value as Description, Quantity.Price as NetEA, Tot.Price as TotalNet FROM( SELECT A.order_id as order_id, A.Value as Value, A.Price as Price, $P{rn1} = if($P{pk1}=A.order_id, $P{rn1}+1,1) as rowNumber, $P{pk1} = A.order_id FROM (SELECT o.order_id, o.order_log_field_values as Value, o.order_log_price as Price FROM order_log_field_setup oORDER BY o.order_id ) A) Quantity[/code]I am using 6.4.3

An update and so slightly different question: I managed to get this to work properly in the preview in Jaspersoft Studio. All fields wrap and flow onto the second page with no gap between Group 1 Header and Group 1 footer. I'm not 100% sure what I did that caused it other than the last thing I remember doing was changing all frames to No Stretch. All text fields have Stretch with Overflow with type relative to tallest object. For the group, I have Keep together selected and split type to stretch. I have both Jaspersoft Studio and Server running on 6.4.3. When I preview the above in Studio it's perfect, only two pages long. When I run it on the server, it's three pages with 90% of page 2 blank other than what flowed over from page 1 (group header). Page 3 is all of the group footer. I tried previewing in different formats, the same as I export to on the server and the results are the same, perfect on studio and wrong on the server. I must be missing a setting on the server, but for the life of me, I don't know what. Anyone have any hints? In addition to the above, I found that the Group Header/Footers could be no more than 600px (on a normal Letter size page). Once I separated the groups more making them less than 600px, the groups then flowed together in both preview and on the server.

I have several reports I've combined into a book. One of which does not always have any results in its table, but it does have a page header and footer. I've been trying to find a way to create a Print When espression that would tell it only to print that part when there is data in the table. I have tried variables, but I can't seem to be able to pass a variable to the book. I've looked through all the built in paramenters and variables, but I don't see anything that would be able to tell if there was data in the report or not. I have "When no Data" set to No Pages (and no details in the table itself) and this still is not helping. What would be the best way to go about doing this?

I have a two page report (using groups to create the second page) the problem is the second page is really just a continuation of the first and if data pushes the first group header onto the second page the second group header moves to the third page, which I don't want. I've tried a multitude of things, single group header/footer, Keep Group Together, Prevent Splits, etc. I can't find a way to keep the data together. To make matters worse, the first page is blank for some reason. This is not a standard table, and by the nature of it, can not be, nor can I use the detail band. I have fields that stretch with overflow and thus push other fields off the first page. I don't want the first fields on the second group/page to jump to the third page. How do I prevent this? This would be easier to describe if I could upload screenshots of the output.

Years later this tutorial helped me get past the issue I had with passing the parameters. Thanks!

Thank you, elizam. It worked. I had seen this part of the manual but didn't understand it was what I needed. Wow. Let me just say that I'm not IT, but I have been admin to some complex systems. This is by far the most convoluted and unintuitive setup I've seen. Without some of the background I've had, I can only imagine how difficult and frustrating this would be for a novice report writer. The number of steps that could cause user error is quite high. I hope others find this answer easier than I.

I am creating a report in Jaspersoft Studio 6.4.3 Community. It looks great in the preview. But if I save it to PDF, or open it on the server the fonts change from Calibri to Helvetica and now all the spacing is off. It's very important that everything fits as the report is tightly packed. Calibri is also our official font, so I can't change it. It's not like Calibri is not available, so why is the font being changed and how do I fix it? Update: I tried following the instructions here: https://stackoverflow.com/questions/19232826/when-export-a-report-to-pdf-change-the-font and I made sure to select "Embed this font in PDF document." It made things worse. The version on the jasperserver looks about the same except a couple places where I didn't use styles is a completely different font and the PDF has entire fields missing and is still Helvetica. Update 2: I was looking at an old PDF. The PDF (from the preview) is now okay, but the version on the jasperserver still looks off and PDF generated from it is wrong. How can I tell if the font information is getting onto the server?

I'm new to reporting tools and we're currently looking for one that would work with a web based app we are building that uses a row based database. The issue is we're not looking for analytics at this time, but to create printable pre-filled forms for distribution of our order entry information. A data sheet is one example of an output we'd like to create. To complicate matters while the report is a table, columns are staggered and tightly fit onto a single page. These were originally filled by hand so the look and feel of these forms should be maintained. Has anyone had experience with something like this in JasperReports?