Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×

report not showing all found records


This topic is 5841 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Posted

A report while in browse mode (after being sorted properly) shows 4 records. When switching to preview mode only the 4th record displays and/or prints.

Posted

Is the 4 record also the current record? Do you have your print set to print Current Record?

Posted

Print is set to "records being browsed". Actually I still have the same problem just viewing it in preview mode as well.

Another strange thing is that while in Browse mode, I displayed "Show omitted only", did the appropriate sort, and all the omitted show up in the preview of the report correctly. Then I when "Show omitted only" to go back to the first found set and do the sort, It still only previews one of the four records in the original found set.

Posted

are you doing this with scripts?

If so, be sure you don't have the Restore set in the script.

Lee

Posted

Yes with scripts.

In regards to taking the restore off, do you mean to not set a sort at the layout level?

Posted

1. In layout setup did you chose List view only?

2. Are you sorting the found set in the script?

3. When in preview mode can you move between the 4 records? If so see question 1.

Whenever I've had a problem displaying a report properly it is usually one of these problems that have caused it for me.

hth

Posted

That and having a Script Step for printing that restores a printing of the Current Record, rather than the Found Set.

if none of this solves the problem, then attach a copy of your file.

Lee

Posted

1. In layout setup did you chose List view only?

2. Are you sorting the found set in the script?

3. When in preview mode can you move between the 4 records? If so see question 1.

Whenever I've had a problem displaying a report properly it is usually one of these problems that have caused it for me.

hth

Lee, Mr_Vodka and Aldipalo

Good news and bad news

Good - I have it working

Bad - I'm still not sure what solved it.

1. I had all 3 views checked in layout setup

2. I was sorting the found set in the script (I assume that was the goal since it is working

3. I couldn't view records in preview but could pg down/up between them in browse mode

Lee, regarding your comment "are you doing this with scripts?...If so, be sure you don't have the Restore set in the script."

I wasn't exactly sure what you meant by not having the restore set in the script but I did go to each layout and from browse mode, erased the sort default data and then set it up in the script.

Also Lee you asked if I was doing subsummary reports. Yes and in regard to this, I when through each part and reset the leading/trailing settings.

Thanks for your help gentlemen!

This topic is 5841 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.