[Cross-posted from the Memberships forum, at the suggestion of a Community Manager. Original post here.]
At the Met Museum, when a customer buys a membership on site, we print their membership card for them immediately, but we have been having some technical challenges recently and I'm curious about what other organizations are doing.
If you're printing cards on site:
Those are the main questions, but I'll describe what I'm dealing with here in case it's relevant for anybody:
The current process at the Met uses an SSRS report configured as a Constituent Report, and it gets printed to a printer that has multiple hoppers for different card stock for different membership levels. (The printer is a CD800, if you're keeping score at home.) The hopper gets selected using escape codes included in the report. We ran into a problem over the summer when we upgraded our report servers from SSRS 2012 to SSRS 2019 -- the new version required the report to be exported to PDF and printed from there, which added an annoying extra step, and for some reason the escape codes for hopper selection stopped working. So we kept a 2012 server running just for this one report, and that was fine until an automatic Windows update was applied this past Monday night, which removed ActiveX. SSRS 2012 uses ActiveX for printing, and this update removed the print button from the interface. We are currently investigating our options, and finding out what other organizations are doing is part of that investigation.
Thank you for any info that you can provide!