Skip to main content
Featured group

Reports & Dashboards

This is a public group. Ask questions, share posts and collaborate about reports & dashboards!

Currently, we have to limit the time frame to reduce the size of the file on a report showing all of the activities on opportunities if there are any, but we really only need the last activity record which we get in the Excel by exporting and deduping.

1 answer
  1. Jul 14, 4:53 PM

    Unfortunately you can't create a Row-Level Report Formula in a Custom Report Type that has a "with or without" Object Relationship.   

     

    You'd need to do something custom like a Record Triggered Flow that inserta the most recent Activity Id into a custom field on the Opportunity Object, or something like that, but even then you're facing some pretty long odds

0/9000
26 comments
  1. Jul 7, 7:21 AM

    good 

     

0/9000

*** Important Update: Step-Up Authentication for Report Actions ****** Important Update: Step-Up Authentication for Report Actions ***Hey Trailblazers! We have some important updates to share about the upcoming Step-Up Authentication requirement for Report Actions —Hey Trailblazers! We have some important updates to share about the upcoming Step-Up Authentication requirement for Report Actions —  Here's what you need to know: 

  

Change 1: Step-Up Challenges Now Scoped to Export Actions Only

Step-Up Authentication challenges will now trigger only when exporting or printing reports — not when simply viewing reports, dashboards, or accessing the Reports/Dashboards tabs in the UI. 

 

The Session Level Policy setting has been added to reflect this:

 "Require periodic step-up authentication when exporting or printing"

This updated policy replaces the prior setting upon enforcement. Find this by going to Setup -> Identity Verification and selecting the new policy for Reports and Dashboards. 

 

Change 2: Profile Login IP Restrictions as an Alternate Control

Step-Up Authentication for report exports will not be required when both of the following conditions are met:  

  • A user's Profile has Login IP restrictions configured, AND
  • Either the user's IP address hasn't changed between login and report export, or "Enforce login IP ranges on every request" is enabled in Session Settings

This gives admins a meaningful alternate control if your org uses IP-based access restrictions and when configured, users will not see step-up challenges during report export. 

 

Enforcement Timeline — No Changes  

Enforcement dates remain unchanged from what was previously published:

  • All Sandboxes: June 17 – June 24
  • Production: July 1 – July 25

 Additional Resources

Have questions? Drop them in the comments below — we're here to help! 

15 comments
  1. Jun 29, 5:11 PM

    @Kristi Maness

    thanks for this information:  "...in our testing, we have OKTA authentication for login but I currently have Salesforce authenticator as well so it kicks me there to verify the export."    

    I was

    wondering whether Admins could respond to the report export challenges via the regular authenticator.   To me, that seems easier than going back to the initial login method for Admins, which in our case might be Entra with a biometric option.  Is this what others are seeing?    (thanks, this has been very confusing for our small-ish org)

0/9000

We have Live Chat and Whatsapp on messaging sessions and need to report on the agents handling, however, I cannot report on the history object of a messaging session to capture all advisors which have handled the session. I am able to report on the Session Owner, however, this will only capture the last advisor to handle the session, but this could be handled by several advisors, especially Whatsapps as these could be replied to at a later stage by the customer and be routed to a different advisor. Has anyone been able to report on Messaging session history, it is not available for me in report types?    

 

@Reports & Dashboards 

