Jump to content
Sign in to follow this  
hutchlad

Exporting Report Issue

Recommended Posts

Hey Guys,

Just a quick one, I have a large report that groups products together via Style, and has totals at the bottom in the green section (I realise they arent totalling but thats not my issue)

My issue is, that when I export as a spreadsheet, my products stay grouped by Style, but I cannot for the life of me get the totals to stay underneath the columns of each group! Any help or advice would be appreciated, I just want it so that its in the format below with the group of products, then the totals beneath.

 

image.png.ed17a0c38774f600378214e893367fce.png

Share this post


Link to post
Share on other sites

I don't understand what your picture is supposed to show, esp. the role of the multiple columns.  In any case, records are exported directly from the data level and not from your layout. If your export is grouped, you will have exactly one row for each group, and one column for each field included in the export field order. There will be no extra row for totals. If you really need that, consider other methods.

Share this post


Link to post
Share on other sites
1 hour ago, comment said:

I don't understand what your picture is supposed to show, esp. the role of the multiple columns.  In any case, records are exported directly from the data level and not from your layout. If your export is grouped, you will have exactly one row for each group, and one column for each field included in the export field order. There will be no extra row for totals. If you really need that, consider other methods.

On my layout, I have my products grouped by STYLE. Which will have say 5 or 6 related products as shown in the above image as 'grey fields'

Where the GREEN field is, that is where I wanted a sub summary of the fields above. I didn't think you would need more information than that?

Share this post


Link to post
Share on other sites

I am afraid I still don't understand what you're talking about - esp. the part about "say 5 or 6 related products". I would expect a report of products grouped by style to look something like this:

Style 1
• Product A: $10
• Product B: $15
Subtotal: $25 
   
Style 2
• Product C: $100
• Product D: $150
• Product E: $200
Subtotal: $450  
  
Grand Total: $475

 

And, as I already said, this has no bearing on how your export will look like. If it's grouped by style, then at most it will look like this:

ttt.png.76c3ba37e14bb1c1d47f9d7190eb11f3.png

though more typically like this:

tttt.png.5a2f46012711deff7157f9bc7a546796.png

 

 

