Jump to content

  •  

UPGRADE DEADLINE - SEPTEMBER 26, 2014!
FileMaker Inc. has a deadline for users of version 10,11, 12 as Individual box or volume licenses (with expired maintenance).
If you don't renew your maintenance and upgrade to FMP 13 you will no longer be eligible to upgrade, at the discount pricing.

Volume Licensing upgrade pricing for FileMaker Pro 13, FileMaker Pro 13 Advanced and FileMaker Server 13 will be discontinued.
Individual upgrade pricing for FileMaker Pro 13 and FileMaker Pro 13 Advanced will increase after September 26, 2014.
As of 27-September-2014, FileMaker 10 products will no longer be available for purchase or support.

http://help.filemaker.com/app/answers/detail/a_id/13865


Photo

Calculate Item on Report


  • Please log in to reply
10 replies to this topic

#1 moj6054  novice

moj6054
  • Members
  • 54 posts
  • FM Application:11 Advance
  • Platform:Windows 7
  • Skill Level:Beginner
  • Time Online: 1d 11h 2m 41s

Posted 27 February 2012 - 12:37 AM

Hi, I have a problem with report, I have three table(product,invoice,invoicelineitem) and want to know for each item how many I sold(qty)
for example:
Invoice:
Invoice:1 Item A qty::5
Item B qty::6

Invoice::2 Item A qty::7
Item B qty::6



I want see in report:
Item A qty::12
Item B qty::12

Attached Files


  • 0

#2 comment  consultant

comment
  • Members
  • 24,192 posts
  • Time Online: 329d 7h 14m 27s

Posted 27 February 2012 - 01:50 AM

Produce your reports from the Linetems table. A report sorted and summarized by invoice will look like your first example; a report sorted and summarized by item will look like the second one.
  • 0

#3 moj6054  novice

moj6054
  • Members
  • 54 posts
  • FM Application:11 Advance
  • Platform:Windows 7
  • Skill Level:Beginner
  • Time Online: 1d 11h 2m 41s

Posted 27 February 2012 - 01:58 AM

How I can summarized in report?
  • 0

#4 comment  consultant

comment
  • Members
  • 24,192 posts
  • Time Online: 329d 7h 14m 27s

Posted 27 February 2012 - 02:18 AM

This way?

Attached Files


  • 0

#5 moj6054  novice

moj6054
  • Members
  • 54 posts
  • FM Application:11 Advance
  • Platform:Windows 7
  • Skill Level:Beginner
  • Time Online: 1d 11h 2m 41s

Posted 27 February 2012 - 03:21 AM

Thank you very much,
But In my database don't change like you sample, can u see?
  • 0

#6 comment  consultant

comment
  • Members
  • 24,192 posts
  • Time Online: 329d 7h 14m 27s

Posted 27 February 2012 - 04:25 AM

I don't understand what you mean.
  • 0

#7 moj6054  novice

moj6054
  • Members
  • 54 posts
  • FM Application:11 Advance
  • Platform:Windows 7
  • Skill Level:Beginner
  • Time Online: 1d 11h 2m 41s

Posted 27 February 2012 - 05:04 AM

I change my database like your sample, But in report have error and don't show like your report

Attached Files


  • 0

#8 comment  consultant

comment
  • Members
  • 24,192 posts
  • Time Online: 329d 7h 14m 27s

Posted 27 February 2012 - 05:18 AM

I am afraid that's something you'll need to work out on your own. So far, I don't see that you have a reporting layout with the necessary sub-summary parts, nor a script to produce the report.
  • 0

#9 moj6054  novice

moj6054
  • Members
  • 54 posts
  • FM Application:11 Advance
  • Platform:Windows 7
  • Skill Level:Beginner
  • Time Online: 1d 11h 2m 41s

Posted 27 February 2012 - 05:36 AM

I design layout but in the end, it give me wrong result.

Attached Files


  • 0

#10 LaRetta   Lifelong FM Student

LaRetta
  • Members
  • 9,810 posts
  • LocationOregon
  • FM Application:13 Advance
  • Platform:Mac OS X Mavericks
  • Time Online: 220d 5h 29m 16s

Posted 27 February 2012 - 10:23 AM

If you look again at Comment's InvoiceReports.fp7, you will find a layout named Report. This has sub-summary parts like what was explained. Not a single layout in your last file has a report layout or sub-summary in it at all.

I have modified your file and added a Report layout. When you create a new layout, FM walks you through 'report' and adding sub-summary parts - it even shows you the resulting report (to the right) as you design it, inserting sub-summary parts as you specify. You need to understand how this works.

Look at your report layout in layout mode. It clearly shows the sub-summary parts. You can work with them by selecting Layouts > Part Setup.

Attached Files


  • 0
Each assumption is an educated guess, a likely condition or event, presumed known and true in the absence of absolute certainty.

#11 moj6054  novice

moj6054
  • Members
  • 54 posts
  • FM Application:11 Advance
  • Platform:Windows 7
  • Skill Level:Beginner
  • Time Online: 1d 11h 2m 41s

Posted 27 February 2012 - 01:24 PM

thank you I find my answer.
  • 0




FMForum Advertisers