hd_loki

So the issue did have to do with pagination, but in addition, I had to remove the call Code:response.setContentLength(pdfasbytes.length); and instead of Code:[code]outstream.write(pdfasbytes); I changed the outputstream.write method to include the length and offset Code:[code]outstream.write(pdfasbytes,0,pdfasbytes.length); in addition to unchecking the ignore pagination flag. :S

Here is the code I am using which I found on a post regarding the same topic: ServletOutputStream outstream = response.getOutputStream(); response.setContentType("application/pdf"); response.setContentLength(pdfasbytes.length); response.setHeader("Content-disposition","attachment; filename="runs.pdf""); response.setHeader("Expires","0"); response.setHeader("Cache-Control","must-revalidate, post-check=0, pre-check=0"); response.setHeader("Pragma","public"); //outstream.write(pdfasbytes); outstream.write(pdfasbytes,0,pdfasbytes.length); outstream.flush(); outstream.close(); But this isn't working either. Please help. Thanks, Heather

Hi, I inadvertantly searched iReports forum for tips on this and posted before going to the JasperReports forum. I am trying suggestions found there, but am not having any luck. I found one suggestion regarding unchecking the 'ignore pagination' option and tried that but it did not work for me. I looked for a possible overflow parameter on the exporter but could not find one. Can anyone who has solved this problem provide some context and a possible solution? Thanks Post edited by: hd_loki, at: 2008/03/26 16:37

I have a required query that if i hard code a beginning date works exactly. When I substitute the correctly defined Date parameter, JR cannot parse or breaks the query string. (amended) I see that the virtualizer is optional and returns null on even successful runs for functioning reports. The query is this: select floor((start_time - to_date('2007-01-01', 'YYYY-MM-DD'))/7) as week_no, sum(run_count) as run_count, from X where id = 100 and start_time between to_date('2007-01-01', 'YYYY-MM-DD') and to_date('2007-02-01', 'YYYY-MM-DD') group by floor((start_time - to_date('2007-01-01', 'YYYY-MM-DD'))/7) (removed xtra cols to simplify.) I am trying to substitute the expression to_date('2007-01-01', 'YYYY-MM-DD') with the date paramter. It appears that somehow the parsing of the query string just breaks down. Is it possible for me to do this? Why is the query string not parsed correctly? Post edited by: hd_loki, at: 2008/03/06 15:51 Post edited by: hd_loki, at: 2008/03/06 15:52

Well, I've made a little progress on this date grouping (by non-standard date formats). But have a few more questions if anyone would like to offer some help. What i've done is used a query (created by our resident oracle guru) using the rownum returned along with records in the Oracle RS: select sum(run_count) as run_count,floor(rownum/7),avg(avg_time) as avg_time from (select avg_time,run_count from stats_mv where start_time >= $P{psub_startDate} AND start_time < $P{psub_endDate} order by start_time )a group by floor(rownum/7) I created a class DateManipulator which receives the input startDate and int of increment to roll the date the given number of days and return the resulting Date. *But* I am wanting to group by that first and subsequent 7th day and believe I will need to implement the custom incrementer. Am I going in the right direction? I have searched the forum and can only find one instance of code implementing JRIncrementer, is there any documentation regarding the usage of this interface? Thanks for any help

Hi, Thanks for the tip. I was able to create a correct bucket expression before grouped by 'yyyy-ww', but I need to make the grouping as 7 day intervals from the start date, regardless of the week. I assume the custom function would create a custom expression to somehow mod off the week of the year based on the beginning expression?

Hi, I have created a crosstab which displays session run counts by referrer / date and have successfully set groupings on date for YYYY and YYYY-MM for a given date range but what I would like to do is to have the dates grouped in 7 day intervals rather than an exact week. So in other words, not necessarily Monday to Monday, but in increments of 7 days based on whatever the start_date parameter is (could be any day of the week). Is there a way to do that in a crosstab? Thank you, Heather