In the search, type system and click the result, "System Control Panel".
Click Advanced system settings.
Click the Hardware tab.
Click Device Installation Settings.
Click the 'No' radio button.
Click 'Save Settings' to close the dialogue box.
Click the OK button to the close the previous dialogue box.
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:
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.
I had no idea (in Windows 7) that you can do more than disconnect or lock a computer that you have remoted into. There were many times that I wanted to either Log off or Restart the computer and could not. I thought it was a limitation of Remote Desktop.
And then I learned about ALT-F4.
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.
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!
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!