Lantica User Forum - Column headers on each page?

(UTC)

Lantica User Forum › Lantica Discussions › Lantica Discussion › Column headers on each page?

(Moderator: Forum Admin)

‹ Previous Topic | Next Topic ›

Page Index Toggle

Pages: 1

Send Topic

Print

Hot Topic (More than 10 Replies)

Column headers on each page? (Read 2328 times)

John_Y_Cannuck Junior Member Offline decidedly un-geek! Posts: 97 Location: Lindsay Ontario Canada Joined: Mar 8^th, 2004	Column headers on each page? Apr 1^st, 2005 at 2:28am	Print Post
	Most of my reports run many pages between 15 and thirty usually, but sometimes several hundred. It would be nice to have the column headers at the top of each page.


	WWW IP Logged

Hammer YaBB Administrator Lanticans Offline Fire bad. Tree pretty. Posts: 3436 Location: Ohio Joined: Nov 22^nd, 2002	Re: Column headers on each page? Reply #1 - Apr 1^st, 2005 at 1:18pm	Print Post
	Sesame Reports are HTML, which does not really have the concept of "pages". If you put the column titles in the Group Header, they will repeat with each Group Break. You can also use a small amount of programming to have them print every n records. A future version of Sesame will include different kinds of reports that include more page-centric features.

	- Hammer The plural of anecdote is not data.
	WWW IP Logged

John_Y_Cannuck Junior Member Offline decidedly un-geek! Posts: 97 Location: Lindsay Ontario Canada Joined: Mar 8^th, 2004	Re: Column headers on each page? Reply #2 - Apr 5^th, 2005 at 4:32pm	Print Post
	Ok, I'll give that a shot. Is there a way I can print just the record that is on screen quickly?


	WWW IP Logged

John_Y_Cannuck Junior Member Offline decidedly un-geek! Posts: 97 Location: Lindsay Ontario Canada Joined: Mar 8^th, 2004	Re: Column headers on each page? Reply #3 - Apr 5^th, 2005 at 4:49pm	Print Post
	One more addition to the above question. Why would one LE not allow me to put it in a report? It doesn't show up on the drop down list.


	WWW IP Logged

Ray the Reaper Global Moderator Members Lantica Support Offline The One & The Only Posts: 2482 Joined: Aug 20^th, 2003	Re: Column headers on each page? Reply #4 - Apr 5^th, 2005 at 7:23pm	Print Post
	You can print the form that is on the screen by choosing one of the print options in the printing commands folder under the record commands section of the tree. The Bind to list in the report writer is a list of fields from the underlying database. The field may be named a different thing than the layout element on the form. To see which field a layout element is bound to select that element and go to the other tab of the property viewer. Next to where is says "Bound to" will be an exclamation point followed by the name of the field. -Ray

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

Bob_Hansen Senior Member Members Offline WOW, They have the Internet on computers now! Posts: 1861 Location: Salem, NH Joined: Nov 24^th, 2002	Re: Column headers on each page? Reply #5 - Apr 5^th, 2005 at 7:29pm	Print Post
	Quote: Is there a way I can print just the record that is on screen quickly? See the March 2005 issue of Inside Sesame. Tom Marcellus has written an article, and provided the code, on that exact task. I have used it and am very happy with the result. Quote: One more addition to the above question. Why would one LE not allow me to put it in a report? It doesn't show up on the drop down list. Make sure that the element is bound to a field in the database. Only bound elements will be available on reports, but all of the actual fields are available. You may need to add a Value Element to your report and copy the programming from the unbound element into the report programmin.

	Bob Hansen Sesame Database Manager Professional Sensible Solutions Inc. Salem, NH 603-898-8223 Skype ID = sensiblesolutions
	WWW Skype/VoIP IP Logged

