Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-07-2022, 08:53 AM
jdonbavand jdonbavand is offline Project 2019 - using custom fields in reports Windows 10 Project 2019 - using custom fields in reports Office 2021
Novice
Project 2019 - using custom fields in reports
 
Join Date: Apr 2022
Posts: 10
jdonbavand is on a distinguished road
Default Project 2019 - using custom fields in reports


I want to create a report using two custom text fields in a table but I cannot see how to do so - is it feasible?
Reply With Quote
  #2  
Old 04-08-2022, 11:19 AM
ProjectPlanner's Avatar
ProjectPlanner ProjectPlanner is offline Project 2019 - using custom fields in reports Windows 10 Project 2019 - using custom fields in reports Office 2019
Advanced Beginner
 
Join Date: Mar 2021
Location: UK
Posts: 72
ProjectPlanner is on a distinguished road
Default

Add the 2 custom text fields to an existing or a new table and select this table when generating your report. Here a quick task report I generated using 3 custom text fields



Planners' Place
Reply With Quote
  #3  
Old 04-09-2022, 12:39 AM
jdonbavand jdonbavand is offline Project 2019 - using custom fields in reports Windows 10 Project 2019 - using custom fields in reports Office 2021
Novice
Project 2019 - using custom fields in reports
 
Join Date: Apr 2022
Posts: 10
jdonbavand is on a distinguished road
Default

Thanks - I know how to create them in a table but I wanted to use MS Project's Report tab to create a more professional looking report with Title etc, but you don't seem to be able to use custom fields in that. Is it possible other than copying and pasting into Word and 'prettying' it up as a Word table?
Reply With Quote
  #4  
Old 04-09-2022, 01:13 AM
ProjectPlanner's Avatar
ProjectPlanner ProjectPlanner is offline Project 2019 - using custom fields in reports Windows 10 Project 2019 - using custom fields in reports Office 2019
Advanced Beginner
 
Join Date: Mar 2021
Location: UK
Posts: 72
ProjectPlanner is on a distinguished road
Default

I might be missing something but to create a report, don't you need a table?

If it's a Visual Report, the custom fields are also available to you.
Reply With Quote
  #5  
Old 04-09-2022, 01:38 AM
jdonbavand jdonbavand is offline Project 2019 - using custom fields in reports Windows 10 Project 2019 - using custom fields in reports Office 2021
Novice
Project 2019 - using custom fields in reports
 
Join Date: Apr 2022
Posts: 10
jdonbavand is on a distinguished road
Default

If you go to the Report tab, you can create nice Reports in table format but when I go to the Field Picker list, I cannot find any of my custom fields.
Reply With Quote
  #6  
Old 04-09-2022, 01:53 AM
ProjectPlanner's Avatar
ProjectPlanner ProjectPlanner is offline Project 2019 - using custom fields in reports Windows 10 Project 2019 - using custom fields in reports Office 2019
Advanced Beginner
 
Join Date: Mar 2021
Location: UK
Posts: 72
ProjectPlanner is on a distinguished road
Default

By nice report, I guess you mean Visual Report? Are you saying your fields are not listed under Available Custom Fields in the Field Picker list?

Which fields are you trying to find and can you share a screenshot of your Field Picker list? Something similar to below.

Reply With Quote
  #7  
Old 04-09-2022, 01:55 AM
jdonbavand jdonbavand is offline Project 2019 - using custom fields in reports Windows 10 Project 2019 - using custom fields in reports Office 2021
Novice
Project 2019 - using custom fields in reports
 
Join Date: Apr 2022
Posts: 10
jdonbavand is on a distinguished road
Default

If you go to the Report tab, you can create nice Reports in table format but when I go to the Field Picker list, I cannot find any of my custom fields.
Reply With Quote
  #8  
Old 04-09-2022, 01:57 AM
jdonbavand jdonbavand is offline Project 2019 - using custom fields in reports Windows 10 Project 2019 - using custom fields in reports Office 2021
Novice
Project 2019 - using custom fields in reports
 
Join Date: Apr 2022
Posts: 10
jdonbavand is on a distinguished road
Default

No I didn't mean the Visual Reports which 3xport straight to Excel but the ones that were introduced in Project 2013 where you can create your own Reports using Tables and Charts.
Reply With Quote
  #9  
