gr4nt4

Hi Matt Thanks for the reply, unfortunatly in this case its not an option.

I have an SQL that returns null values but the chart fails to compile due to a 'nul pointer Exception' so I've used the code $F{PRODUCTDESC}==null?"":$F{PRODUCTDESC} However this now produces an legend segment that has no description in (see graphic) I'm looking to do one of the below: 1. Remove the single segment from the legend 2.Change the segment color to white and the segment border to white 3. Have the chart compile correctly even with a nul value.

Is there any way to prevent the lable cut off as shoen in the pottom of the image ... other than reducing the number of data points?

Hi I want to create a hyperlink in a report that launches a PDF file located in the same directory as the report files. help appreciated

Hi All I have two text fields both set to stretchWithOverFlow and have identical settings (used copy & paste) located in the title band. Each one uses parameter that contains a string Text field 1 example of expression data 50217,50218,50219,50220,50221,50222,50223 up to 400 Text field 2 example of expression data 6281, 6283, 6285, 6286, 6287, 6288, 6289 up to 100 when run within the IDE both perform as expected and both expand down to fill with the correct info, text 1 in IDE text 2 in IDE however when run on the server only one performs as expected the second expands sideways causing all the other text fields to expand to the same width Text 1 on server text 2 on server I tried placing the text fiels in a frame as per one suggestion but still the same. any thoughts please

Hi All I have two text fields both set to stretchWithOverFlow and have identical settings (used copy & paste) located in the title band. Each one uses parameter that contains a string Text field 1 example of expression data 50217,50218,50219,50220,50221,50222,50223 up to 400 Text field 2 example of expression data 6281, 6283, 6285, 6286, 6287, 6288, 6289 up to 100 when run within the IDE both perform as expected and both expand down to fill with the correct info, text 1 in IDE text 2 in IDE however when run on the server only one performs as expected the second expands sideways causing all the other text fields to expand to the same width Text 1 on server text 2 on server I tried placing the text fiels in a frame as per one suggestion but still the same. any thoughts please

Hi All What are the bugs/restrictions or issues with using the crosstab in 1.2.8?

Hi All What are the bugs/restrictions or issues with using the crosstab in 1.2.8?

Spot on , it works fine now, many thanks

Hi All I passing in a parameter that is used to switch between sub reports I have been able to achieve this in ireports IDE but when run on the server it does not switch correctly code used to switch the sub report in the sub reports expression $P{DeviceTypeID}=="1"?$R{rpt.sub.subname1}: $R{rpt.sub.subname2) + ".jasper" any thoughts?

I'm trying to create a report as follows 1-Store1 statistics(group by store) 3-----Store 1 device1(group by device) 1-Store2 statistics (group by store) 2-- Store 2 order summary of devices 1 & 2(group by store) 3-----Store 2 device 1 orders(group by device) 3-----Store 2 device 2 orders(group by device) I can get stats by store (1) fine and the device level fine (3) but cannot get (2) Is it posible to have two groups using the same expression ie 1 & 2 are both by store. I've tried a subreport for the order summary (2) but it extends the processing time and report size plus I cannot get it not to print when the store only has 1 device even though I can get a count of devices from a variable and use the "print when expression" any help sugestions? [file name=SubDetail.jrxml size=31965]

Hi I have 4 devices in 2 locations and I'm trying to summarise as follows Averages for location 1 (device 1&2) Totals of device 1&2 Total of Device 1 Total of device 2 Averages for location 2 (device 3&4) Totals of device 3&4 Total of Device 3 Total of device 4 I have grouped by location and device and get Averages for location 1 (device 1&2) Total of Device 1 Total of device 2 Averages for location 1 (device 1&2) Total of Device 1 Total of device 2 but cannot figure out how to get the Totals of device 3&4 Should it be posible with groups or will I have to use a sub report? many thanks [file name=Image1.jpg size=16591] Post edited by: gr4nt4, at: 2008/03/18 10:05

Hi I have 4 devices in 2 locations and I'm trying to summarise as follows Averages for location 1 (device 1&2) Totals of device 1&2 Total of Device 1 Total of device 2 Averages for location 2 (device 3&4) Totals of device 3&4 Total of Device 3 Total of device 4 I have grouped by location and device and get Averages for location 1 (device 1&2) Total of Device 1 Total of device 2 Averages for location 1 (device 1&2) Total of Device 1 Total of device 2 but cannot figure out how to get the Totals of device 3&4 Should it be posible with groups or will I have to use a sub report? many thanks

Hi abheekd Many thanks for the reply, however I'm just the report creator using iReport. Is there a way of doing it just by passing a parameter?

Hi ichytoes :) could you give more detail how you achied this. Thanks