Reports

[mhudd]

I'm trying to create a financial report in FM.

My problem is I only want entries that have money associated with them to appear in the report. Right now everything is appearing even if it doesn't hae moeny associated with it. The report looks great, it's just looks like it could kinda long with a lot of blank entries...

Does this make any sense?

[LuckyMe]

If I understanding your problem correctly, then why dont you Find the entries that have money associated first, then it will show the records that entries that have money associated

Good luck

[mhudd]

The fields that have financials are in a portal and I'm not real sure how to find my financial related fields in a portal...

[mhudd]

I forgot to mention that I'm also allowing the user to generate the report by date and one other field criteria...

[mhudd]

So...actually it looks like I need to enter a script set that locates just the records that have money and have it done while letting the user search by date and the one other field criteria....... it's got me...

[RussBaker]

As far as using a portal in your parent file to view only the child records that have money in them...

Create a field in the child file that gives you a "yes" or "no" if the record has money in it.

something like =if(isempty(money)=1,"no","yes") would do the trick if you only want to show records where a money field actually contains a value. You may have to determine your own calculation depending on what you want.

Then append this to the key field in this child.

Then append "yes" to the key field in the parent.

Now, only records that have money in them will show up in the portal in the parent.

If you're going to be printing out reports in a related system, then I think its best to print the reports from the child file. You then need to find the "yes" records in the child before printing.

Russ Baker

Canberra, Australia