hi...



i am developing a program and access is the database that i choose as backend. i am having a trouble on using the data report. i have 3 tables and all of them are linked by the employee id



table1-consist of names

table2-consist of their charges(amount)

table3-consist of their payment in charges



below is the sample query that i made to linked the 3 tables



"Select table1.*,table2.*,table3.* from (table1 INNER JOIN table2 on table1.eeid=table2.eeid) INNER JOIN table3 on table1.eeid=table3.eeid where table1.eeid="string""



i set the connection of data report on the ff:

set datareport.datasource=recordset



and i also set the datafield of the textbox inside the data report.



when i execute the program, the system doesn't give me an error but the data report show no data on every datafield.



what could be my mistake. please help...



thanks....

hi chaw12,



try to test your query and populate it in list view or data grid, if it's fine. if yes, then the problem would really be in you data report building.



i recommend you to download this program sample that deals complicated data reports like what you trying to do. link>>

Thank you for your reply Toxiod



i did what you told me and yes the query that i made also shows the data on listview. thank you also for the link. the program seems to be much interesting i still dont know to what to post at that link. can i post my topic here at that link? will it count?



i'm still trying to find out what could be my mistake.

thanks...

absolutely chaw12

Hi toxiod



i already found out my mistake in my data report and i have it running now. but there is still some question in my mind.. is it possible to create in data report where in, like i want to give the user the command to print all the names of employee at the same report and along with their names is the charges and the detailed payment history that they made? the format could be like this...



employeeName1

....charge1(let say the employee is charge amounting to $5)

.......payment1

.......payment2



employeeName2

....charge1

.......payment1

.......payment2

....charge2

.......payment1

.......payment2



hope you get what i mean...



thanks

hi chaw12,



definitely! but you have to familiar with datashaping to do that.

here's the sample program that uses that technique. link>>



toxiod

too bad i did not even know that there is a data shaping... thanks for the info.. im already searching right now.

i recommend you to download this program sample that deals complicated data reports like what you trying to doTera Online

Rift Platinum

Tera Gold

when i execute the program, the system doesn't give me an error but the data report show no data on every datafield.







roof repair

hi to all



ive already managed to get what i want on my report and thanks for the reply..