SQL Server Reporting Services (SSRS) – How to Stop Creation of rdl.data Files

An rdl.data file will be created each time when the report is viewed with different input parameters. The data file caches the data so running the report again in the IDE with no changes to the parameter data will render quickly.

To stop the creation the data files, do the following:

For example: Visual Studio 2015
C:\Program Files (x86)\Microsoft Visual Studio 14.0\Common7\IDE\PrivateAssemblies

Change the CacheDataForPreview key in the RSReportDesigner.config file from true to false

Here is an update to date (as of today) chart of Visual Studio versions:

Windows: Computer thinks second hard drive is a system disk. Can’t create a System Image.

I accidentally installed a program (SQL Server) to my second hard drive that I also use to backup my c:\ drive as a system image called, "windowsimagebackup".

I removed the SQL Server software, reformatted the second hard drive, and when I clicked on Create a System Image, it recognized my second hard drive…… until I rebooted. I was back to square one.

What I came to learn was that during a reboot, if your system finds any lingering entries in the registry that are services that point to the second hard drive, it will again flag the drive as a system disk before the login screen appears.

Here is what I did to fix the problem.

1) Remove any programs and services that are using the second hard drive.
2) Run the registry editor in CCleaner and get rid of any pointers to the second hard drive.

Run Computer Management by type Computer Management in the search bar.
1) Under Storage, click Disk Management.
2) Right click the second hard drive and click Delete Volume
3) Right click on the second drive and make sure it is MBR.
4) Right click and click New Simple Volume (creates a partition).

Reboot.

The system should not flag your second hard drive as a system disk, and it should now be recognized as a drive for creating system images.

Microsoft Outlook: Error 0x8004010F when you try to send or receive email in Outlook

Corruption can occur if you transfer a .pst file from one computer to another. This is what I did which caused this error message when trying to send/receive email.

Here is a solution that can fix the problem:

1) Click File and enter your Account Settings.
2) Highlight the account under the Email tab and click Change Folder.

3) Click New Outlook Date File…

4) Enter a new name temporary name for your .pst file and click OK.
5) Select the Inbox of your created temporary .pst file. and click OK.
6) Back at the Account Settings screen (Image above after step 2), click Change Folder.
7) Select the inbox of your original .pst file and click OK.

8) Close out of the Account Settings and test the Send and Receive.
9) If the problem is resolved, delete the temporary .pst file if it still exists.

Toon Boom – Can’t return License

If I have an activate Toon Boom license before restoring my hard drive of my Windows computer to a previous system image, I can't return the license to the Toon Boom after the restore. (If I forget to return the license before the doing the restore – if it is at all possible).

The license is stuck, but there is a way to remove it.

Instead of running the license wizard through the UI….

…run the ClientActivation executable from an elevated DOS command prompt instead. Doing it this way will give you a Delete button to remove the license after the return fails.

1) Start an elevated (Run as administrator) cmd prompt.
2) Go to the directory where Toon Boom resides.
3) Type the following at the prompt   ClientActivation.exe -advanced

The Delete button will appear disabled, but after the return fails, the Delete button will be enabled. Click the Delete button and it will remove the license.

That's it!
 

 

Hide duplicate row SSRS 2008

Let's say you have a SQL table with 2 columns. The first column is a name and the second column is a street address. For every address a name has, the name column is repeated for every row as such:

name          address
John Doe    100 West Main Street
John Doe    200 Apple Road
John Doe    300 Orange Circle
Todd Toe     123 Maple Drive
Todd Toe     543 Ridge Road

Now you wish to build a report to display this data, but you don't feel like grouping the name column in your SQL nor do you want to group the name column in your report.

So, in the tablix of your report, you create two rows. The first row displays the name column and the second row display an associated address. The problem is that you don't want to repeat the name row for each address like this:

John Doe                                                                                          
100 West Main Street
John Doe                                                                                          
200 Apple Road
John Doe                                                                                          
300 Orange Circle
Todd Toe                                                                                          
123 Maple Drive
Todd Toe                                                                                          
543 Ridge Road

You want it to look this:

John Doe                                                                                          
100 West Main Street
200 Apple Road
300 Orange Circle
Todd Toe                                                                                          
123 Maple Drive
543 Ridge Road

You can do this (without any grouping) by simply using the Previous expression of SSRS.

1) Right Click on your name row and choose row visibility.
2) Click the 'Show or hide based on an expression' radio button and click the expression button.
3) Enter the expression:
    =iif(Fields!name.Value = Previous(Fields!name.Value), True, False)

That's it!