guvengulabi44

Hi Giulio, I use jasperreports-2.0.0 with poi-2.5.1 and all things are good but when I upgrade poi-3.5.beta I take an error:"java.lang.NoSuchMethodError: org.apache.poi.hssf.usermodel.HSSFSheet.addMergedRegion(Lorg/apache/poi/hssf/util/Region;)I" then I upgrade my jasperreports versiyon 3.1.4 I take this error again. What can I do, can you help me?

hi, crosstab column number is variable so crosstab with change depend on column number. I want to fit crosstab to page with. I want to crosstab width same as page width always. How can I do this?

Hi, I use ireport-2.0.0 I create a report wiht crosstab. You know crosstab column number change depend on data which came with query. In my report column number in crosstab change between 2 and 5 and crosstab width change depend on column numbers. I want to fit crosstab width to page width. Ä°f number of column change, column width change and totaly crosstab width equall to page width. How can I do this? Can you help me...

Hi, I use ireport-2.0.0 I create a report wiht crosstab. You know crosstab column number change depend on data which came with query. In my report column number in crosstab change between 2 and 5 and crosstab width change depend on column numbers. I want to crosstab width be static, dont change. So I want create I crosstab always with 5 columns. If number of column less then 5. I want to add extra colums to make it totaly 5 column and print zero in extra columns. How can I create crosstab with extra column? It is urgent. Please help me..

Hi Giulio, I use jasperreports-2.0.0 with poi-2.5.1 and all things are good but when I upgrade poi-3.5.beta I take an error:"java.lang.NoSuchMethodError: org.apache.poi.hssf.usermodel.HSSFSheet.addMergedRegion(Lorg/apache/poi/hssf/util/Region;)I" then I upgrade my jasperreports versiyon 3.1.4 I take this error again. What can I do, can you help me? Post Edited by guvengulabi44 at 06/16/2009 11:50

Thanks, for your help I did what you say It work. But I have a another problem with ireport. I want to use user define parameter as optional, I take data from database, I use three parameters in my query, two of them is always entered by users, one of them is optional, if user dont enter any data parameter. query take all data depend on this parameter. Ä°f user enter a value for this parameter query use this parameter value. My code example is: mud.Id=$P{mudId} t.Id=$P{ttId} s.Id like $P{sid}--- > I want to use this parameter as optional If user dont enter any data it take all s.Id from database. If user enter any value for $P{sid} parameter. This value used by s.Id But this code dont work. Can you help me...

Hi, I use ireport 2.0.0 there is no noData band in this version of ireport. I use datasource to take data from database, but sometimes there is no any data in database at this time I want to print 'no data message' instead of data how can I do. can anyone help mee...

Hi, I want to use three parameter in query. Two of is must and other is optional. User can enter a value or set it default. Ä°f user enter a value this parameter take the user value. Else it takes al releated values. example: AND ilmud.ID=$P{ilMudurlukId} and tb.ID=$P{ttBinaId} and sd.ID like '%' When I use code above sd.ID take all value in database. Ä°f user enter the value for sd.ID it don't take user value. Ä°t takes al values in database. But I want to take user value if user enter a value otherwise it takes al values in database. Can anyone help me....

Hi, I want to use three parameter in query. Two of is must and other is optional. User can enter a value or set it default. Ä°f user enter a value this parameter take the user value. Else it takes al releated values. example: AND ilmud.ID=$P{ilMudurlukId} and tb.ID=$P{ttBinaId} and sd.ID like '%' When I use code above sd.ID take all value in database. Ä°f user enter the value for sd.ID it don't take user value. Ä°t takes al values in database. But I want to take user value if user enter a value otherwise it takes al values in database. Can anyone help me....