Jump to content
Sign in to follow this  
hung pham

A difference dynamic view of a portal

Recommended Posts

Hi,

I have two files A abd B and they related by key called CWC Number.

In one layout of A that have portal that show all record of B that has matched CWC.

Example:

You are looking at portal:

Org Code Est 1 Est 2

AD10 1 3

FD10 2.4 5.0

AD10 3 4

In the SAME layout, how can I display the above portal that look like this

Org Code Est1 Est 2

AD10 4 7

FD10 2.4 5.0

As you see it does not show the duplicated Org Code, but it show the total. In this case its show AD10 one time and its total. Assume I cannot make any change in the this view. View only.

Let say I add another AD10 and some estimate, after I exit record, then this view shoulb be updated/refresh by the changed at once.

I can do self join to get the total base on Org Code but how can I do for NOT showing the duplicated Org Code.

Thankyou in advance

Hung.Pham@msfc.nasa.gov

Share this post


Link to post
Share on other sites

quote:

Originally posted by hung pham:

Hi,

I have two files A abd B and they related by key called CWC Number.

In one layout of A that have portal that show all record of B that has matched CWC.

Example:

You are looking at portal:

Org Code Est 1 Est 2

AD10 1 3

FD10 2.4 5.0

AD10 3 4

In the SAME layout, how can I display the above portal that look like this

Org Code Est1 Est 2

AD10 4 7

FD10 2.4 5.0

I can do self join to get the total base on Org Code but how can I do for NOT showing the duplicated Org Code.

I can see what you are trying to accomplish here. The thing to remember is that portals display RECORDS. So you need to find some way to restrict the number of records displayed, so that only 1 occurance of each Org_Code is a valid record in the relationship.

I would suggest a calculation that checks to see if the given record is the first one and flags it as the "summary" record:

Assuming as self-relationship in the B file ( Org_Code::Org_Code ) and a unique record ID for each record, create the following calculation:

cSummaryRecord = If ( Self By Org_Code::RecordID = RecordID, Org_Code, "" )

The use this as the key in the second portal on your main layout. This should only show 1 record for each Org_Code, regardless of the actual number of records. You can then use the various Sum() and Count() type functions to get your sub-totals for each Org_Code

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

×
×
  • Create New...

Important Information

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