Hot Topic (More than 10 Replies) Positioning text or elements on a report (Read 3182 times)
esgage
Junior Member
**
Offline


No personal text

Posts: 55
Joined: Dec 8th, 2005
Positioning text or elements on a report
Feb 13th, 2006 at 1:01pm
Print Post Print Post  
To whom it may concern:

I am designing reports for my application and I still have problems trying to position text or value boxes in a report anywhere but in the left of the screen. I have tried using both the "look" tab and clicking right, and the "position" tab to make the element wider, but both of these steps do nothing. In one of the Sesame samples, I did find the following as a programmed value:

Var vDate as String

vDate = @Date
vDate = @Right(VDate,5) + "/" + @Left(vDate,4)

Header = "<CENTER><B>Invoice Report " + vDate + "</B></CENTER>"

I redid this for my own application to the following:

LE76 = "<CENTER><B>Packing List " + "</B></CENTER>"

After playing around with this I discovered that the command I copied over positioned the Packing List in the center of the output. This is great. I see the right part of the program shut off the centering for the rest of the report. However, I did not see any reference for <CENTER><B> in any manuals. I tried to change this to <RIGHT> and it did not work. Ideally, I would like my output on one item of a programmed element and one of a text element on the right of the screen.

1. How can I achieve this?
2. Where can I find information on the <CENTER> and <B> (what does that refer to?) in the program manual?

Any input is great, I have been trying to figure out how to position text for some time now and I am not getting anywhere. I did get information from an earlier question and they told me to use the "Look" tab and label alignment tab. Again, this did not work.

Thank you!

Kevin
E & S Gage
  
Back to top
 
IP Logged
 
Bob_Hansen
Senior Member
Members
*****
Offline


WOW, They have the Internet
on computers now!

Posts: 1861
Location: Salem, NH
Joined: Nov 24th, 2002
Re: Positioning text or elements on a report
Reply #1 - Feb 13th, 2006 at 4:50pm
Print Post Print Post  
Hi Kevin

The phrases you are seeing between <   > are called tags and are part of HTML programming language.

Adding HTML to your reports is very powerful, but is not a part of Sesame.  It is a separate programming language.  It is the language that web pages are written in and your browser is designed to interpret it.

If you to to most web pages, including this one, from the Main Menu at the top, click on View/ Page Source (terms may vary depending on browser), and you will see the HTML code underlying the web page you are looking at.  You will see "tags" used extensively in that viewing window.

There are many on line resources available. 
Here are a few I have looked at that you may find useful:

http://www.pageresource.com/html/index2.htm

http://www.davesite.com/webstation/html/
Start with the MiniChapters, Chapter One at:
http://www.davesite.com/webstation/html/chap01.shtml

http://www.htmlcodetutorial.com/document/

http://www.w3.org/MarkUp/Guide/

  



Bob Hansen
Sesame Database Manager Professional
Sensible Solutions Inc.
Salem, NH
603-898-8223
Skype ID = sensiblesolutions
Back to top
IP Logged
 
esgage
Junior Member
**
Offline


No personal text

Posts: 55
Joined: Dec 8th, 2005
Re: Positioning text or elements on a report
Reply #2 - Feb 13th, 2006 at 6:02pm
Print Post Print Post  
Bob:

Thanks for the info! However, is there a way to do what I want (make text on right of screen) in the Sesame report writer?, or do I have to figure out and use this HTML code? I am not a computer programmer and I am learning quite a bit about the Sesame programming, but I still would like to keep it simple!

Thanks!

Kevin
  
Back to top
 
IP Logged
 
Bob_Hansen
Senior Member
Members
*****
Offline


WOW, They have the Internet
on computers now!

Posts: 1861
Location: Salem, NH
Joined: Nov 24th, 2002
Re: Positioning text or elements on a report
Reply #3 - Feb 13th, 2006 at 7:49pm
Print Post Print Post  
You will usually have to use the Sesame Program editor on a Report element. 

