Hi All, Fairly new to SAS and this is my first my post/question. Apologies if I'm not following protocol. BACKGROUND: I am part of a team developing reports for a client using stored processes authored in Enterprise Guide. We have the reports setup for the 4 main output destinations HTML, PDF, RTF, and Excel. Each has the client's banner across the top. All are working exactly as expected except for Excel. ISSUE: The banner in Excel appears as the first title line. However, because the image is a reference instead of embedded like PDF or MS Word (RTF), the image covers the next few title lines. These are the title of the report, date run, by whom, etc.. QUESTION: Is there a way to force the preimage to embedded within the Excel document like in Word or PDF? I have tried putting the title texts down to a higher title number (ie. title6), but the position in the Excel spreadsheet doesn't change. I have also tried using the "~{newline X}" like we used in our footers to get more than 10 lines of footer text. Any advice is greatly appreciated. If I haven't provided enough information, please let me know. Thanks, Michael
... View more