Salesforce IdeaExchange
- then -
Force.com Platform Comments
| Force.com Platform Ideas
|
Reports and Dashboards Comments
| Reports and Dashboards Ideas
Exclude report footer when using Export Details to Excel
In reporting, when using the "Export Details to Excel" function, the generated report always contains a multi-line report footer. This footer is useful when reviewing reports in Excel, but it causes issues when you use that Excel file as an import file for another application.
How about a checkbox on the Export screen that you can select to "Exclude report footer"?
|
LogoJon 11/13/07 |
Agreed, it bugs when I work with the data in Excel. Same with the auto-filter feature. |
|
smplsol 11/15/07 |
This would reduce a lot of importing mistakes. |
|
saariko 11/15/07 |
I would have this as an optional area/fields. |
|
rpr2 11/16/07 |
A way to get exactly what is being requested here is to use Connect for Office. When you import your report to Excel select the option Raw Data and the filters will not be enabled, and there will be no extra info included at the end of the report. For me, having this information included is useful. It documents who ran the report and when if the extract is going to be circulated to other people - which is something that we do often. |
|
RK 11/27/07 |
Similar Idea here: http://ideas.salesforce.com/article/show/70089/Get_Rid_Of_Automated_Footer_on... |
|
wgzpayne 11/30/07 |
I use a macro to auto-fit my columns so the data is clearly visible. This footer always makes Column A far too wide... it's such a pain to have to delete it every time and makes my macro, well, useless. |
|
Hayley 12/03/07 |
I''m a great fan of this idea. The choice to exclude the details, or possibly put the details of the list pulled on a 2nd sheet. I exports reports from OneSource that provide the list details on a 2nd sheet. |
|
remym 12/04/07 |
It would be great to have this as a toggled option. |
|
drdan 12/10/07 |
From A legal requirement it is a good thing to have some of those comments there. Perhaps it could be removed from an admins. of exported data. |
|
heatherp 12/28/07 |
Yeah I think we should have the option to include the footer or not. I actually use the footer on reports sent to clients, but inhouse we don't need it. |
|
RK 01/03/08 |
Merged Idea
originally posted 06/25/07
Get Rid Of Automated Footer on CSV Report Extract
Because of limitations in Salesforce's reporting engine (too many rows, too many columns, limitations on printable view rows), there are times where I need to do data analysis work outside SF.com. For example, I might want to do analysis on 500K rows of data, which would require me to import the data into MS SQL
To keep my data clean at import, I need to go in and manually delete the automated footer that is placed at the end of the report (see picture). Although some of the files may be small and manageable, a 500K row (at a size of 50MB or more) csv file takes a long(!!) while to open up in Notepad. I'd like a way to suppress the footer either for all cases, or make it selectable as the report is exported. |
|
Kissa 01/03/08 |
Merged Comment
originally posted 08/23/07
I find it annoying!
|
|
wandrian 01/23/08 |
I agree this would be ideal to offer it as an option. There are times when having the footer is ideal especially if you are pulling the data on various occasions. |
|
Melissa_Hughes 02/05/08 |
I think the issue is that the info display at the bottom of spreadsheet. We then sort without removing this data. I would request to move it to the top and include the criteria. |
|
Jenny_Council 04/25/08 |
We find it out of order that this footer appears to copyright our data. SF do not have a copyright on Excel, the spreadsheet or the data contained, and they must already have copyright on their own side of the process. The "confidential information" clause implies it is the data itself - which belongs to us! So the copyright part should not be there, with or without a toggle. |
|
julian.peebles@transerainc.com 09/11/08 |
Merged Idea
originally posted 08/14/07
Remove footer for reports exported to Excel or .csv file
Give users the option to remove footer that is automatically populated at the bottom of report when exported to a Excel or .csv file. It's possible to upload this data into another application and the footer causes extra development to have it removed from each report.
|
|
RK 09/11/08 |
Merged Comment originally posted 08/14/07 |
|
Kissa 09/11/08 |
Merged Comment
originally posted 08/23/07
I find it annoying!
|
|
sane 10/24/08 |
Good Idea. We need this out of our reports as well. As a matter of fact: It is our data, so it is our copywright, not salesforce's |
|
sdm101 11/04/08 |
Also the formatting has Merged Cells and Wrapped Text clicked on. Please take these "features" away please. Thx. |
|
alaskagal 11/04/08 |
I agree, this is our data. This should not even be there... |
|
NicoleW 11/11/08 |
Possibly include as an admin option to default to "do not include" |
|
elizabeth_leath 11/13/08 |
It would also be nice to have a "hide filter criteria" option. For reports with multiple formula filter criteria, hiding the criteria from the standard users would be beneficial and help to avoid any confusion. |
track comments for this idea
Please log in to post a comment
last 100 promotions:
- CThompson
- cjones613
- cased19
- adept4
- joshvh
- chris_shauldev
- arlon_wilber
- elizabeth_leath
- BradPhillips
- lineagepower
- collabengine
- Fujifilm
- dlange@centerstance.com
- crmfyi
- ashah807
- crop1645
- philsiu02
- maribeth
- AnaSales
- NicoleW
- needinfo
- NetGenIT
- jasonkoe
- andreas_dangl
- JenCalvert
- herbertschmid
- jeff_hoffmann
- sum3
- studentforce
- Jaymes
- mbushinski
- georget
- 7/11/2007_1:27
- romandraut
- newleaders
- shankman
- randymchrysler
- NSDavid
- deshotton1
- prisch
- bluelane
- jennyjoycs
- jimson
- jsaf
- bgarner
- Arod
- mikedemko
- adptsr
- freemank
- brendav
- kenschaff
- iswinson
- jonathan_m_kane_ltd
- tommy1555
- jevans4
- jp_hess
- ndunn
- jencrms
- dmcheng
- nlg
- alaskagal
- richard_moore
- terralogos
- happyspartan
- llopo
- alvie_beck
- emg
- goldenfool
- pj100
- jeff333
- tinal
- altiasolutions
- leonmarkham
- bhfs
- forcesuperuser
- newby
- steven_m
- rosa
- wsuycott
- pindy
- aneesh_bhatia
- nnr
- reed_overfelt
- baldfatlimey
- EnPro
- mhamberg1
- sandraj
- john1300aust
- vsliwa06252008
- georgier
- robertokaiser
- saraw
- jennylincoln
- victoryjennifer
- sunedlm
- angie
- mikecore
- martin.brown02212008
- KEISA
- dearnr12132007
recently demoted by:
- garethdavies
- johnwa
- alex.lares@v2sa.com
- romit
- erinshannon
POST IDEA