Hey folks,
I haven't posted in a while so I maybe rusty. I am looking to create a Report in the following format:
Project# Descrip Client Name Value Billed Unbilled
1234 Test ABC Co. $100 $50 $50
Invoice# InvDate AmtInv
1 Jan 01 $25
2 Jan 10 $25
5678 Sample DEF Co. $1000 $250 $750
Invoice# InvDate AmtInv
3 Jan 01 $250
4 Jan 10 $750
So essentially, I will multiple projects and under each project I will have to create a subreport(I guess) for the invoices on these projects. I am wondering is this just a matter of adding a subreport to the "Detail" section of my report. I cannot figure out how to set it up so that after each project # will display the invoices. I have two tables. One will all the project data and one with all the invoices. And both are linked via the project #. I did setup a one to many relationship but that don't seem to work. Any suggestions would be great.
Thank you,
Great site!
________
chevrolet cobalt specifications
I haven't posted in a while so I maybe rusty. I am looking to create a Report in the following format:
Project# Descrip Client Name Value Billed Unbilled
1234 Test ABC Co. $100 $50 $50
Invoice# InvDate AmtInv
1 Jan 01 $25
2 Jan 10 $25
5678 Sample DEF Co. $1000 $250 $750
Invoice# InvDate AmtInv
3 Jan 01 $250
4 Jan 10 $750
So essentially, I will multiple projects and under each project I will have to create a subreport(I guess) for the invoices on these projects. I am wondering is this just a matter of adding a subreport to the "Detail" section of my report. I cannot figure out how to set it up so that after each project # will display the invoices. I have two tables. One will all the project data and one with all the invoices. And both are linked via the project #. I did setup a one to many relationship but that don't seem to work. Any suggestions would be great.
Thank you,
Great site!
________
chevrolet cobalt specifications
Last edited: