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 am trying to install SMC on solaris 10. es-guisetup is giving errors as given below: smcdatabase service is always in maintenance mode. I am running postgres on 5433 port. Please help me in this regard. Here is the log file: # cat core-db-setup [More]
Hi everyone, I keep my 4 & 5 star songs on my C drive and the rest (all stars, 1,2 3, etc.) on my exhternal hard drive. Whenever I want to listen to my music, all I can readily play are the tunes on my C drive. I'm guessing the issues having one libr [More]
this is my wifes computer and she put her old ipod on spanish. now have the computer but i away in hawaii at work and need to change my itunes page to english. i went to preferens and their is not even english spot. i can't read spanish but managed t [More]
Hello! I purchased a Samsung LED TV for monitoring FC Studio trough a AJA Hi5 HDMI miniconverter. I can't afford a Hires SDI HD Pro monitor (3.000 euro or more). Image on the TV looks bluish than on the Apple Cinema Display or another PC monitor. But [More]
For example, when I use PlotLine to plot thousands of lines on the graph control, I want to delete some of them, but there is thousands of plotHandle generated. How can I get the plotHandle of the specific line on the graph control with using mouse t [More]
Hi there, Can anybody please assist.  When you have made changes to a FSV, you copy the structure to Report Painter with KE5b - but this is only for GLPCT table (EC-PCA).  Which transaction can be used to do the same for cost centres CCSS table?Hi, 1 [More]
Hi, If i have SQL Server 2008 R2 Enterprise License key for a single instance and I am installing all the shared features from the setup. Then is my license counted as being used or no? Or is it only used when i install Database Engine? Please mark t [More]
Hi, I tried to run the following JDO query: Query query = pm.newQuery(SomeClass.class); query.setFilter("someMap.contains(entry) && entry.key == value"); query.setOrdering("entry.value ascending"); query.declareVariables(" [More]
I've been reading posts here for a while and was saddened to hear the bad reports on the Memorex DVD's, as I had managed to buy about 100 of them quite cheap. So far I must be quite lucky, because I have burned about 25-30 with no problem on my iMac [More]
This is the link to upgrade the Epson printers to Lion, including Print CD. http://www.epson.com/cgi-bin/Store/support/supportLion.jspLion certainly has drivers for some Epson printers.  These will allow basic use of the printer.  Plugging your print [More]