August 2017 – James Software Development Corner

Microsoft Visual Studio – Debugging doesn’t start

There have been many suggestions to get this working. I will give you three that worked for me in the order they should be tried.

Restart your computer. Some of the projects files run in the background. Stop them if

… Read the rest

SQL Server Reporting Services (SSRS) – How to Hide Columns When Exporting to CSV

You can suppress elements that you don’t want to include in a CSV export by doing the following:

Click an element.
In the properties windows, Choose “NoOutput” in the DataElement Output property.

Please follow and like us:

… Read the rest

Google Chrome – MailTo Handler Doesn’t Work in Google Chrome

Add missing protocol mail handler in chrome settings manually in order to for a gmail compose window to appear when clicking a mailto:xxxxxxx@xxxxx.com link on a web site.

Google Chrome

1) Click Settings

2) Scroll to the bottom and

… Read the rest

SQL Server Management Studio – Order by different columns based on values in the different columns

Wrap your head around this one!

Here is an example of an order by in a SQL Statement that shows how specific you can get when ordering your data.

order by location_3,
case 
 when location_3 ='c' then
 case 
 when location_4

… Read the rest

SQL Server Reporting Services (SSRS) – Order by different values from the same database table column

Let’s say you want to order your data in your tablix by last name, but you want certain names to be sorted first.

1) Double click the first grouping under Row Groups.
2) Select ‘Sorting’.
3) Click the ‘Add’.
4)

… Read the rest

SQL Server Management Studio – Get metadata on mdf database files

In SQL Server Management Studio, you can run the following commands against your MDF database files to get metadata information.

--SQL Server DBCC CHECKPRIMARYFILE with Option = 0
--First, we will use it with zero to check if it is

… Read the rest

Google Chrome: How to Extract Only the Pages You Want from a PDF Using Google Chrome

1) Open the PDF in Google Chrome.
2) Select Print.
3) Click the Change button in Destination and choose Choose ‘Save as PDF’.
4) Click the radio button to choose your print range.
5) Click ‘Save’.
6) Follow the ‘Save … Read the rest

File Explorer: Restore Your File Explorer Windows on a Cold Boot

I find this very useful when I have to do a quick reboot in the middle of the day and have multiple explorer windows open that I don’t want to have to drill down and bring up again.

Please follow

… Read the rest

Google Calendar: Recover a Deleted Google Calendar Event

You can see your Trash from Google Calendar on your computer. In Trash, you can:

See deleted events for 30 days
Restore deleted events
Delete events forever

In https://calendar.google.com

Click the drop-down to the right of the calendar you want … Read the rest