Hi,
I have made a report where I first get a title out of my table trips (NL(Rows=3)-function). Underneath this title I get more info about this trip from another table (NL(Rows)-function).
When I print this information I would like to get my title from my NL(Rows=3) info into the Excel function -> Page Layout -> Print Titles -> Rows to repeat at top. This way when I print the report and a new page starts you have the title of the NL(Rows=3) on top of the page.
Does anyone knows how to do this (if it's possible)?
Regards,
Bert
Date
Votes
7 comments
-
Jet Reports Historic Posts Nobody…? :roll:
-
Jet Reports Historic Posts Hi Bert,
Yes it's possible. What you need to do is:
1. highlight all the rows where you place your title. in my example, I've highlighted row 5,6,7
2. define name for those rows, in my example, I gave it "MyTitle"
3. Page Layout -> Print Titles -> Rows to repeat at top = MyTitle
And that's it. those title rows will be repeated for each page that you print. Does it work for you ?
Andy -
Jet Reports Historic Posts Hi Andy,
Thanks for your reply.
Unfortunately, this does not work for me.
My titles I want to print is a result of an NL Row function. So I actually want to print the result of my NL Row function. When I do it your way, I get the result of my first NL Row function which keeps repeating on the next pages. And that's not correct ofcourse.
E.g.:
=NL("Rows=2";"Customer";"Name") -> This result I want to print as a title when starting on a new page.
=NL("Rows";"Customer";"Address";"Name";C4)
Regards,
Bert -
Jet Reports Historic Posts Hi Bert,
Sorry that I didn't truly understand what you meant the first time around. You are right, the method I showed you in my last post wouldn't work for this case.
But, good news, what you are asking is still possible. And this time, I think I got what you need. Go ahead and take a look at the samples I attached.
The worksheet is saved in report mode, so that you can immediately see that what you want is possible. Just press print preview to see the result.
Ok, after you see proof that it's possible. Here's how you can do it:
1. go to design mode, and notice that the NL (Rows) function that I want to make into title sits on row 3.
2. however, since I'm following your example, using NL(Rows=2). You need to put in "$3:$5" in the "Print Titles" -> "Rows to repeat at top". and the reason is because:
a. jet will use 2 rows to make replication (in this case row 3 & 4)
b. you need to "extend" it a row, so that every replication created by jet will be included in the title (and that's why you include row 5)
3. after you see how it works, go ahead and proof it for your self. it's easy, just modify the query in C3. I intentionally use limit = 5 here to give you sample.
go ahead and change this value 3, 7, 10, … and see that it really works =)
cheers,
Andy -
Jet Reports Historic Posts Hi Andy,
I want to thank you for your help and your answers, but according to me it's not possible.
Your solution does not work for me.
I've also made a report to show you what I actually want.
In my first line I have a Customer No., in my second line I have an amount out of the Cust. Ledger Entry. I always want on top of a new page the customer no. But using the "print titles" option in Excel doesn't help me. It keeps giving me the first customer no.
In my example, I want customer no. K00034 on page 2…
Regards,
Bert -
Jet Reports Historic Posts Ahh…. I see….. so that's what you want.
Well… I've already posted a solution for this kind of problem. It's not exactly like how you would like it to be, but I think it's the best solution for your problem.
http://community.jetreports.com/viewtopic.php?f=7&t=2530#p7552
And, even better, I've modified the spreadsheet especial for you (according to the sample you gave me).
What you need to do now, is to play with the "limit=" variable I've put in sheet Preparation, cell D3.
I gave it value of 49, because it just so happen that a full page is exactly 50 lines in my computer. So I have to substract it by 1 for the title row.
It might be different for you, and especially if you change the font size and play with the margin. But, all you need to do is just to change the "limit=" variable to make it fit into 1 page.
Cheers,
Andy -
Jet Reports Historic Posts Thanks Andy for the solution.
However, I think is to much work and effort just to have my titles printed out (especially with my different font and row height).
But perhaps this solution can be interesting for someone else.
Thanks again.
Bert
Please sign in to leave a comment.