But... you can write your text, including your HTML code in a text editor like NotePad or WordPad, then copy and paste into the Sesame Program Editor.

You can also use any HTML editor, and copy/paste from there into the Sesame Program Editor.  You can use HTML tools so you don't need to learn a lot of the code, then view the source code, copy it to clipboard, and paste it into Sesame Program Editor.

Many ISPs provide HTML programs/utilities for you to design your own web pages.  You don't need to make web pages, just the code that you want in your report.  Check with your ISP to see what they provide for free tools.


  



Bob Hansen
Sesame Database Manager Professional
Sensible Solutions Inc.
Salem, NH
603-898-8223
Skype ID = sensiblesolutions
Back to top
IP Logged
 
Ray the Reaper
Global Moderator
Members
Lantica Support
*****
Offline


The One & The Only

Posts: 2492
Joined: Aug 20th, 2003
Re: Positioning text or elements on a report
Reply #4 - Feb 13th, 2006 at 7:52pm
Print Post Print Post  
Quote:
Bob:

Thanks for the info! However, is there a way to do what I want (make text on right of screen) in the Sesame report writer? 


What section of the report are you in?
Freeform or Table/Columnar report?

-Ray
  

Raymond Yoxall Consulting
ray.yoxall@gmail.com
ryoxall@lantica.com
Sesame Applications, Design and Support
Back to top
IP Logged
 
esgage
Junior Member
**
Offline


No personal text

Posts: 55
Joined: Dec 8th, 2005
Re: Positioning text or elements on a report
Reply #5 - Feb 13th, 2006 at 8:07pm
Print Post Print Post  
Bob:
Thanks, I tried the HTML code:
LE56 = "<p align = "right"><b>Packing List " + "</b></P> This did not work. Program editor came back with an error.

However, this worked
LE56 = "<CENTER><B>Packing List " + "<B></CENTER>"

I tried to subsitute "CENTER" with "RIGHT" and that did not work. I found the HTML code above to make stuff align to the right but I could not alter this to fit Sesame.


Ray:

I have the report with 2 sections table is in one view and freeform in the other.

Thanks,

Kevin
  
Back to top
 
IP Logged
 
esgage
Junior Member
**
Offline


No personal text

Posts: 55
Joined: Dec 8th, 2005
Re: Positioning text or elements on a report
Reply #6 - Feb 13th, 2006 at 8:07pm
Print Post Print Post  
Bob:
Thanks, I tried the HTML code:
LE56 = "<p align = "right"><b>Packing List " + "</b></P> This did not work. Program editor came back with an error.

However, this worked
LE56 = "<CENTER><B>Packing List " + "<B></CENTER>"

I tried to subsitute "CENTER" with "RIGHT" and that did not work. I found the HTML code above to make stuff align to the right but I could not alter this to fit Sesame.


Ray:

I have the report with 2 sections table is in one view and freeform in the other.

Thanks,

Kevin
  
Back to top
 
IP Logged
 
Ray the Reaper
Global Moderator
Members
Lantica Support
*****
Offline


The One & The Only

Posts: 2492
Joined: Aug 20th, 2003
Re: Positioning text or elements on a report
Reply #7 - Feb 13th, 2006 at 8:14pm
Print Post Print Post  
Quote:
Ray:

I have the report with 2 sections table is in one view and freeform in the other.

Thanks,

Kevin


Hello Kevin,

In what section of the report though are you trying to align something to the right? View Header, Group Header, Group Body, Group Footer, View Footer, etc.

-Ray
  

Raymond Yoxall Consulting
ray.yoxall@gmail.com
ryoxall@lantica.com
Sesame Applications, Design and Support
Back to top
IP Logged
 
esgage
Junior Member
**
Offline


No personal text

Posts: 55
Joined: Dec 8th, 2005
Re: Positioning text or elements on a report
Reply #8 - Feb 13th, 2006 at 8:24pm
Print Post Print Post  
Ray:

I am would like the text aligned to the right in both the Report header and view header sections.

Kevin
  
