November 22, 2017 at 8:50 am
Hello,
I need to pass a comma separated values to subreport. The string that is used to obtain input parameters is below
"02 Programming & Broadcasting expenses, 03 Selling expenses,04 General & Admin. Expenses, 05 Other operating income/(expenses), net"
It used to be done with help of Split function but now i have to deal with extra field "05 Other operating income/(expenses), net" that has comma within it so now Split function divides new string to "05 Other operating income/(expenses)" and "net".
Can you please help me to find solution to pass all 4 parameters?
I've tried to concatenate values like this
= "02 Programming & Broadcasting expenses" & "," & "03 Selling expenses" & "," & "04 General & Admin. Expenses" & "," & "05 Other operating income/(expenses), net"
but it doesn't work. I don't see any solution
November 22, 2017 at 8:55 am
lukaszpiech - Wednesday, November 22, 2017 8:50 AMHello,
I need to pass a comma separated values to subreport. The string that is used to obtain input parameters is below"02 Programming & Broadcasting expenses, 03 Selling expenses,04 General & Admin. Expenses, 05 Other operating income/(expenses), net"
It used to be done with help of Split function but now i have to deal with extra field "05 Other operating income/(expenses), net" that has comma within it so now Split function divides new string to "05 Other operating income/(expenses)" and "net".
Can you please help me to find solution to pass all 4 parameters?
I've tried to concatenate values like this
= "02 Programming & Broadcasting expenses" & "," & "03 Selling expenses" & "," & "04 General & Admin. Expenses" & "," & "05 Other operating income/(expenses), net"
but it doesn't work. I don't see any solution
Best guess, change the delimiter between elements to something like a vertical bar (|).
November 23, 2017 at 1:09 am
So, it's that simple. Man i feel stupid
Thank you for quick reply!
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy