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

0

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.

0

Share this post


Link to post
Share on other sites

Posted

How I can summarized in report?

0

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?

0

Share this post


Link to post
Share on other sites

Posted

I don't understand what you mean.

0

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

0

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.

0

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

0

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

0

Share this post


Link to post
Share on other sites

Posted

thank you I find my answer.

0

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