Why is a Column Missing from my Salesforce Report?


Overview


While creating a new Report, Cloud Pacific ran into issues when grabbing and dragging a single column over to a different location on the report. In the Report below (image 1), you will see the following columns: Field, Old Value, New Value, and Modify Date.


Image 1



When the “New Value” column was grabbed and dragged to the left-hand side of the “Old Value” column, the “New Value” column disappeared, and the height of the rows increased in size (image 2).


Image 2



However, the “New Value” column was still included on the report according to the ‘Columns’ section on the left side bar (image 3).


Image 3



Given these findings, it seemed that the column was still on the report but had become hidden. Unfortunately, the only way to enlarge columns in a Salesforce report is to click and drag the column to the desired width--but since it was not visible, we were unable to enlarge it.



Proposed Solution


To troubleshoot this issue, first check to ensure that the Field Level Security (FLS) for the missing column (field) is enabled for your profile.


If the column is still not visible once the FLS is confirmed, remove the column from the report and re-add using the “Column” section on the left-hand side of the page (image 3).


If the following solutions have been exercised and the column is still not visible, the problem is likely a caching issue within your browser.


Clearing your browsers cache is quite simple but will slightly vary depending on the browser. In this example, we are using Google Chrome as the browser.


How to clear the cache in Google Chrome:


1. On your computer, open Chrome.

2. At the top right, click More.

3. Click More tools. Clear browsing data


4. At the top, choose a time range. To delete everything, select All time.



5. Next to "Cookies and other site data" and "Cached images and files," check the

boxes.



6. Click Clear data in the bottom right corner of the pop-up window.



To avoid this issue in the future, adjust the column location by clicking the drop-down menu on the desired column and select “Move Right” or “Move Left” (image 4).


Image 4



Or adjust the positions of the columns by clicking and dragging the column value on the left sidebar under “Columns” to the desired location (image 5).


Image 5

15 views0 comments