Thursday, November 29, 2007

SQL Reporting Notes

SQL Reporting Notes
I noticed an issue with SQL Reporting and the PDF formatting.  I was receiving a lot of extra pages between page breaks.  I realized that the grid margins had moved to be extremely wide which caused the problem.
If you have this problem be sure to check your margins.

If you are developing a 11" x 8.5" be sure that your grid is equal to your width minus the margin for left and right.

Example you have a report to be 11" wide with 1/2" margins this means your grid and I repeat cannot be wider than 10" or you will have blank pages and please be sure not to nudge it by accident.

Tuesday, November 27, 2007

SQL Reporting Services Expression

If you ever need to insert "data not available" or "n/a" use the following code.

=IIf(Fields!HoursAllocated.Value is nothing, "No Data Supplied", Fields!HoursAllocated.Value)

ASP.NET Account locked out please check before banging your head.

aspnet_wp.exe could not be started. The error code for the failure is 80004005. This error can be caused when the worker process account has insufficient rights to read the .NET Framework files. Please ensure that the .NET Framework is correctly installed and that the ACLs on the installation directory allow access to the configured account.

For more information, see Help and Support Center at

aspnet_wp.exe could not be launched because the username and/or password supplied in the processModel section of the config file are invalid.

For more information, see Help and Support Center at


Check the following:  Make sure the ASP.NET Machine Account is not locked out...  It will save you a lot of headaches.

Monday, November 26, 2007


Have you ever needed to use RUNAS for testing security on your applications?
If so, and you have gotten a second account for testing and get weird errors such as not finding the application be sure to change the Start In to point to the actual executables location rather than the %HOME%%HOMEPATH%

Tuesday, November 13, 2007

Check empty array Trick

The old trick for checking for an empty array is

Dim X() As String

If (Not X) = -1 Then
Debug.Print "empty"
Debug.Print "UBound is " & UBound(X)
End If

Wednesday, November 07, 2007

InfoPath and Web Services

Have you ever had this issue developing a Web service with InfoPath?

InfoPath cannot submit the form.
An error occurred while the form was being submitted.
The SOAP response indicates that an error occurred:

System.Web.Services.Protocols.SoapException: Server did not recognize the value of HTTP
Header SOAPAction:http://localhost <-- Questions Have you changed the URL here but it the change does not work on the Submit for the InfoPath form?

Well first things first. Every time you update the Web service you need to re-do the connection to the Web service inside of InfoPath. I discovered this after about 2 hours of trying to find out what I was doing wrong in my code VS.NET 2005 UGH!!!!

Hack away fellow gurus.

More to come on the solution I am working on. I am thinking about creating a White Paper and I will include all Blogs that have helped me with this solution.