Semicolon as field delimiter in csv export SSRS report
For a new project I needed to use a csv rendered SSRS report, but the default settings were not sufficient (comma delimited). I had to do some research, but managed to get what I want: Export without headers Semicolon as field delimiter Dot as decimal separatorContinue Reading
How to give group headers or footers alternate colors in a SSRS report
Introduction I needed to create a SSRS report that only showed group headers (or footers) and still have alternate colors (every other row has another background color). Problem Normally I would use an expression like “= iif(RowNumber(Nothing) Mod 2 = 0, “Silver”, “White”)” for the ‘backgroundcolor’ property.Continue Reading
Use USB adapter for Samsung Note 10.1 as a USB host
I’ve recently bought a Samsung Connectivity kit, that included a USB adapter which I used together wit a standard USB cable to connect the Note 10.1 (GT-N8010) to my camera. After a update to Android 4.1.2 it stopped working…. My solution was to reboot the tab and that did theContinue Reading
How to connect a Samsung tablet to a monitor or beamer via the optional HDMI adapter
Introduction After some weeks using my Samsung note 10.1 I wanted to expand its possibilities and be able to transfer the screen image to my TV.Continue Reading
Passing a multiple value parameter to a query or report with data driven subscription.
Problem I sometimes would like to pass a ‘IN’ clause using a parameter, mostly when I’m using a data driven subscription (SSRS) on a report that has a multi-value parameter and can also be run interactive (via Internet Explorer) I spend hours looking for a ‘simple’ solution, only to foundContinue Reading
Dropped frames while capturing video with moviebox from Pinnacle
Introduction I have recently started converting all my VHS and Mini-DV tapes to mp4 and decided to use the Pinnacle MovieBox for this task, as it accepts firewire (Mini-DV) and S-Video / AV input (VHS).Continue Reading
Starting Tricks and Tips
This is the first post, used to try out some things for tricks-and-tips.nl. Like some styling, formatting etc. etc. I will be using this blog for sharing some things that might be handy for other people. But I have to figure out some things first. Like, how to indent textContinue Reading