Hidden Fields Affecting Output
Posted: Wed Jan 18, 2012 12:57 pm
				
				I have hidden fields in reports (fields that are off the printed page) that are used for internal calculations. When the user chooses to send the report to an Excel file, these hidden fields are shown, even though there is no data in them. ____The issue is that I have a second line that contains a description that is printed in the first of these hidden fields rather than the field it is supposed to be printed in.____1. How do I suppress the printing of these hidden fields?____2. How do I get the 2nd line to print in its proper place on the Excel report?____In the example below, Desc1 and Desc2 that prints is a description and prints over the first hidden field and is not in the last field where it belongs.____For example, the report will look something like this:____Field1  Field2     Hidden Hidden Desc__Item1   Something1 Desc1  blank__Item2   Something2 Desc2  blank