Page 1 of 1

Hidden Fields Affecting Output

Posted: Wed Jan 18, 2012 12:57 pm
by Andy
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