Relevance help - tables

1

I’m trying to put the results of this relevance statement into a table:

(name of it, number of subscribed computers of it) of bes custom sites

This is what i attempted. Hoping someone can help me out.

<?relevance (html "" & html ("") & (it) & html "
Custom Site Name Number of Subscribed Computers
" ) of concatenations of trs of ( td of (item 0 of it) & td of (item 1 of it) ) of ( name of it, number of subscribed computers of it, ) of bes custom sites ?>
2

I think you’re most of the way there. number of subscribed computers of it will give you an integer, but you need to cast it as a string in order to format it the way you want. You also need to wrap your table headers in th tags, then wrap the whole thing in a tr tag:

tr of (th of "Custom Site Name" & th of "Number of Subscribed Computers") & concatenation of trs of (td of (item 0 of it) & td of (item 1 of it as string)) of (name of it, number of subscribed computers of it) of bes custom sites

So here’s the absolute barest of all bare bones HTML to turn it into a custom web report:

<HTML>
<body>
<table>
<?relevance 
tr of (th of "Custom Site Name" & th of "Number of Subscribed Computers") & concatenation of trs of (td of (item 0 of it) & td of (item 1 of it as string)) of (name of it, number of subscribed computers of it) of bes custom sites
?>
</table>
</body>
</HTML>
3 Likes
3

That’s perfect. Thanks for your help