I have been playing with the quoting process to see if I can put two options in one quote form, a standard delivery and a rush delivery. I currently have to add the rush delivery as a note. I would prefer to have two tables, with each table with a total for the standard and rush delivery.
I tried listing both options together as a starting point and received the following print out:
I don't know why the quote total was only USD 4,800 and not USD 10,400.
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
Translate
