Answers - Salesforce Trailblazer Community
Ask Search:
Best Answer chosen by Patty Ryder
Avi RAvi R
Patty - Create a custom report type with 'Reports' as main object and 'Dashboard Components' as related. Then you would be able to create a report to see what reports are being used in a particular dashboard(s). 

To create a custom report Setup--->Create--->Report Types
Andrew FrancisAndrew Francis 
When resizing a column on a report to make it smaller, instead of wrapping the text within each cell Salesforce simply clips the text. Is there a way to wrap the text like the Legacy Run Page did?

Example of the clipped text:
User-added image
Best Answer chosen by Andrew Francis
AMIT DATTAAMIT DATTA
Hi Andrew,

This Functionality is not supported in Reports now. Please upvote the below idea.

https://success.salesforce.com/ideaView?id=08730000000J7xM

Regards,
Amit.
Sudha RameshSudha Ramesh 
In classic UI, we have the option to create formulas and add the new formula field to the report. I am unable to locate this in lightning. 
Best Answer chosen by Sudha Ramesh
arpit vijayvergiyaarpit vijayvergiya
Hi Sudha,
Follow these steps.

User-added image

Thanks,
Arpit vijayvergiya
Best Answer chosen by Munna Jaiswal
Russell McGibbonRussell McGibbon
Hi Peter, I needed to update a profile with some object settings which it wouldn't let me do on the profile. So I created a new permission set with the required permissions on and then assgined it to all the users that have the profile. Fortunatly there wasn't too many users with that profile but its pretty easy to assign them from within the permission set. I've also been able to amend existing permission sets on the object and system permissions. I'm in a Full Production sandbox using the Winter release and LEX is not setup. Hope this helps
Steve MolisSteve Molis 
User-added image

Opportunity History Reports are f*cking awesome, they allow you to see the complete lifecycle of the Opportunity tracking changes to the "core" Opportunity Metrics: Amount, Stage, Close Date, Probability%, Forecast Category. And unlike Field History Reports they're available right out of the box and immediately have access to historical data from "Day 1" of your SFDC org.  In other words: they work retroactively.  They also have more robust Field Filtering, and access to Cross-Filters (they also don't look like they fell out of the top of the Ugly Tree and hit every branch on the way down).
 
However Opportunity History Reports do have an Achilles’ Heel:  You can’t easily see or filter by the current Stage, Amount, Probability%, Close Date, Forecast Category.  But you can do this (and whole lot more!) just by adding a few simple Formula Fields to the Opportunity Object.  Now some folks are probably saying: 

“I don’t want to add more formula fields, I don’t want my Opportunity to look like a Race Car at the Daytona 500!”. 

Here’s the thing; you don’t need to add the new fields to the Opportunity Page Layout, you just need to give the Users/Profiles “Read” access to the Data in the fields.  So you can keep your precious Opportunity Page layouts as pure as the driven snow in an Ansel Adams landscape.
 
Anyway, it's just an idea that I came up with.  I’m like Leonardo DaVinci, my mind is full of ideas...  although most of them are about as useless as a Wooden Helicopter powered by ropes and pulleys. 
 
And now without further ado here are the fields:
 
Current Stage
Datatype = Formula
Result = Text
Formula = TEXT(StageName)
 
Current Close Date
Datatype = Formula
Result = Date
Formula = CloseDate
 
Current Probability%
Datatype = Formula
Result = Percent 0 decimals
Formula = Probability
 
Current Amount
Datatype = Formula
Result = Currency
Formula = Amount
 
Current Forecast Category
Datatype = Formula
Result = Text
Formula = TEXT(ForecastCategoryName)  

User-added image
Best Answer chosen by Miglena (Salesforce.com) 
Steve MolisSteve Molis
Hi Nate,
If you need a report that shows the current Stage, Close Date, $Amount, Probability% and the historical changes to those fields in 1 Report.    

For eaxmple:  Yuo need a Report of all Opportunities that are currently in the Negotiation/Review Stage with the complete History of Stages, $Amount, Probability, Close Date, etc.  

With a standard Opportunity History Report if you Filter the Report by "To Stage" [equals] Negotiation/Review you'll get any Opportunity that was ever in the Negotiation/Review stage regardless of what Stage they are currently in. 
Steve MolisSteve Molis 
Here's a Formula I built to create an "Ultimate Parent Account" field that you can use to create Opportunity Pipeline reports that roll up all Opportunities under the top Account in the hierarchy. 

*** in this example I'm testing up to a 5 Tier Account Hierarchy (Compiled size: 342 characters) ***

