Jump to content

  •  

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 10h 43m 59s

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
  • 23,958 posts
  • Time Online: 319d 1h 39m 2s

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 10h 43m 59s

Posted 27 February 2012 - 01:58 AM

How I can summarized in report?
  • 0

#4 comment  consultant

comment
  • Members
  • 23,958 posts
  • Time Online: 319d 1h 39m 2s

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 10h 43m 59s

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
  • 23,958 posts
  • Time Online: 319d 1h 39m 2s

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 10h 43m 59s

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
  • 23,958 posts
  • Time Online: 319d 1h 39m 2s

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 10h 43m 59s

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,676 posts
  • LocationOregon
  • FM Application:13 Advance
  • Platform:Mac OS X Mavericks
  • Time Online: 205d 22h 4m 4s

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 10h 43m 59s

Posted 27 February 2012 - 01:24 PM

thank you I find my answer.
  • 0




FMForum Advertisers