Forum Discussion

Tconolan's avatar
Tconolan
Contributing Cover User
6 years ago
Solved

Adding Fields in Report Designer

Hi I am trying to run a report of fees by client by poscode. It appears you cant use the postcode field in billing reports. The postcode field does not come up in the available list. Is there a wa...
  • nickypic's avatar
    nickypic
    6 years ago

    Hi Tconolan 

     

    Thats great news.

     

    It is not possible to do ranges on a text field (Postal). 

     

    The like filter can be to show more post codes if similar eg.    Like *28*     This should show all postcodes from 2800 to 2899 but could also accidently include any street numbers with 28 at the start.

     

    The above is the best I can offer.  You may need multiple reports or alternatively export the report to Excel and apply filters there.

     

nickypic's avatar
nickypic
Former Staff
6 years ago

Hi Tconolan 

 

Thats great news.

 

It is not possible to do ranges on a text field (Postal). 

 

The like filter can be to show more post codes if similar eg.    Like *28*     This should show all postcodes from 2800 to 2899 but could also accidently include any street numbers with 28 at the start.

 

The above is the best I can offer.  You may need multiple reports or alternatively export the report to Excel and apply filters there.

 

Tconolan's avatar
Tconolan
Contributing Cover User
6 years ago

Thanks Nicky

I did that and got the result you mentioned.

I will export to excel and filter in there. 

Thanks again.

Tony.

 

FAQs

Australian Tax FAQ's (DESKTOP + ONLINE)

Hello everyone!  We've collated a list of frequently asked questions users have posted on the Forum for your convenience. Check them out below! GENERAL What do I need to do before starting a ne...

Looking for something else?

Search the Community Forum for answers or find your topic and get the conversation started!

Community home

Dig into MYOB Academy for free courses, learning paths and live events to help build your business with MYOB.

 

Related content