This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I've got a table that gets output to Excel but I need to add a "Header". I can't use the Header tool. I need the text to show in Cell A1 (not just show up in the Print Preview) and I need the table to move down a few lines to accommodate that. I've been playing around with the Reporting Tools with no luck.
It needs to look like what I have below. Thanks in advance for any ideas/help.
Look into the Report Text tool. Select to "Attach text to existing field" and position the text above the existing field. You can reference fields in the text so you should be able to get the output you need.
That works if I wasn't repeating the column heading every time the account number changed - which is what the user wants. What was happening is the 3 lines were repeated above each set of column headings. To only insert the report name once I had to group all those first.