CRP Files are a text file that can be opened in notepad or similar program, they have a format specified in the help file:
2017 SOLIDWORKS PDM Help - Formatting a Report Query. You do not have to have access to the SQL database to change the file but it makes it much easier in determining "HOW" to change it, because you can develop the queries and test them there and then bring into CRP file. One of the most difficult parts is figuring out what is stored where in the database. If you search the forums they can provide a lot info and there are charts showing the relationships between tables on there also, just don't have link handy.
I have attached a file with the modification to the attached report of adding the Full Name from the PDM Tables.
If you want to get rid of the username you can delete that from the section "SELECT U.Username, G.Groupname, G.Description, U.FullName" this is showing which columns are shown and there order flows the order here.
Report.crp.zip 505 bytes
This worked beautifully!!