The Cow YaBB Administrator Offline Posts: 2530 Joined: Nov 22^nd, 2002	Re: Column headers on each page? Reply #6 - Apr 5^th, 2005 at 7:30pm	Print Post
	Quote: You can print the form that is on the screen by choosing one of the print options in the printing commands folder under the record commands section of the tree. -Ray You can also print a single record as a report by narrowing your result set to that particular record and running the report.

	Mark Lasersohn&&Programmer&&Lantica Software, LLC
	WWW IP Logged

John_Y_Cannuck Junior Member Offline decidedly un-geek! Posts: 97 Location: Lindsay Ontario Canada Joined: Mar 8^th, 2004	Re: Column headers on each page? Reply #7 - Apr 5^th, 2005 at 10:30pm	Print Post
	Inside Sesame? ???


	WWW IP Logged

Bob_Hansen Senior Member Members Offline WOW, They have the Internet on computers now! Posts: 1861 Location: Salem, NH Joined: Nov 24^th, 2002	Re: Column headers on each page? Reply #8 - Apr 5^th, 2005 at 10:39pm	Print Post
	Inside Sesame

	Bob Hansen Sesame Database Manager Professional Sensible Solutions Inc. Salem, NH 603-898-8223 Skype ID = sensiblesolutions
	WWW Skype/VoIP IP Logged

John_Y_Cannuck Junior Member Offline decidedly un-geek! Posts: 97 Location: Lindsay Ontario Canada Joined: Mar 8^th, 2004	Re: Column headers on each page? Reply #9 - Apr 5^th, 2005 at 11:33pm	Print Post
	Thanks, ordered!


	WWW IP Logged

John_Y_Cannuck Junior Member Offline decidedly un-geek! Posts: 97 Location: Lindsay Ontario Canada Joined: Mar 8^th, 2004	Re: Column headers on each page? Reply #10 - Apr 5^th, 2005 at 11:35pm	Print Post
	Quote: You can print the form that is on the screen by choosing one of the print options in the printing commands folder under the record commands section of the tree. The Bind to list in the report writer is a list of fields from the underlying database. The field may be named a different thing than the layout element on the form. To see which field a layout element is bound to select that element and go to the other tab of the property viewer. Next to where is says "Bound to" will be an exclamation point followed by the name of the field. -Ray I must be maing the wrong choices. When I do that, I get the entire results set, not just the one on screen.


	WWW IP Logged

Bob_Hansen Senior Member Members Offline WOW, They have the Internet on computers now! Posts: 1861 Location: Salem, NH Joined: Nov 24^th, 2002	Re: Column headers on each page? Reply #11 - Apr 6^th, 2005 at 2:51am	Print Post
	Are you selecting from under Record Commands, and not from under Printing?

	Bob Hansen Sesame Database Manager Professional Sensible Solutions Inc. Salem, NH 603-898-8223 Skype ID = sensiblesolutions
	WWW Skype/VoIP IP Logged

John_Y_Cannuck Junior Member Offline decidedly un-geek! Posts: 97 Location: Lindsay Ontario Canada Joined: Mar 8^th, 2004	Re: Column headers on each page? Reply #12 - Apr 6^th, 2005 at 9:49am	Print Post
	Didn't realize I could print from there, thanks again.


	WWW IP Logged

John_Y_Cannuck Junior Member Offline decidedly un-geek! Posts: 97 Location: Lindsay Ontario Canada Joined: Mar 8^th, 2004	Re: Column headers on each page? Reply #13 - Apr 6^th, 2005 at 9:54am	Print Post
	" The Bind to list in the report writer is a list of fields from the underlying database. The field may be named a different thing than the layout element on the form. To see which field a layout element is bound to select that element and go to the other tab of the property viewer. Next to where is says "Bound to" will be an exclamation point followed by the name of the field." That makes sence. I think it may have had a different name when I originally set up the form. Thank you sir!


	WWW IP Logged

Page Index Toggle

Pages: 1

Send Topic

Print

‹ Previous Topic | Next Topic ›

« Board Index ‹ Board Top

Top

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

Valid XHTML

Valid CSS

Powered by Perl

Source Forge