Datatype: Formula 
Result: TEXT 
Formula: 
 
IF(NOT(ISBLANK(Parent.Parent.Parent.Parent.Parent.Name)), Parent.Parent.Parent.Parent.Parent.Name,
IF(NOT(ISBLANK(Parent.Parent.Parent.Parent.Name)), Parent.Parent.Parent.Parent.Name,
IF(NOT(ISBLANK(Parent.Parent.Parent.Name)), Parent.Parent.Parent.Name,
IF(NOT(ISBLANK(Parent.Parent.Name)), Parent.Parent.Name,
IF(NOT(ISBLANK(Parent.Name)),Parent.Name,
Name)))))

 
Best Answer chosen by Miglena (Salesforce.com) 
Steve MolisSteve Molis
An #AWESOME bonus tip from @Jeremiah Dohn to turn the Ultimate Parent into a Hyperlink to that Account

Datatype: Formula 
Result: TEXT 
Formula: 
 
HYPERLINK('/' + 
IF(NOT(ISBLANK(Parent.Parent.Parent.Parent.Parent.Name)), Parent.Parent.Parent.Parent.Parent.Id, 
IF(NOT(ISBLANK(Parent.Parent.Parent.Parent.Name)), Parent.Parent.Parent.Parent.Id, 
IF(NOT(ISBLANK(Parent.Parent.Parent.Name)), Parent.Parent.Parent.Id, 
IF(NOT(ISBLANK(Parent.Parent.Name)), Parent.Parent.Id, 
IF(NOT(ISBLANK(Parent.Name)),Parent.Id, 
Id))))), 
IF(NOT(ISBLANK(Parent.Parent.Parent.Parent.Parent.Name)), Parent.Parent.Parent.Parent.Parent.Name, 
IF(NOT(ISBLANK(Parent.Parent.Parent.Parent.Name)), Parent.Parent.Parent.Parent.Name, 
IF(NOT(ISBLANK(Parent.Parent.Parent.Name)), Parent.Parent.Parent.Name, 
IF(NOT(ISBLANK(Parent.Parent.Name)), Parent.Parent.Name, 
IF(NOT(ISBLANK(Parent.Name)),Parent.Name, 
Name))))))

 
Andrea GertzAndrea Gertz 
I've been asked to create a scheduled report...no problem.
The challenge is that the information requested for the report comes from various objects related to the account and contract, but some are related to objects related to the account.

Here is a summary of how they're related:

Object relationships

Is there a way to get all of this in one report?  (We have Roll-Up Helper, but I was looking to avoid some extra backend clutter)
Best Answer chosen by Andrea Gertz
Steve MolisSteve Molis
I don't think you can get there in a single report, you're probably looking at a Joined Report, or more likely a Dashboard
CB IT Support - RobinCB IT Support - Robin 
I have a user who cannot remove fields from a custom report type when using GC; the box with the fields will never highlight so that he can drop the field. However, I've logged in as the user at my location and removed the fields just fine, using GC. I advised the user to try IE and when he did it worked. I asked him to log back in to GC and clear history, cookies, cache and it still didn't resolve the issue. The only other thing worth mentioning is that he is on a different network than I am, although I'm not sure if that affects anything. I'm stumped on this one. Any ideas? 
Best Answer chosen by Ed (salesforce.com) 
CB IT Support - RobinCB IT Support - Robin
I actually figured this one out! The user had their Chrome browser set to 90% zoom. When we changed it to 100% it worked like a charm! Just a crazy one-off. 
Bill DavisBill Davis 
When I create a report there are times when I want to automatically email the report to specific users using the Schedule Report feature.  But this report email is always sent even if it has no results in it.

Is there a way to supress the email if there are zero results in the report?

Many of our other tools have this in the scheduling options as a simple checkbox, is there an option to supress somewhere?
Best Answer chosen by Bill Davis
Steve MolisSteve Molis
 No, there is no Auto-Supress if NULL option for scheduled reports.  
This isn't really considered a problem on our SFDC.Org,  because if the Report is empty but that is not the correct or expected result, it serves to alert everyone that something is wrong.  
Vineeth VVineeth V 
I recently started tracking the field on a custom field in account object. Is there any possibilty that to retrieve the entries in report prior to the period that I enabled it? 
Best Answer chosen by Vineeth V
Sunil SarillaSunil Sarilla
Hi Vineeth,
It is not possible to retrieve the entries prior to the period of tracking.
Your best bet is to look into backup files if you are backing up the data.