Alignment issue while Concatenating two Strings

(0) Share

Report

Posted on by Community Member

In purchase order report i have to print "type and description" in a line called "Spec".I am concatenating two strings in X++ DP class but while printing i am facing alignment issues in SSRS

Below is my Code :

Spec = Spec + "/n" + type +" "+ Description ;

I am getting value in SSRS Report like,

Spec:

test file

testing Drawing

But what i need is like properly aligned table format.How to achieve the below table format in X++ code

test file

testing Image

*This post is locked for comments

I have the same question (0)

All responses (9)

Answers (1)

Mea_ 60,284 on at

Like (0)

Report

Hi Anna Mu,

What about using table in SSRS and put Spec in the first column and type in the second?

Was this reply helpful? Yes No
Martin Dráb 237,976 Most Valuable Professional on at

Like (0)

Report

If you want a properly aligned table, why don't you use the Table control? It's there exactly for this purpose.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi ievgen,

I cannot do that because of the table structure.So i have no other option other than choosing this option

Was this reply helpful? Yes No
Martin Dráb 237,976 Most Valuable Professional on at

Like (0)

Report

That's sounds weird; I would like to hear why exactly you say it's impossible. If it's a table, the table control should be able to handle it.

Also, the solution you've chosen won't ever work well with proportional fonts.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Martin,

I said , i cannot print those two fields separately in two columns of the ssrs report because

there is already a datasource for the purchase order lines.My requirement is , i have to print the Document Type and Description for all the items in the purchase order lines.Recently i have tried the following code,

public static Notes concatDocuRefNotes(DocuRefSearch _search,RecId _purchLineRecId)

{

DocuRef docuRef;

Notes result;

#xppTexts

while select TypeId,Name from docuRef order by TypeId where docuRef.RefTableId

== tableNum(PurchLine) && docuRef.RefRecId == _purchLineRecId

&& docuRef.Restriction == DocuRestriction::External

{

result += "\n" + docuRef.Name +" "+ docuRef.TypeId ;

}

return result;

}

}

Please suggest me a solution do to proper alignment between two strings for all the lines printed respectively.

Kind Regards,

AnnaaMu

Was this reply helpful? Yes No
Mea_ 60,284 on at

Like (0)

Report

Hi Anna Mu,

Its very hard because characters has different width for different fonts and theoretically you can do this calculations but amount of efforts and complexity of this solution do not worth it. You need to do it in a proper way, that is a table control in SSRS report and it is possible as well. For example, you can add 2 new fields to a data source and if one line has 2 documents then all the fields except doc type and description would be repeated, then you will handle duplicated data it in the report.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thanks for the reply,

Before going to tablix control i have tried the following in Code level

public static Notes concatDocuRefNotes(DocuRefSearch _search,RecId _purchLineRecId)

{

DocuRef docuRef;

Notes result;

#xppTexts

while select TypeId,Name from docuRef order by TypeId where docuRef.RefTableId == tableNum(PurchLine) && docuRef.RefRecId == _purchLineRecId

&& docuRef.Restriction == DocuRestriction::External

{

if (!result)

{

result = "<table>";

}

result += "<tr><td style='width:auto;'>"+ docuRef.Name + "</td><td>" + docuRef.TypeId + "</td></tr>";

}

if(result)

{

result += "</table>";

}

return result;

}

But when i print the report it shows value like

<table><tr><td style='width:auto;'>"TESTFIRST "</td><td>" FILE "</td></tr>

Please help me whether there is a fix for the above code,or else i ll go with tablix control.

Regards,

AnnaaMU

Was this reply helpful? Yes No
Martin Dráb 237,976 Most Valuable Professional on at

Like (0)

Report

Even if it worked with the HTML renderer, what would you expect to happen with renderers that don't use HTML? Use the SSRS table control instead; all SSRS renders know how to work with it.

Was this reply helpful? Yes No
Verified answer

Chaitanya Golla 17,225 on at

Like (1)

Report
Hi,

You can try the approach to calculate the string length of Description and append the spaces(to the right) of the first part of field type to match the length. Please use the following code in your DP class.

static void alignment(Args _args) { str type = "test file"; str description = "testing drawing"; int pst, pst1, i; str typeStr, spec; #file pst = strFind(description, #delimiterSpace, 1, strLen(description)); pst1 = strFind(type, #delimiterSpace, 1, strLen(type)); i = pst1; typeStr = subStr(type, 1, pst1-1); while (pst1 <= pst) { typeStr = typeStr + #delimiterSpace; pst1++; } type = typeStr + #delimiterSpace + #delimiterSpace + subStr(type, i+1, strLen(type)); spec = Spec + '\n' + type + '\n' + Description; info(strFmt(spec)); }

Output:

Was this reply helpful? Yes No