many table in one report

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

balu - 11 Sep 2007 17:58 GMT

dearsir,
how to establish relationship and normalise to get the report for the tables
below viz.[fuelinvoces]
field invoiceid 'text' (PK)
" invoceddate 'date/time'
" invoicedquantity 'number'
" actual quantity ' number'
" decanted storagetankname ' text'
table [storagetankdata]

field decantingid 'autonumber'(pk) ,,(i have not found any altarnative id )
" tankname
" tankmeasurement beforedecant 'number'
" tankmeasurementafterdecant 'number'
" invoiceid 'number'
" decanteddate 'date
table [fuelissues]
field issuedate 'date'
" isuueid 'text'(PK)
" enginenuber 'text'
" tankname 'text'
table [miscellaniousissues]
field misissueid 'text(PK)
" quantity 'number'
" purpus 'text ,, (any purpus like foe
gensets)
" tankname 'text'
now i want the one report [date],
[tankname],[onhandbalence],groupbyof[fuelinvoices]"all details of that
day",(sum(onhandbalence+actualquantity)),groupbyof(fuelissues),groupbyof(miscellaniousissues),closingbalence:(sum(onhandbalence+actualquantity))-(sum(fuelissues+miscellaniosissues)) In one report
dear sir is it possible how to do it please

Reply to this Message

Haze1023 - 11 Sep 2007 19:32 GMT

Are all of your tables setup in the relationship? If they are you should be
able to select fields from multiple tables when using the report wizard.
Or you could create a query to combine all of the data into one table,
including your calculated fields and then create a report based off of the
query.
Also if you are linking the table you have 2 different field types listed
for InvoiceID, one is a number and the other is text.

> dearsir,
> how to establish relationship and normalise to get the report for the tables
[quoted text clipped - 27 lines]
> day",(sum(onhandbalence+actualquantity)),groupbyof(fuelissues),groupbyof(miscellaniousissues),closingbalence:(sum(onhandbalence+actualquantity))-(sum(fuelissues+miscellaniosissues)) In one report
> dear sir is it possible how to do it please

Reply to this Message

balu - 13 Sep 2007 14:34 GMT

im extremly sorry for wrong information please sir,
the invoice id is purely textfield
and what im expecting is the how to normalise the table relationships to get
the desired out put i mean the report .please sir kindly advise me to
establish the relationship and any further breaking up of tables necessary
and also advise me an code to open an perticular exl file on click of an
command button which can open an exl file which is in the MYdocuments ,
my email is GONALLI@GMAIL.COM
THANKS FOR YOUR KIND HELP
YOURS

> Are all of your tables setup in the relationship? If they are you should be
> able to select fields from multiple tables when using the report wizard.
[quoted text clipped - 35 lines]
> > day",(sum(onhandbalence+actualquantity)),groupbyof(fuelissues),groupbyof(miscellaniousissues),closingbalence:(sum(onhandbalence+actualquantity))-(sum(fuelissues+miscellaniosissues)) In one report
> > dear sir is it possible how to do it please

Reply to this Message