ActiveReports issue with textbox controls and Excel

We just upgraded to ActiveReports 8 and a lot of our existing reports are now having issues when outputting to Excel.

The current issue is a field in a report is being output to the wrong Excel column, however, when the user chooses to output the report to PDF, everything works fine.

See attached Excel file. AgentFinanceChargeReport.xlsx

The values for the following columns are not in the same columns as the header:
MTD Finance Charge
YTD Amount Finance
YTD Finance Charge

After debugging, I noticed that the Textbox properties: WrapMode, Multiline, Width, and Alignment might be contributing to this issue, but am not certain.

Is anyone aware of any bugs that might be causing such an issue in ActiveReports 8?
LVL 8
pzozulkaAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

mlmccCommented:
I don't know about Active Reports and there aren't many if any experts in EE who use it.

I use Crystal Reports and it can have similar issues if the heading and the detail fields are not precisely lined up and exactly the same width.  
Also Crystal has an issue if there is any white space between fields in a row.  It will treat the white space as a column

mlmcc
pzozulkaAuthor Commented:
Off topic, but is there a reason to why few people use Active Reports? I'm new to it so don't know too much about it.
mlmccCommented:
This site is not necessarily representative of who uses what software.

I believe most people use Crystal Reports/Business Objects, MS SSRS, Oracle reports, or perhaps Cognos.  

Active Reports may be very popular just that no experts here (remember we are all volunteers and most found our way here generally because we had an issue or question then stayed to answer/help others).

Have you tried the Active Reports web site?

I know there have been Active Reports questions asked here but most have gone unanswered or a generic response like mine led to an answer.

mlmcc

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Crystal Reports

From novice to tech pro — start learning today.