SSRS – Get date parameter as end of day

I’ve built a report within SQL Services Reporting Services 2005 (SSRS) that pulls its data based on a date range, chosen through start and end date parameters.

The problem is, if on those parameters I choose April 21st, it’s actually choosing April 21: 00:00. This means if there’s any data that is relevant during the day on April 21st, it wouldn’t be selected.

I needed a way to have my user select April 21st, but have it return values for end of day April 21st. The solution actually proved easier than I originally thought, as I was making it too complicated.

Full credit to Samson Loo who posted about this (outside of SSRS) here:


My dataset and linked functions all reference the parameter @EndDate, so I didn’t want to go through and change all of that.

Instead, I created a new report parameter called @EndDateEOD, and set its properties to what @EndDate originally was.

Parameter for EndDateEOD

I made sure to place this new parameter above my existing @EndDate.

Then I modified @EndDate to make it hidden, and set this as the default value:



This is adding one day to what the user selects. At first glance this seems like it would produce incorrect information, however in reality, if a user selects April 21st (in reality April 21 00:00:00), then this will use the date April 22 00:00:00 in the dataset, which is what we want.

Searching folder across VPN produces no results

I came across an issue where a user on Windows XP was using Windows Explorer to search within a folder located in a branch office across a VPN. However, their search produced no results, even when it was confirmed there should be.

After some digging I found a Microsoft hotfix that fixed this, but it wasn’t easy to find so hopefully this post may help others find it sooner.

The hotfix is available from this article:


When you run a search for files or for folders across a slow network link in Microsoft Windows Server 2003 or in Microsoft Windows XP, the search result set is empty. This symptom occurs even though the files or the folders in question actually exist. Additionally, you receive the following message:

"Search is complete. There are no results to display."

For example, you may experience this problem when you search a remote mapped drive over a wide area network (WAN) link.


BigBlueButtonA quick review of BigBlueButton, and how I customized it for our corporate purposes.


I’ve been looking for a good web conference and desktop sharing application for a while now. We used to use DimDim, until it got bought out by Salesforce and shutdown.

I briefly used Mikogo, and really liked its scheduling features. However, the performance was poor and it was limited to 10 attendees. Also, it didn’t provide audio or video functionality. This wasn’t a deal breaker, however it sucks to have to use multiple tools for related purposes.

I finally stumbled upon BigBlueButton. This is an open source project originally designed for Academia; it is very feature rich and was relatively easy to set up (for an open source project). One of its most attractive features to me is the fact that it sits in my LAN, instead of a provided service. Since we’ll be using this to communicate between departments and branch offices, the latency is MUCH lower across our VPN’s rather than to an outside service. This gives much better performance than anything we’ve tried yet.

Some of the things it does, and we’ll be using it for:

  • Multiple meeting rooms for separate groups of users
  • Document sharing and whiteboard
  • Audio & video conferencing
  • Public and private chat
  • Desktop sharing (full screen or region)

I set up my environment from the VMware image, but I’ll be trying to convert that vmdk to a VHD for Hyper-V soon so it can run in my Hyper-V cluster.

I only ran into a couple problems (audio application freeswitch didn’t install correctly) but the documentation wiki was very helpful in getting those problems resolved. Overall the support resources are excellent.


My first real issue with BigBlueButton (and the ultimate reason for this blog post) was that the default installation is very “demo” oriented. This is what the default screen appears like:


The obvious problem with this screen is that it seems “temporary”, unfinished and unsuited for our organization. It is targeted at someone like myself, who is interested in the latest features and the API examples.

However, I needed a default interface that made it simple for my users to join a meeting room, with a clean looking page and helpful information. Here’s what I’ve ended up with:

Customized company portal for virtual boardrooms

Other than the obvious cosmetic changes, the primary changes I’ve made showing a list of meeting rooms available, and displaying those currently in a meeting. The code for these two features comes from two of the demo.jsp pages provided with BigBlueButton.
On your site you can find them by navigating to http://yoursite/bigbluebutton/demo/demo2.jsp.

These jsp files are located at var/lib/tomcat6/webapps/bigbluebutton/demo

These are the demo page purposes:

  • Demo2.jsp – Join a selected course from a list
  • Demo3.jsp – Join a course from a list with a password
  • Demo4.jsp – Activity monitor

The index page that needs to be modified is located here: /var/www/bigbluebutton-default/index.html

To redesign my index.html page I took the form from demo2.jsp, and inserted it into the “Join” div; I then copied the demo4.jsp page, stripped out the header and extra content, and then made an iframe on my index.html to point to this new .jsp page.

I then added a bit of text as a description for my users, in an collapsible div for a clean look, and modified the design of the page to fit our company design.

