Thomas Zimmer

what do you mean exactly? is the field content cut? try to use the option "Print When Detail overflows" for your text fields. Cheers, Thomas http://www.thomaszimmer.net

simply use a bullet image as the first element in your list-element or report layout. if I missed the real problem, pls. post your report. Cheers, Thomas http://www.thomaszimmer.net

<server-install-dir>/apache-tomcat/webapps/jasperserver-pro/... (if you installed bundled with tomcat, otherwise you should know by yourself) Cheers, Thomas http://www.thomaszimmer.net

You cannot use the detail band, if you do not have a set of datarecords to print. Instead set the report property "When no data type" to "All sections, No detail" and use the title or summary band to layout your single value parameters. If you want to print a collection of records in your report, you could use a collection of java beans (representing a record set) as a datasource: new net.sf.jasperreports.engine.data.JRBeanCollectionDataSource($P{MyBeanCollection}) Of course, you will have to build the bean collection first outside the report... Cheers, Thomas http://www.thomaszimmer.net

Hi Robin, I assume you are using the Table-Component as you wrote. I'm not very comfortable with this, but page breaking seams easy. Attach a dataset to the table having the group. Activate the property "Start on new page" with the dataset group you like. the table groups start on new pages now. see the example report attached (using foodmart jdbc datasource, works on the Jasperserver, too). IMHO, Never ever user page breaks in Jasperreports! Even if I don't know your report, i would say, better build a table-layout report without the table element, possibly as asubreport. You will have more control and flexibility like thi, although it may a bit more work to implement. Cheers, Thomas http://www.thomaszimmer.net

Hi Simona, deploy the subreports manually. two posibilities: 1) In the Repository Navigator, click on the subfolder "Resources" of your report and add your subreports as JRXML Documents 2) In the Web-UI of JAsperreports Server Edit the report, Select Controls & Resources from the left menue, then add your subreports as JRXML Documents (Resource) BEWARE! In both cases you have to change the subreport expressions (in all reports using a subreport) Jasperreports Server uses expressions like "repo: reportname.jrxml" (in iReport you have a static path to your local file system). For the main report and the regular upload, iReport will change these expression, for your subreport and its sub-subreports you wil have to do this for yourself. A good practice would be to store the subreport paths in a parameter ($P{SUBREPORT_DIR}), then pass the variable around to all subreports. so you will have it to change only in the main report. But additionally you will need another variable to set the file extension "jrxml"; in iReport you need the extension "jasper"... My proposal: use parameter $P{SUBREPORT_DIR} with default value "repo:" and $P{SUBREPORT_EXT} with default value ".jrxml". Activate the "Use as prompt" option for the parameters. Your subreport expression(s) will be $P{SUBREPORT_DIR} + "reportname" + $P{SUBREPORT_EXT} If you execute your reports in iReport, you will be requested to give the file path and extension, on the server everything will be fine. Other way would be to upload reports only once (with the manual corrections wrote above), then always execute the report remotely (right click in the repository navigator, "Run Report"; if you edit your report or subreport, open them from the repository navigator, then upload and run remotly again) However, each possible solution for this has its own pitfalls (e.g. iReport will not compile the subreports automatically anymore, you will have to upload the subreports as resources manually... Cheers, Thomashttp://www.thomaszimmer.net

would be nice for other to describe shortly what the problem was exactly...

hard to as long you do not give more information... the error says that the expression cannot be evaluated. so, what can be wrong? possibly one of the fields is null? or the field "media_stock_target_price" is zero? (but in this case, as far as I know, you would get a "division by zero" error) check the datatypes and all possible contents of the fields! check the needed datatype of the element the expression is used in (TextField or sth like this?) Cheers, Thomas http://www.thomaszimmer.net

let me say, there is no perfect solution for this. but once, I built soemthing similar: just implement a subreport which will be called recursivly. Then pass the datasource (tree structure of your directories), respectivly subtrees to the subreport. It´s not so easy, but it can be done. Cheers, Thomas http://www.thomaszimmer.net

hey thanks ankur.. I have tried placing in summary band but now its adding empty pages in the starting.. I have solved this issue by writing SELECT 1 FROM DUAL IN MAIN QUERY For normal, you would not need to do that, you leave the query blank or use it to query the table data. Place your table in the title or summary band, remove the detail (and all othe bands you don´t need), then activate the report setting "When no data = All section, no detail". Cheers, Thomas http://www.thomaszimmer.net

You could have asked Microsoft or Jaspersoft to implement an converter... ;) No, there doesn´t exist any converter for any output format to convert to JRXML template (beyond .JASPER format....) You Cheers, Thomas http://www.thomaszimmer.net