Sign in to follow this  
Followers 0

Calculate Item on Report

11 posts in this topic

Posted

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

Stuff.zip

Share this post


Link to post
Share on other sites

Posted

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.

Share this post


Link to post
Share on other sites

Posted

How I can summarized in report?

Share this post


Link to post
Share on other sites

Posted

Thank you very much,

But In my database don't change like you sample, can u see?

Share this post


Link to post
Share on other sites

Posted

I don't understand what you mean.

Share this post


Link to post
Share on other sites

Posted

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

Stuff.zip

Share this post


Link to post
Share on other sites

Posted

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.

Share this post


Link to post
Share on other sites

Posted

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

Stuff.zip

Share this post


Link to post
Share on other sites

Posted

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.

StuffMOD.zip

Share this post


Link to post
Share on other sites

Posted

thank you I find my answer.

Share this post


Link to post
Share on other sites

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 account

Sign in

Already have an account? Sign in here.


Sign In Now
Sign in to follow this  
Followers 0