viking79

Hello, What I am trying to do is create a text box property that for example: I have a column called customfieldid I want to have if customfieldid = 19 than it prints the value from the info field. Any ideas on how to do this would be greatly appreciated. Thanks, Viking

Hello, I am working on a report and I have a column I have summed. The summed value is currently in the column footer line. The problem is it puts the output near the bottom of the page even though I have moved everything up to where it is nearly touching the detail line. Is thier a setting or something to make it appear right under the column when the report is ran? Any help is greatly appreciated, Viking79

Hi, thanks for the response. The thing is I'm uploading the report into Fishbowl Inventory. I have the jasper Server plugin for iReports, Is there anyway to use that?

Is it possible to add drop down boxes for users instead of having them type anything in? Thanks

Thanks again for the help, that worked perfectly. Take care

Thanks for the response. I tried the first option because a total is all I am really looking for, but I get the error -104invalid expression in select list(not contained in either aggregae function or the GROUP BY clause Any ideas? Take care

Thanks for your help, it happened to be an interger data type so the second one worked out just fine. Thanks again :)

Hi, I want the report I'm working on to bring back info based on where an id equals either 1,2,or 11 When I put all three in the query, I get errors, Any suggestions? Thanks

Hi, thanks for the reply. I still don't get the group band part and when I put in my query Group By po.num, I get an error. I may have tried putting the Group By in the wrong part of the query. Here is my code without the group by, any suggestions? Thanks again Code:SELECT PO."NUM" AS PO_NUM, PO."VENDORCONTACT" AS PO_VENDORCONTACT, PO."DATECREATED" AS PO_DATECREATED, PO."QBCLASSID" AS PO_QBCLASSID, POITEM."TOTALCOST" AS POITEM_TOTALCOST, PAYMENTTERMS."ID" AS PAYMENTTERMS_ID, PAYMENTTERMS."NAME" AS PAYMENTTERMS_NAME, QBCLASS."NAME" AS QBCLASS_NAMEFROM "VENDOR" VENDOR INNER JOIN "PO" PO ON VENDOR."ID" = PO."VENDORID" INNER JOIN "POITEM" POITEM ON PO."ID" = POITEM."POID" INNER JOIN "PAYMENTTERMS" PAYMENTTERMS ON PO."PAYMENTTERMSID" = PAYMENTTERMS."ID" INNER JOIN "QBCLASS" QBCLASS ON PO."QBCLASSID" = QBCLASS."ID" AND QBCLASS."ID" = POITEM."QBCLASSID" AND PAYMENTTERMS."ID" = VENDOR."DEFAULTPAYMENTTERMSID"Where paymentterms.id = 11order by po.num ASC

Hello, I working on a summary and I want to sum total cost. For example if PO # 12234 has two items I want to sum those two items and if PO # 56788 had 3 items I want to sum those 3 together and have both POs on the same report. Right now when I run the report in the total cost column I get each individual item. Thanks

Hey thanks for all your help, still not getting the info we need, but I think is has to do with how we are trying to join the tables, rather than the text expression. I think once we figure that out, I can use some of the ideas you had to get the text boxes to fill out. Anyways, thanks again :)

Parttrackingid is int Trackingtextinfo is varchar Sorry about that, probably should have mentioned that/tools/fckeditor/editor/images/smiley/msn/regular_smile.gif Post Edited by viking79 at 01/27/2012 15:38

Hi, thanks for the response. What I would like to do is if ParttrackingID is equal to 5, I need it to print the value of TrackingTextInfo in the box. That's were I'm really hung up. I have several different sections of the report that need fulled, and ParttrackingID value is what dictates what goes in each one but the actual value I want shown is in the trackingtextinfo, if that makes sense. Any suggestions? Thanks and take care

I want to get the value of a field to show based on whether the values of two other fields match. I wrote a text expression I thought might work but no luck yet. Any ideas? Here is the expression as it stands riight now. It's not erroring out, it just doesn't bring back the desired value. Thanks Code:(($F{PARTTRACKINGID}== $F{TRACKINGTEXTTAGID})?"getValue($F{TRACKINGTEXTINFO})":"")

Hello, In my report I have the box for print repeated values unchecked, and even checked again in the XML view, but when I run the report it still wants to repeat values? Any suggestions? Thanks