I have one composite datawindow. In that three DW are there.
First DW contains the company name and address.
Second DW contains the peoject description and cost of the project.
Third DW contains the total cost of project, overall time taken and other details.
All the above three DW have detail part only
My requirement is
1. When we print the report then the thrid DW should be bottom of the page (even that there are one project then this DW should be in the bottom of the page)
2. In second DW, some project description will go more than one. That time report system should adjust the hegiht automatically. If the project description end within a line then the second project desc should start next line itself.
3. If the report goes to more than one page then first DW should print on each page begining and the third DW should print in the bottom of the last page.
4. If the reports goest to more than one page then the bottom of each page should print the page number..
I tried like below
1. third DW should print at the bottom of the page - I have add dummy UNION ALL SQL and restict the number of rows to 24 in the second DW and set the visible propert as 1 when the length of project description as greater than 0.
if we are not set autosizeheight then its working fine for the 24 projects. if the projects more than 24 of If we set the autosizeheight property true then report not coming properly.
2. I have check the autosize height of the detail band and for the project description column. If we did like that then the system actual size of the column size (as per the DB table definition). so if the project desc is one line then alson two or three blank lines are there and then the second project starting. But I dont want this extra blank lines.
3. I dont have any idea about this.
Please guide me to sort out this problem. It is very urgent.
