Jump to content
We've recently updated our Privacy Statement, available here ×


  • Posts

  • Joined

  • Last visited

zgadson's Achievements


Explorer (4/14)

  • Week One Done
  • One Month Later
  • One Year In
  • First Post Rare
  • Collaborator Rare

Recent Badges



  1. Hello, I've got a 2 parameters that work perfectly, except when they're both in the same query filter. I'm limted to Domain language, so this is what I've got: My field LoadTmsStatus can only be 4 values: Scheduled, InTransit, Delivered, or Closed, and I have a Boolean parameter that selects one or both of these two parameters: $P{InTransitINTERNAL} = new ArrayList(Arrays.asList(new String [] {"Scheduled", "In Transit"})):null & $P{DeliveredINTERNAL} = new ArrayList(Arrays.asList(new String [] {"Delivered", "Closed"})):null Again, they work fine if I only have one of the parameters as a filter, but when I include them both, my report fails. Any help would be greatly appreciated!
  2. Need some help creating a Domain query to pull only select values from a field. In short, I have a "Load.LoadStatus" field name containing only 3 values: OnTime, Late, & Delivered. I also have 3 boolean parameters - one for each status. I want to combine OnTime and Late so I can have a 4th status which will effectively show me everything in transit. (This parameter would be a Multi-Select Query type.) ****** I've tried so many different combinations. Load.LoadStatus == ("OnTime, "Late") Load.LoadStatus in(Ontime, Late) ("OnTime", "Late") in Load.LoadStatus etc. What am I missing?
  3. Hey guys, I've got a timestamp field and I'm trying to create a date parameter to get today's date starting at 00:00:00 and ending at 23:59:59 so the parameter includes all of today. Is there a date/time format I can use in my paremeter to pick "Today()", but set the time for 00:00:00? I can do the same for the end date at 23:59:59. Thank you, Zach
  4. Being limited to Domain Queries I've had a helluva time getting reports to do what I want. Everything is a workaround, and now I'm stuck (again). I've got multi-select parameters that work, however, I can only select one value. If I try to select multiple values I get an error. If I'm understanding correctly, the reason for this is because I cannot use IN in a Domain query. How can I make my parameters work to let me select multiple values? (Parameters are Collections w/ nested strings). Here's my Domain Query: <queryFilterString> LoadRefNum.QualifierName == 'CSTRF' and LoadRefNum.RefNumValue != null and Load.DateTime_PlannedStart in (StartDate:EndDate) and Load.TransportModeName in (TransitMode) and Load.LoadTmsStatus in (TransitStatus)</queryFilterString> Here's my Source Code: <parameter name="TransitMode" class="java.util.Collection" nestedType="java.lang.String" isForPrompting="false"> <property name="com.jaspersoft.studio.js.ic.path" value="/public/Fastway/InputControls/TransitMode"/> <defaultValueExpression><![CDATA[new ArrayList(Arrays.asList(new String[] {"LTL"}))]]></defaultValueExpression> </parameter> <parameter name="TransitStatus" class="java.util.Collection" nestedType="java.lang.String" isForPrompting="false"> <property name="com.jaspersoft.studio.js.ic.path" value="/public/Fastway/InputControls/TransitStatus"/> <defaultValueExpression><![CDATA[new ArrayList(Arrays.asList(new String[] {"InTransit"}))]]></defaultValueExpression> Additionally, my source code and parameters for the above two parameters are identical (minus field names of course), but the default value expression only works for the first one. No matter what I do, I cannot get "InTransit" to be checked by default in the input control. It worked once, and I don't know what I did that made it stop working. Any help y'all could give would be greatly appreciated.
  5. I have been able to create numerous complex reports just by trial and error, but I'm now at an impasse. I only have domain access to create reports, so I cannot use basic SQL select statements. I have a field called Load.TransportModeName and this field only contains 2 values ("LTL" and "TL"). I need an input parameter that asks the user to select one or both of these values. Basically, what I need to accomplish is the equivalent of this (I think), but I need to do it at the query level: SELECT * from Load where $X{IN,load.TransportModeName, param_TransitMode} Would very much appreciate any assistance or guidance.
  6. Hello! I'm trying to pull username into my report, but when I do it's in the format of "username_companyname_hiredate" in a text box. How can I use the Expression Editor to only return the text before the first underscore (username only)? Alternatively, I have another field I can use in a similar format, but with spaces between words ("username companyname hiredate") if that's easier to work with. (We're stuck with using Domain reports, as we do not have access to SQL or other coding properties, so the Expression Editor is our only option to make this work.) Thank you! Zach
  7. Hello. Have a question that I'm sure someone can answer easily. I have a report with a date column in the text field: new SimpleDateFormat("dd-MM-yyyy").format($F{Load.DateTime_PlannedStart})[/code]And I have start/end parameters set to prompt upon report creation: $P{start_date} and $P{end_date}, both with java.sql.timestamp formatting to match the date field. Is there a way to connect the parameters to my date field using the expression fields? (I don't have acess to metadata, so building sql code never seems to work for me, in addition to not knowing where to put it in the source of the report in the first place.) Any help would be very much appreciated. Thank you!
  8. I can see my posts just fine from my own machine, but you are correct. I've noticed they do not show up when I use a computer other than my own. They're all hosted in my Gmail photos which is clearly not working. Can you see the photo here? /sites/default/files/user_uploads/djohnson53/capture_1.png
  9. Hello, I'm having an issue with setting up my data adapter. I've created reports just fine with how it's currently setup, but for more detailed reports I need to be able to access the metadata so I can create 'SQL select' statements using the pre-defined options set in the metadata dropdown if that makes sense. If I click on the text tab at the bottom of this window it gives me the option to modify the code that uses the <xxx> type of language (which I know is still SQL) but whatever I add there never seems to work. I really need access to the metadata to properly build my SQL select statements. Can anyone help me?
  10. Thanks for the reply, however, I do have 2 questions. 1) My data is arranged more in a freeform type of way - I did not use the Table function. Do I need to use the Table for this to work? 2) Below is all I have access to as far as SQL coding. I've tried a few simple SQL Select statements but nothing seems to work in here. Where/how would I add the code you provided? (I'm really not computer illiterate, but this is entirely foreign to me.) Thank you! Zach
  11. Hello, desperately seeking some assistance getting my report to work. I have a logistics report to track freight for my comapny but it returns multiple lines for one order. In the sample of my report below, it returns multiple lines for every one load number, likely due to the data source consisting of multiple tracking updates for every load. That said, how do I filter the Status Update and Status fields to only use the most recent values? What I want is for every load number to be contained to only one line with the most recent update and status. If I can use the expression editor for this, that woud be awesome, but I'd sincerely appreciate any direction or advice. I'm sure it's not as difficult as it seems but I'm completely lost and frustrated. Relevant Code: <?xml version="1.0" encoding="UTF-8"?> <!-- Created with Jaspersoft Studio version 7.2.0.final using JasperReports Library version 6.6.0 --> <queryFields> <queryField id="Load.LoadNum"/> <queryField id="LoadStatusActivity.DateTime_StatusEvent"/> <queryField id="LoadStatusActivity.LoadStatusComment"/> </queryFields> <groupList> <group columnName="LoadStatusActivity.LoadStatusComment"/> <group columnName="LoadStatusActivity.DateTime_StatusEvent"/> <group columnName="Load.LoadNum"/> </groupList> <queryFilterString> Load.LoadNum == 'L181008-00023'</queryFilterString> <sortList> <sortColumn columnName="LoadStatusActivity.DateTime_StatusEvent" ascending="false"/> </sortList> </query>]]> </queryString> <field name="Load.LoadNum" class="java.lang.String"> <property name="com.jaspersoft.studio.field.label" value="LoadNum"/> <property name="com.jaspersoft.studio.field.tree.path" value="Load"/> <fieldDescription><![CDATA[LoadNum]]></fieldDescription> </field> <field name="LoadStatusActivity.DateTime_StatusEvent" class="java.sql.Timestamp"> <property name="com.jaspersoft.studio.field.label" value="DateTime_StatusEvent"/> <property name="com.jaspersoft.studio.field.tree.path" value="LoadStatusActivity"/> <fieldDescription><![CDATA[DateTime_StatusEvent]]></fieldDescription> </field> <field name="LoadStatusActivity.LoadStatusComment" class="java.lang.String"> <fieldDescription><![CDATA[LoadStatusComment]]></fieldDescription> </field> <group name="Load.LoadNum"> <groupExpression><![CDATA[$F{Load.LoadNum}]]></groupExpression> </group> <columnHeader> <band height="44" splitType="Stretch"> <staticText> <reportElement x="0" y="0" width="100" height="30" uuid="3f6001d9-85cd-4717-bbf9-905cf1bbd0f0"> <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="6062cd80-9dfa-4723-9cbe-1d0650881bbd"/> </reportElement> <textElement> <font size="14" isBold="true"/> </textElement> <text><![CDATA[Load Number]]></text> </staticText> <staticText> <reportElement x="120" y="0" width="100" height="30" uuid="36de86f2-54fb-4ab8-95a4-e8c25eb49a61"> <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="af544b8b-36da-498e-8808-8e894aaafae0"/> </reportElement> <textElement> <font size="14" isBold="true"/> </textElement> <text><![CDATA[status Update]]></text> </staticText> <staticText> <reportElement x="280" y="0" width="100" height="30" uuid="6d53d1a5-f2cf-4a99-af28-caacff67c487"> <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="e828e01c-312e-464e-932f-869d1751a788"/> </reportElement> <textElement> <font size="14" isBold="true"/> </textElement> <text><![CDATA[status Comment]]></text> </staticText> </band> </columnHeader> <detail> <band height="24" splitType="Stretch"> <textField> <reportElement isPrintRepeatedValues="false" x="0" y="0" width="100" height="18" isRemoveLineWhenBlank="true" uuid="12a476ec-cf43-4b94-a988-ea00621baf32"> <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="6062cd80-9dfa-4723-9cbe-1d0650881bbd"/> </reportElement> <textFieldExpression><![CDATA[$F{Load.LoadNum}]]></textFieldExpression> </textField> <textField> <reportElement isPrintRepeatedValues="false" x="120" y="0" width="100" height="19" uuid="26c71bd3-5248-4318-b26d-4320d1d84b80"> <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="af544b8b-36da-498e-8808-8e894aaafae0"/> </reportElement> <textFieldExpression><![CDATA[$F{LoadStatusActivity.DateTime_StatusEvent}]]></textFieldExpression> </textField> <textField> <reportElement x="280" y="0" width="100" height="18" uuid="b001bdcb-adbb-4fdc-8c9a-88145a2cf213"> <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="e828e01c-312e-464e-932f-869d1751a788"/> </reportElement> <textFieldExpression><![CDATA[$F{LoadStatusActivity.LoadStatusComment}]]></textFieldExpression> </textField> </band> </summary> </jasperReport>
  12. Hey guys, need some quick direction on how to handle a data source that supplies multiple values/lines to my report. In short, my report is for tracking trucks, and my last column is 2 fields combined to show the (a) status date and (b) status comments. It works perfectly, but as you can see from the sample of my report below, it returns multiple lines due to the data source consisting of multiple tracking updates for every load. That said, how do I select only the update with the most current date? If I can use the expression editor for this, that woud be awesome, but I'd sincerely appreciate any direction or advise. Thank you! Zach
  13. Hello, Having trouble in Jasper Studio Professional getting my report to remove duplicate values/lines. I can hide duplicate values, but I want the entire line to go away. I'm very computer literate, but this has been frustrating me for over a week now. ANY help anyone can give me would be greatly appreciated. The Load Number would otherwise be repeated, but where it's not repeated, I want the whole line to disappear with it. Additionally, the repeated lines only appeared once I'd added the Status Activity field to my report. I imagine it's becuase there are multiple status updates for every load. That said, having a report to only show the most recent status update is my ultimate goal. Here is my code: <![CDATA[ <query> <queryFields> <queryField id="Load.LoadNum"/> <queryField id="Load.LoadTmsStatus"/> <queryField id="Load.DateTime_PlannedStart"/> <queryField id="Load.TransportModeName"/> <queryField id="Load.TradingPartnerName"/> <queryField id="Load.ProNum"/> <queryField id="LoadStatusActivity.LoadStatusComment"/> </queryFields> <groupList> <group columnName="Load.LoadNum"/> </groupList> <queryFilterString> Load.LoadTmsStatus == 'InTransit'</queryFilterString> <sortList> <sortColumn columnName="Load.LoadNum" ascending="false"/> </sortList> </query>]]> </queryString> <field name="Load.LoadNum" class="java.lang.String"> <property name="com.jaspersoft.studio.field.label" value="LoadNum"/> <property name="com.jaspersoft.studio.field.tree.path" value="Load"/> <fieldDescription><![CDATA[LoadNum]]></fieldDescription> </field> <field name="Load.LoadTmsStatus" class="java.lang.String"> <property name="com.jaspersoft.studio.field.label" value="LoadTmsStatus"/> <property name="com.jaspersoft.studio.field.tree.path" value="Load"/> <fieldDescription><![CDATA[LoadTmsStatus]]></fieldDescription> </field> <field name="Load.DateTime_PlannedStart" class="java.sql.Timestamp"> <fieldDescription><![CDATA[DateTime_PlannedStart]]></fieldDescription> </field> <field name="Load.TransportModeName" class="java.lang.String"> <fieldDescription><![CDATA[TransportModeName]]></fieldDescription> </field> <field name="Load.TradingPartnerName" class="java.lang.String"> <fieldDescription><![CDATA[TradingPartnerName]]></fieldDescription> </field> <field name="Load.TradingPartnerNameClient1" class="java.lang.String"> <fieldDescription><![CDATA[TradingPartnerNameClient]]></fieldDescription> </field> <field name="Load.ProNum" class="java.lang.String"> <fieldDescription><![CDATA[ProNum]]></fieldDescription> </field> <field name="LoadStatusActivity.LoadStatusComment" class="java.lang.String"> <fieldDescription><![CDATA[LoadStatusComment]]></fieldDescription> </field> <group name="Load.LoadNum"> <groupExpression><![CDATA[$F{Load.LoadNum}]]></groupExpression> </group> <background> <band splitType="Stretch"/> </background> <title> <band splitType="Stretch"> <property name="com.jaspersoft.studio.unit.height" value="px"/> </band> </title> <pageHeader> <band splitType="Stretch"> <property name="com.jaspersoft.studio.unit.height" value="px"/> </band> </pageHeader> <columnHeader> <band height="31" splitType="Stretch"> <staticText> <reportElement x="0" y="0" width="100" height="30" uuid="f8fe60df-56a6-47f0-b6e3-fe27dce35ae4"> <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="d6081118-b3b9-44e3-82f9-49f9752636d6"/> </reportElement> <textElement verticalAlignment="Middle"> <font size="14" isBold="true"/> </textElement> <text><![CDATA[Load Number]]></text> </staticText> <staticText> <reportElement x="110" y="0" width="60" height="30" uuid="2e421488-984f-47ed-a999-90e7aab70bdf"> <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="7a46d7c2-ec8e-453a-8b54-c07efaa6ecd1"/> </reportElement> <textElement verticalAlignment="Middle"> <font size="14" isBold="true"/> </textElement> <text><![CDATA[status]]></text> </staticText> <staticText> <reportElement x="180" y="1" width="100" height="30" uuid="4ff99f5c-cc2b-432e-a2a9-0c4afd390ee8"> <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="da67e068-402b-4c32-9847-49c595ea136b"/> </reportElement> <textElement verticalAlignment="Middle"> <font size="14" isBold="true"/> </textElement> <text><![CDATA[ship Date]]></text> </staticText> <staticText> <reportElement x="290" y="1" width="40" height="30" uuid="d8e576c5-3db7-44f8-ade0-3b14c61b0d91"> <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="44f34002-76e5-44a4-8cdb-25d651056efd"/> </reportElement> <textElement verticalAlignment="Middle"> <font size="14" isBold="true"/> </textElement> <text><![CDATA[Mode]]></text> </staticText> <staticText> <reportElement x="340" y="1" width="80" height="30" uuid="03da95b7-2e6a-4bd6-b3cf-4674fb950648"> <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="a691234a-7f02-46b3-8e05-eaf074615f20"/> </reportElement> <textElement verticalAlignment="Middle"> <font size="14" isBold="true"/> </textElement> <text><![CDATA[Carrier]]></text> </staticText> <staticText> <reportElement x="430" y="0" width="100" height="30" uuid="91fc1200-61ef-4de7-a8b7-76fc99fe09ca"> <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="9b44bd07-d3a2-42a9-bbed-95dc0c848d7a"/> </reportElement> <textElement verticalAlignment="Middle"> <font size="14" isBold="true"/> </textElement> <text><![CDATA[PRO Number]]></text> </staticText> <staticText> <reportElement x="540" y="1" width="120" height="30" uuid="49fea68c-493a-4d34-8420-6b867b2bc913"> <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="18f91241-8124-4328-9d8e-0276a5c9f095"/> </reportElement> <textElement verticalAlignment="Middle"> <font size="15" isBold="true"/> </textElement> <text><![CDATA[status Comment]]></text> </staticText> </band> </columnHeader> <detail> <band height="20" splitType="Stretch"> <textField> <reportElement x="110" y="0" width="60" height="20" uuid="39325141-d433-49b4-bfd0-0ef23b43a572"> <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="7a46d7c2-ec8e-453a-8b54-c07efaa6ecd1"/> </reportElement> <textElement verticalAlignment="Middle"/> <textFieldExpression><![CDATA[$F{Load.LoadTmsStatus}]]></textFieldExpression> </textField> <textField> <reportElement x="180" y="1" width="100" height="19" uuid="21d2ce70-0843-4daa-955d-ec4c36fb0d69"> <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="da67e068-402b-4c32-9847-49c595ea136b"/> </reportElement> <textElement verticalAlignment="Middle"/> <textFieldExpression><![CDATA[$F{Load.DateTime_PlannedStart}]]></textFieldExpression> </textField> <textField> <reportElement x="290" y="0" width="40" height="19" uuid="6aecbc3d-8d7b-4a38-86c6-28a66f3528a5"> <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="44f34002-76e5-44a4-8cdb-25d651056efd"/> </reportElement> <textElement verticalAlignment="Middle"/> <textFieldExpression><![CDATA[$F{Load.TransportModeName}]]></textFieldExpression> </textField> <textField> <reportElement x="340" y="0" width="80" height="19" uuid="7acb49e0-e24f-4a8d-a91c-4320aea07fe2"> <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="a691234a-7f02-46b3-8e05-eaf074615f20"/> </reportElement> <textElement verticalAlignment="Middle"/> <textFieldExpression><![CDATA[$F{Load.TradingPartnerName}]]></textFieldExpression> </textField> <textField isBlankWhenNull="true"> <reportElement x="430" y="0" width="100" height="19" uuid="6a837c7a-0cbc-41b6-83a0-244f76b6ca3c"> <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="9b44bd07-d3a2-42a9-bbed-95dc0c848d7a"/> </reportElement> <textElement verticalAlignment="Middle"/> <textFieldExpression><![CDATA[$F{Load.ProNum}]]></textFieldExpression> </textField> <textField isBlankWhenNull="false"> <reportElement x="540" y="1" width="120" height="19" uuid="38b8fa9b-8a0d-418d-8609-f3929a57c701"> <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="18f91241-8124-4328-9d8e-0276a5c9f095"/> <property name="net.sf.jasperreports.style.isBlankWhenNull" value="true"/> <property name="net.sf.jasperreports.consume.space.on.overflow" value="true"/> <property name="net.sf.jasperreports.print.keep.full.text" value="true"/> <property name="net.sf.jasperreports.text.save.line.breaks" value="true"/> <property name="net.sf.jasperreports.text.truncate.at.char" value="true"/> </reportElement> <textElement verticalAlignment="Middle"/> <textFieldExpression><![CDATA[$F{LoadStatusActivity.LoadStatusComment}]]></textFieldExpression> </textField> <textField> <reportElement isPrintRepeatedValues="false" x="0" y="0" width="100" height="20" isRemoveLineWhenBlank="true" uuid="209d6e81-5584-4245-94c0-b3d674af29bb"> <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="d6081118-b3b9-44e3-82f9-49f9752636d6"/> </reportElement> <textElement verticalAlignment="Middle"/> <textFieldExpression><![CDATA[$F{Load.LoadNum}]]></textFieldExpression> </textField> </band> </detail> <columnFooter> <band splitType="Stretch"> <property name="com.jaspersoft.studio.unit.height" value="px"/> </band> </columnFooter> <pageFooter> <band splitType="Stretch"> <property name="com.jaspersoft.studio.unit.height" value="px"/> </band> </pageFooter> <summary> <band splitType="Stretch"> <property name="com.jaspersoft.studio.unit.height" value="px"/> </band> </summary></jasperReport>[/code]
  14. Hello, I'm having an issue where I can add fields to my report from one source (IE, my Load domain) the report is fine, but as soon as I try to add a field from a different source (IE, LoadStatusActivity), it immediately duplicates items on my report as shown in the preview below. Is there a workaround for this? Or a way to only show unique/distinct values for a specific field? I've tried so many different ways to remove duplicates from my report for the last few days (printwhen, remove lines when blank, floating, keep relative to top, grouping, etc.) and nothing has worked so I'm at a total loss. So far, this route is as close as I can get to the end result I'm looking for. Any help would be greatly apprecaited.
  15. Hi guys, need some help. Working with JasperSoft Studio Professional and I've got a field by the name of Load.LoadTmsStatus with values of either In Transit or Delivered, and I can't for the life of me figure out the expression I need for my table to only list orders with a status of In Transit. Would be extremely thankful for any help or direction. Thank you!
  • Create New...