Kurt Knippel Posted August 3, 2000 Share Posted August 3, 2000 quote: Originally posted by GarrettD78: I have two databases that I am trying to sum up. One has the summary field and in that table it works fine. But in the relational table where the report is, I simply put that summary into a sub-summary when sorted by a field. This does work on the first page of the report. I get the correct numbers on everything, but on the next pages I loose this field. The computer quits printing this field. What do I do? You cannot use summary fields on related fields or summary fields from related files. This is just not possible. In general reports need to be in the same file as the data that they are summarizing. I am sure that there is a way to make you report work and may simply involve moving the location of the report. ------------------ =-=-=-=-=-=-=-=-=-=-=-=-= Kurt Knippel Senior Filemaker Developer http://www.database-resources.com mailto:[email protected] =-=-=-=-=-=-=-=-=-=-=-=-= Link to comment Share on other sites More sharing options...
Newbies GarrettD78 Posted August 3, 2000 Newbies Share Posted August 3, 2000 I have two databases that I am trying to sum up. One has the summary field and in that table it works fine. But in the relational table where the report is, I simply put that summary into a sub-summary when sorted by a field. This does work on the first page of the report. I get the correct numbers on everything, but on the next pages I loose this field. The computer quits printing this field. What do I do? Link to comment Share on other sites More sharing options...
Newbies wayking Posted August 3, 2000 Newbies Share Posted August 3, 2000 so, in other words, if i have a need to publish summarized data to the Web i need to begin by getting rid of FileMaker? is that your message? the company i work for develops most of their databases in Lotus Notes (ugh). i have managed to avoid Notes and stay with FileMaker up to this point, but if FileMaker is incapable of publishing summarized data in a Web interface i need to quit wasting my time with it and begin learning to develop in Notes. Link to comment Share on other sites More sharing options...
Newbies GarrettD78 Posted August 3, 2000 Newbies Share Posted August 3, 2000 I was able to get some of the numbers by using a GetSummary function in one table and then adding that into the report. I sometimes get the right number and sometimes the number is wrong and other times the number doesn't even appear. If I look at the table where the info exist the GetSummary function is working correctly. Why won't FM just move that number to the report. Link to comment Share on other sites More sharing options...
Kurt Knippel Posted August 4, 2000 Author Share Posted August 4, 2000 quote: Originally posted by wayking: so, in other words, if i have a need to publish summarized data to the Web i need to begin by getting rid of FileMaker? is that your message? the company i work for develops most of their databases in Lotus Notes (ugh). i have managed to avoid Notes and stay with FileMaker up to this point, but if FileMaker is incapable of publishing summarized data in a Web interface i need to quit wasting my time with it and begin learning to develop in Notes. Huh?!?! I am not even sure of what you are refering to? ------------------ =-=-=-=-=-=-=-=-=-=-=-=-= Kurt Knippel Senior Filemaker Developer http://www.database-resources.com mailto:[email protected] =-=-=-=-=-=-=-=-=-=-=-=-= Link to comment Share on other sites More sharing options...
Kurt Knippel Posted August 4, 2000 Author Share Posted August 4, 2000 quote: Originally posted by GarrettD78: I was able to get some of the numbers by using a GetSummary function in one table and then adding that into the report. I sometimes get the right number and sometimes the number is wrong and other times the number doesn't even appear. If I look at the table where the info exist the GetSummary function is working correctly. Why won't FM just move that number to the report. Because the Summary functions work on the records within each individual FILE. If the report does not exist within the same FILE then the summary functions will not work. This is not a Filemaker specific issue and you will find this is the same with all databases. There are two ways around this: restructure where and how you are reporting (i.e. where the report layout is) or invest in one of the high end reporting applications which can summarize data from multiple systems into a single report. ------------------ =-=-=-=-=-=-=-=-=-=-=-=-= Kurt Knippel Senior Filemaker Developer http://www.database-resources.com mailto:[email protected] =-=-=-=-=-=-=-=-=-=-=-=-= [This message has been edited by captkurt (edited August 03, 2000).] Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 8675 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 accountSign in
Already have an account? Sign in here.
Sign In Now