Page Index Toggle Pages: [1] 2  Send Topic Send Topic Print Print
Hot Topic (More than 10 Replies) Positioning text or elements on a report (Read 2671 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: 2482
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: 2482
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
 
Page Index Toggle Pages: [1] 2 
Send Topic Send Topic Print Print