1 answer
  1. Jun 28, 12:13 AM

    You've hit a real gap in Salesforce's standard reporting — MessagingSessionHistory is not exposed as a report type, so you can't get at multi-agent handling through the normal Reports UI.

    A few options depending on your technical resources:

    1. SOQL via Reports on a related object (limited)

     

    If you just need owner changes, MessagingSessionHistory tracks field history including OwnerId changes. You can't report on it natively, but you

    can

    query it via SOQL in the Developer Console or Workbench to validate what's being captured before committing to a build: 

    SELECT Field, OldValue, NewValue, CreatedDate FROM MessagingSessionHistory WHERE Field = 'OwnerId' 

    This confirms the data is there — it just isn't surfaced in reports.

    2. Custom LWC or Flow writing to a custom object

     

    The cleanest reportable solution is to create a custom object (e.g. Messaging_Session_Agent__c) as a child of MessagingSession, and write a record to it every time ownership changes — either via a record-triggered Flow on MessagingSession when OwnerId changes, or via an Apex trigger if you need more control. Once the data lives in a custom object, it's fully reportable with standard report types.

    3. Einstein Analytics / CRM Analytics

     

    If your org has CRM Analytics, you can pull MessagingSessionHistory directly into a dataset via a dataflow and report on it there — no custom object needed.

    4. Scheduled report via Apex + custom object

     

    A scheduled Apex job that queries MessagingSessionHistory nightly and syncs agent-handling records to a custom object — lower complexity than a real-time trigger if you don't need same-day accuracy.

    The Flow approach (#2) is probably the fastest path if you want this reportable in standard Reports & Dashboards without a big build. 

    I hope that helps!

0/9000

I'm trying to export a Salesforce report with some formatting on it. I have 2 fields in the grouped rows of the report and 1 field in the grouped columns. When I export the report as a formatted .xlsx, it only exports up to about 2000 rows. It's 2014 rows when you include the header (4 rows), the filters list (7 rows), the grouped column header (1 row), the regular column headers (1 row), the subtotal row (1 row), one more grouped value beyond what is visible in Salesforce (1 row), and the subtotal of that final value (1 row).    If I remove the second grouped row, I don't reach 2000 rows and it exports fine, so that wasn't a good test to run. So I ran a different report that I knew would generate more than 2000 rows when grouped. I only added 1 grouped field, and then saved and exported as a formatted .xlsx report, and this successfully generated the desired formatted and grouped report and 68,580 rows of data. Then I added another grouped field, and then saved and exported again as a formatted .xlsx report, and it exported 71,425 rows. So then finally I added a grouped column field, and that's when it started cutting off the data, and I'm only getting 2000 rows of data, 2011 rows if you include all those headers and subtotal lines and stuff.    So why, when a report has multiple groupings, am I running into a data limit?    This could potentially be a recent issue. A user sent this problem to me and informed me that they have been using this same report for years and exporting it as formatted .xlsx this entire time, but is running into this issue now for the first time. The data he is pulling has not suddenly surpassed 2000 rows, what he is pulling should have always had many thousands more records, and it would have been that way for a long time. I can't prove he's used that exact report this entire time, or that he exported it as he states he has, but he's been with the company for multiple years and is a trustworthy source on this kind of information so I am inclined to believe them.   

 

@Reports & Dashboards 

3 answers
  1. Jun 27, 5:10 AM

    Hi @Caitlynn Pérez When a report is grouped by both rows and columns it becomes a matrix report in salesforce. According to docs, when exporting a matrix report in Lightning Experience using the Formatted Report option, you can export up to 2,000 rows and 100 columns. In your case when grouping is added at only row level then its a simple tabular report and it can be exported upto100k which why you are able to export more than 2k records but it is limited to 2k when a column is added to group along with row(because now it becomes matrix and limit applied). In short its a limitation that you are facing in this usecase.

    https://help.salesforce.com/s/articleView?id=analytics.reports_export.htm&type=5

    https://trailhead.salesforce.com/content/learn/modules/lex_implementation_reports_dashboards/lex_implementation_reports_dashboards_report_formats

0/9000

Hello All,  

 

I've been reviewing the article about the new step up authentication requirements for report actions, 

Prepare for the upcoming Step-up Authentication requirements on Report Actions, and it says specifically, "Available in Sandboxes: 

Starting May 27, 2026, staggered over approximately 7 days".  

 

Therefore, I should see the "

Require periodic step-up authentication when exporting or printing

" option when I go to Setup --> Identity Verification --> Session Security Level Policies --> Reports and Dashboards, I do not see that option. The only options I have are: None, Block, Raise session to high assurance, Raise session to high assurance when exporting or printing, Require periodic step-up authentication. 

 

Another quote from the article, "Unlike the broader “

Require periodic step-up authentication” setting that was previously made available, the “Require periodic step-up authentication when exporting or printing

” policy allows users to view reports and dashboards without triggering a step-up challenge. While the new policy replaces the former by default upon enforcement, admins may see and select either option prior to enforcement." 

 

Does anyone out there have the specific "

Require periodic step-up authentication when exporting or printing

" option available in their orgs? 

 

I talked to Support and they say it should be available soon but could take up to 4 days, which would leave us 7 business days to test and understand end user effects and develop an effective communicaiton plan. This doesn't seem like good business practice on Salesforce's part. 

 

@Reports & Dashboards

2 answers
  1. Jun 22, 1:18 PM

    @Richardson Handjaja et. al. I understand that it was available as of 6/18 for my org. But the article clearly states, "Available in Sandboxes: Starting May 27, 2026, staggered over approximately 7 days", which means it should have been available no later than June 3rd for testing and understanding end user effects and developing an effective communication plan. Essentially being given 7 business days from the time the feature is available to enforcement is, in my opinion, an example of Salesforce not being a good business partner. I'm frustrated that they didn't do, in regards to the availability date, what they said they were going to do. And, I feel like they should extend the enforcement date by the time they missed having this feature available.

0/9000

🎉 Big shoutout to our incredible Forum Ambassador, @Sushil Kumar for an awesome deep dive on "Add Custom Link to Lightning App Record Page"!📘 Check out the article here >> https://help.salesforce.com/s/articleView?id=005336072&type=1 

 

🔍 Found it helpful? Have thoughts to share?

 Let us know by clicking the "Yes" or "No"  button at the bottom of the article—your feedback helps us improve!🎉 Big shoutout to our incredible Forum Ambassador, for an awesome deep dive on> 🔍 Found it helpful?" style="display: block;" />

 

#Reports & Dashboards

4 comments
0/9000
1 answer
  1. Jun 13, 3:54 PM

    Assuming you have already tried following built-in Report types :

    File and Content Engagement: Tracks how many times a file has been downloaded, shared, liked, or commented on.

    File and Content Downloads: Details which users downloaded specific files and exactly when they did it.

    Content Authors & Timeframes: Displays how many files each author has published and monitors publication volumes within a specified window.  

     

    Workarounds for Tracking Files on Records:

    If you need to report on which files are linked to standard or custom objects, native custom report types will not work because the underlying link object (ContentDocumentLink) is blocked from custom report types. Instead, use these common workarounds: 

    SOQL Queries: Run a query via the Salesforce Workbench or developer tools on the ContentDocumentLink object. For example: 

    SELECT ContentDocumentId, LinkedEntityId FROM ContentDocumentLink WHERE LinkedEntityId IN (SELECT Id FROM Account)

     

    Flow Automation: Build a Salesforce Flow that triggers whenever a file is uploaded. The flow can automatically check a custom checkbox field (e.g., Has_File__c) or update a timestamp field on the parent record, making the parent record easily filterable in standard reports.

0/9000

A dashboard with over reports using 3 different custom report types, A, B, C.   The report types B and C custom objects have no parent child relations with the custom objects in report type A.   The dashboard filter is based on the custom object/field in report type A.  

So Dashboard components using report type B or C has the "unavailable. There are no related fields in the report." error.

Any suggestion to get the Dashboard filter working for components using report types B and C?

5 answers
  1. Jun 12, 3:10 PM

    I achieved this by using the same API name for my custom field across all objects. Then the filter will work for report types A&B and B&C on the same dashboard.

0/9000

Hi Community,    I'm trying to build a Case report in Salesforce and need some guidance on the configuration.    **Requirement Overview:**  I need a summary report on the Case object that groups data by two fields:  - **Record Type** (standard field)  - **Request** (custom field)    For each unique combination of Record Type + Request, I need the following three columns:    1. **Closed Cases Count** – Count of cases where the Status picklist field contains "Closed"  2. **Open/Non-Closed Cases Count** – Count of cases where the Status field does NOT contain "Closed"  3. **SLA Missed Count** – Count of cases where the SLAMissed field (checkbox) is TRUE    **What I've tried / Where I'm stuck:**  I can group by Record Type and Request easily, but I'm struggling to get three separate conditional counts in the same report row. Salesforce summary reports don't natively support conditional column counts (like COUNTIF in Excel), so I'm not sure of the best approach.    **Questions:**  - Is this achievable with a native Salesforce Summary or Matrix report using bucket fields or custom summary formula.    Any guidance or examples would be greatly appreciated. Thanks in advance!   

 

@Reports & Dashboards 

1 answer
  1. Jun 10, 1:14 PM

    Can you post screenshots of the Report, showing the Report Type, the Settings, and Filters that you're currently using, the results you're currently getting, and a mock-up of what you want?  ​​​​​​​ 

     

    For questions related to Reports and Dashboards those are really helpful

0/9000