Back to top
 
IP Logged
 
Bob_Hansen
Senior Member
Members
*****
Offline


WOW, They have the Internet
on computers now!

Posts: 1861
Location: Salem, NH
Joined: Nov 24th, 2002
Re: Positioning text or elements on a report
Reply #9 - Feb 13th, 2006 at 9:16pm
Print Post Print Post  
Using HTML here are samples:

In Report Header element programming:
LE0="<h1 align=center>This is for Report Header</h1>"

In View Header element programming:
LE1="<h2 align=right>This is for View Header</h2>"
  



Bob Hansen
Sesame Database Manager Professional
Sensible Solutions Inc.
Salem, NH
603-898-8223
Skype ID = sensiblesolutions
Back to top
IP Logged
 
esgage
Junior Member
**
Offline


No personal text

Posts: 55
Joined: Dec 8th, 2005
Re: Positioning text or elements on a report
Reply #10 - Feb 13th, 2006 at 9:28pm
Print Post Print Post  
Bob:

Thanks for the info, but like I said when I started this thread, I tried that and it did nothing. Here is what I did:
I have a Static Text element in the Report Header of a report that is labeled Packing List. I clicked this to make it active, clicked 09 for top right and saved it. I confirmed that it registered by viewing the Property viewer on the bottom left, color/text tab, and text alignment on the very bottom. Indeed it says Text alignment Top right. However, when I save this and preview it the Packing List in the Report Header still shows flush to the left.

Thanks,

Kevin
  
Back to top
 
IP Logged
 
Bob_Hansen
Senior Member
Members
*****
Offline


WOW, They have the Internet
on computers now!

Posts: 1861
Location: Salem, NH
Joined: Nov 24th, 2002
Re: Positioning text or elements on a report
Reply #11 - Feb 13th, 2006 at 9:32pm
Print Post Print Post  
Kevin, reread previous posting, I changed while you were reading.....you were too fast for me.
  



Bob Hansen
Sesame Database Manager Professional
Sensible Solutions Inc.
Salem, NH
603-898-8223
Skype ID = sensiblesolutions
Back to top
IP Logged
 
Bob_Hansen
Senior Member
Members
*****
Offline


WOW, They have the Internet
on computers now!

Posts: 1861
Location: Salem, NH
Joined: Nov 24th, 2002
Re: Positioning text or elements on a report
Reply #12 - Feb 13th, 2006 at 9:37pm
Print Post Print Post  
Change from this:
LE56 = "<CENTER><B>Packing List " + "<B></CENTER>"

To this:
LE56 = "<p align=right><b>" + Packing List  + "</b></p>"
  



Bob Hansen
Sesame Database Manager Professional
Sensible Solutions Inc.
Salem, NH
603-898-8223
Skype ID = sensiblesolutions
Back to top
IP Logged
 
esgage
Junior Member
**
Offline


No personal text

Posts: 55
Joined: Dec 8th, 2005
Re: Positioning text or elements on a report
Reply #13 - Feb 13th, 2006 at 10:06pm
Print Post Print Post  
Bob:

Let me tell you again, I really appreciate your time and any other people's time helping me out with this. This did not work either. It got thru the program checker. However, when I put that in, during preview I got "Some or all of the programming in this report has failed to compile. No report programming will be run. LE56 is put in the View Header portion of the report. Could this be the problem?

  
Back to top
 
IP Logged
 
esgage
Junior Member
**
Offline


No personal text

Posts: 55
Joined: Dec 8th, 2005
Re: Positioning text or elements on a report
Reply #14 - Feb 13th, 2006 at 10:13pm
Print Post Print Post  
Bob / Ray:

I have to leave work now. I am off tomorrow. Any input you can think of tomorrow, would be greatly appreciated. I will check the board Wed.

Thanks again for all your help!

Kevin
  
Back to top
 
IP Logged
 
The Cow
YaBB Administrator
*****
Offline