Old 04-09-2022, 02:09 AM
ProjectPlanner's Avatar
ProjectPlanner ProjectPlanner is offline Project 2019 - using custom fields in reports Windows 10 Project 2019 - using custom fields in reports Office 2019
Advanced Beginner
 
Join Date: Mar 2021
Location: UK
Posts: 72
ProjectPlanner is on a distinguished road
Default

I'm on holiday and this laptop does not have MSP 2019, so cannot try it out. I'll be back at work on 18-Apr and will try it out then if you don't have a resolution by then.
Reply With Quote
  #10  
Old 04-09-2022, 07:07 AM
jdonbavand jdonbavand is offline Project 2019 - using custom fields in reports Windows 10 Project 2019 - using custom fields in reports Office 2021
Novice
Project 2019 - using custom fields in reports
 
Join Date: Apr 2022
Posts: 10
jdonbavand is on a distinguished road
Default

Many thanks. Enjoy your holiday
Reply With Quote
  #11  
Old 04-17-2022, 10:27 AM
ProjectPlanner's Avatar
ProjectPlanner ProjectPlanner is offline Project 2019 - using custom fields in reports Windows 10 Project 2019 - using custom fields in reports Office 2019
Advanced Beginner
 
Join Date: Mar 2021
Location: UK
Posts: 72
ProjectPlanner is on a distinguished road
Default

So assuming we have these 2 custom text fields



We go and create a new Table report



To add the 2 custom text fields in the report, go to Other Fields >> Custom and they should appear on top of the expanded list, if you named them else they will appear alongside other custom text fields with default names.



custom flag and number fields will be under Flag and Number respectively in the Select Field picker

Last edited by ProjectPlanner; 04-17-2022 at 10:32 AM. Reason: images too large
Reply With Quote
  #12  
Old 04-18-2022, 12:59 AM
jdonbavand jdonbavand is offline Project 2019 - using custom fields in reports Windows 10 Project 2019 - using custom fields in reports Office 2021
Novice
Project 2019 - using custom fields in reports
 
Join Date: Apr 2022
Posts: 10
jdonbavand is on a distinguished road
Default

Thanks - I will retry - I couldn't find those Custom fields before. We have visitors at present but will get back to you when I have had chance to try it.
Reply With Quote
  #13  
Old 04-19-2022, 02:19 AM
jdonbavand jdonbavand is offline Project 2019 - using custom fields in reports Windows 10 Project 2019 - using custom fields in reports Office 2021
Novice
Project 2019 - using custom fields in reports
 
Join Date: Apr 2022
Posts: 10
jdonbavand is on a distinguished road
Default

Thanks - that works. I don't know why I couldn't see the custom fields when I tried before. I was recovering from COVID so may be I just wasn't thinking straight!

Many thanks.
Reply With Quote
  #14  
Old 06-07-2022, 07:51 AM
hedg hedg is offline Project 2019 - using custom fields in reports Windows 10 Project 2019 - using custom fields in reports Office 2019
Novice
 
Join Date: Jun 2022
Posts: 2
hedg is on a distinguished road
Arrow

Hi,
I am able to get the custom filed in the table, but how to get the same custom field in the graph and chart. And I am wandering how to re-arrange the custom table column. that means I want to move the column left and right side.


Thank you
Reply With Quote
  #15  
Old 06-19-2022, 05:15 AM
jdonbavand jdonbavand is offline Project 2019 - using custom fields in reports Windows 10 Project 2019 - using custom fields in reports Office 2021
Novice
Project 2019 - using custom fields in reports
 
Join Date: Apr 2022
Posts: 10
jdonbavand is on a distinguished road
Default

To move fields around, right-click on them in the Field List and select either Move up or Move down.
Reply With Quote
Reply

Tags
custom fields, report

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Project 2019 Reports window scroll not working properly CLL3 Project 1 12-01-2021 03:55 PM
Excel Reports from Project with Custom Fields mspwizardlol Project 0 07-22-2019 05:11 AM
Reports created in Project 2016 not viewable in Project 2010 Murali Narayanan Project 0 05-23-2019 03:59 PM
Project 2019 - using custom fields in reports Visual Reports (custom) Quinton Project 3 03-29-2012 08:03 AM
running reports out of ms project nmanus Office 0 09-09-2009 12:47 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:23 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft