pihoward

I am new to iReport and have been asked to create a business price quote using this application. I purchased Giulio's book 'the definitive guide to iReport' but I can not find the answers to my questions below. 1) when I print my quote, the lines do not print ? Although I can see them in the pdf format 2) how do I reference 1 of many values that have the same field name? eg I have multiple item numbers but I want to capture the value in 1 ( item 45-0900/ I need the associated description of this field) Once I have captured this value , I will populate a field in the title band. right now this field is item_id but the description field is item_descr used for every item's description. When I try to access this field, I get the last value not item 45-0900 description. I do have a field @id but when I try this I get the same results/ the last value that is in the item_descr field. Thanks in advance Pat

Hi I am new to IReport and I am trying to create a business quote. When I print the quote the lines are missing but when I view the pdf report the lines are present . Any ideas why? Thanks in advance, Pat 1. The query below will show you the Name of the Sales person, the name of the items they have sold and the quantity of items they have sold. Place this query in the main report query section. select 'John Doe' as 'SalesPerson', 'Tennis Balls' as 'ItemsSold', 2 as 'Quantity' union all select 'Jane Doe', 'Baseball Gloves', 3 union all select 'Jane Doe', 'Pool Table', 5 union all select 'John Doe', 'Pool Table', 2 2. Go to create new Crosstab and place this in your "Summary" band 3. Select the available dataset. In this example it will be the main report query then click next 4. Select the "SalePerson" field for Row group 1 then click next 5. Select the "ItemsSold" field for Column group 1 then click next 6. Select the "Quantity" field for Detail field and select "Sum" for Function and then click next. **Note** If you are already doing the calculation in your query then you can set the Function to "Nothing". 7. Depending on your requirement, select the appropriate group totals. For this example we will have both row and column totals then click next or finish 8. Now run the report 9. For formatting changes either go to the "crosstab-1" tab on the top or simply right click on click on "Go to crosstab design tab..." 10. This is all you need to do to create a simple cross tab.