Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

shantanu73
New Contributor III

Want to know the Step to get particualar word printed at the End of Report

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

23 Replies
Not applicable

Re: Want to know the Step to get particualar word printed at the End of Report

How important is it to You?Smiley Happy

shantanu73
New Contributor III

Re: Want to know the Step to get particualar word printed at the End of Report

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

Not applicable

Re: Want to know the Step to get particualar word printed at the End of Report

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?

shantanu73
New Contributor III

Re: Want to know the Step to get particualar word printed at the End of Report

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

shantanu73
New Contributor III

Re: Want to know the Step to get particualar word printed at the End of Report

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

Not applicable

Re: Want to know the Step to get particualar word printed at the End of Report

Hi

I do remember but it takes much loger than I thought

I'll try to do this on weekend

Ok?

shantanu73
New Contributor III

Re: Want to know the Step to get particualar word printed at the End of Report

Hello Pari,

I will wait for your important Solution on Monday.

Thanks in Advance

Shantanu

shantanu73
New Contributor III

Re: Want to know the Step to get particualar word printed at the End of Report

Hello Pari,

I am waiting for your Solution.

Thanks & Regards

Shantanu

shantanu73
New Contributor III

Re: Want to know the Step to get particualar word printed at the End of Report

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