jbl429

Great question. I'd love to know if anyone else has an answer to this.

good question... I'm hoping someone can provide an answer here as well.

Are you passing these parameters properly to the subreport?

Hi, I'm hoping you all can help me with a problem in iReport. I'm trying to create a multi axis chart, but I want them to share an axis. The reason for this is because the numbers are very closely related, but to write a query that joins the two values is VERY expensive (the two queries take 30 minutes alone to run, and way more when I join them). Is this possible to do? I'll also be adding a 3rd chart which I want to use the secondary axis, so I'd like this to be as clean as possible. Any help would be greatly appreciated. Thanks.

Hello everyone, I'm hoping I can get some help creating a specific crosstab. It's been driving me crazy. Basically I have a query which I have used to create a chart based off our inventory. The query returns the following columns: Date, count, value. Very simple output, but it's an incredibly expensive query, as it goes through thousands of log records to piece together the information. The problem is, I want to use this for a crosstab as well without rewriting the query. It already takes several minutes to run on a small sample of data, I'm afraid if I write another query for the crosstab, it'll take an insanely long amount of time to run. The crosstab I want to run should have the date as the column header, and either count & value as individual rows below it, or grouped together (I'm perfectly happy with either one, as long as I can get one of them!) Is there anyone who can help me with this? I'm running short on time, and this one crosstab is holding me back. Any help would be greatly appreciated!

brooneyx1, Thanks for your solution, but it's something that won't work well for me. If someone needs to run a report for a date range from a few months ago, the user will have to figure out how many days back they are running the report for. This won't fly with our users. We are trying to set up a reporting system and empower our users to run reports on demand. I like the way it's done in iReport with the default values, and was hoping there would be a similar solution in JasperServer.

Hello, I am trying to set up several reports in JasperServer which have date parameters. Typically the report is based off of a weekly period. Usually I will use parameters of {DATE_START} and {DATE_END} which works fine-- when running the report you can choose whatever start and end date you wish and the report runs beautifully. The problem, however, is scheduled reports. I want to send a report at the end of each week with {DATE_START} = 7 days ago and {DATE_END} = today. But when scheduling reports, I have to choose a specific start and end date. Furthermore, I can't even ignore these parameters have the default values used. This seems a little insane. If I want a report where users can choose the parameters I have to create one report. If I want a report to mail daily, I have to create another report with no parameter controls, and set the default values in iReport. If I want weekly report, I have to create a 3rd report. And a month end report is a 4th one. This is a serious pain. Is there something I'm missing? Please someone tell me there's a better way to handle this! Thanks in advance, Jeff

can anyone help?

Yes, I'm trying to do the same thing. Any help would be greatly appreciated. Thanks! Post Edited by jbl429 at 08/11/2009 13:54