Lantica User Forum - Reports

(UTC)

Lantica User Forum › Lantica Discussions › Lantica Discussion › Reports

(Moderator: Forum Admin)

‹ Previous Topic | Next Topic ›

Page Index Toggle

Pages: 1

Send Topic

Print

Normal Topic

Reports (Read 1206 times)

Foster Ex Member	Reports Aug 15^th, 2005 at 5:34pm	Print Post
	Could not find reference to my proiblem so will ask: I have records of items in boxes. I want to list the contents of one box. I do a search, find the box and see the items sorted as I like. I do a report and get all records. I know I am doing something wrong, but don't know what ???


	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: Reports Reply #1 - Aug 15^th, 2005 at 7:16pm	Print Post
	I am missing the problem... 1. Are you getting all items from all boxes in the report vs. just the items from the one box? 2. Does the report have a Saved Retrieve Spec?

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

Foster Ex Member	Re: Reports Reply #2 - Aug 15^th, 2005 at 7:58pm	Print Post
	Just the items from the one box. The report does not have a Saved Retrieve Spec. I uses sort box at bottom of column and entered box # on retrieve screen. Got list of items just like I wanted, sorted correctly. Asked for a report. Report listed all boxes, not sorted as I wanted.


	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: Reports Reply #3 - Aug 15^th, 2005 at 9:04pm	Print Post
	Reports run on the Current record set. It does not sound like you first did a Retrieve for just the records for that box number. And it also sounds like you are using the Sort by box number when you want to retrieve by box number and sort by some other value. If you are only looking at one box, it does not make sense to sort by box, because there will only be one box in the current record set. This would only make sense if you had more than one box number in the current record set. Do this to restrict the records to the one box: 1. Retrieve the records for the desired box number. Check that the number of records in the record set is correct. 2. Now sort the records by the Item number, or description, or whatever other Sort criteria you have. 3. Run your report and you should be all set.
	« Last Edit: Aug 16^th, 2005 at 10:43pm by Bob_Hansen »
	Bob Hansen Sesame Database Manager Professional Sensible Solutions Inc. Salem, NH 603-898-8223 Skype ID = sensiblesolutions
	WWW Skype/VoIP IP Logged

Foster Ex Member	Re: Reports Reply #4 - Aug 15^th, 2005 at 9:49pm	Print Post
	Sorry I am not clear. That is exactly what I did! But results were wrong. I will call it quits for today and worry about it tomorrow.


	IP Logged

The Cow YaBB Administrator Offline Posts: 2530 Joined: Nov 22^nd, 2002	Re: Reports Reply #5 - Aug 16^th, 2005 at 12:08pm	Print Post
	What version number of Sesame are you using?

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

Foster Ex Member	Re: Reports Reply #6 - Aug 16^th, 2005 at 12:45pm	Print Post
	version 1.1.2


	IP Logged

Foster Ex Member	Re: Reports Reply #7 - Aug 29^th, 2005 at 4:20pm	Print Post
	OK, I found I had an attached spec that was overriding everything else. Now how do I delete and/or change spec? Could find no instructions in manual.


	IP Logged

Ray the Reaper Global Moderator Members Lantica Support Offline The One & The Only Posts: 2482 Joined: Aug 20^th, 2003	Re: Reports Reply #8 - Aug 29^th, 2005 at 4:36pm	Print Post
	Hello Foster, You remove a spec the same way you add one. Redesign your report in Sdesigner Click Attach Specs Choose the Appropriate Spec Type Choose "Select a Different Spec" in the Attach a Spec drop down Choose "[NONE] - Detach Current Spec" Click Attach. -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: Reports Reply #9 - Aug 30^th, 2005 at 3:11am	Print Post
	I guess I was not clear in my reply on the 15th ??? Sorry about that. Glad you finally got it resolved.

	Bob Hansen Sesame Database Manager Professional Sensible Solutions Inc. Salem, NH 603-898-8223 Skype ID = sensiblesolutions
	WWW Skype/VoIP 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