(UTC)
  Lantica User Forum › Lantica Discussions › Lantica Discussion › Report as Table vs. FreeForm
(Moderator: Forum Admin)
‹ Previous Topic | Next Topic ›
Page Index Toggle Pages: 1 Send Topic Send Topic Print Print
Normal Topic Report as Table vs. FreeForm (Read 3948 times)
Bob_Hansen
Senior Member
Members
*****
Offline


WOW, They have the Internet
on computers now!

Posts: 1861
Location: Salem, NH
Joined: Nov 24th, 2002
Report as Table vs. FreeForm
Mar 17th, 2005 at 5:57am
Print Post Print Post  
I am working on a FreeForm Report, one element and label per line.  All looks good until printing.

Instead of printing top down, it is printing left to right.

I opened the htm source code and found that html coding for a table is being inserted at the top of the report.  And each of the elements, labels, are going into cells across the report.  Here is the code where the report Body begins:
Code
Select All
<BODY>
<P>
<TABLE BORDER=0 WIDTH=650 STYLE="DISPLAY:INLINE; FLOAT:LEFT;"><TR><TD><FONT COLOR="#000000" FACE="Arial" STYLE="FONT-SIZE:11pt">Header</FONT></TD></TR></TABLE>
<BR>
<TABLE BORDER=0 CELLSPACING=0 CELLPADDING=2>
<TR>
This is followed by cell definitions and contents.

This is my first FreeForm report using 1.1.1.  I have not seen this before, and hope it is just coincidence.  FreeForm reports created in earlier versions print OK with 1.1.1. 

How to undo and get back to normal? 
Since FreeForm and including most form elements, I have over 40 elements, plus labels, NewLines, etc. that I will need to do over again if I need to recreate the report.

Any one else with this problem?
.
  


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


Fire bad. Tree pretty.

Posts: 3436
Location: Ohio
Joined: Nov 22nd, 2002
Re: Report as Table vs. FreeForm
Reply #1 - Mar 17th, 2005 at 1:34pm
Print Post Print Post  
Bob,

Do you have Widths set for the elements in the Group Body? If so, set them all back to 0 and see if the problem goes away.
  
- Hammer
The plural of anecdote is not data.
Back to top
WWW WWW  
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: Report as Table vs. FreeForm
Reply #2 - Mar 20th, 2005 at 6:54pm
Print Post Print Post  
Hi Erika...

The Header was set for 650.  I reset it to 0 and ran report again, same thing.

I just created another identical report, only has three elements, a NewLine after each Label and Element.

Never assigned any widths, all = 0.  Report still comes out with Table format. 

Report Specs here :

Report Header:
Static unbound

Report Body:
Static unbound label, bound COMPANYNAME= Text, Newline1
Static unbound lable, bound STATE=text, NewLine2
Static unbound lable, bound DETAILS=mutiline text, NewLine3

Will be removing multiline text element to see if it changes.
Stay tuned.......
  


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


Fire bad. Tree pretty.

Posts: 3436
Location: Ohio
Joined: Nov 22nd, 2002
Re: Report as Table vs. FreeForm
Reply #3 - Mar 20th, 2005 at 6:57pm
Print Post Print Post  
If you can't figure it out, send it into Support so we can check it out. My test freeforms are doing fine, so there must be something odd.
  
- Hammer
The plural of anecdote is not data.
Back to top
WWW WWW  
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: Report as Table vs. FreeForm
Reply #4 - Mar 20th, 2005 at 7:23pm
Print Post Print Post  
No change, actually getting worse, but getting better information for analysis.

1.  I first tried making the multiline text element invisible.  No change.
2.  I then removed the element from the report.  No change.
3.  I then removed the label and NewLine elements for that value.  No change.
4.  I then removed everything from the body of the report, leaving only the header.  NO CHANGE!

Here is the source code of the current report with only a header:
Code
Select All
<HTML>
<HEAD>
<TITLE>NewReport</TITLE>
</HEAD>
<BODY>
<P>
<FONT COLOR="#000000" FACE="Arial" STYLE="FONT-SIZE:11pt">Header</FONT>
</P>
<TABLE BORDER=0 CELLSPACING=0 CELLPADDING=2>
</TABLE>
</BODY>
</HTML>