Posts: 2530
Joined: Nov 22nd, 2002
Re: Positioning text or elements on a report
Reply #15 - Feb 14th, 2006 at 12:22am
Print Post Print Post  
Kevin,

I looking to see if there is a problem with this (assuming there is - a fix will be in 1.1.4).

In the meantime, if you are comfortable with SBasic and HTML, you can remedy this as Bob has suggested. I am not sure why you are having problems compiling the program he has supplied. His solution appears to work so long as a width has not been specified for the static text element.

If you are okay with HTML, but do not want to use SBasic, you can place the snippet Bob has supplied (minus the element name, the equal sign, and the quotes) right in the label for the static text element.

If you wish to use neither SBasic or HTML, you can place a "spacer" element before your title and set its width to a fairly high number (try 700 or so). That will push you title over to the right by the width of the spacer.
  

Mark Lasersohn&&Programmer&&Lantica Software, LLC
Back to top
IP Logged
 
Bob_Hansen
Senior Member
Members
*****
Offline


WOW, They have the Internet
on computers now!

Posts: 1861
Location: Salem, NH
Joined: Nov 24th, 2002
Re: Positioning text or elements on a report
Reply #16 - Feb 14th, 2006 at 2:07am
Print Post Print Post  
I have rerun the code I supplied and it tests OK.  The message might be coming from another section of code. 

Check other report elements and comment them out until the offending section is identified.  I have seen the Test Program pass , and then fail in Preview because of values that are in quotes.  The Test Program does not do syntax checking inside quotes at times, not sure when, but that is where I would start to comment out code.....sections with quotes.

  



Bob Hansen
Sesame Database Manager Professional
Sensible Solutions Inc.
Salem, NH
603-898-8223
Skype ID = sensiblesolutions
Back to top
IP Logged
 
The Cow
YaBB Administrator
*****
Offline



Posts: 2530
Joined: Nov 22nd, 2002
Re: Positioning text or elements on a report
Reply #17 - Feb 14th, 2006 at 2:59am
Print Post Print Post  
Quote:
I have seen the Test Program pass , and then fail in Preview because of values that are in quotes.  The Test Program does not do syntax checking inside quotes at times, not sure when, but that is where I would start to comment out code.....sections with quotes.


As far as I know the only difference between the compiler in SDesigner (used to test) and the runtime compiler is that the SDesigner compiler includes "ghosted" elements (elements moved off of the form) and the runtime compiler does not. Both run the same compiler with the same library on the same code.

If either is evaluating anything inside quotes (without a missmatched quote mark), please supply an example of this occuring to Ray as soon as possible. Or post a small example here (maybe under a new thread?)
  

Mark Lasersohn&&Programmer&&Lantica Software, LLC
Back to top
IP Logged
 
Bob_Hansen
Senior Member
Members
*****
Offline


WOW, They have the Internet
on computers now!

Posts: 1861
Location: Salem, NH
Joined: Nov 24th, 2002
Re: Positioning text or elements on a report
Reply #18 - Feb 14th, 2006 at 4:54am
Print Post Print Post  
Quote:
please supply an example of this occuring to Ray as soon as possible. Or post a small example here (maybe under a new thread?)
I will do that the next time I see that.  If I get a chance, I will see if I can force that to happen.  And Yes, I will do that under a separate Subject.

  



Bob Hansen
Sesame Database Manager Professional
Sensible Solutions Inc.
Salem, NH
603-898-8223
Skype ID = sensiblesolutions
Back to top
IP Logged
 
esgage
Junior Member
**
Offline


No personal text

Posts: 55
Joined: Dec 8th, 2005
Re: Positioning text or elements on a report
Reply #19 - Feb 15th, 2006 at 1:18pm
Print Post Print Post  
Mark:

