Dynamics Community Forum Thread Details

Fixing Bank Details RDLC Alignment

Hi all,

I have a problem in business central al programming, where i want all the bank name and bank account no. to show as a block and start from the same position. I will send the photos so you could see it better The fist photo is how the textboxes are in the rdlc layout, how the bank details are currently shown and the third is how i want them to show. The bank names number may vare depending on the invoice, it can be 3 banks or more or less. The bank name field is Text[100] but usually there are no invoices that have bank account with this much of characters, maybe max 50 characters. The bank names characters may vary from bank to bank. and the bank account no. is Text[30], but usually is 16 characters or 20. The BankAccountRec referes to the Record "Bank Account"

Here is my current code, that it might be wrong but to get an idea. In the RDLC report layout i have added the Bank Name and Account No. in two different textboxes:

        BankAccountRec.SetFilter("Bank Account No.", '<>%1', '');
        if BankAccountRec.FindSet() then
            repeat
                BankName += BankAccountRec.Name + CopyStr(' ', 1, MaxStrLen(BankAccountRec.Name));
                AccountNo += BankAccountRec."Bank Account No." + CopyStr(' ', 1, MaxStrLen(BankAccountRec."Bank Account No."));
            until BankAccountRec.Next() = 0;
    end;