scottn

The way we do it for all input controls is by adding an "All" option to the input control query, i.e.: SELECT "All" AS `DISPLAY_NAME` UNION SELECT DISPLAY_NAME FROM TABLE That then makes the first option always "All". Then to handle that in the report, we use something like this: ($X{IN,'All', parameter_mlist} OR $X{IN,DISPLAY_NAME,parameter_mlist}) So basically the logic will accept everything if "All" is selected because it short circuits the logic before it gets to the second check where it actually looks at the column in the database.

We are also looking to solve this problem. Has anyone found a solution to this? Thanks, Scott

jrechter Wrote: After searching on how to set a daily scheduled task on a report whose date field has to default to yesterday (current day - 1), I came upon this thread, which seemingly would fix my problem, but alas, did not. When I manually run the report, I can default the End Date to the previous day, and the report runs fine, giving me the previous day's information. When I scheduled this report to run each day, I would expect the End Date to increment a day at a time, but instead, it saves the initial date that the schedule was made, and the result is that I get the same report every day. End Date is always 07/04/2009. I've played around with _ScheduledTime but have been unsuccessful. Any help would be appreciated on how to make the date parameters dynamic within scheduled tasks. Thanks. Hi, We solved this by adding some SQL to the report query to give us different scheduling options, and then you simply pass the parameter to the report for it to run (i.e. "Previous Day" or "Month to Date"). Below is the SQL as an example. -Scott Code: (CASEWHEN $P{report_schedule} = "Month to Date" THEN (DATE(NOW()) + INTERVAL 1 DAY)WHEN $P{report_schedule} = "Previous Month" THEN (DATE_FORMAT(CONCAT(YEAR(NOW()),"-",MONTH(NOW())-1,"-",DAY(LAST_DAY(NOW() - INTERVAL 1 MONTH))),"%Y-%m-%d") + INTERVAL 1 DAY)WHEN $P{report_schedule} = "Previous Year" THEN (DATE_FORMAT(CONCAT(YEAR(NOW()),"-",MONTH(NOW())-1,"-",DAY(LAST_DAY(NOW() - INTERVAL 1 MONTH))),"%Y-%m-%d") + INTERVAL 1 DAY)ELSE ($P{end_date_text} + INTERVAL 1 DAY)END)

We solved this by using SQL similar to the below, which uses a parameter like suggested above: Hope that helps. =) -Scott Code: Post Edited by scottn at 09/21/2009 17:15

I have been experiencing similar issues as well. In regards to the formatting aspect, I've had a few cases now where the report gets saved minus ALL formatting, resulting in a black and white unformatted version afterwards. As Rameshinpower already mentioned, this seems to be highly tied to the memory load within iReport. I've noticed that the higher the current memory is compared to the maxiumum memory (as viewed on the memory toolbar) the greater the risk of one of these errors occuring during saving. If your report does get saved with a null value that makes it impossible to open, I have found that if I edit the file manually with a text editor to fix those null values that I will normally be able to open the file again afterwards. Also keep in mind that sometimes when it gives the null pointer value error that it is just temporary, in that if you close iReport and attempt to re-open the report a few times it will often open eventually as normal. Hope some of that helps, as I know it is very frustrating to work on a report and then have it be corupted for no apparent reason. =) -Scott

Hi all, I am currently using iReport 3.1.2 ,and can not figure out how to share styles between reports. In the older versions of iReport there was a "style library" that you could select from, which had an option for local within the report and a repository type option so that you could share the styles between reports. However in the current version of iReport, that style library does not seem to exist anymore, and I do not see a way to add the styles to the JasperServer repository or anything else like that. Any help / suggestions would be appreciated! Thanks, Scott

tidussea Wrote: i am using iReport3.0 and jasperReport3.0. i have tick the box of BOLD in iReport and compile it to jasper file, but when i product report using the jasper file, BOLD takes no effect. all text are the same, no BOLD so, i wonder what is the problem here and how to make BOLD take effect? Are you using a very small font? It is hard to tell the difference between bold and non-bold once the font size gets pretty small, so that is one possible issue. -Scott

Gaby38 Wrote: I confirm that installing the plugin XML and Schema fixed the problem for me. Previously "corrupted" reports can now be loaded in editor.As already said, this installation forces the upgrade of the IDE environment. In fact my error was "Invalid byte 2 of 3-byte UTF-8 sequence" and not "1 of 1-byte UTF-8 sequence" but I think that the troublr source is the same. This also solved my problem thankfully! However instead of installing the "XML and Schema" plugin, you may just install the "IDE Platform" plugin which is ultimately what solves the problem without having to install the extra plugin unless you need / want it. =) -Scott Post Edited by Scott Nemes at 01/09/09 20:36