fender989100

mlopez_1

Hi guys I have a report with the next query: SELECT id, AttributeName, AttributeValue FROM Attributes WHERE $X{IN, id, id_list} In Jaspersoft Studio all works fine I have there just id_list input field and I can add there id one by one as many as I want Then I uploaded that report to Jasper server and was trying to create id_list field for input. But Jasper only gives me two choices: 1) Multi Select List of Values 2) Multi Select Query But no one is good for me because I have about 3000000 values if ID What I want, just have possibility to type a couple of IDs manually in input field

Thank you KKriplani It works Jasper Soft Studio has some troubles with Preview mode When I've uploaded report to the Server everythings start to work

--

Thanks I know about that technic, but It's not working. $P{Id} == null ? "where 0=0" : "where id=" +$P{Id}; $P{Id} always will be null in current expresion, no matter param was fiels or not

Hi I have input id param in my report. If id == null then I need to use a query like this: SELECT id, name FROM company But if id == 1 (or another number) I need to use that query: SELECT id, name FROM company WHERE id = 1 I've tried ti create one param that depends from another param, for example: $P{id} == null ? "WHERE true" : (" WHERE id = " + $P{id}) but it's not working, the resuls is always "WHERE true" Is that possible to do?

Hi When you create shcedule task for a report, there is option for FTP result sending I need to customize FTP sending, for example I want to encrypt the report before send it to FTP Could someone give me a tip or some example?

"Remove line when blank" is not working for me. Of Course this remove subreport, but row also contains another fields. And as result, row will not be deleted

Hello I have report with many rows. Each row contains some fields and one subreport Sometime subrepot contains only null fields. So, I need to remove report row if subrepot contains null fields.