Edited by comment

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  

  • Similar Content

    • By 360Works
      New Major Version Release:
      Scribe 4!
      We are excited to announce a new major version of a popular 360Works plug-in, introducing Scribe 4! 360Works Scribe is the ultimate document automation plug-in for FileMaker; it allows integration with Word, Excel, and PDF documents. In this release, we are taking it to the next level by adding in the ability to read your scanned documents, such as receipts, forms, or contract PDF files, with OCR (Optical Character Recognition) functionality. Additionally, we added features to allow you to merge PDFs and get meta-data from them, plus multiple fixes for existing functionality in Scribe.
      New OCR Functionality
      Scribe 4 ships with brand new OCR functionality to read your scanned documents and extract text to be added into FileMaker. For example, a law firm can scan in loads of paper legal contracts and have the text extracted and imported into the appropriate FileMaker records! Scribe leverages the technology of Amazon Textract which goes beyond simple OCR by not only extracting text but also identifying key information like the contents of fields in forms.

      Click here for a cool demo file showing how to use this new OCR functionality in Scribe!
      New PDF Merge Feature
      We added two new functions to merge and manipulate PDFs with Scribe. For example, if you have a couple of PDFs stored in container fields, the new function ScribePDFMerge allows the two PDFs to be merged together. The new ScribePDFSplice function allows a multi-page PDF to be split up into smaller PDFs. This is beneficial if you have containers with multi-page PDFs, and only need to utilize a specific part of the entire PDF file.
      Get PDF Meta-Data
      You can now get meta-data about a PDF, such as the name of the author and page count. The new ScribeGetPDFAttributes function will return various meta-data about a PDF. This can be helpful if you want to have FileMaker manage PDF files according to the author or number of pages specified in the meta-data.
      Multiple Improvements to Existing Functionality
      We also made several upgrades to the existing Scribe functionality. When using Excel with Scribe, the Excel cell reading and writing images to Excel cells has been greatly improved. We also made fixes for the ScribeDocSubstitute function for replacing a value.
       
      Try or Buy Scribe 4
       
      Availability
      Scribe 4 is available now at the Scribe product page. Active maintenance subscribers for Scribe or the 360Works Portfolio Bundle can download new major version 4 at no additional cost. All purchases within the last 12 months are still under an active maintenance subscription. If the maintenance on Scribe has not been renewed within the last 12 months, you will need to purchase a new license to use Scribe 4.

      For new license purchases, we have several license types available based on number of users, client-side or server-side usage, and a solution bundle license for developers with a vertical market solution.

      A free, fully functional demo is available to test Scribe. While in demo mode, Scribe will run for 2 hours every time you launch FileMaker (or FileMaker Server, for server deployment).

      Full pricing, license type information, and the demo version can be accessed at the Scribe product page.
        Try or Buy Scribe 4     Stay updated with 360Works


      360Works

      Questions? Please Email plugins@360Works.com
       
    • By Jon David Wardlow Petrie
      Hello My name is Jon Petrie and I am in the same boat as you are and I am trying to setup the samthing as you are with Filemaker To keep track of my bank transactions.
    • By Michael Stevens
      I have a parent table with 3 child tables.  In the child table, there can be many related fields.  I need to export only one row of data for each record in the parent table.  This would require that a new column be created for each of the many values related in the parent to the child.

      For Instance:
      Noah Justin has 3 Email Address NJ@Test.com, NJ2@Test.com, and NJ3@Test.com

      When I do an Excel Export from FM I get
      Column 1 .       Column 2
      Noah Justin    NJ@Test.com
                                NJ2@Test.com
                                NJ3@Test.com

      I need:
      Column 1 .     Column 2 .        Column 3 .          Column 4
      Noah Justin  NJ@Test.com  NJ2@Test.com  NJ3@Test.com

      I'm sure it's pretty common and there is an easy solution to this.  

      TIA
    • By ken_s2007
      I'm not well versed in summary layout parts and reports, but am trying to learn.
      I have a (personal) database to track investments (stocks, mutual funds, bonds, etc.). I have fields such as: number of shares, price, and value (technically: shares * price). Each record has three checkboxes: buy, sell, and current holding (previous (historical) records do not have 'current' checked).
      After establishing a found set (of a particular investment), I have a script that constrains the found set to buys, sells, and current record(s) (plural, because the same investment could be held in multiple accounts). (All historical records (except buys and sells) are thus not in the found set.)
      I have a script, triggered on layout enter, that sorts by buy, sell, and current. (Buys and sells are executed trades.)
      I have a sub summary part, and in it, a summary field based on value.
      The layout displays the records sorted as I want, and the summary field displays the correct total for each of the three groupings of records.
      What I want is to get the value of each of those summary fields, so that I can do a calculation: (Sells + current holding) - buys = profit / loss.
      Of course using the single summary field doesn't work.
      I could run a script to find the buy records, set a variable based on the summary field value, find the sell records, set a variable on the summary field, and so on. Then have fields with those variables (plus a calculation field) in the trailing grand summary.
      I could also create separate fields for buy (shares, price, and value), sell, and current, but I'd prefer not to.
      I thought I'd ask, because I might be missing a simpler method. thanks
    • By brownt
      I have a friend for whom I've done a bit of consulting helping him build some project tracking tools in FileMaker.  Helped him through the basic stuff around relating tables together, doing a bit of scripting, creating some basic reports based on data he's entered... Well, now he's hooked!  And would like to do everything for his business in FileMaker.  His current partner does everything in Excel, and has over the years developed a project management spreadsheet he uses to track project funds, activities and generate a financial summary for their clients...  Well, now I've been asked to see if it can be redeveloped in FileMaker, because my friend doesn't want multitudes of Excel sheets for every project, that he has to paw through when he wants to pull data for his other tracking tools that are in FileMaker.   He'd like to be keeping all the data in one place.
      His partner's Excel sheet basically tracks the date of an activity, a note about the activity (what business or consultant or company performed the activity), what kind of activity it is (each spreadsheet for each project may have anywhere from 8 to 16 different kinds of activity) and how much money was associated with that activity (credit or expense).  Tracking that is not a tough deal in FileMaker, that piece I've already sketched out.  Reporting on it is where I'm having problems, because he'd like FileMaker to produce a report that looks as close to what the Excel sheet looks like, including columns for each kind of activity they're tracking, with activity totals, balances, budget remaining, etc...  Where I'm really really running aground is the fact that there may be any number of different kinds of activity going from project to project.  Some may have 7 different kinds of activity, some may have 15 or 20. 
      I've included a sanitized, example version of one of his Excel files.  I can't wrap my head around how best to do up a report that doesn't have a set number of fields (what would correspond to the columns in his Excel).  I could do it as a great big flat file database and put in fields for every possible kind of project activity, I guess, but.... argh!  
      I would welcome any thoughts on how a report like the one I've included as an Excel file here could be created in FileMaker...  Or if the combined expertise here figures this is something that is best left to Excel (I must admit, my thoughts have drifted that direction as I wrestle with this).
       
      Thanks in advance!
      report.xlsx
  • Who Viewed the Topic

    1 member has viewed this topic:
    taylorsharpe 
×
×
  • Create New...

Important Information

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