If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
manytables data in one report
dear friends
i have many tables but i want all table data in a custamised way in one report viz table [invoice] (date,invoiceid(pk),invoiceddate,supplairid(fk),) table [receivedinvoice] ( invoiceid(fk),fuelquantityreceived,) table [decanteddata] (date,decantedid(pk generatedkey),decatedtotank,tankbalencebeforedecan t,tankbalenceafterdecant) table[fuelissues] (date,issueid(pk),issuedquantity,issuedto) table[misc issues] (date,misissueid(pk),purpus,misquantity) these are the available data The report recquired is date(groupby,between specified dates),openingbalencesum tankbalenceafterdeacnt - sum ( issuedquantity+misquantity)),totalreceivedinvoice: sum(fuelquantityreceved,between date 00.00 hrs to next day 00.00 hrs),progrssivetotalreceivedinvoice:sum(fuelquanti tyreceived , between startdayof month and now()),fuelclosingbalence at cosing:sum(tankbalenceafterdecant - sum( issuedquantity + misquantity) i traid to generate report in many ways but failed , 1) kindly advise is im lapsed in table normalisation and setting up relationship 2) how to do all calculations to for everyday in a month in one report except fuelquantity and date remainig all data types are text fuel quantity number if any help offered may be sent to Please have a look at it please, |
Thread Tools | |
Display Modes | |
|
|