TBSupport
asked on
Stored Procedures Controlling Printing
Hello:
The first attached stored procedure places asterisks on a Crystal Web Viewer report called the Bill of Lading. These asterisks display, when the report is printed.
The second stored procedure controls the reprint of this bill of lading.
The final attached document is programming for a table called EPBLRPT.
The asterisks are not supposed to print if you reprint the report. It seems to me that this is probably based on the data in the EPBLRPT report. But, the only record in this table is one that is dated 03/09/2015.
Can someone please examine this programming and determine if there is a way to prevent the asterisks from displaying , when the report is printed more than once?
Thank you! Much appreciated!
TBSupport
sp-EP-BillOfLading.docx
sp-EP-BillOfLadingByReqShipDate-Reprint.
EPBLRPT.docx
The first attached stored procedure places asterisks on a Crystal Web Viewer report called the Bill of Lading. These asterisks display, when the report is printed.
The second stored procedure controls the reprint of this bill of lading.
The final attached document is programming for a table called EPBLRPT.
The asterisks are not supposed to print if you reprint the report. It seems to me that this is probably based on the data in the EPBLRPT report. But, the only record in this table is one that is dated 03/09/2015.
Can someone please examine this programming and determine if there is a way to prevent the asterisks from displaying , when the report is printed more than once?
Thank you! Much appreciated!
TBSupport
sp-EP-BillOfLading.docx
sp-EP-BillOfLadingByReqShipDate-Reprint.
EPBLRPT.docx
ASKER
Hi mlmcc:
No, I don't know if it's a second print. But, since one of the stored procedures has the title "reprint" in it, I would think that there's a way to do it.
TBSupport
No, I don't know if it's a second print. But, since one of the stored procedures has the title "reprint" in it, I would think that there's a way to do it.
TBSupport
My thought was you could add a parameter to the SP that does the printing and test it before you add the ***** to the field. Add ***** on first print and ' ' on subsequent prints.
mlmcc
mlmcc
ASKER
Hi mlmcc:
What would be the syntax, for this parameter?
TBSupport
What would be the syntax, for this parameter?
TBSupport
You're talking about '*****'+orders.SOPNUMBE , correct? Just making sure.
The logic there has no obvious connection to reprinting. It's just looking at orders.REQSHIPDATE. The only connection would be if REQSHIPDATE was set to 1/1/1900 when (or after) the order was printed. If that's the intent, then I guess the question would be, why isn't REQSHIPDATE being changed? That might be the first thing to look at.
It makes sense that EPBLRPT only contains one record, since the reprint SP can only use one value from that table. I would assume that when you request a reprint, you ask for a specific date, and the program/whatever is supposed to put that date in EPBLRPT. The 03/09/2015 date that you mentioned would presumably be the last date that someone asked to reprint.
Adding a "reprint" parameter to sp_EP_BillOfLading might be an option, but anything that uses sp_EP_BillOfLading might need to be changed, to accommodate the new parameter.
Another option would be to change how you use the @shopOrder parameter. The advantage to that is that it won't affect anything else that uses sp_EP_BillOfLading, because the parameters won't change. The reprint SP sets @shopOrder to null, which tells the main SP to include every SOPNUMBE (the main SP replaces the null with '%', and uses that in a Like comparison). Since the reprint SP is not using @shopOrder to send specific values to the main SP, we can use it for something else.
You could change the reprint SP to set @shopOrder to 'reprint' (or some unique value, if SOPNUMBE could actually be "reprint"). Add a @reprint variable to the main SP, which it would set to 'Y' if @shopOrder = 'reprint'. Then @shopOrder could be set to '%' (just like when it's null). You'd use the @reprint variable to decide whether or not to include the "*"s. Or, now that I think about it, you could forget the @reprint variable and just use @shopOrder. You'd just need to change the Where to recognize that 'reprint' meant "include all SOPNUMBE values" (ie. it's the same as '%').
If that sounds good, but you need some help with the code, just let me know.
James
The logic there has no obvious connection to reprinting. It's just looking at orders.REQSHIPDATE. The only connection would be if REQSHIPDATE was set to 1/1/1900 when (or after) the order was printed. If that's the intent, then I guess the question would be, why isn't REQSHIPDATE being changed? That might be the first thing to look at.
It makes sense that EPBLRPT only contains one record, since the reprint SP can only use one value from that table. I would assume that when you request a reprint, you ask for a specific date, and the program/whatever is supposed to put that date in EPBLRPT. The 03/09/2015 date that you mentioned would presumably be the last date that someone asked to reprint.
Adding a "reprint" parameter to sp_EP_BillOfLading might be an option, but anything that uses sp_EP_BillOfLading might need to be changed, to accommodate the new parameter.
Another option would be to change how you use the @shopOrder parameter. The advantage to that is that it won't affect anything else that uses sp_EP_BillOfLading, because the parameters won't change. The reprint SP sets @shopOrder to null, which tells the main SP to include every SOPNUMBE (the main SP replaces the null with '%', and uses that in a Like comparison). Since the reprint SP is not using @shopOrder to send specific values to the main SP, we can use it for something else.
You could change the reprint SP to set @shopOrder to 'reprint' (or some unique value, if SOPNUMBE could actually be "reprint"). Add a @reprint variable to the main SP, which it would set to 'Y' if @shopOrder = 'reprint'. Then @shopOrder could be set to '%' (just like when it's null). You'd use the @reprint variable to decide whether or not to include the "*"s. Or, now that I think about it, you could forget the @reprint variable and just use @shopOrder. You'd just need to change the Where to recognize that 'reprint' meant "include all SOPNUMBE values" (ie. it's the same as '%').
If that sounds good, but you need some help with the code, just let me know.
James
ASKER
Hi James:
Thanks, for your great insights!
Yes, if there's anyway that you could help with the reprint syntax, that would be wonderful! Anything that you could provide would be helpful!
TBSupport
Thanks, for your great insights!
Yes, if there's anyway that you could help with the reprint syntax, that would be wonderful! Anything that you could provide would be helpful!
TBSupport
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
If not then I can't think of a way to do it.
mlmcc