Hello All,
I�m am working with a set with two one to many links.
I have a client who wants a report printed out in the �green bar� format, where every other line item is shaded. This is no problem, but there is a twist. The client wants the �green bar� effect even if there are no records. They use the report to write on and want some sort of �lines� on the report to make it easier to write on. I can put a graphic (frame etc.) on the report to provide the line effect, but this reeks havoc with the report if there are records. If records exist, they �push� the graphics around and make the report a mess. I�ve tried using a bitmap background but this doesn�t work as the effect needs to carry through different report sections. I�ve thought about creating a series of calc fields that lookup to the children records and either print the child record or a �green bar�. This doesn�t sound like a great idea to me. Short of creating a dummy table and populating it with at least a set number of child records for each parent, (which I don�t want to do very bad) does anyone have any ideas how to approach this? At first blush, this doesn�t sound like it should be any big deal to do, but I�d hate to tell you how many hours I�ve spent bumping my head against the alpha wall !
Thanks,
Jim
I�m am working with a set with two one to many links.
I have a client who wants a report printed out in the �green bar� format, where every other line item is shaded. This is no problem, but there is a twist. The client wants the �green bar� effect even if there are no records. They use the report to write on and want some sort of �lines� on the report to make it easier to write on. I can put a graphic (frame etc.) on the report to provide the line effect, but this reeks havoc with the report if there are records. If records exist, they �push� the graphics around and make the report a mess. I�ve tried using a bitmap background but this doesn�t work as the effect needs to carry through different report sections. I�ve thought about creating a series of calc fields that lookup to the children records and either print the child record or a �green bar�. This doesn�t sound like a great idea to me. Short of creating a dummy table and populating it with at least a set number of child records for each parent, (which I don�t want to do very bad) does anyone have any ideas how to approach this? At first blush, this doesn�t sound like it should be any big deal to do, but I�d hate to tell you how many hours I�ve spent bumping my head against the alpha wall !
Thanks,
Jim
Comment