|
|
Omitting Records
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
|
|
0
|
|
|
|
Reply
|
Buckbuck
|
3/28/2011 5:38:23 AM |
|
On Mar 27, 11:38=A0pm, Buckbuck <buck.matthe...@yahoo.com> wrote:
> 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 =3D Wages
DJ
|
|
0
|
|
|
|
Reply
|
David
|
3/28/2011 2:41:33 PM
|
|
"Buckbuck" <buck.matthew74@yahoo.com> wrote in message
news:cbab39bc-9221-4227-b197-14a15d4b7d8d@34g2000pru.googlegroups.com...
> 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 :o)
|
|
0
|
|
|
|
Reply
|
Your
|
3/28/2011 8:27:59 PM
|
|
|
2 Replies
225 Views
(page loaded in 0.069 seconds)
Similiar Articles: duplicating record with children - comp.databases.filemaker ...... like: Go to Related Record Go to record [First] Loop Exit loop if [status(currentfoundcount) = 0] Duplicate Record Set Field [ParentID; Global] Omit Record ... Remove Duplicate Records Question - comp.databases.filemaker ...The 'Omit' step leaves you on the next record, but in the last run of identical ID's, if you omit the last one there is no next record so you land automatically on the ... Random record selector? - comp.databases.filemakerIs there a way to command FileMaker to select x number of records with certain ... Go to Record [ By Calculation: int(Random * 100) ] Omit Record Exit Loop If ... Save as .pdf in Windows? - comp.databases.filemakerSo omitting records would be done with CTRL-T. Albert wrote: > Hi -- > > I'm a happy Mac-platform Filemaker user trying to help out a local > museum with using their ... how do I go to specific record in preview to print it - comp ...insert at the beggining of your script these three lines: show all records (but the record that the user is interested is on front) omit record (omit the interested ... Multiple field search query using an omit - comp.databases ...Multiple line fields - comp.lang.awk Multiple field search query using an omit - comp.databases ... Printing multiple fields from individual records - FMP 5.5 - comp ... Duplicating child set - comp.databases.filemaker... First] Loop Exit loop if [status(currentfoundcount) = 0] Duplicate Record Set Field [ParentID; Global] Omit Record Go to Record [First] Omit Record End ... Making Filemaker search smarter - comp.databases.filemaker ...Go to first record loop exit if foundcount = 0 if not OK, omit else go to next record, exit after last end loop -- Hans Rijnbout Utrecht, Netherlands Exporting to Word / RTF using XML / XSLT? - comp.databases ...... your full document in a global (warning: 64,000 character limit), you need to get your found set down to one record (three script steps: show all records, omit record ... Reading all text responses to Questionnaire - comp.databases ...I've built my first database for a questionnaire, and there are 300 records ... the Q23 values, one after another, then the Q24 > > values, then Q25 values, omitting ... Selecting and Omitting Records Using Logical FilesSelecting and Omitting Records Using Logical Files. The system can select and omit records when using a logical file. This can help you to exclude records in a file ... Omitting records with empty fields DataBaseHow do I set up a report where I want to view a list with certain fields containing a value to print If that field is empty, I would like the report to sk 7/15/2012 9:04:17 AM
|
|
|
|
|
|
|
|
|