0

Creating an extra filter

Jet Reports Historic Posts

November 12, 2015 01:29

None

Follow

Hi,

I have the Jet Express version and am trying to create a report to calculate how much we have spent for each project.

I am using these filters

Job No.
Job Task No
Job Task Description
No.
Resource name
Description
Total Cost (LCY) - total cost to date

How can I add another column to the same table to show how much was spent for this month alone. I would like for this to be shown next to how much was spent to date (Total Cost, LCY).

Thanks in advance

• Facebook
• Twitter
• LinkedIn

3 comments

• 0
  
  Jet Reports Historic Posts November 12, 2015 22:29

  Hello -
  
  Although this question would probably be a better fit for the Jet Express Express Community Site (http://expresssupport.jetreports.com/index.php), let's take a look.
  
  While Jet Essentials provides the ability to add certain custom formulas to an NL(Table), Jet Express strictly returns values from the database itself. Thus, if you have a flow field for cost that is impacted by a date filter, it would be possible to add a filter to your NL(Table) function for the desired date range.
  
  Alternately, if there are dates within your table, you could filter the NL(Table) to only return entries within the desired date range. In this way, the totals at the bottom of the table might provide the value you are seeking.
  
  I realize this is not exactly what you are after. You might want to try posting on the Express site to see if any of those users have ideas.

• 0
  
  Jet Reports Historic Posts November 13, 2015 03:43

  Thank you for your response

• 0
  
  Jet Reports Historic Posts November 18, 2015 15:25

  Hi There,
  
  I would add an option worksheet and have the datefilter in there and so just add another total cost column but have it linked to the option filter which you can change each time you run the report.
  
  Post your sheet if you like and I presume I can add the options filter for you if you like
  
  Regards
  
  Jared