13 Replies Latest reply on May 11, 2016 11:21 AM by TSGal

    save/send to excel bug

    zoro

      There is a bug with this fonction from a report with summary, it's alway an empty file.

       

      what I have on os 10.11.3 and 14.0.5

       

       

       

       

        • 1. Re: save/send to excel bug
          TSGal

          zoro:

           

          Thank you for your post.

           

          Please describe your layout in more detail.  Make sure none of the fields are touching the Header part.

           

          TSGal

          FileMaker, Inc.

          • 2. Re: save/send to excel bug
            zoro

            this is the result save/send to pdf

            • 3. Re: save/send to excel bug
              zoro

              I tried to joint a pdf file in down.

              save/send to pdf is perfect

              Lets make a test with save/send to excel you will have nothing

              probably the error come with statistic field

              Capture d’écran 2016-05-09 à 10.37.58.png

              • 4. Re: save/send to excel bug
                TSGal

                zoro:

                 

                A screen shot of the Layout would be more helpful.  I am unable to determine what fields are Number, Calculation, Summary, etc.

                 

                Regardless, I have a similar file with Text, Number and Summary values, and the data is exported to an Excel file.

                 

                If you want, send in a copy of your solution and I'll try to replicate the issue.  I have sent you a private message with instructions where to send your file.

                 

                TSGal

                FileMaker, Inc.

                • 5. Re: save/send to excel bug
                  beverly

                  TSGal,

                  This discussion may be of use.

                  save/send to excel get empty file

                  beverly

                  • 6. Re: save/send to excel bug
                    zoro

                    Capture d’écran 2016-05-09 à 13.08.24.png

                    Capture d’écran 2016-05-09 à 13.07.24.png

                    These document are the report of the same records

                    save/send to excel with the first file without summary there's no problem

                    the second one with summary, the fat number is the number of the record, is what I want to excel

                    export dont make a summary and save/send to excel doesn't work

                    • 7. Re: save/send to excel bug
                      zoro

                      @"Regardless, I have a similar file with Text, Number and Summary values, and the data is exported to an Excel file."

                       

                      Check if you have some double records in your file to know if the summary make a difference in the report.

                      • 8. Re: save/send to excel bug
                        TSGal

                        zoro:

                         

                        I'm not sure what you mean by "double records", but I do have records that are duplicated, and I do have some entries where the break field only has one value, and some with as many as ten values.

                         

                        TSGal

                        FileMaker, Inc.

                        • 9. Re: save/send to excel bug
                          zoro

                          Does it mean you don't understand where is the problem.

                          • 10. Re: save/send to excel bug
                            TSGal

                            zoro:

                             

                            I have not yet received your file, so I cannot determine what is causing your export to fail.

                             

                            TSGal

                            FileMaker, Inc.

                            • 11. Re: save/send to excel bug
                              TSGal

                              zoro:

                               

                              I received your file.  Thank you.

                               

                              There is no Body part, so nothing will be exported.  Therefore, use Export Records -> Excel Worksheet.

                               

                              I have updated the file and sent it to our Technical Support liaison.  If you don't receive the file within one hour, please let me know, and I'll make sure the file is sent to you immediately.

                               

                              TSGal

                              FileMaker, Inc.

                              • 12. Re: save/send to excel bug
                                zoro

                                Your file doesn’t work, check the column « N enregistrement » the summary doesn’t correspond to the report.

                                 

                                I don’t use body part on this report because I need only « N enregistrement » summary result for a sequence of production, I don’t want repeating the same pieces

                                 

                                I use different views report for different machines but it have to have the same « N enregistrement »summary on each

                                 

                                What we can see in export to pdf is perfect but the machines don’t work with

                                 

                                What I can understand is the commande SAVE/SEND TO EXCEL can’t export summary only body part and it’s what I need.

                                 

                                Do I well understand?

                                 

                                Do you Know how to export summary?

                                • 13. Re: save/send to excel bug
                                  TSGal

                                  zoro:

                                   

                                  I see the difference.  If you want the spreadsheet to appear exactly like the PDF file, I can do that.  Give me a couple of minutes, and I'll have a new file sent to you shortly.

                                   

                                  TSGal

                                  FileMaker, Inc.