anbuselvan2558 Posted November 18, 2009 Share Posted November 18, 2009 Hi ,I need an sample report like the below structure. Can anyone help me out.... Please ... Maths Department Science Department Social Science Algebra Gomentry Statistics Bilogy Chemistry Physics Botony Civics Economic sem1 sem2 sem1 sem2 sem1 sem2 sem1 sem2 sem1 sem2 sem1 sem2 sem1 sem2 sem1 sem2 sem1 sem2 Student 1 45 78 78 Student 2 50 85 Student 3 75 100 89 8 Student 4 79 90 35 Student 5 79 65 45 is this possible through iReport. You can also mail me on anbuselvan2558@gmail.comThanks in Advance Link to comment Share on other sites More sharing options...
Giulio Toffoli Posted November 18, 2009 Share Posted November 18, 2009 This looks like a simple crosstab. Giulio Link to comment Share on other sites More sharing options...
anbuselvan2558 Posted November 20, 2009 Author Share Posted November 20, 2009 Thanks Giulio,If you could provide me some sample it would be really great.Or if you could guide me how to group the second row based out of First row it would be very helpful. Please let me know if you need any further details. Link to comment Share on other sites More sharing options...
kchaudhry Posted November 20, 2009 Share Posted November 20, 2009 Here you go Link to comment Share on other sites More sharing options...
anbuselvan2558 Posted November 23, 2009 Author Share Posted November 23, 2009 Hi kchaudhry, Thank you Thanks lot ........ It is woking fine. Thanks for the help. Thank you once again Link to comment Share on other sites More sharing options...
fheswara Posted November 26, 2009 Share Posted November 26, 2009 Hi, can u make these three columns (Maths Department | Science Department | Social Department) into one big columns called "List Of Study Fields"? cos i dont know whats wrong with this but seems the cell width only bigger 2 columns size not full Thanks Link to comment Share on other sites More sharing options...
anbuselvan2558 Posted November 26, 2009 Author Share Posted November 26, 2009 Yes fheswara, You are correct. I am facing the same issue. We will try to ask the experts.Hi kchaudhry,Once again I am thanking you for guiding me in right way. I need few more help as well. It would be really great if you could help us out in this issue. One more problem that I am facing is I need this report with some modification that is please find sample report below: (Nothing I just need to give the total number of students with rages at bottom) Maths Department Science Department Social Science Algebra Gomentry Statistics Bilogy Chemistry Physics Botony Civics Economic sem1 sem2 sem1 sem2 sem1 sem2 sem1 sem2 sem1 sem2 sem1 sem2 sem1 sem2 sem1 sem2 sem1 sem2 Student 1 55 45 78 78 Student 2 70 50 85 Student 3 75 45 100 89 8 Student 4 79 90 35 Student 5 45 79 65 45 Total No of Students 60 > 2 1 0 1 1 0 0 1 1 0 1 0 1 0 0 1 0 1 50 =>& < 60 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 40 =>& < 50 1 1 0 0 0 1 0 0 0 1 0 0 0 0 0 0 0 0 <40 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 1 0 Please guide me...Eagerly waiting for your reply. Thanks Link to comment Share on other sites More sharing options...
fheswara Posted November 30, 2009 Share Posted November 30, 2009 So, no one reply my question? i though u said that is was easy and simple report? Link to comment Share on other sites More sharing options...
kchaudhry Posted December 1, 2009 Share Posted December 1, 2009 The second portion could be done by creating another cross tab. You can create a subdataset and then use it for your second crosstab. Link to comment Share on other sites More sharing options...
anbuselvan2558 Posted December 2, 2009 Author Share Posted December 2, 2009 Hi kchaudhry,Thanks for the info & guidence. But how can i create a subdata set in an dynamic content. That is if there are 100 students then this report would be displayed across many pages. But in each and every page I have to show that total section.Can you please help me out. Thanks in AdvanceAnbuPost Edited by anbuselvan2558 at 12/02/2009 04:52 Link to comment Share on other sites More sharing options...
fheswara Posted December 2, 2009 Share Posted December 2, 2009 Hi, Can u help me how to create crosstab header column with a maximum width size?Why i can only make it bigger 2 column size Thanks,Faisal Link to comment Share on other sites More sharing options...
anbuselvan2558 Posted December 2, 2009 Author Share Posted December 2, 2009 Hi kchaudhry,Can you please help us to come out from these two problem as Faisal and I have asked in previous forum list.I have just edited this to bring it in top of discussion sectionThanks in advance Anbu Link to comment Share on other sites More sharing options...
anbuselvan2558 Posted December 3, 2009 Author Share Posted December 3, 2009 can anyone help me out this issue Link to comment Share on other sites More sharing options...
kchaudhry Posted December 7, 2009 Share Posted December 7, 2009 It seems like you need to change the group header properties. You can go to Crosstab Properties > row and column groups > print the group header at this position > Center or Stretch Link to comment Share on other sites More sharing options...
fheswara Posted December 8, 2009 Share Posted December 8, 2009 Which ireport version that u use? where is the menu for this: "row and column groups > print the group header at this position > Center or Stretch" I cant find that menu in my crosstab properties Link to comment Share on other sites More sharing options...
fheswara Posted December 8, 2009 Share Posted December 8, 2009 I'm using ireport 3.5.3, i only have this menu for crosstab properties:- Repeat Column Headers- Repeat Row Headers- Column Break Offset- Ignore Width Property- Run Direction- Parameters Map Expression I also put my crosstab inside Summary Band Thanks,Faisal Link to comment Share on other sites More sharing options...
kchaudhry Posted December 8, 2009 Share Posted December 8, 2009 I am using a very old version of ireports (1.2.8). Did you click on "properties" or "crosstab properties"? Link to comment Share on other sites More sharing options...
anbuselvan2558 Posted December 8, 2009 Author Share Posted December 8, 2009 Hi kchaudhry,I am using jsaper ireport 3.5.2. I am not getting the menu what you have mention under crossTab properties.Please find attached the screenshot of my jasper report. Please let me know how should I have to navigate to that menu.ThanksAnbu Link to comment Share on other sites More sharing options...
anbuselvan2558 Posted December 8, 2009 Author Share Posted December 8, 2009 Hi kchaudhry,One more question.Is it possible to bring header and footer for all the pages if the summary band is spanned across the pages?Currently I am getting the page header only in the first page not in all the pages. The cross tab data is getting extended in the summary band. Please any guidance would be highly appreciatedThanksAnbu Link to comment Share on other sites More sharing options...
kchaudhry Posted December 8, 2009 Share Posted December 8, 2009 Unfortunately, I don't have that version so I won't be able to tell you the specifics. However, from the main report can you right click on the crosstab element and see if you get the option for "crosstab properties". Link to comment Share on other sites More sharing options...
fheswara Posted December 9, 2009 Share Posted December 9, 2009 Hi kchaudhry, No, when i right click on crosstab element there is no "crosstab properties" menu,i only have crosstab properties menu on the right side of the panel, but in that properties there is no menu that you mentioned before. Thanks Link to comment Share on other sites More sharing options...
christrueman Posted December 9, 2009 Share Posted December 9, 2009 Try this. Hope it helps and that I've put the right files up Post Edited by christrueman at 12/09/2009 17:09 Link to comment Share on other sites More sharing options...
anbuselvan2558 Posted December 11, 2009 Author Share Posted December 11, 2009 Thanks a lot for the response/ suggestion christrueman. Your suggestion was good. But have to rework on my java code that is a big task. It is there any other way or property through which I can achieve this. I hope is this an issue in crosstab ireport.Any help regarding this issue is highly appreciatedAnbu Link to comment Share on other sites More sharing options...
anbuselvan2558 Posted December 11, 2009 Author Share Posted December 11, 2009 Hi,Can anyone help me out in strecting or spanning the first column in crosstab. Which is spanning only up to 2 cols.Thanks Anbu Link to comment Share on other sites More sharing options...
fheswara Posted December 12, 2009 Share Posted December 12, 2009 Hi thanks before, but i still cant stretch the column dynamically. my data its so dynamic it can shrink and grow anytimes. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now