I have an error in a report when I try to split a field that doesn’t have the index value in the field. the first 22 worked but the 23rd didn’t exist but it may in some cases. I have potentially 1 to 78 indexes and it may vary. The Field shows #error Expression I’m using: =Microsoft.VisualBasic.S…

Let try this: Public Function GetItem(ByVal s as String, itm as integer) as String Dim sa() as string sa = split(s, chr(13)) if (sa.Length < itm) then return("") end if Return sa(itm) End Function Then your expression would be same on every item but you would vary the ind…

[image] Mark_Wonsil: =Code.GetItem(First(Fields!Description.Value, “JobHead”),< zero-based item # >) Oh, if it’s on the detail grouping then remove the “First( )” function: =Code.GetItem(Fields!Description.Value,< zero-based item # >) Also, maybe it doesn’t like the ByVal in the function de…

I tried both and neither made a difference. =Code.GetItem(Fields!Description.Value, “JobHead”,24) =Code.GetItem(Fields!Description.Value,24) Error: The Value expression for the text box ‘Textbox26’ refers directly to the field ‘Description’ without specifying a dataset aggregate. When the repor…

It’s odd you don’t get that error message on Textbox26 with your previous expression with the First(Fields!Description.Value, "JobHead" :thinking: Did you type the expression in or copy/paste? If the latter then make sure your double quotes are straight and not fancy.

Yes Calvin, I have some issues to fix after I solve this.

I think I copied and Pasted. Then replaced with the number.

I’m looking at your example string, now I’m wondering how they were origianlly generated? and just wanted to make sure a string should look like this if opened in NotePad++ ? [image] and description(s) in part entry looks like this? [image]

[image] Mark_Wonsil: sa = split(s, char(13)) chr(13) instead of char(13)?

Correct. Too many languages in my head… Fixed.

Using Split in SSRS

Epicor ERP 10

ckrusen (Calvin Krusen) October 22, 2020, 3:39pm 35

Here’s one way make multiple coulmns in SSRS…

Topic		Replies	Views
SSRS Report Help Epicor ERP 10 ssrs , reports	40	2218	February 22, 2024
<cr> & <lf> Epicor & Report Builder Kinetic ERP ssrs , report-builder , text-field-format	17	1870	February 24, 2023
SSRS COLON / LINE TERMINATOR Expression Error Epicor ERP 10 ssrs , expression	5	4833	May 25, 2022
SSRS report not displaying the field? Kinetic ERP ssrs	1	676	August 5, 2023
SSRS - Control Line Wrap Epicor ERP 10 ssrs	12	4665	January 10, 2021

Using Split in SSRS

Related topics