All fields available to Reports

  • 1
  • Idea
  • Updated 2 months ago
  • Not Planned
I would really really like it if all fields were available to Reports. Sure, keep the templates with the field report matrix as it is now, but then make another default Template that allows all fields to be accessible. 

I have already tried to make several reports, and continually find that I cannot use one of the fields needed to 'complete' the report. It is very frustrating.

I realize there is some backend stuff preventing this, but I think this should be a top priority. Having all the data there, and not being able to use it seems a waste - one of the reasons we got Replicon in the first place was to avoid this.

It would also solve a lot of peoples problems on this forum, which seem to be - I am trying to make a report template, but I cannot because a field is not available....

Photo of Jeff Bethune

Jeff Bethune

  • 9 Posts
  • 0 Reply Likes
  • frustrated

Posted 7 months ago

  • 1
Photo of Megan


  • 4 Posts
  • 0 Reply Likes
Yes this is definitely something that we have also found frustrating and not using much of the reporting within Replicon because of this which is a shame.  Would be good to have that available and also the ability to have a clean export of csv format data so that we could easily produce pivots and charts with the data without having to clean it up or auto fill information across blank columns which is a tedious task.
Photo of Akbar Ali Khan

Akbar Ali Khan, Official Rep

  • 185 Posts
  • 5 Reply Likes
Hi Jeff,

Thank you for using Replicon community,

I understand your requirement here, I have forwarded this to my product management team and will get back to with an update.

Photo of Jeff Bethune

Jeff Bethune

  • 9 Posts
  • 0 Reply Likes
This is just a follow up - I have tried to create several reports that I would assume are very common, but do not have access to all the fields for each individual report. For example:

Goal: Create a report that estimates the billing of a project, per user, for the hours they have been allocated in the resource planner.

Joe Bill rate = $100/hr
Jane Bill rate = $100/hr (its 2019!)

So if Joe and Jane are allocated 50hrs each for an upcoming month (timesheets have not been created yet), the report would show Total project Estiamted Billing is $10000 (Column Sum) becuase Joe hrs * Bill rate is = $5000, plus the same for Jane.

This is essentially the information available in the Projects tab if the Estimated billing column is enabled, however in that view there is not option to break down per user.

I have tried custom columns across many templates and can get part of the picture, but not the whole picture. This problem has arisen for many of the reports I am trying to create. I think this is an extremely limiting problem with Replicon that should be addressed with a high priority.
Photo of Jeff Bethune

Jeff Bethune

  • 9 Posts
  • 0 Reply Likes
As an update - I was able to create this report in the example using the Project Team Assignment Template. However I would still like a template that allows all fields!
Photo of Barnes, Matthew

Barnes, Matthew

  • 2 Posts
  • 0 Reply Likes
I agree with Jeff and Megan. It would be very helpful to have the ability to build a report that can access all fields. It is essential for us to build the payroll reports we need. As an example, key payroll input data includes OT and DT pay codes, billable hours, and time off details. Currently, we have to run three separate reports to get this data. Seems like an avoidable nuisance. 
Photo of Vinodh.V

Vinodh.V, Community Moderator

  • 179 Posts
  • 4 Reply Likes
Hello Matthew,

Thank you for adding your inputs.

We understand the requirement here and we have forwarded this requirement to our Product management team and they will look in this and will update this thread.

We really appreciate your time and patience.


Photo of Charlene Eriksen

Charlene Eriksen, Product Manager

  • 436 Posts
  • 43 Reply Likes
Hi everyone,

Unfortunately we don't have anything currently planned to enhance our reporting to allow a broader mix of columns. However, we did recently release data connectors to allow you to feed Replicon data into BI tools like Tableau and Power BI, which may help with more reporting flexibility. You can find more details here:

Photo of Jeff Bethune

Jeff Bethune

  • 9 Posts
  • 0 Reply Likes
Thank you for the reply and update Charlene. 

I realize that how the Replicon dbs are structured, a broader mix of columns is not possible. 

I continually stumble on a desired report that I am confident many other people would want, which is however, not one of the possible combinations of columns as limited by the templates. 

If you could narrow down some more useful templates, I really think this should be a prioritized item. It definitely puts a caveat on the usability of the reporting function of Replicon.

I have been told that there are some custom reports that can be created. A unique approach to meeting these needs would be to generate a forum post etc where active community members could request and/vote on templates (column combinations). A format for this forum could be similar to your Report Field Matrix. This could indicate to the dev team which reports are the most worth pursuing, if in fact they are possible to create. Just an idea.

I could list off several desired reports - however probably not worth explaining in this thread. Based on your reply, I doubt this will become a product focus anyway. The reply is appreciated anyway.