I need to make a quotation report which will need to bring in different subForms/Reports. The problem I have is that if the content of the subform is longer that the area allocated it truncates the rest of the SubReport, or if its shorter it leaves a whopping great white space between Sub components.
I have....
tbl-QuoteDetails - this holds the details for the customer - Quote#, name, address etc
tbl-Quoteparts - this holds the parts that were sold to the Customer - this has a field "type" which seperates the type of part into categories.
tbl-Installation - this holds the Installation details for each Part category in tbl-QuoteParts
As there are different fields used for each category, and the order of each part category in interspersed with the Installion detail, I need to use a different Subform for each category in each of the tbl-QuoteParts & tbl-Installation
I need to be able to have a quotation show all of the records for all of the SubForms without truncation and without huge spaces between subForms/Reports
Any thoughts? Thanks.