Jump to content
Sign in to follow this  
gullfounder

Creating a monthly Report

Recommended Posts

Hi,

I am new to file maker. I wanted to create a report of my monthly sale. For Example

For month Jan-1-2012

Product Qty Price

Product 1 100 1000

Product 2 200 2000

Total Sale 3000

But i cannot understand it how to make it. I am uploading the File.

https://rapidshare.com/files/3524128622/Project_Filemaker%20TuckShop.fp7

Share this post


Link to post
Share on other sites

See here

http://fmforums.com/forum/topic/76326-monthly-quarterly-reports

Share this post


Link to post
Share on other sites

See if this helps. Go to your Sale layout and check out the new button. Study how the report layout is set up, and how the script takes the global values to define a search string for the date range and checks for errors (use Script Debugger and Data Viewer to see it in slow motion). You may want to set up a dedicated layout where you can configure and initiate reporting.

You find a lot of information in the FileMaker Online Help; also, when you create a new layout there's a Report Assistant which helps defining the parts and fields you need for a typical report.

btw, you can post files here in the forum, and you should zip your files before posting (actually, you must zip them before posting here, but it's generally a good idea).

Project_Filemaker TuckShop_rep.fp7.zip

Share this post


Link to post
Share on other sites

Sorry mr_vodka. But it didn't help. But let me explain it to you. what i really wanted to do.

I have Products table and sale and sale Detail. When ever i sale something the items the transaction record goes to Stock table. the stock table stores what products are sold. How many are sold!

So, I only wanted to make a report Utilizing it to show How much of my products are sold in particular month.

Share this post


Link to post
Share on other sites

You're on the right track. Define summary fields for the prices (Total) and quantities (Count; not running!) you need, place them in the sub-summary (or sub-summaries) and sort (at least) by the field the sub-summary is based on.

Be aware that you can use the same summary fields in the summary parts, where they will show a summary for the group, and e.g. in the header, to show a summary of the found set.

Share this post


Link to post
Share on other sites

Neo, I wanted to add the all the similar products together. I mean there qty that is sold in the month should all be added to together.

post-106853-0-13481300-1344436222_thumb.

Share this post


Link to post
Share on other sites

I wanted to merge the similar products qty. How can i do it? in the report i see another entry of layz and coke. i wanted to see the merged and only show 1 time.

post-106853-0-91283000-1344437971_thumb.

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  

×

Important Information

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