kchaudhry

You don't really need a "print when expression" for this. Simply right click on the field > properties > common > uncheck "print repeated values" and that should do the trick.

I can totally relate to your pain. Not sure what version you are using. I use 1.2.8 and was able to turn the message off by going to: Options > Configure Plugins > Check for iReport updates > Configure > Uncheck "Check for update on iReport startup" > Save

You can achieve this by creating a crosstab report. If you are not familiar with crosstabs, here are some steps to create a simple crosstab. 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.

You will have to provide more information. What other sections are there that you want to display? What are the contents of these sections?

Under report properties there is an option for "Title on a new page". If you turn this on, the details will hopefully start on the second page.

One way of doing this is by creating a new column in your query where you can define your desired order of the months and then "Order By" that column. When you use this query you will have to check the "data is presorted" option in crosstab properties. Hope this helps

What band did you place your cross tab in? Try moving it to "Summary" band and the error should go away.

I haven't tried this but it's worth a try. Try adding a dummy group and put your fields in the group header and check the property to "print header on each page".

Try the attached jrxml.

Right click on the band where you have placed these field and then uncheck "Split allowed" and that should do the trick.

For the background color of the cell are you using a style? If so, then do you have the mode set to "Opaque"? I have it set this way and it works for me in excel/pdf/html. For the second question simply right click on the band you want to supress and change the hieght to 0. Hope this helps.

Eventhough "Data is Presorted" has always worked for me. One way of doing this is to create a new column and sort based on that column. For example you can use sort/decode like this select case when tablename.fieldvalue = 'Sample1' then 1 when tablename.fieldvalue = 'Sample2' then 2 when tablename.fieldvalue = 'Average' then 3 end orderfield from tablename order by orderfield

Yes, you can have crosstabs in groups. You just need to change the "Reset type" property to evaluate properly. For example if you are placing your crosstab in the group footer then right click on the crosstab then to go to crosstab properties > crosstab data > reset type and set that to "Group" and for "Reset group" select the name of your group and it should work. I have attached an example. Hope this helps!

oops, I am using a very old version so wasn't aware of that. Here is what you can try. 1. Create a new Text Field 2. Right click on it and go to properties > font > check "is styled text" (do not check bold) 3. Now go to Text Field tab and paste the following in textfield expression "<style isBold=\"true\" pdfFontName=\"Helvetica-Bold\">"+"Test"+"</style>" If this seems to work then simply replace "test" with your desired text. Hope this helps!

You will probably have to specify the "PDF font name" to be bold like "Helvetica-Bold". If you click on the drop down, you will see a listing of the regular and bold fonts.

This is happening because you have placed the chart in the "Detail" band. Try placing it in group footer band.

Add "Order by id" in your query.

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.

There a couple of ways you can show the value for 5. One way is to use the "case statement" in your sql or the other way is to use a "full outer join" in your sql. I prefer to do the case statements. Here is an example select sum(a.case1) 'Value 1', sum(a.case2) 'Value 2' from (select case when fieldvalue = 1 then 1 else 0 end case1, case when fieldvalue = 2 then 1 else 0 end case2)a Just keep adding all the conditions. This is sql server syntax, you might have to adjust it for the database that you are using. As for your other question, why are you putting the variable in the detail band? Can't you put it in summary or group footer?

On the add/modify group properties screen there is a property called "min height to start new page". You will need to change this for your subgroup. If you get the height of your subgroup header + the height of you details band and put the sum of these values for this property it will force the subgroup to be printed on the next page. You might have to play around with the numbers a little but it will work. Hope this helps!

Unfortunately, I don't have that version so I won't be able to tell you the specifics. However, from the main report can you right click on the crosstab element and see if you get the option for "crosstab properties".

I am using a very old version of ireports (1.2.8). Did you click on "properties" or "crosstab properties"?

It seems like you need to change the group header properties. You can go to Crosstab Properties > row and column groups > print the group header at this position > Center or Stretch

new Boolean ($F{Field}.equals ("") || $F{Field} == null)

You can probably add a group on this field and then check the "print header on each page" option.