[jasperreports-questions] The saga of sorting dynamically
Here is the scenario - For my company I implemented JasperReports as the reporting software since we wanted to move away from fee based software. so far so good. We use a custom datasource to fill up our report. In other words Jasper does not connect to db at all. For a report that I am currently working on my db team has written a stored procedure. One of the things that a client can do is choose the sort by col. They would do this by checking a radio button. They have a choice of three cols. eg. radio buttons have col1, col2 and col3 as choice. The user could choose col3 as the sort button. As a result the report should first be sorted by col3 and then by col2 and col1 in any order. Always the first col will be the user's choice. My db team says that they cannot parametrize the order by clause in the sql. They have asked me to see if I can pass in the user's choice to Jasper and Jasper can take care of changing the sort order. In the past I have implemented a cross tabs report using Jasper and I know that cross tabs can sort. But as far as I know I am not sure if I can change the sorting order runtime. Would anyone know if this can be done in Jasper and if so than how. thanks rahul - Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys -- and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV___ jasperreports-questions mailing list jasperreports-questions@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jasperreports-questions
Re: [jasperreports-questions] Extra white space when detail section overflows
Check the footer, if u are not using it , remove it or configure it to be at certain height from bottom of page Sent from my iPhone On Sep 14, 2011, at 6:09 AM, Muttalib Hossain wrote: > Hi > > In my report whenever the detail section overflows to the next page > there's an extra white space left at the bottom (where couple of rows > of data can easily fits) > Does anyone knows how to eliminate this space. > > Thanks, > Muttalib > > -- > BlackBerry® DevCon Americas, Oct. 18-20, San Francisco, CA > Learn about the latest advances in developing for the > BlackBerry® mobile platform with sessions, labs & more. > See new tools and technologies. Register for BlackBerry® DevCon today! > http://p.sf.net/sfu/rim-devcon-copy1 > ___ > jasperreports-questions mailing list > jasperreports-questions@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/jasperreports-questions -- BlackBerry® DevCon Americas, Oct. 18-20, San Francisco, CA Learn about the latest advances in developing for the BlackBerry® mobile platform with sessions, labs & more. See new tools and technologies. Register for BlackBerry® DevCon today! http://p.sf.net/sfu/rim-devcon-copy1 ___ jasperreports-questions mailing list jasperreports-questions@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jasperreports-questions
