include all data fields if record available for a report
If a record is included in the list of data to select for the report, allow all fields on the record to be added to the report. Example: opportunity report allows me to report org role id and type but not the start and end date. We track when donors are added to our legacy society through org roles (because it's dated) and stewarding those members through opportunities, it would be helpful to know when they joined (start date).
Lynn Oltmanns
shared this idea
Hello, Thanks for your time in the idea lab. This message is to let you know we are going to archive this idea based on the level of engagement in comparison to other idea lab items. The reason we do this is to keep the Idea Lab clean and up to date based on feedback from clients like yourself. Keep in mind this idea may exist somewhere else in the Idea Lab, a quick search may give you a similar idea with higher engagement. Also, feel free to recreate this idea if you would like to, and keep in mind specific wording can help people find and vote for your idea. If you have any questions, issues, or concerns please let us know! Thank you.
-
Sally Weldon
commented
If a field exists for data entry, it should be available for reporting. Here's our running list:
missing fields custom report by group:
Fund Advisor Fund
• Scholarships
• Last Login Date -Campaigns:
• Group Information (we don’t use but if we did we would need this data)
• Start Date
• Total Seats
• Seats Sold
o Any updates to campaigns have not resulted in more reporting fields available, only the basic 12 fields – an event details page has 21 fields, groups tab has three, Requests has three.Profile:
• Primary address TYPE
• Address Date (for summer/winter)Grants:
• Master Grant ID
• Grant Advisor (one entered, not Fund Advisor) (added 8/14/2023)
• Grant Letter Template (added 6/2/2023) -
Madison Leighty
commented
We have had to build workarounds for this kind of limitation more than once. For example, we are unable to create a single report that lists all open opportunities *and* opportunity note information where it exists (need to create two separate reports and then combine in Excel) in order to get an overview of moves management activities. Additionally, we would love to build multiple functional reports that incorporate donation and profile fund category information together (e.g., report a list of donations over a period of time and include profile info of the fund founder for each donation's fund), but we are unable to do so because these areas currently must be reported separately. Enhancements and expansions to the custom reporting area by CSuite developers would not only have a major impact for those of us who rely heavily on reporting for our work, but also greatly reduce the number of IdeaLab requests that boil down to "please add ___ field to ___ custom report."