bhanulakshmi Posted May 26, 2008 Share Posted May 26, 2008 Hello friends, I want to generate a report which should look like in the following desing the main report.That means Table A has 4 columns and n rows.Table B has 3 columns and n rows, and Table C has 2 columns and n rows. OK now the problem is I want to generate it based on the size of the department. Ex: if one office has 3 departments A,B,C Should repeat 3 times.(first A,B,C again A,B,C again A,B,C) And one office may have 4 departmentsso. i tshould generate four times(A,B,C, A,B,C, A,B,C A,B,C). that means department size is not fiexed. It is dynamic. How can I design such a report. I tried many times I could not get the answer. Please help me!!!! A CustomerID Name Address Phone ------------------------------------------ 3002 Alias 3/B,Portland 88776363 3002 Shaun 366,sthoms 443444444 B CustomerID Age Pincode -------------------------------- 23455 44 67544444 C Age Location ----------------- 43 penusal Thanks and Regard Bhanu lakshmi. Link to comment Share on other sites More sharing options...
teodord Posted May 26, 2008 Share Posted May 26, 2008 Hi, I don't understand what is the department made of.You need to explain the structure of your underlaying data better.But in any case, I think it is all about using subreports to display department information in a loop. You should check the /demo/samples/subreport sample provided with the project distribution package. I hope this helps.Teodor Link to comment Share on other sites More sharing options...
bhanulakshmi Posted May 26, 2008 Author Share Posted May 26, 2008 Hi sir, I have attached the file of the sample output. [file name=Jasper_reportforum.doc size=54272] 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