Jump to content

Summary field


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

Recommended Posts

I have a report with a sub-summary. The field x is in the body and I want a field in the sub-summary that sums the values of x displayed. However, I cannot use a sub-summary field to total x, as x exists in a different table to the one the report is included in.

I could use a lookup to bring x into the required table, but I need a simpler solution as this is a task for high school students who need not know about lookup fields.

Any ideas?

Link to comment
Share on other sites

Basicly do you make subsummary reports in the relational end of the matters where the most atomic data exisits. However could this be a little tricky with the version you're on, since GTRR(FS) haven't arrived yet. So if you make a found set in the parents table do you need to gather all the primary key values, put them in a global field in the children table and relate the global to the foreign keys, and then fire the GTRR(SO) over there instead in the selfjoin to establish a found set belonging the found set of parent records.

Then is it smooth sailing with subsummary reports, remember that the field values from the parent records are availiable just by referencing them on the layout.

If you should be lost in my weird way of putting my words, poke into:

http://www.kevinfrank.com/download/multi-gtrr.zip

--sd

Link to comment
Share on other sites

This topic is 6075 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.