Questions tagged [custom-reports]
The custom-reports tag has no usage guidance.
144
questions
0
votes
0answers
14 views
Adding a field in a report
I have 3 objects. Case , Account and Address. The Case object is having Account lookup and we can easily pull account information via lookup fields in report.
But, there is no look up field present in ...
0
votes
0answers
25 views
Show a Join Report WITHOUT Chart on Lightning Home Page
I have a very simple use case:
Have a Joined Report
I want to show that on the Lightning App Home page
Have tried the following:
Create a Joined Report with Chart > Added to a Dashboard > ...
0
votes
0answers
10 views
Report for Accounts that purchased X but not Y?
Currently I have 3 objects, Accounts, Orders, and OrderLineItems. Orders have a parent relationship to OrderLineItems, same with Accounts/Orders, and then there is also a lookup relationship between ...
0
votes
2answers
17 views
Scheduled report did not complete - Update the schedule and change the running user
I am in the standard 'System Administrator' profile, and this permission has the 'Schedule Future Runs' permission.
I want to change the running user on a scheduled report from an inactive user to an ...
0
votes
0answers
4 views
Topic assignment custom report issue
I have create one report against Topic assignment and Feed post object,Topics assignment as parent object and Feed post as child object in custom report type.
From this report type i have created ...
1
vote
0answers
17 views
Row-level formulas not visible for all profiles
I have a row-level formula defined on my report on a field which is accessible to only a couple of profiles including Admin. The weird thing is that the formula is visible only to the Admin profile ...
0
votes
0answers
10 views
Partner users unable to access Object Milestone fields in custom reports
We have a custom report type for workorders with milestones, (Workorder(A) & ObjectMilestones (B) relation). The report is accessible to the internal users. However, for partner users, they are ...
0
votes
1answer
91 views
Lightning Experience Reports & Dashboards Specialist step-3 issue
Working on Lightning Experience Reports & Dashboards Specialist Step-3 as per the instruction but it is showing error. Can you please help me to find the issue.
Instruction:
Top Case Drivers by ...
0
votes
1answer
15 views
How can I stop using Data Loader to assign owners to Campaign Members?
Salesforce Enterprise Classic
I have an outbound team of 10 individuals. We are calling contacts and leads for various reasons.
Our Marketing Automation Platform populates Salesforce Campaigns with ...
0
votes
2answers
58 views
Is there a way to create an Account Send Summary Report with data shown day by day?
I need to create a report with number of sends, number of deliveries, delivery rate, unique opens, cumulative opens, open rate, unique clicks, cumulative clicks, click rate and email name, but I need ...
1
vote
0answers
15 views
Using Salesforce dashboard in salesforce MOBILE sdk based app or may be some other app out side salesforce context
I want to render the salesforce based dashboards in mobile app which is based on SFSDK only. What will be the best way to do it?
Currently i am making the call to get the dashboard data and then ...
0
votes
0answers
9 views
Report on Chatter for custom object
I need to create a report for my custom object when chatter post is idle for more than 2 to 3 hours. When latest post for a particular record has happened more than 2 to 3 hours then if I run the ...
2
votes
0answers
224 views
0
votes
0answers
18 views
Joined reports not recognising a field to join objects on
I have the following objects in my org:
Thing__c->Master-Detail-> Item__c -Lookup-> Concrete_Item__c -Lookup-> Join object -Lookup-> Account
and lastly a Thing_Account__c which has simply two fields ...
1
vote
0answers
15 views
Joined Reports with 2 unrelated child objects
I'm trying to create a joined report with a custom object (object A) as the base. It is the Master in two Master-Detail relationships (Object B and Object C). Object B and Object C are NOT related.
...
0
votes
1answer
32 views
Create a Formula field on Lead with converted Account Details
In our organization a sale is considered as complete only when a custom picklist called Account status is changed to 'Registered' on an Account. (We deal with registering new companies)
Business ...
0
votes
1answer
32 views
Reports : Using PREVGROUPVAL within a group only
I am trying to compute relative expected revenue through months. I am doing this using prevgroupval and it works fine. However, I have to add another level of grouping 'Stage'. With 'stage' being the ...
1
vote
0answers
18 views
Smart Totaling in Reports
How to avoid smart totaling feature in Salesforce Reports?Is there any workaround for this?
0
votes
0answers
7 views
Filter DuplicateRecordSets by Group
I have created a report to get DuplicateRecordSets and the DuplicateDataItems (Accounts) in each set, and grouped by DuplicateRecordSet.
I want to filter by the group. Basically want to keep only ...
0
votes
0answers
11 views
Creating a custom report on Opporutnity Split and History
We have a requirement where we need to see the Opportunity history with the Opportunity split details. Where we show the Split Owner, Split amount with the value of the amount that has been changed.
...
1
vote
1answer
50 views
How to run report and dashboard for real time event monitoring data
I have enabled real time event monitoring in production org and now requirement is to run report for couple of events(URIEvent,APIEvent,LightningURIEvents)
I dont see we can create report on big ...
0
votes
1answer
30 views
I want to hide Edit(Salesforce Classic) action from Report
I want to hide the Edit(Salesforce Classic) action from the report record, I checked in Profile and permission set, I not getting any permission related to hiding these button, This is a standard ...
0
votes
0answers
34 views
Using Territory Management Users for Dynamic Sender Profiles
I was wondering if anyone has ever come across the use of territory users being used as dynamic sender profiles for a one-to-one direct marketing experience.
The issues I am currently experiencing ...
2
votes
0answers
46 views
Reports for Opens in dark mode and device. Is there such a report in SFMC?
A couple of questions:
Is there a report/query available in SFMC to gather users who opened their email in dark mode?
Is there a report/query to find out what email clients users opened their email ...
0
votes
0answers
8 views
Make column to show total amount based on grouping
I have a report (below) that is grouped by pay period then pay element then pay item. What I want is instead of the Amount column showing two lots of 1000 (because there are two pay items) to show one ...
-1
votes
1answer
33 views
Is it possible to create a custom chart type in salesforce (one that can be used in reports)? [closed]
Salesforce reports lets you pick from a number of chart types (bar, line, pie etc), is it possible to extend these types for my org?
I want to create my own chart type and make it available in the ...
0
votes
1answer
46 views
How would I make a lead with lead history report?
How do you make a lead with lead history custom report?
I tried making the report type only to find that lead history isn't one of the possible secondary objects.
Since lead history is a related ...
0
votes
0answers
22 views
How to get Related Records of Related Records in a Report
I have an account called "Main". I have a custom object called affiliations that stores information about an account's relationship with another account. I can get all of the accounts affiliated with "...
1
vote
1answer
38 views
How to make a Report Folder publicly available for everyone in the org?
Title says it all: How to make a Report Folder publicly accessible for everyone in the org?
0
votes
0answers
27 views
Joined reports with master-detail relationship
I'm having problems trying to make a report of some custom objects, they're arranged like this:
A (detail) <-- B (master) --> C (detail of B)(master of D) --> D (detail)
Any ideas of how to get ...
2
votes
1answer
40 views
How to display summarised data as a text
I have a summary report on the User Presence object, it displays status duration at the summary level. the duration is in seconds and I need to display this in HH: MM: SS format.
The problem I'm ...
1
vote
0answers
20 views
Number of unique Accounts per custom field report
I have a text field myTextField__c custom field on Account object and i want to create a Lightning report "Unique myTextFields" where i want to have a number (a dashboard gauge) of customers that have ...
0
votes
0answers
15 views
How to Generate a report with Role Hierarchy for custom object?
We have role hierarchy filter in Opportunity object. The same way i need to filter records based on role hierarchy for custom object. report type is standard. Can you anyone suggest me any idea how to ...
0
votes
1answer
42 views
Report for users with and without Activities shows Record Count (1) for users without Activities
I created a report that shows Users with Activities from this week. It groups records by Full Name and for Users with Activities, it shows a correct number of records. For Users without Activities, it ...
0
votes
1answer
98 views
Dynamic campaign name
I need a unique campaign name to match triggered send mails (e.g. journeys) in a further system (after export the report).
Therfore I had the idea to put a suffix on the campaign name. E.g. ...
0
votes
1answer
75 views
Get field value User in Report on Custom object
Is it possible in Saleforce lighting to have a report on a custom object and get a field value from the user object without adding a formulafield on the custom object or is there a way to add the ...
-2
votes
2answers
223 views
How to call report in xlsx file format
could you please help me how to call report Xlsx file format, i am tried to below code, but i am not get the result:
public class BatchUtilClass {
@future(callout=true)
public static void ...
0
votes
1answer
120 views
I am not get the tabular report body in the attached email [closed]
I am not get the tabular report body in the attached email ,could you please help me.
global class Exportertest implements Schedulable,Database.AllowsCallouts{
global void execute(...
0
votes
0answers
14 views
A report with a Custom Report Type has a field not properly displaying
I am trying to create a report that utilizes a custom Report Type. I need this report to have fields and get filtered across three objects, Contact - A, Inquiries - B (With or Without A), and Offers - ...
0
votes
1answer
193 views
Report Filters filtering only by created date
I want to Create some reports on Account object and i see as filter Created Date as well as to choose to filter between other date fields (find screenshot). I cannot lock this field or exclude it from ...
0
votes
0answers
118 views
MobilePush - Track Push Notifications' Opens
One of our customers has asked a detailed report of users who opened a push notification. Is there such a report or some sort of a data view to query from? would be very helpful. Thanks!
0
votes
0answers
241 views
Open a salesforce report in LWC page
Dears,
is there a way to open a salesforce report inside a LWC page?
i have tried to add an iframe but the problem is that it redirect to the report in new window immediately. and here is how i use ...
0
votes
0answers
8 views
Global Report NO LONGER Global
I created a Global Report for all my users that was working just fine. In the last couple weeks, two of my users stopped getting the report. I went to log in as one of them to find out why they ...
0
votes
0answers
49 views
salesforce Report Amount converted field is showing wrong values
We have created a report for opportunities which shows amount of product lines (Custom object created by us where amount is a custom field) and amount(converted). When we run the report converted ...
0
votes
2answers
264 views
Can't pass 'greater than' or 'less than' operators in reportFilters via url
I have a lightning component that redirects to a custom report passing filters via url. This component is working inside a community and, as far as I know, you need to generate your url with a '...
0
votes
0answers
44 views
Can't redirect to custom report from community
I have a lightning component that redirects to custom reports including filters if needed and it's included inside one of our salesforce communities.
The issue is that the generated URL works fine ...
0
votes
1answer
65 views
Report on average time before first stage change
I am looking to generate a report which would put out a very specific timeframe which is from the stage "new" to "open - on progress", irrespectively of current stage the opportunity is in. I tried ...
0
votes
1answer
38 views
Delete Report Folder From Managed Package
We have managed package with custom Reports. We are planning to clean up some folders. Will it be a problem if report folder is deleted from Managed package which is already added in package earlier.
1
vote
0answers
16 views
Report Formulas - Divide Summary Field by Number of Users
I am trying to find the Average Number of Hours each user logs per week (by Billable vs Non-Billable Hours). I have attached a screenshot.
I want the sum of the hours (20.34) divided by the number of ...
0
votes
1answer
19 views
Activity Information Fields
While creating a report on Events and Activities, I can see the following fields available.
However, these fields are neither available on Event nor or Activity. I have checked the field list from ...
