Jump to content

Recommended Posts

Hi

I need to show "incomplete" text next to my job price total on my summary report when the "Job Price" field on the customer job ticket does not have a price,

Sample:  

1.png

in the Hide object when, I have: not isEmpty (JobPrice) but it's not working it only works for the fields that customers have no prices on the job ticket and I want it to show if any price is missing for the customer job tickets..

Sample:  

2.png

Sample:   

3.png

Sample:   

4.png

Hope I'm making my self clear, your help will much appreciated.

Sorry, I did not know how to insert images so I'm using my google drive links for the images.

Pio Soto

 

Edited by Ocean West
made images to show inline.
Link to post
Share on other sites

Pio,

Welcome to the forums i edited the post to make images show inline.

In your job table create a calculated field isIncomplete to IsEmpty ( Jobs::JobPrice) then in the parent custom table Create a isIncomplete  that is Sum ( jobs::isIncomplete )   then you will have a count of how many jobs have no price.  

Hide logic would hide isIncomplete = False   You could even add this number to your customer so you know how many items are incomplete.

Link to post
Share on other sites

I don't really follow your description and this is largely a guess:

If you have a summary report of jobs grouped by customer, and you want to show your text when not all jobs in a group have a value in the JobPrice field, you need to define two summary fields:

  • sCountJob - Count of any field that cannot be empty (typically JobID);
  • sCountPrice - Count of JobPrice

Then set your text to hide when:

GetSummary ( sCountJob ; Customer ) = GetSummary ( sCountPrice ; Customer )

where Customer is your breakfield (the field you use for sorting the records and for the sub-summery part).

 

Edited by comment
Link to post
Share on other sites

Thank you guys for your help, the GetSummary is the one that worked for me, I really appreciate you guys taking the time to help.

Pio

Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.