I have developed a Quote application where the client can ask for a quote for a product with respect for a specific quantity (max of 6 quantities). In other words the client may ask for a quote on say 2000 units, 3000 units etc upto a maximium of 6 quantities.
The quote request is entered into a single reord that has the format
ProductName, Quantity 1, Quantity 1 Price, Quantity 2, Quantity 2 Price, ...., Quantity 6, Quantity Price 6
All quantity and quantity price fields are initially set to zero so if the client only asks for a quote on two quantities then Quantity 1, Quantity Price 1, Quantity 2, Quantity Price 2 will be filled in while Quantities 3 to 6 and Quantity 3 to 6 Prices will still contain zero.
The quote report has the following format in the Detail section
Quantity 1 Quantity 1 Price
Quantity 2 Quantity 2 Price
Quantity 3 Quantity 3 Price
Quantity 4 Quantity 4 Price
Quantity 5 Quantity 5 Price
Quantity 6 Quantity 6 Price
If a quantity is zero I basically set that quantity and its corresponding price to blank so it doesn't appear on the report.
My question is - How can I get the rest of the report in the details section following the Quantity , Quantity Price details to move up and occupy the space if the Quantity and Quantity Price is zero (blank).
So for example if the customer has only requested a quote for two quantities then the lines for Quantities/Quantity Prices 3 to 6 are to be ignored and the On Cost details would now occupy the Quantity/Quantity Price 3 line.
Can I use the On Format property of the Detail section to somehow flag a line to indicate that it is not needed so as to allow the Can Grow/Can Shrink properties to take effect.