Forum | Synoptix

Learn, Create, Report
It is currently Thu Jul 18, 2019 9:34 pm

All times are UTC - 7 hours [ DST ]

Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 1 post ] 
Author Message
PostPosted: Thu Mar 21, 2019 2:27 pm 
Site Admin
User avatar

Joined: Tue Dec 10, 2013 3:27 pm
Posts: 403
Position: Forum Administrator
Download a 1 page PDF of these instructions here:

Account & Bounded Range Guide.pdf [78.76 KiB]
Downloaded 20 times

--The reporting client allows you to enter a range of account numbers within the report designer.
This will roll up all accounts within the range into a single cell, and is the equivalent of if you had entered each account number individually.
--An account range beginning and end number are separated by a colon.
--Wildcards are designated by question marks, representing placeholders instead of an actual number. The wildcards must be the same length as the account number they are representing. Wildcards can be used at any location within the account number.
--In order for an account mask to be filterable, it must contain wildcards.

Wildcards account mask.png [9.77 KiB]
Downloaded 3626 times

--Bounded ranges allow you to further narrow the window within segments of the account number. Essentially, they are a range within a range. It has been compared to the absolute range function in Excel.
--If your validation list is too expansive, this is a good indicator you need a bounded range.
--Bounded ranges are designated by brackets. Only the range you wish to parse needs to be contained in the bracket, rather than the whole account mask.

Bounded Range.png [5.7 KiB]
Downloaded 3626 times

--You can include multiple bounded ranges in the Account Numbers window, simply separate them with a comma.
--In order to apply filters within a bounded range, it must contain wildcards.
--A defined object with numbers in it cannot be filtered.
--If an account mask contains a bounded range and wildcards, and you want those wildcards to be filterable, the wildcards must also be placed within brackets.

Filtering bounded range.png [4.83 KiB]
Downloaded 3626 times

Display posts from previous:  Sort by  
Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 1 post ] 

All times are UTC - 7 hours [ DST ]

Who is online

Users browsing this forum: No registered users and 1 guest

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Powered by phpBB® Forum Software © phpBB Group
Powered by Reputation System © Pico88