Yes, well don't laugh, I could not find this on the WWW so I was obviously not using Google properly.  Anyway here's just a quick note on how to do if else statements in Report Builder 2.0

I'm looking at the following if statement:

copyraw
If (MyFieldName = 0) Then
     Return 1
Else
     Return MyFieldName
  1.  If (MyFieldName = 0) Then 
  2.       Return 1 
  3.  Else 
  4.       Return MyFieldName 

Can be expressed as:

copyraw
IIf(Fields!MyFieldName.Value = 0, 1, Fields!MyFieldName.Value)
  1.  IIf(Fields!MyFieldName.Value = 0, 1, Fields!MyFieldName.Value) 

Category: SQL Server Reporting Services :: Article: 261

The Issue

After modifying a report and on running it, Report Builder 2.0 returns the following error:

alt

An error occurred during local report processing.
An error has occurred during report processing.
Query execution failed for dataset 'DataSet1'.
The variable name '@GroupName' has already been declared.  Variable names must be unique within a query batch or stored procedure.

Thought I'd put something here as a lot of my clients and friends are all surprised by the Aero features and weren't aware that these existed in Windows Vista (and originally from Linux variants).

Sometimes you may only have partial Aero effects. This can be because Windows may not think your machine is powerful enough to run these effects without affecting performance.

If this is happening to you, and you don’t mind about a possible slight slow down on performance you can force enable them -

  1. Go to Control Panel -> System and Security -> System
  2. Click on advanced system settings on the left and then performance settings.
  3. Under the visual effects tab you should see that the option “ Let windows choose what’s best for my computer “ is by default checked.
  4. Below it you should see a list of visual effects, some of which will be unchecked if you are not experiencing the full range of Aero features.
  5. Select the custom option and then select all the effects from the list below it. Hit apply and ok and you should have all the Aero effects enabled.

 

Now what are these Aero effects?


ASCII Extended Character Set

 

Typing an ASCII character

In DOS:
Hold down the <Alt> key while typing the decimal number on the keyboard keypad. (Example:  <Alt>178)
 
In Windows for a DOS character:
Hold down <Alt> while typing the decimal on the keyboard keypad. (Example:  <Alt>230)
 
In Windows for a WIN character:
Hold down <Alt> while typing "0" then the decimal number on the keyboard keypad. (Example:  <Alt>0140)

I just had to put something here as I have been buying and returning failed/corrupt USB pens.  In the past few months I have been trying to upgrade my 16Gb USB Integral Pen from Play.Com to a 32Gb equivalent.  I use my USB pen as the "My Documents" folder on every computer I use.  It was fine with my 16Gb one but my 32Gb ones have all failed at some point.

I went for a cheap one on Play.com (Verbatim 32Gb@£49.99 & Kingston DataTraveler@?) and an even cheaper one on Ebay.com (Leather 64Gb@£29.99).  In hindsight, the Ebay one was obviously going to fail (faking the disk size).

I got badgered by my colleagues to splash out and get a worthwhile pen.  Aside from some other failures, I decided to get the bulletproof, waterproof, fireproof, shockproof 32Gb USB Pretec Pen (as advertised by Gadget Show on Five.tv).  Turns out this is an incredibly fragile pen. If files are being written to it and it gets nudged, this will corrupt the pen.  BTW I don't use the "remove device safely" rubbish as my old pen never did and it was fine for over a year.  The default setup in windows XP is that it doesn't need it.

Bulletproof, waterproof, fireproof, shockproof BUT NOT joe-proof! ...


 This is an issue relating to the Time Server Synchronization error.  Basically you start up windows live messenger and get the following error:

{rokbox title=|Messenger Error 80048820|}/images/screenshots/windows_live_error_80048820.png{/rokbox}

Basically you need to check that the time on your windows clock is accurate or close to real Internet time:

The Issue

People have reported that although they have manually set the date/time on their computer, this gets changed by the windows time server (time.windows.com) when connected to the Internet and for some reason it doesn't display the right date/time.


The Quick Fix

First off, check there aren't any Update for Windows 7 releases at Microsoft's Windows Update


Applies to:
  • Microsoft Windows XP
How?
 I keep having to do this every year as I reghost all my machines (=restore to sorta factory settings), so instead of googling it and going through other websites that work and don't; I thought I might as well post the way I do it:

  1. Open up windows explorer
  2. Go to Tools -> Folder Options
  3. Click on the File Types tab
  4. Scroll down and select (NONE) Folder as file type
  5. Click on Advanced
  6. Click on New...
  7. For the Action type what ever you want the context menu to display, I use Command prompt from here
  8. For the Application value type c:\windows\system32\cmd.exe (this will be different on winnt, browse if unsure to your cmd.exe program)
  9. Click on OK > OK > Close

Notes:
  • Added by default since Microsoft Windows 7

 Thought I'd put a note about this as I spent ages rewriting an entire system.  The HTTP_REFERER environment variable can be changed by the user anyway but I was using it as an additional validation check.

The only solution is to not use it for verification purposes as it will only work in every other browser except Internet Explorer (more specifically versions 6 and 7...???)

 

For more details: http://www.webmaster-talk.com/php-forum/19149-_server-http_referer-fails-under-internet-explorer.html


 This is in the case that you have only one optical drive which is a minimum of a CD Writer and you want to make a copy of a CD.

  1. Insert original CD in the drive
  2. In the CD Drive dialog box, click CANCEL
  3. On the desktop, double-click on MY COMPUTER
  4. Right-click on the CD drive and select OPEN
  5. Go to EDIT > SELECT ALL > EDIT > COPY
  6. PASTE to a temporary folder
  7. Select all the files, right-click on them and select SEND TO > DIRECTCD

 


Credit where Credit is Due:


Feel free to copy, redistribute and share this information. All that we ask is that you attribute credit and possibly even a link back to this website as it really helps in our search engine rankings.

Disclaimer: Please note that the information provided on this website is intended for informational purposes only and does not represent a warranty. The opinions expressed are those of the author only. We recommend testing any solutions in a development environment before implementing them in production. The articles are based on our good faith efforts and were current at the time of writing, reflecting our practical experience in a commercial setting.

Thank you for visiting and, as always, we hope this website was of some use to you!

Kind Regards,

Joel Lipman
www.joellipman.com

RSS Feed

Related Articles

Joes Revolver Map

Joes Word Cloud

zoho   code   list   creator   used   error   field   client   case   script   report   google   time   uploaded   mysql   where   would   files   order   version   joomla   need   form   page   first   date   user   value   windows   note   work   website   name   following   data   deluge   server   display   database   system   using   parameter   table   create   source   license   find   function   added   file   JoelLipman.Com

Accreditation

Badge - Certified Zoho Creator Associate
Badge - Certified Zoho Creator Associate

Donate & Support

If you like my content, and would like to support this sharing site, feel free to donate using a method below:

Paypal:
Donate to Joel Lipman via PayPal

Bitcoin:
Donate to Joel Lipman with Bitcoin bc1qf6elrdxc968h0k673l2djc9wrpazhqtxw8qqp4

Ethereum:
Donate to Joel Lipman with Ethereum 0xb038962F3809b425D661EF5D22294Cf45E02FebF
© 2024 Joel Lipman .com. All Rights Reserved.