tag:blogger.com,1999:blog-6266231010760265271.post6810213492445728390..comments2024-03-28T05:23:13.144-04:00Comments on Bekwam Blog: Parameterizing a JasperReports CrosstabCarlhttp://www.blogger.com/profile/15013889141640529637noreply@blogger.comBlogger25125tag:blogger.com,1999:blog-6266231010760265271.post-30409607127024423512016-05-20T13:45:52.923-04:002016-05-20T13:45:52.923-04:00Hello carl,
I just start to use jasper report. it...Hello carl,<br /><br />I just start to use jasper report. it is a simple problem but it does not work.<br />I just want to click on and it should show me the report below the link as a drop down.<br /><br />thanksAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-6266231010760265271.post-89017929824199656362016-03-09T20:16:05.818-05:002016-03-09T20:16:05.818-05:00Hi,
How to hyperlink from a crosstab Row Group ce...Hi,<br /><br />How to hyperlink from a crosstab Row Group cell. pls helpAnonymoushttps://www.blogger.com/profile/13624903080176863451noreply@blogger.comtag:blogger.com,1999:blog-6266231010760265271.post-38045548730667908262015-09-11T07:34:51.843-04:002015-09-11T07:34:51.843-04:00Hi,
I'm not sure this will be available withi...Hi,<br /><br />I'm not sure this will be available within the crosstab. Are you able to see it in a page header or page footer band?Carlhttps://www.blogger.com/profile/15013889141640529637noreply@blogger.comtag:blogger.com,1999:blog-6266231010760265271.post-82710019327441605182015-09-11T06:23:31.970-04:002015-09-11T06:23:31.970-04:00hi i want to map report variable to PAGE_COUNT in ...hi i want to map report variable to PAGE_COUNT in cross tab how i can i do thisAnonymoushttps://www.blogger.com/profile/13106696822763165326noreply@blogger.comtag:blogger.com,1999:blog-6266231010760265271.post-89619982366644437472015-01-05T06:04:58.859-05:002015-01-05T06:04:58.859-05:00Hi Carl ,
I have using the counter jar class.I&#...Hi Carl ,<br /> <br />I have using the counter jar class.I'm able to getting serial no. but whenever I',m generating the same its serial no is not resetting. serial number is generating from the last generated number. How to fix this issue ? Please help me.<br /><br />For example .<br /><br />Attempt 1: Counter No starting from . 1,2,3,4,5<br />Attempt 2: 6,7,8,9 <br /> Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-6266231010760265271.post-61121317550212220372012-11-28T07:54:42.490-05:002012-11-28T07:54:42.490-05:00Hi,
I have a crosstab made by iReport, I want to c...Hi,<br />I have a crosstab made by iReport, I want to click on a measured value and drilled into the detailed information that is summarized in this value. So far, I could not find any solution for it. I am just wondering if it is possible. If so, would you please help me in this issue?منhttps://www.blogger.com/profile/09298715577078324409noreply@blogger.comtag:blogger.com,1999:blog-6266231010760265271.post-64143019930951739552012-09-07T00:57:44.766-04:002012-09-07T00:57:44.766-04:00Hi Carl,
Thanks for your support, This thing gives...Hi Carl,<br />Thanks for your support, This thing gives the subgroup in front of the Parent group, I want that option in the below of the Parent Group(in same row) not in another column.°ღ•ÁŚℋℐŚℋ●•٠·https://www.blogger.com/profile/06416793556712922056noreply@blogger.comtag:blogger.com,1999:blog-6266231010760265271.post-55559337313044512202012-09-06T17:13:57.149-04:002012-09-06T17:13:57.149-04:00Hi,
I think this can be handled with the Crosstab...Hi,<br /><br />I think this can be handled with the Crosstab Wizard. Use a java.util.Date field from the Main Dataset. When you walk through the wizard, you'll be presented with a row group option for the field and can group by the date parts (year, month, day).<br /><br />See a screenshot that I just put up on this post.Carlhttps://www.blogger.com/profile/15013889141640529637noreply@blogger.comtag:blogger.com,1999:blog-6266231010760265271.post-16924850104638175742012-09-06T02:08:51.649-04:002012-09-06T02:08:51.649-04:00Hi Carl,
I am having one more question, that i n...Hi Carl, <br /><br />I am having one more question, that i need to make a grouping in the cross tab.<br />Let's take your above example, in that you are having the years on left hand side with serial number, now I want to add the months under that the years (suppose each year take any of two months)<br />Can you help me how it can be possible.<br />It looks like this: <br />1. 2012 <br /> Jan<br /> Mar<br />2. 2013<br /> Jun<br /> Aug<br />°ღ•ÁŚℋℐŚℋ●•٠·https://www.blogger.com/profile/06416793556712922056noreply@blogger.comtag:blogger.com,1999:blog-6266231010760265271.post-25412258406974865772012-09-06T02:03:18.704-04:002012-09-06T02:03:18.704-04:00OkOk°ღ•ÁŚℋℐŚℋ●•٠·https://www.blogger.com/profile/06416793556712922056noreply@blogger.comtag:blogger.com,1999:blog-6266231010760265271.post-54468063985827366622012-09-05T19:15:02.103-04:002012-09-05T19:15:02.103-04:00Hi,
I got this to work with 4.7.0. I skipped the...Hi,<br /><br />I got this to work with 4.7.0. I skipped the auto-increment (++), so Groovy isn't required.<br /><br />Thanks for commenting.<br /><br />http://bekwam.blogspot.com/2012/09/the-improved-crosstab-counter-in.html<br />Carlhttps://www.blogger.com/profile/15013889141640529637noreply@blogger.comtag:blogger.com,1999:blog-6266231010760265271.post-9095257651616953402012-09-05T01:50:00.977-04:002012-09-05T01:50:00.977-04:00Actually it is 4.6.0 version,
And when you are acc...Actually it is 4.6.0 version,<br />And when you are accessing this variable as a measure in the cross tab then you need to select the Calculation for that measure is Nothing.°ღ•ÁŚℋℐŚℋ●•٠·https://www.blogger.com/profile/06416793556712922056noreply@blogger.comtag:blogger.com,1999:blog-6266231010760265271.post-64065162572993518202012-09-04T06:45:13.466-04:002012-09-04T06:45:13.466-04:00The counter wasn't incrementing for me. I cou...The counter wasn't incrementing for me. I could pass the variable to the crosstab's text expression, but using "++" didn't seem to change the value. Using a count function in the variable (with the added group header), I got the same total listed with each expression.<br /><br />Are you on 4.7.0?<br />Carlhttps://www.blogger.com/profile/15013889141640529637noreply@blogger.comtag:blogger.com,1999:blog-6266231010760265271.post-7441566021848128232012-09-04T01:49:21.755-04:002012-09-04T01:49:21.755-04:00Hi,
Yes , I am using Groovy. What happened Carl.Hi,<br />Yes , I am using Groovy. What happened Carl.°ღ•ÁŚℋℐŚℋ●•٠·https://www.blogger.com/profile/06416793556712922056noreply@blogger.comtag:blogger.com,1999:blog-6266231010760265271.post-53126732367553300112012-09-03T12:25:32.457-04:002012-09-03T12:25:32.457-04:00Hi,
Are you using Groovy (rather than Java) for t...Hi,<br /><br />Are you using Groovy (rather than Java) for this?Carlhttps://www.blogger.com/profile/15013889141640529637noreply@blogger.comtag:blogger.com,1999:blog-6266231010760265271.post-27695996412390394932012-09-03T05:10:37.217-04:002012-09-03T05:10:37.217-04:00Thanks, and i also find the solution without using...Thanks, and i also find the solution without using the Scriptlet, something like this.....<br /><br />1. Create at variable under Variables, named as GROUP_COUNT.<br />2. Create a Group Header on the basis of which you want to count.<br />3. Go to GROUP_COUNT properties and select the following:<br /> a. Variable class Integer<br /> b. Calculation Count<br /> c. Reset Type Report<br /> d. Increment type Group<br /> e. Increment group <br /> f. Variable expression $V{GROUP_COUNT}++<br /> g. Initial Value Exp. 0<br /><br />Now you can use this variable in the Cross tab it will print the serial number as per you group/column.<br /><br />This is thing which I tried and worked at grouping level.°ღ•ÁŚℋℐŚℋ●•٠·https://www.blogger.com/profile/06416793556712922056noreply@blogger.comtag:blogger.com,1999:blog-6266231010760265271.post-15960364722579707402012-09-01T14:02:37.944-04:002012-09-01T14:02:37.944-04:00Hi,
Take a look at this blog post: http://bekwam....Hi,<br /><br />Take a look at this blog post: http://bekwam.blogspot.com/2012/09/a-crosstab-counter-in-jaspersoft.html.<br /><br />I wrote a small Java class that invoke via a Text Field Expression in the Row Group Header of the Crosstab.Carlhttps://www.blogger.com/profile/15013889141640529637noreply@blogger.comtag:blogger.com,1999:blog-6266231010760265271.post-18976044202239701782012-08-31T01:47:57.344-04:002012-08-31T01:47:57.344-04:00numerical counter value, which will get incremente...numerical counter value, which will get incremented with each row of cross tab.°ღ•ÁŚℋℐŚℋ●•٠·https://www.blogger.com/profile/06416793556712922056noreply@blogger.comtag:blogger.com,1999:blog-6266231010760265271.post-34757508184672011182012-08-30T17:40:17.033-04:002012-08-30T17:40:17.033-04:00Hi,
I'm not sure what you mean by serial numb...Hi,<br /><br />I'm not sure what you mean by serial number. Are you referring to something like an item number of a product or a numerical counter value?Carlhttps://www.blogger.com/profile/15013889141640529637noreply@blogger.comtag:blogger.com,1999:blog-6266231010760265271.post-42928615768216770312012-08-30T05:48:21.505-04:002012-08-30T05:48:21.505-04:00thanks Carl,
Can u pls tell, how to add serial nu...thanks Carl, <br />Can u pls tell, how to add serial number in cross tab.°ღ•ÁŚℋℐŚℋ●•٠·https://www.blogger.com/profile/06416793556712922056noreply@blogger.comtag:blogger.com,1999:blog-6266231010760265271.post-56590934896805182452012-08-13T21:29:31.484-04:002012-08-13T21:29:31.484-04:00I haven't put these two elements together, but...I haven't put these two elements together, but this video on creating a report that has both a list and a chart might help. A lot of reports will have a one-to-one correspondence to a query, but you can create more complicated ones. <br /><br />http://bekwam.blogspot.com/2011/04/tutorial-ireport-list-component.html.Carlhttps://www.blogger.com/profile/15013889141640529637noreply@blogger.comtag:blogger.com,1999:blog-6266231010760265271.post-24253882684945437082012-08-13T01:23:22.973-04:002012-08-13T01:23:22.973-04:00Is there any way to use crosstab and subreport tog...Is there any way to use crosstab and subreport together, or we can use any thing else instead of crosstab.°ღ•ÁŚℋℐŚℋ●•٠·https://www.blogger.com/profile/06416793556712922056noreply@blogger.comtag:blogger.com,1999:blog-6266231010760265271.post-65033511801651700652012-03-10T20:58:02.372-05:002012-03-10T20:58:02.372-05:00Here's a link to the post referencing the vide...Here's a link to the post referencing the video. There are some notes about installing a Java class in iReport Deisgner.<br /><br />http://bekwam.blogspot.com/2012/03/dynamic-crosstab-sorting-in-jasper.html<br /><br />Good luckCarlhttps://www.blogger.com/profile/15013889141640529637noreply@blogger.comtag:blogger.com,1999:blog-6266231010760265271.post-48766020671898603342012-03-10T19:10:15.791-05:002012-03-10T19:10:15.791-05:00Hi Tom,
I have a video coming out soon that shows...Hi Tom,<br /><br />I have a video coming out soon that shows how to do this using a custom Java class applied to a Comparator expression in the crosstab.Carlhttps://www.blogger.com/profile/15013889141640529637noreply@blogger.comtag:blogger.com,1999:blog-6266231010760265271.post-53821273849273503082012-03-09T18:05:52.217-05:002012-03-09T18:05:52.217-05:00Your explanations are very good.
Perhaps you could...Your explanations are very good.<br />Perhaps you could explain how to alter the sort order in a cross tab via a parameter - so far I have had no luck. Or do I have to use the comparator (like in Java)Tom Parryhttps://www.blogger.com/profile/11224942456027994035noreply@blogger.com