March 2012 – Page 2 – James Software Development Corner

SQL Server Reporting Services (SSRS) – When to use OUTER APPLY instead of LEFT OUTER JOIN for complex SQL Statements

Scenario:

You create a report. You have one parameter called ‘CITY’ which contains all valid cities in the state of Florida. This parameter is used to report on all citizens that live in a particular city.

You have two tables.…

SQL Server Reporting Services (SSRS) – How to remove the first character of a multi valued report parameter when displaying the parameter in a textbox

There are times when you want to display in a textbox on your report the value of a multi valued parameter. If blank is a valid value for your parameter, you don’t want to display the comma in your textbox …

Silverlight – Silverlight plugin installed but not recognized as installed

This issue relates to Internet Explorer only. This problem does not affect Chrome or Firefox.

First, try this:

http://support.microsoft.com/kb/2608523

If that does not work or you get an error stating permission issues with AgControl.AgControl, then try this:

1. Run regedit …

Internet Explorer 9 – How to implement Adblock

Adblock is available for Internet Explorer 9 to block unwanted advertisement banners.

Install the extension by clicking the link below:

http://simple-adblock.com/faq/internet-explorer-9/

…

Firefox – How to implement New Tab Homepage redirect

In order to redirect to your home page or URL of your choice, you can install the New TabHomepage extension.

Install the extension by clicking the link below:

https://addons.mozilla.org/en-US/firefox/addon/new-tab-homepage/

After installing, modify the extension to point to your URL. For

…

Firefox- How to implement Adblock

Adblock is available for Firefox to block unwanted advertisement banners.

Install the extension by clicking the link below:

https://addons.mozilla.org/en-US/firefox/addon/adblock-plus/

…

Google Chrome – How to implement Adblock

Adblock is available for Google Chrome to block unwanted advertisement banners.

Install the extension by clicking the link below:

www.chromeadblock.com

…

Google Chrome – How to implement New Tab redirect

The latest version of Google Chrome does not all for you redirect to your home page when clicking a new tab. You can get this feature by adding the old extension for making the new tab redirect to a URL …

Flash CS5.5 and AS3 – How to save local data to a Flash Shared Object (Flash Cookie)

Create a shared object (Flash Cookie) in Flash to save data for later retrieval. These shared objects are saved with a SOL file extension.

Here are two ways you can find them.

Run the ‘Analyze’ feature of ‘CCleaner’ (You …

Flash CS5.5 and AS3 – Giving keyboard focus to an embedded Flash movie

Add to the beginning of the <body> tag, the onload event handler for your flash object. When the page is produced in the browser, the focus should now be on the flash object.

<body onload="window.document.someflashfile.focus();">
        <div id="flashContent">
            <object

…