Above sub report was created to get the bank name, bank code and branch code. All the different data come under a one data field as below. Please check the below images.
Below image shows the DAC related to this.
I want to assign the Account Value column data corresponding to the 4545,4546,4547,4548 and 4549 ID shown in the above image to separate variables, in order to send them to the main report. If is it possible, can I know how to accomplish my task?
Best answer by Laura02
View original
+18
Hello,
I have an idea you can try. Can you substring the above field to make smaller fields in the detail section of your report? I can’t tell if your fields are predictable length within the concatenated field… but many of the Bank Payment details have a mask and therefore are predictable length.
Example
@BankName = LEFT([CashAccountPaymentMethodDetail.DetailValue],20)
Laura
Thank you
The separation did not work only a trimming was happened to me. Can you please explain your point a little bit more to me? Thank you.
+18
Hello,
At first I thought all the values were in one record… now I see, the same field holds multiple, different kinds of bank data in different records.
Did you notice this similar post, related to supplier banking details?
Thank you
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
