I designed MS CRM Reports using "SQL Server BI development Studio", and define the report size. Everything's fine until, one day, a user reported the report (label) size changed to a much larger size, and the label printer printed out 3 pages, including 2 blank pages. The user had to change the report's size everytime.
Users use Windows RDP service, everyone actually works on the same server. I tested in my session, and everything's fine.
When MS CRM print out report, it should setup printer for the pre-defined size, so, this error mad nosense. I checked all related setting on the user, no clue.
Finally, I noticed that the user and me had different printer as "default printer". I change the user's default printer to mine, suddenly, problem solved.
I have no ideas how it happen, and why it had be solved, just as a reminder.
This is an interested case to show that MS Windows are full of out-of-mind bugs.
Tuesday, October 27, 2015
Wednesday, July 8, 2015
MS CRM 2013 could not print report after windows upgrade from 2008 to 2012
Recently, company upgraded RDP server from windows 2008 R2 to 2012 R2, and user reported one problem on MS CRM 2013.
After upgrade, our CRM system - Microsoft CRM 2013 on premises - could not print report. Normal users will pop up window for username and password. It looked simple: put in administrator's username and password could work. MS SQL Server reporting service needs administrator privilege to download and install ActiveX component for the printing feature.
In Windows 2008, it happened, and after input administrator username and password, everything's fine. But, in windows 2012, it will show "Printing is not available. Verify that ActiveX is enabled, or try using Internet Explorer for the desktop".
Then, I logined RDP server as an administrator, BUT, I still got this error. After Internet search, I still could not fix it. Only useful info is about IE security setting for ActiveX. I confirmed all related ActiveX options are "Enabled", but not luck. I tried many ways, still not luck.
After a day, I thought that it works on windows 2008, but not 2012, it means, some security setting has changed on 2012. So, I tried RUN IE AS ADMINISTRATOR, then, it works. After installed the activeX component, all user could print reports from CRM system.
After upgrade, our CRM system - Microsoft CRM 2013 on premises - could not print report. Normal users will pop up window for username and password. It looked simple: put in administrator's username and password could work. MS SQL Server reporting service needs administrator privilege to download and install ActiveX component for the printing feature.
In Windows 2008, it happened, and after input administrator username and password, everything's fine. But, in windows 2012, it will show "Printing is not available. Verify that ActiveX is enabled, or try using Internet Explorer for the desktop".
Then, I logined RDP server as an administrator, BUT, I still got this error. After Internet search, I still could not fix it. Only useful info is about IE security setting for ActiveX. I confirmed all related ActiveX options are "Enabled", but not luck. I tried many ways, still not luck.
After a day, I thought that it works on windows 2008, but not 2012, it means, some security setting has changed on 2012. So, I tried RUN IE AS ADMINISTRATOR, then, it works. After installed the activeX component, all user could print reports from CRM system.
Subscribe to:
Posts (Atom)