How to repeat Crystal Report Header on each page?

Conditional links in

• QUESTION: This question appears to have been answered but "offline." I need to select non-zero entries on one sheet and link them into a summary sheet with only a subset of the columns. Further, there are at least 106 rows on the source sheet (that number can be increased by inserting similar rows) and the result sheet should stop at 37 and start a new page. Bottom line? I don't even know where to start. ANSWER: Michael There is not a lot to go with here, but I believe you should start with a pivot table. ---------- FOLLOW-UP ---------- QUESTION: Thank you for taking the time to help me, Ken. If my question wasn't complete enough, I will try once more. I have a table with 7 columns, one of which is "quantity" which always begins at zero. (It has 106 fixed rows, but items can be added by inserting a new row, a description, price and again, quantity, if that item doesn't already exist.) I want to generate a "report" (spreadsheet) sent to someone else that only has the rows where a quantity was added (non-zero). That sheet only has 3 columns, all of which come from the source table (description, quantity and extended cost). I know, of course, how to link cells from one to another, but not how to only display certain rows (non-zero qty) nor how to generate a new print page (header and colum headings) every time I get to 37 non-zero qty items. (With 106 rows in the source table, I could obviously generate 3 pages if every item/row was selected.) Does that help, or just confuse things more? ANSWER: Michael I am pretty confused about what you are trying to accomplish. Do you want a report generated and sent every time something is added to the table? Or, every time a quantity is changed from zero to some positive number? Will a report ever have more than one line? Since all the quantities start with zero, it seems like a change in quantity has to be the trigger for generating the report. Are you trying to automate the e-mailing of the report as well? If so, what do you used for you e-mail? Outlook? What doest the 37 non-zero qty items have to do with the question? ---------- FOLLOW-UP ---------- QUESTION: Yes, no and maybe. Does that help? lolol Is this where a picture is worth a thousand years? Maybe this is what I know that I should have explained. I use a template which contains "pretty much" every part (106) I could possibly use I will call "Units" page. (Cols = Quantity, Description, Price, Extended for discussion sake.) Quantity and therefore Extended are at zero. For every item I will need to do the task, I will enter the quantity required which of course results in Extended being calculated. I do not want to print and send that page because it also has my vendor info, what the part costs me, etc., and I don't want what I send to have 101 zero rows if I will only use 5 parts, either. What I wanted to accomplish, then, is to cause my entry on the "Units" page to cause a page I will call "Bid" to be populated with only 3 of the columns and only the non-zero items from "Units." Then I could print it and mail it. "Thirty-seven rows" is an issue because, with the heading info, thirty-six rows is all that will comfortably print on one page. In the past, when I did this manually, if there were more than thirty six, I started a new page manually and cut and paste the remaining non-zero rows items. The last problem is this. Sometimes, a job requires something not already in my list, and so unusual I don't want to carry it in my list (if I did, I would easily have 1000 rows to wade through looking for the items I need or the items that have to be updated if I change vendors or they change cost). What I would like to do in that case is just insert a row on the "Units" page and have it, like any of the others, populate the "Bid" page as if it was also originally in the Template. Since I have never done more than link cells from page to page, I have no idea how to make this as "variable" as is required. Hence, all my manual effort in the past. Ken, thank you again. I wanted to make this simple and minimize your time. I'm sorry that I haven't accomplished that. Dynamically, yes, as page 1 (call it "units") is modified, page 2 (call it, hmmm, "bid"?) should be updated. If I change the quantity in row 1 from zero (I start with a empty "units" page each time using a template) to 1 (or 1 to 5 for that matter), I want to see a row in "bid" populated from the "units" page showing, trying to be simple, honest, the description, quantity I entered, and the result of price * quantity which is also an element on the source/"units" page. So, if I changed the quantity on 5 rows, I would

• Answer:

  Michael I believe your "question" is more than I or probably anyone else can answer in this forum. It seems as if you are building an application for whichcould be an ideal platform, but I suspect you are going to have to pay someone or do a lot of work yourself. Good luck.