Hi William,

If I understand you correctly, if you want to print 2 separate tables, you can add details band 2 times, and apply filter to each of them. For example, first filter will be something like [Description] = 'rush' and second one [Description] != 'rush'.

As for the amount, probably you use incorrect variable. Please check to which field that label is bound. If it is bound to Amount of the QuoteItems table, then it will show amount of the first row. You have to bind it to Amount field of the quote itself.

If still struggle, you can export your template and I will point out to issues.

Hi William,

If I understand you correctly, if you want to print 2 separate tables, you can add details band 2 times, and apply filter to each of them. For example, first filter will be something like [Description] = 'rush' and second one [Description] != 'rush'.

As for the amount, probably you use incorrect variable. Please check to which field that label is bound. If it is bound to Amount of the QuoteItems table, then it will show amount of the first row. You have to bind it to Amount field of the quote itself.

If still struggle, you can export your template and I will point out to issues.

Hi Eugene,

Thanks for delving into this.   At present, I am using two separate quotes on two different reports, with reference in each quote to the other option.  This "gets it done" for the moment.  Both options on one sheet would preclude the possibility of a client missing a rush option, but it would also mean changing the delivery time, which is on the general quote template and not within the quote item.  The rush delivery would be sooner at a higher price.

I am not sure I understand "first filter will be something like [Description] = 'rush' and second one [Description] != 'rush'.  Is the exclamation point a typo or does it have a special meaning within the database?

BTW, would a general tutorial on SQL help, such as www.programiz.com/.../database-introduction