How to Change the Default Rendering on SSRSIn Feburary 2016 18,

In Feburary 2016 18,
Locate the report you will be creating a link to using the ReportServer portal in SSRS. Typically, this is found at http://servername/ReportServer. The interface will be minimal, but will display the same folders and reports as the Report Manager.
Copy the URL. Note that the URL may contain several parameters, but the part to look for is the report path, which can be found between the '?' and the first '&', if any exists. In the following example, the report path is '/Folder/Report%20Name':http://servername/ReportServer?/Folder/Report%20Name&rs:Command=Render
Create a new URL using the report path with some additional parameters to specify the rendering format. The 'rs:Format' parameter specifies the rendering format for the report. The following values are common for a default installation of SSRS: HTML4.0, MHTML, IMAGE, EXCEL, PDF and CSV. The 'rs:Command' parameter set to 'Render' instructs the report server to render the report in the specified format.For example, for a URL that always renders the report as a PDF document, use the following:http://servername/ReportServer?/Folder/Report%20Name&rs:Format=PDF&rs:Command=Render
Render a report as an Excel document this way:http://servername/ReportServer?/Folder/Report%20Name&rs:Format=EXCEL&rs:Command=Render
In Feburary 2016 18,

How to Troubleshoot Mac USB IssuesIn Feburary 2016 04,

In Feburary 2016 04,
Check that the USB device is connected to the appropriate jack. There is a USB jack in the back of most keyboards, but it often only works with a mouse.
Unplug any USB devices and wait a few moments before reconnecting them. You can often fix problems with your USB keyboard and mouse by using this method. Try restarting your computer if the malfunction persists after you reconnect the USB device.
Test your USB peripherals in another computer. If the problem exists in the second computer, you may need to have the device serviced or look for an updated version of the firmware that supports your USB item. Check the manufacturer's website for these updates.
Try different devices in the same USB port. For example, if your mouse if behaving strangely, see whether an external drive or an iPod is able to connect to the computer via that USB port.
Disconnect any USB hubs that you're using and connect each device one at a time to your computer. You need to troubleshoot the devices individually to find out whether the USB hub or the one of the devices is causing the problem. Be sure to test each peripheral with a working USB cable.
Reset the parameter random access memory (PRAM) and nonvolatile RAM (NVRAM) on your computer. Turn off your computer, then restart it and immediately press and hold the 'Command,' 'Option,' 'P' and 'R' keys on the keyboard. Release the keys after you hear the startup chime for the third time and your computer should boot normally.
Consider reinstalling the operating system after clearing your computer's hard drive. Be sure to back up all of your data before you erase the disc. You may also want to bring the computer to a Mac service center and have the logic board examined.
In Feburary 2016 04,

How to Convert SQLite to TextIn Feburary 2016 03,

In Feburary 2016 03,
Load a SQLite database and enter the sqlite3 environment by typing the following text at the command prompt:$ sqlite3 mydb.dbReplace 'mydb.db' with the name of your database. A database with the specified name will be created if none already exists.
Convert a value to the TEXT data type with the 'CAST' expression by typing the following command at the command prompt:$ sqlite3 my_db.db INSERT INTO my_table VALUES(CAST(97 AS TEXT))Replace 'my_table' with the name of your table. In the code, the number 97 is inserted into the table as a TEXT value.
Exit the sqlite3 environment by typing '.quit', '.q' or '.exit.' and pressing the 'Enter' key.
In Feburary 2016 03,