We use CR to develop reports for our client. Once we have designed the report, we then upload the report into SumTotal for client use. A lot of our reports have a multi-line/object page header and when the report is exported out of SumTotal into a Data Only Excel document, only the last line or text object will show in the excel file. This does not occur when the report is exported with formats. I have tried the following without any success:
1. Tried to break out the page header into a multi-section (A,B,&C).
Result: Only the object in PH-c will show when exported data only.
2. Used the Report Export Options and unchecked "Simplified Page Header."
Result: Only works when exporting directly from the CR application, does not work when report is uploaded into SumTotal and exported.
3. Tried to use a single text object and use returns between each line.
Result: All lines are shown, however strung together in one line within one row in Excel.
I am looking to have the lines in the page header to show in a line by line - row by row manner.
Does anyone know a work around or how to set that up?