skeeve

Hey there, Doing it all in SQL is great, but how did you do it? Did you do it in a stored procedure? Or in the SQL query itself? Thanks a lot.

Ok, Lucian. Thanks for the info. I'll try the custom data source and I'll post a feature request as well. Regards, Skeeve

Hi again, Sorry to reply to my own post, but I've been digging and digging, and still can't figure out an answer to my problem. So, I'm re-asking my question in the hopes that someone might have an answer out there for this one. Thanks again! I'm hoping to get strong enough in Jasper to start answering questions myself at some point. Skeeve

Hi there, I'm wondering if anyone knows of the best practice to get all of the dates in a range reflected in the rows of a cross-tab report, even if there are no records for some of the dates in the range. So, as an example, I run the crosstab with rows for each date in a range, and get: Code:Date | some info | more info | Total 1/1/07 | 4 | 8 | 12 1/2/07 | 3 | 2 | 5 1/3/07 | 4 | 5 | 9 Total | 11 | 15 | 26 But, let's say there was no data for 1/2, it would be: Code:[code]Date | some info | more info | Total 1/1/07 | 4 | 8 | 12 1/3/07 | 4 | 5 | 9 Total | 8 | 13 | 21 I want: Code:[code]Date | some info | more info | Total 1/1/07 | 4 | 8 | 12 1/2/07 | 0 | 0 | 0 1/3/07 | 4 | 5 | 9 Total | 8 | 13 | 21 Any ideas on how this might best be done using JasperReports? I've toyed with creating a SP to add dummy rows for dates that don't exist, but this seemed wrong somehow. Thanks for your thoughts! Post edited by: skeeve, at: 2007/02/01 18:32 Post edited by: skeeve, at: 2007/02/05 20:11 Post edited by: skeeve, at: 2007/02/05 20:13

Hi! I third the motion for more scriptlet/subdataset examples. I bought both the iReports and JR Ultimate Guide, and neither have examples of how to make it work. I'm stuck getting the "Parameter not found : REPORT_SCRIPTLET" error. There's probably a really simple explanation for this, but I can't find it to save my life. Skeeve

Hi there, I couldn't find a previous discussion on this. I created a Scriptlet called: MonthSchedulePrintableScriptlet and set my SubDataset to use it for a crostab. But, no matter what I do, I get: Parameter not found : REPORT_SCRIPTLET when I try to reference it in a field like this: ((com.phase1.report.jasperreports.scriptlets.MonthSchedulePrintableScriptlet)$P{REPORT_SCRIPTLET}).getColumnCount() I know the class is being found, because if I delete the field and then delete the class file, I get a class not found exception. If I recompile the class file and run the report, it runs. Then, when I add the field back, the REPORT_SCRIPTLET error comes back. If anyone can help me here, I'd be grateful. Thanks! Skeeve

Hi there, I'm new to JasperReports and I'm excited about it. I created a servlet (with Spring) that runs reports pretty well. I use JasperReportsMultiFormatView and pass the format via the URL. However, I have to support a large Excel spreadsheet format that ignores pages entirely. This format would basically create a huge Excel grid with no paging. I've been using iReport to create the reports, but I haven't seen anything other than the "Ignore Pagination" option under the Build menu. This prevents pagination vertically, but still doesn't let my grid (crosstab) grow to the right. Furthermore, it's just the build menu anyway -- so it doesn't help me once I deploy. There's a class called: net.sf.jasperreports.view.save.JRSingleSheetXlsSaveContributor that seems to be close to what I need, but it's for saving the file, not for having the server upload it to the client. Does anyone have any thoughts on what might be the best way to either add a format to my current setup using JasperReportsMultiFormatView or to create a custom view? Thanks for your thoughts! Skeeve