Hello all, I want to use " SELECT TOP p from table1" which p is a parameter that the user defines in generation time. I have used " SELECT TOP $P{p} from ... " but it is not correct. Although I can display just #numbers of records in my report using $V{REPORT_COUNT} and a parameter, I do not want this case. I want to realy fetch only p records from database. can anyone help me?
Hi, I'm trying to run my .jasper(compiled file) report file from jaspersoft studio to jasperreport server. But I dont know how to do and where to do. Even in server side it allowed me just to upload only .jrxml files.
Dear all, I am working with AEOS-2.4.6.1 Enterprise nedap product. Although I have enabled report generation I cannot generate reports. I think the version of the iReport embed in aeos should be equall with the one that I have generated my reports but I dont know what is the version of the one that is embed in aeos-2.4.6.1 or aeos-3.1.1. Can anyone help me
hello hozawa thanks but I have authorization for that server. In fact, I can login their server and run jasperreports server and upload my reports directly in the server. but I cannot export my reports from jaspersoft studio to jrserver.
Hi, I try to export my reports to jrserver. But I cannot login. the error "unauthorized" occures. In our company everything is ok, however when I want to run reports in another comapny this error occures.
Dear all, I try to use $X{IN, accesspointname, $P!{ACCESSPOINT}}) in my query but I face with this error :Unrecognized SQL escape 'in' at line position 1977. why ?? I am using jaspersoft studio 5.5.1
Dear Rajesh, Hi, Thanks alot for your help. However, I want to fetch combobox values from database, not manually. For example, set a query(select name from table1) and then I see all names in combo and.I would be appreciated if you help me.
Dear Rajesh, Hi, Thanks alot for your help. However, I want to fetch combobox values from database, not manually. For example, set a query(select name from table1) and then I see all names in combo and.I would be appreciated if you help me.
Dear Rajesh, Thank you for your reponse. I want to create a SortBy parameter on which I can sort my reports based on my columns(my fields in DB). So I've decided to create a combobox which values are my fields in DB so that I can select my fields to sort my report according to that field. But now I don't know how to create combobox itself nor how to provide its values.