The Wayward Programmer

I was attempting to set up an email subscription on our production server the other day but kept getting errors when the subscription ran. The development server subscriptions ran fine, the configuration settings for both servers appeared identical. The weird thing was that I could send a subscription through email as long as I didn't attach the report. After much searching, and pulling out my hair, I finally found this KB article: A call to the "AuthzInitializeContextFromSid" API function fails during the delivery of an e-mail subscription in SQL Server Reporting Services My hint was the error in the error log: ERROR: Throwing Microsoft.ReportingServices. Diagnostics. Utilities. ServerConfigurationErrorException: The Report Server has encountered a configuration error; more details in the log files, AuthzInitializeContextFromSid: Win32 error: 5; possible reason - service account doesn't have rights to check domain user SIDs.; KB article 842423 walks yo...

For Visual Stuido 2005: Select the whole row, open the "Properties" pane. In the Background property click the drop down box and select "Expression". In the pop up box, copy/paste the =IIF(...) statement. Click OK. Alternate the row color for Detail Lines: =IIF(RowNumber(Nothing) Mod 2, "#eeeeee", "#ffffff") Group Rows Alter row color: ("PO_NUM.Value" is the field that is being grouped on) =iif(RunningValue(Fields!PO_NUM.Value,CountDistinct,Nothing) Mod 2, "#eeeeee", "#ffffff") Alter text color dynamically: 1. Left-click the row and column that you’d like to have dynamicly formatted. 2. Go to Properties Pane and select the drop-down box under Color in the Appearance group. Select the "Expression" option. 3. Replace the word Black (which is the default) with one of the following text and click OK. =iif(Fields!JobStatus.Value = "Failed", "Red", "Black") Same wi...