Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I want to display range of alphabets between two alphabets selected in list boxes
example : I have two listboxes From and To , If I select 'A' in From listbox and 'E' in To listbox then result should display ABCDE in table
Please try this instead
May be using this:
=Concat(Chr(Ord(From) + ValueLoop(0, Ord(To)-Ord(From))))
PFA a not optimized solution
Hi,
I do not want to concatenate the selected values in range , I want to show the data in report between selected alphabets range
example data in report should show between values 'A' to 'E'
Please try this instead
Hi,
another solution using alternate states, set expressions and sample data from your thread listbox from and to date might be:
LOAD *,
Money(Rand()*100) as sales
INLINE [
StoreLocCode
RPOS1
L01RF
34GEF
9C3B
BDF21
BS040
DWKS008
TR97GH
4TYRS
];
hope this helps
regards
Marco
will it work for alphanumeric values?
example
If user enter From value '13l1A' and To value '14D1A ' in the input box and then click on button then below mentioned values should be selected as green in below Listbox
Values should selected as green:
13I1A
13I2A
13I2B
14D1A
Listbox:
13H1B
13I1A
13I2A
13I2B
14D1A
15D2A
15H1A
15H3A
20C6A
20D6B
Your initial question was how to reduce a table based on selections in two list boxes.
Selecting field values based on inputs in input boxes is another question.
Please clarify.
thanks
regards
Marco