I am in the process of attempting to design some reports and filter the output via the status of the job.
Job to have very basic details of job no, description and status.
I am attempting to run a report of all jobs ordered by the status. I wish to order the list of job numbers based on the status of the job whereby the jobs are ordered by status in the order of Completed, Order, Planning and Quote.
=NL("Rows","Job","No.")
When attempting to order the output from the above query based on the status of each job, I cant seem to get the outcome that I was hoping.
=NL("Rows","Job","No.","Status","Completed|Order|Planning|Quote")
I look forward to assistance in due course as I imagine this would be a simple filter that needs to be applied.
Date
Votes
1 comment
-
Jet Reports Historic Posts Hello.
Let's assume that I have data in my table that looks like this:
There are a few different ways to do this.
First, I could do a grouping report where I list out my Status categories and then list out all the records with that particular status:
When I run this:
Another method would be to simply sort my records based on the status field:
When I run this version:
If I needed to show the statuses in an order that was *not* alphabetical, I could hard-code my status categories and then use an NL(Rows) to return the records that match:
I hope that helps.
Please sign in to leave a comment.