(UTC)
  Lantica User Forum › Lantica Discussions › Lantica Discussion › Reports not picking up all records
(Moderator: Forum Admin)
‹ Previous Topic | Next Topic ›
Page Index Toggle Pages: 1 Send Topic Send Topic Print Print
Normal Topic Reports not picking up all records (Read 1324 times)
Jazzer
Member
*
Offline



Posts: 3
Joined: Sep 26th, 2017
Reports not picking up all records
Apr 12th, 2018 at 11:40am
Print Post Print Post  
I have a simple Sesame members database for my club, which currently consists of 1010 members.  When I retrieve all these records and run a report to give me a printed list, this is only showing 988 records, i.e. 22 are missing.  Can anyone please suggest reasons why this could be?
  
Back to top
 
IP Logged
 
Ray the Reaper
Global Moderator
Members
Lantica Support
*****
Offline


The One & The Only

Posts: 2480
Joined: Aug 20th, 2003
Re: Reports not picking up all records
Reply #1 - Apr 12th, 2018 at 1:43pm
Print Post Print Post  
Hello,

Does your report have an attached retrieve spec? One easy way to test this is if you retrieve a small handful of records(10-20) and run the report does it give you the same 988 records in the report?

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



Posts: 3
Joined: Sep 26th, 2017
Re: Reports not picking up all records
Reply #2 - Apr 12th, 2018 at 3:23pm
Print Post Print Post  
Hello Ray

I did what you suggested and retrieved a small batch of records, and the report still lists all records.  It does appear therefore that there is a retrieve spec attached - could you please let me know how can I correct this?

Many thanks

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


The One & The Only

Posts: 2480
Joined: Aug 20th, 2003
Re: Reports not picking up all records
Reply #3 - Apr 13th, 2018 at 2:55pm
Print Post Print Post  
Hi Ron,

The following knowledgebase article covers removing an attached retrieve spec in Sesame Designer. After removing the retrieve spec from the report, you will need to save the report design and reconcile your DB file.

http://www.lantica.com/support/kb/article/000150

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



Posts: 3
Joined: Sep 26th, 2017
Re: Reports not picking up all records
Reply #4 - Apr 13th, 2018 at 3:35pm
Print Post Print Post  
Hello Ray

Thank you so much for your help.  I will follow the instructions in the knowlegebase article you have indicated.

Best regards

Ron
  
Back to top
 
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