Solved

ActiveReports issue with textbox controls and Excel

Posted on 2014-11-21
3
262 Views
Last Modified: 2015-01-06
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?
0
Comment
Question by:pzozulka
  • 2
3 Comments
 
LVL 100

Expert Comment

by:mlmcc
ID: 40458546
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
0
 
LVL 8

Author Comment

by:pzozulka
ID: 40458715
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.
0
 
LVL 100

Accepted Solution

by:
mlmcc earned 500 total points
ID: 40458900
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
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Today I had a very interesting conundrum that had to get solved quickly. Needless to say, it wasn't resolved quickly because when we needed it we were very rushed, but as soon as the conference call was over and I took a step back I saw the correct …
Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …

746 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now