Stuff Text Function

[Elena]

Hello Jan it's me again,

 

I have these strings in the calculated field, that I wish to put commas followed by spaces in between them.

 

I tried simply putting a plus sign to add up the fields, it works, but whenever a field is empty, I am left with the "commas" and the "spaces" showing in the results.

 

My question is:  Shoud I be using the STUFF and SPACE function to put a comma and a space?   Such comma or space should not show whenever there is nothing to use comma or space for.  Is there any other way?

 

Here below is what I have. Probably not a good practice at all.

 

 

[@field:Server]+', '+[@field:Training]+', '+[@field:Telecom]+', '+[@field:Hardware]+', '+[@field:Software]

 

 

Results:

Server Technology, Education & Training , , ,
 

 

The fields Telecom, Hardware, Software are all left empty by the user. The results are showing only the commas and the spaces that I added up.

 

 

 

 

 

 

 

 

[Jan]

Hello Elena,

 

I think, I have found a possible solution.

 

It's needed four Calculated fields that will define to display a comma or not.

 

First field:

CASE
WHEN [@field:Server]!='' AND ([@field:Training]!='' OR [@field:Telecom]!='' OR [@field:Hardware]!='' OR [@field:Software]!='') THEN ', '
ELSE ''
END

Second field:

CASE
WHEN [@field:Training]!='' AND ([@field:Telecom]!='' OR [@field:Hardware]!='' OR [@field:Software]!='') THEN ', '
ELSE ''
END

Third field:

CASE
WHEN [@field:Telecom]!='' AND ([@field:Hardware]!='' OR [@field:Software]!='') THEN ', '
ELSE ''
END

Fourth field:

CASE
WHEN [@field:Hardware]!='' AND ([@field:Software]!='') THEN ', '
ELSE ''
END

Now you can enter value of these fields instead ", ":

[@field:Server]+[@calcfield:1]+[@field:Training]+[@calcfield:2]+ [@field:Telecom]+[@calcfield:3]+[@field:Hardware]+[@calcfield:4]+[@field:Software]

Please, enter your numbers for every Calculated field instead of [@calcfield:N]

 

And now you can add the Footer element and add the following code to hide additional Calculated fields:

<script language="javascript" type="text/javascript">
function hide_column(column_order)
{
     var tbl = document.getElementsByTagName("table")[0];
     var table_header = tbl.getElementsByTagName('th')[column_order];
     table_header.style.display=stl;
     var rows = tbl.getElementsByTagName('tr');
     for (var row=1; row<rows.length;row++)
        {     
            var cels = rows[row].getElementsByTagName('td');
            cels[column_order].style.display=stl;
        }
}

var stl='none';
hide_column(0);
hide_column(1);
hide_column(2);
hide_column(3);
</script>

0,1,2,3 - are numbers of columns with Calculated fields. I placed them at the beginning of the table.

 

I am not sure that it is the best solution.

I hope it works.

[Jan]

Hello Elena,

 

I would ask what type of a DataPage is used?

There is a bit difference between Tabular and Gallery/List Reports.

[Elena]

It is a tabular report.

[Elena]

Jan, I forgot to thank you for these codes. It helped me tremendously and continue to help.

 

Thank you again.

[Jan]

You are very welcome