Is it possible to display a vertical line in a report?

How do I turn on borders?  What I'm thinking of is just a vertical line between my values, so it looks something like this:

Header  |  Header  |  Header  |  Header
123.45  |  456.78  |  789.01  |  234.56
999.12  |  123.45  |  234.56  |  987.65   

Thank you.  That's an interesting look but not exactly what I had in mind.  But I'll keep it in my toolbox for future use.

Do you want this between all columns, or only certain ones?

-Ray

Infinity wrote on Oct 9^th, 2007 at 6:28pm:


haha Good answer. The all elements is done one way, certain ones is done another. I'll just give you the code to do certain ones.

Quote:


ah see you're close. We are going to make use of the new ReportHTMLFilter() command to insert some HTML.

This code goes into Global Code for the Report

#include "SBasic_Include.sbas"

Function AddQuotes(vIn as String) as String
Var vOut as String

	vOut = @Chr(34) + vIn + @Chr(34)
	Return vOut

End Function

ReportHTMLFilter("><font color=" + AddQuotes("#000001"), "  style=" + AddQuotes("border-right-style: solid;"), HTML_INSERT)
 

Then all you need to do to create a line to the RIGHT of a column is to set the font color of that element to be R:0 G:0 B:1, You'll use the custom color tablet to create that color. There's other ways to do it but I figured this way you only have to touch the programming once and the rest is done in the design.

Let me know if you have any questions,
-Ray

I'm gonna skip the Include statement and the function as those are pretty easy to get. So we're gonna focus on the ReportHTML Filter command.

What ReportHTMLFilter does is it runs through the source of the Report after it has been 100% created and it looks for the rule specified in argument 1. So in this case it is looking for
[code]><font color="#000001"[/code]

When it finds it it looks at the 3rd argument to see what it is supposed to do. In this case we are telling Sesame that it needs to insert something before that text, by using the HTML_INSERT define or you can also use a 1 which is the same thing.

Sesame then takes the 2nd argument and inserts it before the match that it found of argument 1.

So for Example let's say your report contains
[code]<TD ALIGN=LEFT VALIGN=TOP><FONT COLOR="#000001" FACE="Arial" STYLE="FONT-SIZE:12pt">City</FONT></TD>[/code]
Sesame will find the match for
[code]><font color="#000001"[/code]
And Inserts
[code] style="border-right-style: solid;"[/code]
before it. So you get
[code]<TD ALIGN=LEFT VALIGN=TOP style="border-right-style: solid;"><FONT COLOR="#000001" FACE="Arial" STYLE="FONT-SIZE:12pt">City</FONT></TD>[/code]
This adds a border to the Right hand side of that Table Cell but not to the Bottom, Top, or Left sides.

If you wanted a border to the right of every column you could just change the 000001 in the first argument to 000000, assuming all your columns have black text, and that will do it. But given how your report is set up, that is probably not what you would want to do.

-Ray

Infinity wrote on Oct 10^th, 2007 at 5:29pm:

http://www.w3schools.com/css/css_border.asp

Infinity wrote on Oct 10^th, 2007 at 6:55pm:

It's a little utility function Ray uses to tack @Chr(34) onto things.