Sage 100

Is there a way to select a default printer for a custom report on the Sage 100 menu? I created a Zebra label report, but the users need to change the printer every time.

Not sure how to do this from the front-end, but in SY_ReportSetting table there is a PrinterName field that holds the ""default"" print. Perhaps change it via DFDM?? Well...the custom reports may not be there, still looking.

Oh, yes! The custom reports are in the SY_ReportSetting table. Just open via DFDM and assign the PrinterName field.

Michelle, I tried that but it didn't work. Did I do it wrong?

Oh no! So, a valid printername didn't ""stick"" when the print screen was opened? There is also a User specific table that holds the default printer for each report. Will have to look for that one.

And now I can't place it :(

did you assign the printer within Crystal Reports???

Lourdes, I did consider that, but not sure if it would work. I would also like the printer listed to be the Zebra printer when the report is selected (if possible).

You can do this with a UI post load event (v2015+) but it requires a little DFDM trickery to make it happen. Refer to this post to see how it is done. https://90minds-com.socialcast.com/messages/39274905?ref=stream Below is the code to make the change. Change ""Export"" to your printer name. ``` sReportTitle = """" : oUIObj.GetValue ""ARG_3$"", sReportTitle If sReportTitle = ""Item Listing"" Then oUIObj.InvokeChange ""DB_Output$"", ""Export"" End If ``` Attached image shows what the record in CM_UIScriptSettings should look like. LibraryName$ and PanelName$ MUST be uppercase. This was tested on v2018.0

I forgot to mention that ARG_3$ contains the report's title and is what I used to limit the setting of the printer to a report with the title of ""Item Listing"".

Also, ARG_2$ (crystal report file name) is another variable you could use to evaluate against.