I'm having trouble designing a report based on a set. The problem is extra rows populating the report.
Set structure has a parent with for children linked on the key, transno.
The last child is linked on the key, WO_NO.
All links are one to many.
Parent
|===child1
|===child2
|===child3
|===child4
|
|===child5
My intention is to have a report with the totals of the work order summarized and displayed as one line. Following that line will be any and all invoices against that one work order.
There may be no invoices, one invoice or three or more invoices against that one work order.
The parent and the first four child tables are summarized and displayed in the work order header. This works fine.
The Parent child5 relation is in the detail section. This works, however; I have a random number of rows with a zero displayed before I get to valid data.
I do realize that this is related to the set structure, but I can't figure out my way around this. I've attached a sample of a page from the report. The work order number is the six digit number beginning with 0. The invoices are the six digit numbers preceded with an M. What I would like to do is to eliminate all the blank rows with a 0.00. The zero's are being generated by the calculated field which totals the columns of the Invoice.
Then again, maybe I can not do it this way. I've been thinking about tmp tables, etc.., but I was hoping that I could do this with existing tables.
Any suggestions would be welcomed.
Thank you,
Ron
Set structure has a parent with for children linked on the key, transno.
The last child is linked on the key, WO_NO.
All links are one to many.
Parent
|===child1
|===child2
|===child3
|===child4
|
|===child5
My intention is to have a report with the totals of the work order summarized and displayed as one line. Following that line will be any and all invoices against that one work order.
There may be no invoices, one invoice or three or more invoices against that one work order.
The parent and the first four child tables are summarized and displayed in the work order header. This works fine.
The Parent child5 relation is in the detail section. This works, however; I have a random number of rows with a zero displayed before I get to valid data.
I do realize that this is related to the set structure, but I can't figure out my way around this. I've attached a sample of a page from the report. The work order number is the six digit number beginning with 0. The invoices are the six digit numbers preceded with an M. What I would like to do is to eliminate all the blank rows with a 0.00. The zero's are being generated by the calculated field which totals the columns of the Invoice.
Then again, maybe I can not do it this way. I've been thinking about tmp tables, etc.., but I was hoping that I could do this with existing tables.
Any suggestions would be welcomed.
Thank you,
Ron
Comment