Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Forums/Friends,
I had developed one report. There are lot of problem PFA of the same. Let me put the one problem first which is very important. It is 3 pages report.
In the 3rd/Last page I had written the words "End of Report" with the help of by ticking the Page Setting->Setting->Appendix Placement-Last Paper
and Appendx Height = 3 %
But problem is that word "End of Report" is get printed at the end of the page of Last/3rd Page. Pls see the attachment.
I want that As Soon As the Report End after 2nd or 3rd line the word "End of Report" should get printed in Last page.
I hope I had able to explain the scenario.
I had struk here. It will be greate help if anybody can show me the way.
Thanks in Advance
Shantanu
How important is it to You?:)
Hello Pari,
It is very important to me because I am developing very complex conventional report. In that regard it is very important to me.
Thanks in Advance
Shantanu
You want me to write macro creating pdf report (with the conditions You want) or it is bad idea, becouse You cant use macro in Your qv report?
how many objects You've got and how many different reports?
Hello Pari,
It is ok, If u desing the report with only 3 object as follows:
1. Text Object
2. Chart Object(Bar/Pie Chat)
3. Chart Object(Pivot Table only with 2 column Cust_Name, Sales_Amt)
The Format Should be as shown
1.Vendor Name 2Bar Chat
Pivot Chart
|-----------------------------|
|Custome|Sales Amt|
-------------------------------
|ABC | 1.00 |
|XYZ | 2.00 |
-------------------------------
|TOTAL | 3.00 |
|-----------------------------|
| |
|---End of Report---- |
| |
| |
| |
| |
| |
|-----------------------------|
At present I had design the report. But the word "End of Report" is coming at the end of last page. Though the report is get end at the half way of the last page. Pls see the attahment I had already attached in 1st trailing mail.
I want as soon as report get end the word "End of Report' should get printed at 1st or 2nd or 3rd line from the end of report as shown above. But not at the end of the last page.
One more request I want to keep Vertical Border line with different Vertical Border colour.
Thanks in Advance
Shantanu
Hello Pari,
I hope I had given required input as request by u or if u required some more information then pls let me know.
I am waiting for your solution please.
Thank
Shantanu
Hi
I do remember but it takes much loger than I thought
I'll try to do this on weekend
Ok?
Hello Pari,
I will wait for your important Solution on Monday.
Thanks in Advance
Shantanu
Hello Pari,
I am waiting for your Solution.
Thanks & Regards
Shantanu
Hello Pari,
Can I aspect some response from you?
R U want me to develop small report and send same to u so that u can change according my requirment?
Regards
Shantanu