Jump to content


  • Content Count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About FMquestions

  • Rank

Profile Information

  • Gender
    Not Telling
  1. Creating a second TO for object does take care of the issue but another issue arose. On the measurement table, the summary field is not displaying the sum of the measurement. Does this have to do with the 2nd TO? Regarding the use of portal for related data, I was wondering if it automatically changed the data in the situation I described before where all 6 records displayed the name for object 1. This is a set of imported data who were assigned pk and fk IDs to maintain relationship between the different tables. Thus, the measurements that were entered had an object fk ID to indicate whi
  2. Thanks for clarifying. There is another issue I came across and I was wondering if you can share your thoughts. I have a layout on the People table with a portal that displays data from the measurement table. However, 2 of the fields from this portal are displaying records from the object table. What I noticed is that all the related records have been changed to reflect the data from the first related record. For example, one person has 3 measurements for 2 objects so there are a total of 6 measurements in this portal. 3 of the measurements should be for object 1 and 3 for object 2. Howev
  3. Ahh, of course. I created a second TO of the test dable and linked it to the measurement table by the studyID but I am still having issue displaying all the related test date. I added an additional subsummary on the report, which is sorted by the person. I placed the portal in this subsummary section but no record is displayed.
  4. I do need the test dates link to the person and I need them link to measurements as well. It seems like I need a second TO of tests In order to get all the related studies to display in the report, If data for the test table is being imported, would I need to import twice (to each TO)?
  5. Thanks. Does this mean I should have a second TO linking tests to measurements?
  6. The table stores information such as the test date, description about the test, the test number, modality of the test .... No, even if two people have a test performed on the same date, it is not guaranteed that they will both have the same tests. For each test date, there will be at least one measurement. For instead, let's say a person has 2 test dates (T1, T2), 2 objects, and 3 measurements. For T1, there is one measurement for object 1 and 1 measurement for object 2. For T2, there is only 1 measurement for object 2.
  7. Thanks for the response. There is a separate report and date table for a reason. Multiple types of report will be generated and stored in container field so that the reports can be downloaded and access in IWP. The dates table store other information relating to the test. Each measurement is associated with a test date and an object. However, the object may not necessarily have a measurement for each test date. Is that clear?
  8. Hi all, I have an issue with getting a portal to display all the child records. As you can see in the ERD attached, there is a measurement table, that is a child of the test date table and both the measurement and the test date table are children of the people table. A person can have multiple objects, which will be measured at different test dates. I am creating a report for each person that is on the measurement table using the object as subsummary. I would like to display all the person's test dates in a grand summary section above all the measurements. At first, I tried using a p
  9. Thanks for sharing this. If I understand correctly, you had 22 portals displaying one record at a time. In my case, instead of having location by year, I would have dates by type of measurement. This is a really neat method but in my case, I would never know how many measurement a person can have and it looks like you need to design the layout knowing the number of measurement or number of location in your example.
  10. I see what you mean about having each parameter as a separate record so that the report can be sorted by the parameter but we want are ultimately interested in the change between each measurements. Thus for each measurement, we want all parameter to be listed together in a row so that we can see them all at once. Does that make sense? I think your method will only provide the sum for each object but I am interested in the sum of all the object for each person. I hope this might clear up some of the confusion: People Table: Person1 Object Table: Cat, Dog Measurement Table (s
  11. It will actually be 6 records in the measurement table because the 2 parameters are in different fields. The assumption is that every time a measurement is made, both the height and weight will be measured. I want to get the baseline (defined as 1st measurement) and the follow-up (defined as the 2nd and 3rd measurement) sum of both the cat and the dog for each person. For each type of measurement (height and weight), I have 2 fields (height_baseline and height_follow-up), and then 2 more summary fields (height_baseline_sum, height_follow-up_sum). As you can see, that is 4 additional field
  12. Hi, I was wondering if it is possible to mimic the summary field type by a calculation so that I can minimize the fields in a table. I have a people, object and measurement table that stores different type of measurement. Let's say a person has two objects (i.e. cat and dog) and the object's height and weight have been measured three times. For the person, I am interested in getting the sum of each type of measurement (height and weight) for the first measurement and then sum of all the subsequent measurements. What I am currently doing is defining two additional fields in the measur
  13. Yes, I see what you mean. However, using local variables would delete the chart as soon as the script ends and I need the chart to be displayed for a summary report.
  14. I thought I cleared them in the beginning of the script with the step: Set Variable[$$valueX[$$objIndex];Value"""
  15. Attached is the modified file. I modified the file so that I am using global variables and to include 2 charts, one for values A and another one for values B. Go to the Galexy layout and go to the first record. Click on the button "Chart ... (Global) w/ parameters", it will take you to the layout with the charts. Everything is displayed correctly. Now if you go back to the Galexy layout, go to the second record, and then click on the button "Chart ... (Global) w/ parameters", you will notice that there is an error in the charts. The chart should only display 2 series. The legend displays the c
  • Create New...

Important Information

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