5.  And now I noticed that the programming for the header is not working.  Here is the test programming:
Code
Select All
Header = "TEST REPORT"
What shows up on the report is "header" (without the quotes).

6.  Just made a new report, added nothing, saved design.  Ran Report, comes up with imbedded table:
Code
Select All
<HTML>
<HEAD>
<TITLE>NewReport0</TITLE>
</HEAD>
<BODY>
<TABLE BORDER=0 CELLSPACING=0 CELLPADDING=2>
</TABLE>
</BODY>
</HTML>


Using Sesame 1.1.1 on WinXpPro.
Will try another Sesame application
  


Bob Hansen
Sesame Database Manager Professional
Sensible Solutions Inc.
Salem, NH
603-898-8223
Skype ID = sensiblesolutions
Back to top
WWW WWW Skype/VoIP Skype/VoIP  
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: Report as Table vs. FreeForm
Reply #5 - Mar 20th, 2005 at 7:30pm
Print Post Print Post  
Before I tried another application, I tried another database in the same application.  No change, empty report = table code.

Added a new report to \Samples\Customers.  Nothing added to the report, just saved design and went to Preview Mode.  Empty report comes up with code for tables.

I guess the next step is to try an earlier version of Sesame.

???   Roll Eyes   ???
  


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


Fire bad. Tree pretty.

Posts: 3436
Location: Ohio
Joined: Nov 22nd, 2002
Re: Report as Table vs. FreeForm
Reply #6 - Mar 20th, 2005 at 7:35pm
Print Post Print Post  
Bob,

You are changing the type on these new reports from Table to Freeform before running them, right? The default is Table.
  
- Hammer
The plural of anecdote is not data.
Back to top
WWW WWW  
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: Report as Table vs. FreeForm
Reply #7 - Mar 20th, 2005 at 8:03pm
Print Post Print Post  
OK....it looks like "table" code is the default and is not a problem.   The problem is how to remove the "table" code to allow a Free Form report?

My original problem has been a Free Form report.  Nothing in Group Header/Footers.  Only have one cell in Report Header and Static, Bound,NewLine cells in the Broup Body section.

(Submitted without seeing previous message from Erika)
« Last Edit: Mar 20th, 2005 at 9:13pm by Bob_Hansen »  


Bob Hansen
Sesame Database Manager Professional
Sensible Solutions Inc.
Salem, NH
603-898-8223
Skype ID = sensiblesolutions
Back to top
WWW WWW Skype/VoIP Skype/VoIP  
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: Report as Table vs. FreeForm
Reply #8 - Mar 20th, 2005 at 8:13pm
Print Post Print Post  
AARGH!   What a dummy, ME!

I had Header View minimized.  The value for Header View was still set for Table, not changed to FreeForm!


(Submitted without seeing previous message from Erika).
« Last Edit: Mar 20th, 2005 at 9:14pm by Bob_Hansen »  


Bob Hansen
Sesame Database Manager Professional
Sensible Solutions Inc.
Salem, NH
603-898-8223
Skype ID = sensiblesolutions
Back to top
WWW WWW Skype/VoIP Skype/VoIP  
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: Report as Table vs. FreeForm
Reply #9 - Mar 20th, 2005 at 9:20pm
Print Post Print Post  
Just saw your last message Erika.

As you can see from my messages, you were correct.  The View mode was still in Table vs. Freeform.  I had only the Header and Group Body columns visible and was totally forgetting about the View.  Could only find the Width.

I finally expanded all columns and located the View option that I had forgotten about.  I guess if I had been looking at forum vs. working on this myself, you would have saved me a lot of effort. 

Thanks for putting in your time to work on this for me. 

  


Bob Hansen
Sesame Database Manager Professional
Sensible Solutions Inc.
Salem, NH
603-898-8223
Skype ID = sensiblesolutions
Back to top
WWW WWW Skype/VoIP Skype/VoIP  
IP Logged
 
Page Index Toggle Pages: 1
Send Topic Send Topic Print Print
‹ Previous Topic | Next Topic ›
 
  « Board Index ‹ Board Top  

Lantica User Forum » Powered by YaBB 2.6.11!
YaBB Forum Software © 2000-2024. All Rights Reserved.

Valid RSS Valid XHTML Valid CSS Powered by Perl Source Forge