I put in the HTML code in the label of the Static Text and it worked. Could the same method be used as a value box? Thanks for the input. It would be nice for future versions of Sesame to have 1 simple button or command that would allow for this text formatting. I love all the features of Sesame. However, as a former user of Q & A for Windows, I miss some of the features in Q & A such as the Freeform reports in which you see the way the report will pretty much look as you are designing it. Other members have mentioned to me how the feature of using mail merge into Word will replicate any of the Q & A for Windows freeform report. However, it would still be nice for former Q & A users to make a report like that right in Sesame. I now need to learn how to use the mail merge with Word to make reports like I had in Q & A. Sesame is great though in all the other areas. Thanks again for the help.

Kevin

E & S Gage
  
Back to top
 
IP Logged
 
The Cow
YaBB Administrator
*****
Offline



Posts: 2530
Joined: Nov 22nd, 2002
Re: Positioning text or elements on a report
Reply #20 - Feb 15th, 2006 at 1:46pm
Print Post Print Post  
Its a bug. As a matter of fact, this very feature was shown in a previous version at the user's conference in Baltimore. The feature got broken when adding a different and unrelated feature. It will be fixed in 1.1.4 (already fixed it - here) and will be, as you say, as easy as pushing a button.
  

Mark Lasersohn&&Programmer&&Lantica Software, LLC
Back to top
IP Logged
 
esgage
Junior Member
**
Offline


No personal text

Posts: 55
Joined: Dec 8th, 2005
Re: Positioning text or elements on a report
Reply #21 - Feb 15th, 2006 at 2:39pm
Print Post Print Post  
Mark:

Ok. I am getting it to work now using HTML code. Is it possible now to make a Static Text and Programmed element in a report appear on the same line?

I have a static text value with our company name that shows on the left. Next, I am putting in the HTML code to put "Packing List" on the right. I am not adding a new line command.

I would like our company name and the Packing list to appear on the same line 1 aligned to the left, the other to the right. Is this possible, right now it puts it on a new line automatically.

Thanks,

Kevin
  
Back to top
 
IP Logged
 
Ray the Reaper
Global Moderator
Members
Lantica Support
*****
Offline


The One & The Only

Posts: 2492
Joined: Aug 20th, 2003
Re: Positioning text or elements on a report
Reply #22 - Feb 15th, 2006 at 4:32pm
Print Post Print Post  
Hello Kevin,

If you are using the code
Code
Select All
  LE56 = "<p align=right><b>" + Packing List  + "</b></p>" 

the <p> starts a new line.

Try the code below
Code
Select All
LE56 = "<TABLE WIDTH=100%><TR><TD WIDTH=50% ALIGN=Left>Your Company Name</TD><TD WIDTH=50% ALIGN=Right>" + Packing List + "</TD></TR></TABLE>" 



-Ray
  

Raymond Yoxall Consulting
ray.yoxall@gmail.com
ryoxall@lantica.com
Sesame Applications, Design and Support
Back to top
IP Logged
 
esgage
Junior Member
**
Offline


No personal text

Posts: 55
Joined: Dec 8th, 2005
Re: Positioning text or elements on a report
Reply #23 - Feb 15th, 2006 at 5:11pm
Print Post Print Post  
Ray:

Worked great, I had to modify your sample and put quotes around packing list, and then it worked. My next question, I tried to use Sesame to change the Font size, but evidently it will not work in this method since this information is in a value box. How can I make the code example you gave me bold and larger. Again, thanks for the help I have no HTML background.

Kevin
E & S Gage
  
Back to top
 
IP Logged
 
Ray the Reaper
Global Moderator
Members
Lantica Support
*****
Offline


The One & The Only

Posts: 2492
Joined: Aug 20th, 2003
Re: Positioning text or elements on a report
Reply #24 - Feb 15th, 2006 at 5:28pm
Print Post Print Post  
Hello Kevin,

You can use Sesame to make that value box's font size bigger and bolder. Select the value box, go to the Text tab of the Property Editor, Choose "Bold" from the drop down that says "Normal", And choose a font size from the drop down box that says 12. Save the layout and preview.

-Ray
  

Raymond Yoxall Consulting
ray.yoxall@gmail.com
ryoxall@lantica.com
Sesame Applications, Design and Support
Back to top
IP Logged