Jump to content

Need help with summary report field


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

Recommended Posts

I previously posted a question about this, but for some reason the thread seems to have disappeared. Here goes again, and I'm attaching a couple of generic sample files. If anyone can solve this one for me, I will reward them with...well, glory and praise. It seems to me like it should be incredibly simple, but I just can't solve it.

In my two stripped down sample files, Clients.fp5 and Services.fp5, I've got 10 clients entered in Clients, with unique IDs. Services references these clients by ID, but some clients have different funding over time; in other words, client #1 may have three services paid for by Medi-Cal but then switches to Self Pay. The report (set up in Services with a script) needs to summarize how many services were provided for each pay source, and then how many discrete clients fell under each pay source. In my example, the correct numbers of discrete clients for each pay source should be: Insurance 6, Medi-Cal 4, Self Pay 5.

Riley Waugh responded to my original post with a general suggestion to get the data via finds or relational portals from the Clients file. I keep thinking there must be a simpler way. Anyone up for this challenge?

Example.zip

Link to comment
Share on other sites

This topic is 6563 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
 Share

×
×
  • Create New...

Important Information

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