Andrus Development

Interesting programming ideas, solutions, and logic that I have used to solve problems or have come across throughout my career.

Thursday, June 02, 2016

0.00000000000 as Text Error when exporting to Excel from SSRS.

›
Just a quick tip/fix for this problem. When exporting a report to excel, sometimes you'll end up getting a long text version of the ...
Wednesday, August 05, 2015

Running specialized CSV in SSRS with different device settings.

›
So this will be useful if you want to change the default settings for a single report, and not all reports, that are exported to CSV. An ex...
Thursday, June 11, 2015

Mocking a user

›
After lots of searching and testing, I finally ended up with piece of code to mock a user for unit testing. this .Principa...
Tuesday, June 09, 2015

Find a field in SQL Server database

›
Sometimes you need to find a field and don't know what table or view it might be coming from. A very useful script to pull out: SEL...

Search for fields on ReportServer

›
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 4...
Sunday, November 09, 2014

Powershell Profile Setup and Resize script on startup

›
1)Setup your profile for powershell:  if (!(test-path $profile )) {new-item -type file -path $profile -force} 2)Open up the profile: ...
Thursday, October 23, 2014

SSRS: Setting a value dynamically for an unknown count of distinct values -- AND -- having a legend outside of a chart

›
One of the tricks that I do, is removing the legend out of charts into a table. To do this, I need to explicitly set the colors and/or mar...

Change Username for ClaimsIdentity in C#

›
I needed a way to change the authentication's username in a website. This basically applies the change, and then signs the user out, ch...
Tuesday, October 21, 2014

Optimizing SSRS Rendering and Performance

›
I often run into the situation of SSRS taking too long to render or a long delay before processing starts. Here are 3 links provided by Mic...
Saturday, October 11, 2014

Somewhat Dynamic Pivot in C#

›
I started working on a dynamic pivot to be used in Kendo UI, where the user could select the datapoints to be shown in the graph. Didn'...
1 comment:
›
Home
View web version

About Me

My photo
William Andrus
Northglenn, Colorado, United States
I'm primarily a BI Developer on the Microsoft stack. I do sometimes touch upon other Microsoft stacks ( web development, application development, and sql server development).
View my complete profile
Powered by Blogger.