160
My company has version 6.5. For years, we have printed 3 copies of our invoices in the Shipper screen. We want to change this to 2 copies. If I pull up the report Invoice (40.680.00), on the report tab there is a 3 in the copies box. I
cannot customize it because it is a report. I don't see anything to change in the Report Control screen. Does anyone know how to change this?
Thanks.
*This post is locked for comments
I won't stop helping, but I will stop posting SQL code. I did not see your post as a criticism in any sense, but it consternated me.
I'm possibly liabile if someone cavalierly alters and executes SQL statements on production databases and can plausibly blame the results on me if things go wrong.
I'm sorry Jonathan if you took this as a criticism. I am very thankful that you posted a reply.
I looked in the system and couldn't find the table. I do not know why, but I thought this could happen to someone else. So, I wanted them to see that in my case it was in the views.
As for the code, I understand exactly why you did this. I always use a select statement before I update. Since there was only one record for this report I didn't include the last part of your statement.
Please don't stop helping people because of this. You saved me a great deal of time and research.
Well, the table is in the System database (as I wrote), and that is a view of the table. Luckily for you, it is an updatable view. The reason I included the second predicate "AND CopiesAllowed = 3" was to protect you from the possibility that this wasn't where the 3 came from. I don't think I'll post any more SQL code to this forum...
Thank you. I never would have thought to check SQL. In case anyone else sees this, the table was in the views folder and was called dbo.vs_RptControl
update dbo.vs_rptcontrol set copiesallowed='2' where ReportNbr='40680'
Thanks again.
You'll need to use SQL, and the table is in the system database.
UPDATE dbo.RptControl SET CopiesAllowed = 2
WHERE ReportNbr = '40680' AND CopiesAllowed = 3;
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (