Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have a MULTI BOX with various selection criteria.
One of the selections is called CUSTOMER SCANNING VERSION, the end user can then select from the following
10.33
10.331
10.333
10.334
10.3318
10.51
10.52
10.525
10.529
10.5214
10.5218
All of these fields are needed, but i would like to make the end user experience easier by grouping all 10.33 together and 10.52 togaether.
Meaning that the end user can just click on 10.33 which will display all data relating to 10.33, 10.331, 10.333, 10.334 and 10.3318.
Can anyone help me do this please?
Thanks, for some reason it didn't work in my script, It blanked out some other fields.
But i tried it in an expression in my multi box and it worked great.
Thanks for your help 🙂
hI,
You could make a change in scrip while loading as under
= MID( ID, 1 , 4) AS MODID
What this does is that it makes the ID no as a 2 decimal number and this will solve your problem
Here's an example on how to create a second field to use for selections which will be associated with the detailed field.
Sorry, i made a mistake, There are no decimal points in the version numbers.
After looking at your attached example, and trying that in my script, it displayed .00 after every version number.
How can i do it without decimals?
What do your actual version numbers look like?
Sorry, they loom like
1033
10331
10333
10334
103318
1051
1052
10525
10529
105214
105218
Sorry to mess you all about 😞
And this is the part of my script..
LOAD
[Cust Code]
AS %LkDealReportTransactionCustomer,
[Cust Status]
,
[Cust Name]
,
Customer
,
[Cust Type]
,
BDA
AS %LkBDACustomer,
[Sales Ledger]
,
[Purchase Ledger Code]
,
[Customer Depot]
,
[Own Store]
,
NAAFI
,
[Nominal Cost Centere]
,
[Customer Group]
,
[Retail Group]
,
[Customer Scanning Version]
FROM
$(cFileName) (qvd);
ENDIF
Well if you know that the first 4 characters of the number are always going to be the 'group' then just replace Johannes' expression with a Left:
Left(F1,4) AS GroupNum,
Hi, Thanks for your help, i can get that working if i change the example that Johannes attached, but i can't seem to get it working in my script.
where would i put it? this is my script;
LOAD
[Customer Group],
[Retail Group],
[Customer Scanning Version]
FROM $(cfilename) (qvd);
ENDIF
Any more help anyone?