dbTalk Databases Forums  

Omitting Records

comp.databases.filemaker comp.databases.filemaker


Discuss Omitting Records in the comp.databases.filemaker forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Buckbuck
 
Posts: n/a

Default Omitting Records - 03-28-2011 , 12:38 AM






FM10
I have a Ledger with a chart of acccounts; wages, rent, production,
office. I want to create a sub-summary report sorted on the chart of
accounts but there is one account - wages, all records of which I want
omited. Can you advise me on the script steps?

Thanks

Reply With Quote
  #2  
Old   
David Jondreau
 
Posts: n/a

Default Re: Omitting Records - 03-28-2011 , 09:41 AM






On Mar 27, 11:38*pm, Buckbuck <buck.matthe... (AT) yahoo (DOT) com> wrote:
Quote:
FM10
I have a Ledger with a chart of acccounts; wages, rent, production,
office. I want to create a sub-summary report sorted on the chart of
accounts but there is one account - wages, all records of which I want
omited. Can you advise me on the script steps?

Thanks
Use Constrain Found Set []
Set it to Omit records when chart = Wages

DJ

Reply With Quote
  #3  
Old   
Your Name
 
Posts: n/a

Default Re: Omitting Records - 03-28-2011 , 04:10 PM



"Buckbuck" <buck.matthew74 (AT) yahoo (DOT) com> wrote

Quote:
FM10
I have a Ledger with a chart of acccounts; wages, rent, production,
office. I want to create a sub-summary report sorted on the chart of
accounts but there is one account - wages, all records of which I want
omited. Can you advise me on the script steps?

Thanks
Before going to the report layout, simply perform a Find (either manually or
set-up a Script to do it) that leaves out those unwanted records.

- Go into Find Mode on a Layout using the correct Table.

- Enter the appropriate dates for the report into the date field
e.g. "1/1/2001...6/1/2011"

- Create a new Find Request (from the Records menu) and
click on the Omit checkbox in the side Status bar and
set the appropriate field to "Wages".

- Perform the Find.

- Sort the Records.

- Go to the Report Layout and print / preview it.


Helpful Harry )

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.