White space on custom reports as report grows

[nore0402]

Hello All

   Some how I get a <br> for every row of my table. above my table. which creates a white space above my table. 

Hopefully I made sense.

Any help would be appreciated.

I’ve added the code below.

        		<th>Computer Name</th><th>Critical</th><th>Important</th><th>Moderate</th><th>Low</th>
                         		<?relevance trs of (td of link of it & td of (number of relevant fixlets whose (source severity of it as lowercase = "critical") of it as string) & td of (number of relevant fixlets whose (source severity of it as lowercase = "important") of it as string) & td of (number of relevant fixlets whose (source severity of it as lowercase = "moderate") of it as string) & td of (number of relevant fixlets whose (source severity of it as lowercase = "low") of it as string)) of bes computers ?>
</table>

Thanks

[Aram]

Try adding concatenation "%0d%0a" of in front of ‘trs’ such as the following:

<?relevance concatenation "%0d%0a" of trs of (td of link of it & td of (number of relevant fixlets whose (source severity of it as lowercase = "critical") of it as string) & td of (number of relevant fixlets whose (source severity of it as lowercase = "important") of it as string) & td of (number of relevant fixlets whose (source severity of it as lowercase = "moderate") of it as string) & td of (number of relevant fixlets whose (source severity of it as lowercase = "low") of it as string)) of bes computers ?>

On a side note, 2 things you might want to consider for the session relevance above:

• note that the ‘relevant fixlets’ inspector can return more than just Fixlets ( https://developer.bigfix.com/relevance/reference/bes-fixlet.html ), and as such, you may want to add an additional element in your whose clause ( https://developer.bigfix.com/relevance/reference/bes-fixlet.html#fixlet-flag-of-bes-fixlet-boolean )
• you may want to limit the scope of sites included in the query

[steini44]

Hi

I’ve done about the same thing with session relevance:

Report Available: 12 Month Rolling Compliance

Hi @leewei I’ve rearranged your query with our needs and came to the following result: ((name of it, ((number of results whose (exists first became relevant of it) of it as floating point - number of results whose (relevant flag of it) of it) * 100 / number of results whose (exists first became relevant of it) of it) ) of bes fixlets whose (exist results of it and (not (name of it contains "Superseded" or name of it contains "corrupt")) and month_and_year of source release date of it = (month_…

You can check this post out and filter on what you need. My query gives a compliance percentage for all the critical patches from the last month. Lee Wei added the computer group. So if you adjust it a little bit, you can have what you need. You can also use Lee Wei’s report, depending on what you need ofc.

[nore0402]

Thanks Aram and Steini44

All is working correctly now after adding concatenation “%0d%0a” of

Thanks