Update: here’s the actual code behind the index.html file:

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "">
<html xmlns="">
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
<title>BigBlueButton -- Open Source Web Conferencing</title>
<link rel="stylesheet" href="css/style.css" type="text/css" />
<script type="text/javascript">
        function autoFocus() {
<script language="javascript">
             function toggleDiv(divid) {
                 if (document.getElementById(divid).style.display == 'none') {
                     document.getElementById(divid).style.display = 'block';
                 } else {
                     document.getElementById(divid).style.display = 'none';
<body onload="autoFocus();" class="nobackground">
        <div id="login"> 
        	<h1 class="logo"> 
            	<a href="">Login Page</a> 
            <h1 class="loginheading">Virtual Boardrooms</h2> 
             <div id="login-form">
                    <p><a class="speciallink" href="javascript:;" onmousedown="toggleDiv('description');">Click twice to expand introduction</a></p>
                    <div id="description">
                        <p>Using BigBlueButton, we have set up a central site to provide web conferencing access.  This is primarily used for:</p>
                            <p> - Document & whiteboard sharing<br />
                             - Presenting what is on the screen to attendees<br />
                             - One-to-many audio conference (ie: a single presenter with limited audience interaction)</p>
                        <p>This tool is not as effective for video and audio conferencing together, as they typically aren't synchronized together. A future version of BigBlueButton is addressing this problem, so in the future this may be the only tool we need.</p>
                        <p>To facilitate video conferencing, we recommend you use the video conferencing information on the wiki <a href="http://wiki/resources/virtual_boardrooms">here</a>.</p>
					<div id="join">
					    <h2>Join a Meeting Room</h2>
                            <FORM NAME="form1" METHOD="GET" action="/bigbluebutton/demo/demo2.jsp">
                                <p>Enter your name:</p>
                                <input type="text" id="username"  name="username" size="29" /><br /><br />
						        <p>Select a meeting room:</p>
						        <select name="meetingID">
				                    <option value="BrownBag">Brown Bag Sessions</option>
				                    <option value="BusDev">Business Development</option>
				                    <option value="Geomatics">Engineering</option>
				                    <option value="Geomatics">Geomatics</option>
				                    <option value="General">General</option>
						        <input type="submit" value="Join"/> 
                                <input TYPE="hidden" NAME="action" VALUE="create">
				        <br /><br />
						<p>For <b>multi-party video conferencing</b>, you can use this <a href="http://vbr/mpvideo.html">virtual boardroom</a>.
					    <p>If you have a regularly scheduled meeting and would like a specific virtual boardroom added, please email <a href="mailto:"> Jeff Miles</a></p>
					    <br />
					    <p>For a tutorial on using certain features of this tool, <a href="">click here</a></p>
		           <div id="currentactivity">
                        <h2>Current Activity</h2>
                        <iframe src="http://vbr/bigbluebutton/demo/activity.jsp" width="490" height="400" frameborder="0" scrolling="no" />		
        <div id="footer">
                        <div id="footCenter">
                        <p>Copyright © 2010 <a href="">BigBlueButton Inc.</a></p></div>
                </div><!--end footer-->

I haven’t modified the actual BBB client, as this requires recompiling the swf files. It’s pretty brand neutral as it is, so I don’t think I’ll be doing anything there.


Overall the performance of BigBlueButton has been great. Document and screen sharing is crisp and smooth, and the video looks great. This is something we’re going to begin using immediately, especially since it is leagues ahead of other tools in features and performance.

My only complaint, and it is a deal breaker for certain uses, is that the audio and video don’t sync up. The audio is typically 2-3 seconds behind the video, which makes it unusable for video conferencing. For now we will be using the opentok basic embed to facilitate video conferencing.

I have heard from the mailing list that version .80 will have a different method of providing audio, one that doesn’t have the lag the current version does. Once this is released we will be trying that out and hopefully dumping opentok and use BigBlueButton exclusively.

Reset AutoCAD in a Windows profile to default

Occasionally I’ll come across an obscure AutoCAD problem that is only occurring for one particular user. I would have narrowed down the issue to conclude:

  • It doesn’t occur on a different computer with the same drawing
  • It doesn’t occur on the same computer with a different user and the same drawing
  • It does occur with the same user and a different drawing
  • It also continues to occur after changing profiles within AutoCAD

First some definitions just for clarification (perhaps there is better terminology out there, but I can’t think of it):

AutoCAD Profile: Profiles within AutoCAD that are accessible through the OPTIONS command

AutoCAD Windows Profile: Set of files, folders and registry entries for a single Windows user that contain all AutoCAD settings for that particular user


Based on the conclusions and definitions above, it is much easier to reset the AutoCAD Windows Profile back to defaults rather than try to find a solution, unless you know the command/variable that is causing your problem.

It should go without saying, this will remove any customizations you have made, including additional CUI files, PC3 files and tool palettes.
To do so:

  1. Navigate to: “%appdata%\Autodesk”
  2. For the Autodesk product with which you are having a problem, append the word “OLD” to that folder
  3. Navigate to “%localappdata%\Autodesk”
  4. For the Autodesk product with which you are having a problem, append the word “OLD” to that folder
  5. Open Regedit
  6. Navigate to HKCU\Software\Autodesk\AutoCAD\
  7. If you have more than one AutoCAD product, you’ll see a variety of R1x.x numbers. These correspond to different AutoCAD releases, with the major number incrementing when a new DWG format is released. For a specific list, see here:
  8. Expand the version you’re concerned with, and you will see a key for each product within that release. For example:
  9. Right click on that key, and choose Export. Save this as a backup in case something goes wrong.
  10. Now delete that key that you just exported.


Now when you start AutoCAD as that user, it will rebuild the AutoCAD Windows Profile from default.


SSRS – Multi Value parameter in Linked Report

I had been trying to get a multi valued parameter into a linked report for the longest time, and when running the report all I would get was an error, “The %variable% is missing a value”.

I just couldn’t figure it out, but it was just me being dumb. The answer is really quite simple:


I was trying to enter my values like this:

value1, value2, value 3


But what you need to do is enter them separately on a different line:


Then SSRS will make a comma delimited list of them for you.