Need Help in Weekly Report

[mskichu]

hello

Iam beginner but I managed to reach till generating reports

I got stuck I need to generate Weekly report for invoices entered any help how

I can do. I have searched on the net I got the result but I cant understand to a advance level if any one please help me

Problem

I have 3 tables and 1 Layout. first table stores all the values for invoice(each) like item and pricing, second table stores Customer information, Third, stores all item and prices for each item.

After Creating the Relationship between the tables. I have created a Layout called "invoice". In which I managed all the fields works properly.

Now I want to view and print report for the invoice Layout by weekly

please help how I have to do

mskichu

http://www.crazytips.com

[ESpringer]

Take a look on this site for discussions about invoices and invoicing. It seems you're missing a crucial table: line items. If I buy three different kinds of things from you on one occasion, we need separate records for *three* line items, all linked to the *one* invoice record. (I take it your third table is not line items, but rather a list of the products available, along with prices, designed to help fill in prices for items on any given invoice. Yes?)

Once you have your tables and relations set up right, then generating reports will require that you have a layout for invoices which shows the data you want to summarize (do you need to include the line items, or just the transaction totals?). Then, you'll script a find to get the invoices from the desired week and print them...

Once you have your data structure very solid, you'll be in a better position to decide the details for your report design and can read and ask more.

[mskichu]

yep

I have changed the whole database as you said thank you very much

Now I can take records form multiple table and generate report

thank you very much

mskichu

www.crazytips.com