Sitemap

Amicuk Programming Answers

Access report export to excel shows =sum() text boxes prefixed with the textbox name

-0001-11-30   Views:0

Advertisement

When exporting reports from access to excel the =sum() (group and total sums) text boxes all have the text box name prefixed to them in excel. They look good in access reports. Any way to turn this off? Why is this happening? I've seen the same issue

When exporting reports from access to excel the =sum() (group and total sums) text boxes all have the text box name prefixed to them in excel. They look good in access reports. Any way to turn this off? Why is this happening?
I've seen the same issue on 2 computers running Access 2010. I also tried this in access 2013 and had the same issue.
See the images below as examples, the first is from access, the second is the report exported to excel.
Access 2010 (http://i.stack.imgur.com/4roFM.png)
Exported report viewed in Excel 2010 (http://i.stack.imgur.com/6B1zj.png)

The replay answer
Advertisement
I've seen the same issue on 2 computers running Access 2010. I also tried this in access 2013 and had the same issue.
Hi Scott,
Did you use the same database file? May I know how did you create the report and those TextBoxes?
I couldn't reproduce your problem, this is what I did:
Create a sample table and the corresponding report. Group it by one of the field, then give it a footer section. In the footer section I inserted a TextBox and set the ControlSource property to "=Sum([fieldname])". But the name of the TextBox didn't
show in the exported Excel file. Check the screenshots here:
We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
Click
HERE to participate the survey.

Go to See the other 3 answers

Access report export to excel shows =sum() text boxes prefixed with the textbox name

Category:DefaultRelease time:-0001-11-30Views:130

When exporting reports from access to excel the =sum() (group and total sums) text boxes all have the text box name prefixed to them in excel. They look good in access reports. Any way to turn this off? Why is this happening? I've seen the same issue[More]

Access Report exporting to Excel Horizontally

Category:DefaultRelease time:2015-10-11Views:130

I've got a rather large report in Access, based on a couple of forms. When i preview it looks fine, Textboxes are all in order with the make and model then the data in text boxes in a column below. There are 7 columns of text boxes like this. When I[More]

SSRS report export to excel

Category:DefaultRelease time:-0001-11-30Views:130

Hi All, I have one developed SSRS report which is a matrix report (having customer name in column area and customer code in row area); and it is working ok no issue here.  Now I want to do something like : Is it possible while exporting to excel, I c[More]

Hyperion Workspace Financial Reporting Export to Excel Query-Ready Missing

Category:DefaultRelease time:-0001-11-30Views:130

Hyperion Workspace Financial Reporting Export to Excel "Query-Ready" option is Missing in the dropdown when you go to File>Export>Excel Only the "Fully Formatted" option is available. From what I recall this option for a "qu[More]

Web report Export to Excel Issue

Category:DefaultRelease time:-0001-11-30Views:130

Hi, I've tried to look at one of the issues already logged about the Export to Excel functionality and I was not able to find a solution to my problem. In my organization we are using BW 3.5. And when I run a web report, and try to export to excel a[More]

Ssrs report export to excel along with parameter filters

Category:DefaultRelease time:-0001-11-30Views:130

HI, In ssrs reports export to excel along with parameter filters,is it possible or not? Could you please help me.. induHi Sriindu, According to your description, you want to export the report into an excel file with the report parameter and filters.[More]

Hyperion Financial Reporting - Export to Excel converting Data to Text

Category:DefaultRelease time:-0001-11-30Views:130

We are using Hyperion Financial Reporting 11.1.2.2 with Hyperion Workspace 11.1.2.2 reporting on an ASO Essbase cube version 11.1.2.2. When we export a report to Excel any data values that are displayed in the report with a negative ('-', '()', etc.)[More]

Cross-Tab Report export to Excel

Category:DefaultRelease time:2015-10-11Views:130

I have a cross-tab report that I need to export to excel and keep the same formatting.  When I export the report the first column is Part # the next is operation #.  The report is grouped on Part number, but each part may have multi operation.  When[More]

Scheduled Report: Export to Excel (Data Only) Fails

Category:DefaultRelease time:2015-10-11Views:130

I have an issue with a new installation of Crystal Reports Server 2008. When I try to schedule a report for extract to Excel (Data Only) the report fails with the following error: Error in File ~tmp202064233ce6330.rpt: Operation not yet implemented.[More]

HFM Report export to Excel changes cell category

Category:DefaultRelease time:2015-10-11Views:130

Greetings, we just updgrated to version 11.1.2.2 and are noticing some strange behavior coming out of an some HFM reports we are exporting to Excel. We are trying to sum up some values and are getting #VALUE!. We have to manually change the category[More]

Job Pricing Reports - Exporting to Excel

Category:DefaultRelease time:-0001-11-30Views:130

Hi, I am testing the standard reports that are availabe in Job Pricing from within the portal.  Example the one report Salary Survey Participation, which is a report that is accessed from ERP, the option to Export to Excel is not working.  In the sel[More]

Hot
Hi I downloaded the generic sync templete from the MDK documentation and deployed it to my MI client but when i try to get the information from the WEBAS it is giving the following error Error: 500 Location: /SAMPLE_GENERICSYNC/start Internal Servlet [More]
For the last two days I've had a problem opening attached photos in the Yahoo Mail Slideshow feature. The screen goes to a grey layer as usual, but the photo never opens to view it. I don't think it's a Yahoo problem as the Slideshow works fine if I [More]
while copying photos from pc to ipad only one folder gets copied and while trying for other folders, the previous one which copied earlier does not appear.Are you selecting all of the folders to sync? Note that if you deselect a folder it will be rem [More]
Hello, when a drop down is not selected (leadSelection=-1) it's left blank (the first row). Is it possible to fill in a wording for this first row? Regards Horst TimckeI guess you are talking about the Web Dynpro UI element "DropDownByIndex". Th [More]
Dear Guru's I have a scenario in Excise return sales in Depot. When i Transfer Mater from Factory to Depot with price is Rs.14000., but when i sales to customer customer price is 13500 but duty will be calculate on Rs.14000. the invoice value will be [More]
Hello! I have installed the uperform server. However, when I enter the product key and company name to configure the server, it pops up an error message," The wrong number of arguments were provided for this method : ValidateKey". Also, the web [More]
Hi Experts, I install Business Content for Purchasing Analysis (Info Cube, Info source, transformation and query) And after thatu2019s I create two custom cube with transformation data flow of business content all work fine, But my customer want the [More]
Forgive me if this is the wrong discussion group. I am new to this area. I'm working on an existing application and the original Oracle cds have been lost. I need the following: 1. forms runtime 4.5.6.5.5 2. reports runtime 2.5.4.0.8 3. whichever ver [More]
Greetings, We are using Exchange 2007 and Office 2010 and 2013 throughout our company.  When I enter information in a to User Profile either on our AD or Exchange Management Console such as Phone Extension or Fax Number, that information does not app [More]
I am looking to design a website for my mother's store and was wondering if anyone knew of a good website design program. I am fairly new to Apple products. ThanksGive RapidWeaver a try. Excellent program and not expensive. <http://realmacsoftware.co [More]