Complex Report Challenge

0

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.com

Thanks in Advance

 

 

 

anbuselvan2558's picture
Joined: Nov 17 2009 - 11:24pm
Last seen: 10 years 1 day ago

24 Answers:

0

This looks like a simple crosstab.

 

Giulio

giulio's picture
27406
Joined: Jan 2 2007 - 4:15pm
Last seen: 9 months 1 week ago
0

 

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.

anbuselvan2558's picture
Joined: Nov 17 2009 - 11:24pm
Last seen: 10 years 1 day ago
0

Here you go

kchaudhry's picture
392
Joined: Apr 9 2007 - 6:10am
Last seen: 12 years 7 months ago
0

Hi kchaudhry, 

Thank you Thanks lot ........

It is woking fine. Thanks for the help.

Thank you once again

 

anbuselvan2558's picture
Joined: Nov 17 2009 - 11:24pm
Last seen: 10 years 1 day ago
0
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
fheswara's picture
Joined: Nov 17 2009 - 7:06pm
Last seen: 10 years 1 day ago
0

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

anbuselvan2558's picture
Joined: Nov 17 2009 - 11:24pm
Last seen: 10 years 1 day ago
0
So, no one reply my question? i though u said that is was easy and simple report?
fheswara's picture
Joined: Nov 17 2009 - 7:06pm
Last seen: 10 years 1 day ago
0

The second portion could be done by creating another cross tab. You can create a subdataset and then use it for your second crosstab.

kchaudhry's picture
392
Joined: Apr 9 2007 - 6:10am
Last seen: 12 years 7 months ago
0

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 Advance

Anbu



Post Edited by anbuselvan2558 at 12/02/2009 04:52
anbuselvan2558's picture
Joined: Nov 17 2009 - 11:24pm
Last seen: 10 years 1 day ago
0
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
fheswara's picture
Joined: Nov 17 2009 - 7:06pm
Last seen: 10 years 1 day ago
0

 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 section

Thanks in advance 

Anbu

anbuselvan2558's picture
Joined: Nov 17 2009 - 11:24pm
Last seen: 10 years 1 day ago
0
can anyone help me out this issue
anbuselvan2558's picture
Joined: Nov 17 2009 - 11:24pm
Last seen: 10 years 1 day ago
0

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

kchaudhry's picture
392
Joined: Apr 9 2007 - 6:10am
Last seen: 12 years 7 months ago
0
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
fheswara's picture
Joined: Nov 17 2009 - 7:06pm
Last seen: 10 years 1 day ago
0
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
fheswara's picture
Joined: Nov 17 2009 - 7:06pm
Last seen: 10 years 1 day ago
0

I am using a very old version of ireports (1.2.8). Did you click on "properties" or "crosstab properties"?

kchaudhry's picture
392
Joined: Apr 9 2007 - 6:10am
Last seen: 12 years 7 months ago
0

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.

Thanks

Anbu

anbuselvan2558's picture
Joined: Nov 17 2009 - 11:24pm
Last seen: 10 years 1 day ago
0

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 appreciated

Thanks

Anbu

anbuselvan2558's picture
Joined: Nov 17 2009 - 11:24pm
Last seen: 10 years 1 day ago
0

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".

kchaudhry's picture
392
Joined: Apr 9 2007 - 6:10am
Last seen: 12 years 7 months ago
0
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
fheswara's picture
Joined: Nov 17 2009 - 7:06pm
Last seen: 10 years 1 day ago
0

Try this.  Hope it helps and that I've put the right files up



Post Edited by christrueman at 12/09/2009 17:09
christrueman's picture
Joined: Jun 22 2009 - 9:30am
Last seen: 4 years 1 month ago
0

 

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 appreciated

Anbu

anbuselvan2558's picture
Joined: Nov 17 2009 - 11:24pm
Last seen: 10 years 1 day ago
0

 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

anbuselvan2558's picture
Joined: Nov 17 2009 - 11:24pm
Last seen: 10 years 1 day ago
0
Hi thanks before, but i still cant stretch the column dynamically. my data its so dynamic it can shrink and grow anytimes.
fheswara's picture
Joined: Nov 17 2009 - 7:06pm
Last seen: 10 years 1 day ago
Feedback