Direction to take on Report/Subreport (1 Viewer)

durdle

Registered User.
Local time
Today, 15:20
Joined
May 7, 2002
Messages
130
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
 
Last edited:

Simon_MT

Registered User.
Local time
Today, 15:20
Joined
Feb 26, 2007
Messages
2,177
I hardly ever use subreports, instead start from the bottom up. Providing there is a relationship you add the high level to the lower level in the Query.

At times even cheat with Forms, put the higher level in the Header!

Simon
 

Users who are viewing this thread

Top Bottom