Custom Credentials for SQL Server Reporting Services 2005 Web ReportViewer#

SQL Server Reporting Services 2005 allows you to connect with a web based ReportViewer control.

This control needs to provide credentials for the reporting server to authenticate the user requesting the report.  By default, the account running the asp.net worker process is used, but you can use the code in this forum posting to create you own custom credentials.

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=409854&SiteID=1

 

Categories:  |  | 
Tuesday, October 24, 2006 2:34:26 PM (Central Standard Time, UTC-06:00) #    Comments [0]  | 

 

Anti-Spam GreyListing#

I recently started getting some soft bounces coming back from Yahoo. 

I believe that this is a "greylisting" operation on their part:  "Message delivery has been delayed."

The typical "lists" are Blacklists (all email is rejected) and Whitelists (all email is accepted).

Greylists utilize what is called a soft error, or soft bounce on the email server. 

When sending an email, there are some errors that cause the transmission to fail and halt, and there are others that indicate that the sender should "try again later."

For example, if you try to send an email to an account that doesn't exist, the sending server will not try to deliver the message again.  But if the error is something like "Mailbox is full", then the sender will keep trying N number of times.

Almost all spammers will not bother to resend these soft bounces.  They are kicking of millions of emails, it isn't worth their time to deal with these soft bounces.

So greylisting does the soft bounce, and sees if the sender tries again.  If they do, then yahoo labels them as an OK sender, and allows their email through.  If they don't try again, yahoo can label them a spammer, and block them out.

 

Categories:  | 
Tuesday, October 24, 2006 2:31:48 PM (Central Standard Time, UTC-06:00) #    Comments [0]  | 

 

AJAX Toolkit Library Growing#

A while back I was looking at the AJAX toolkit page (http://ajax.asp.net/ajaxtookit) and I was really not impressed with anything I saw.

Things like the "Confirm" button, which is basically a button with 10 seconds of javascript coding built into it isn't a big deal, IMO.

But their list of controls has really grown and there are some really interesting things in that toolkit.

It still boggles my mind that they don't have an autocomplete dropdown list where your selections are LIMITED to the choices from the list.

 

Categories:  |  |  | 
Tuesday, October 24, 2006 2:29:30 PM (Central Standard Time, UTC-06:00) #    Comments [0]  | 

 

ReportViewer with heigh=100%#

When you try to assign the web reportviewer control to a height of 100%, it displays as a very short (height wise) format.  For me, adding the style attributes to the form did the trick.

The solution to this problem was found on this page: http://msdn2.microsoft.com/en-us/library/ms252090.aspx.

Considerations for XHTML and ReportViewer Web Server Control

If you configure the ReportViewer Web server control to run in asynchronous mode in an application that is written in XHTML, you must follow specific steps to display the ReportViewer control properly. If the ReportViewer control uses relative height (for example, if the height is specified as a percentage of available space), the control collapses to a height of 0 pixels as a result of how frames and DIV tags render in containing tables in XHTML. You can avoid this problem by using one of the following workarounds:

  • Explicitly set the height on the on the ReportViewer control to an actual value rather than a percentage.

  • Add the following style setting to the head tag:

    <style>html,body,form {height:100%}</style>.

    By forcing the html, body and form tags to maximum height, the frame used in the ReportViewer control will also grow to maximum height, making it visible on the page.

  • Remove the xhtml doctype from the page.

Categories:  |  |  | 
Tuesday, October 24, 2006 2:27:04 PM (Central Standard Time, UTC-06:00) #    Comments [0]  | 

 

Open letter to John Madden... very funny.#
This article is a (fake, but funny) letter from the lowest ranked player in Madden 2k7 to John Madden.

http://www.thephatphree.com/features.asp?StoryID=3159&SectionID=2&LayoutType=1/

Very funny stuff.

Categories:
Friday, October 20, 2006 2:36:13 PM (Central Standard Time, UTC-06:00) #    Comments [0]  | 

 

Using ObjectSwap To Avoid Flash/IE Activation Problems#

Recently Microsoft lost a lawsuit which required that they not "automatically" enable dynamic content in their browser, or something.

Whatever.  The result is that you now have to CLICK on flash swf files running in your browser before they will be "Activated".

The way to get around this is to use javascript to do the dirty work. 

Check out this link for a quick include that can help with the work around:

http://www.sitepoint.com/article/activex-activation-issue-ie

 

Categories:  |  | 
Thursday, October 12, 2006 2:41:01 PM (Central Standard Time, UTC-06:00) #    Comments [0]  | 

 

Printing Vb.Net Forms with PrintForm Component#

Microsoft has released their first 3 Power Packs for Visual Basic 2005, which are "free Add-Ins, Controls, Components, and Tools for you to use with Visual Basic 2005 to make developing great applications even easier."

1 of the first 3 is the Microsoft PrintForm Component 1.0 , which gives you the ability to easily print a form.

I could have really used this on my last project, where I manually wrote the code to do just that.

Categories:  |  |  | 
Monday, October 09, 2006 1:58:15 PM (Central Standard Time, UTC-06:00) #    Comments [0]  | 

 

Make Use Of Culture in SQL Reporting Services Local Reports#

When using SQL Reporting services, you can format things such as dates and currency.

However, depending on the situation you might want to:

  1. Show a report with culture X on a computer running culture Y.
  2. Show a report using the same culture settings as the local computer.

To do (1), all you have to do is set the "Language" parameter of the local report in design time.

To get (2) to work, you need to set the Language parameter of the report as the expression "=User.Language".  This will set the report culture as the culture that the hosting program is running under.

If you have a program that you need to switch between different cultures, you can do so with the following line of code (which changes the culture to "English-Ireland")

System.Threading.Thread.CurrentThread.CurrentCulture = New Globalization.CultureInfo("en-IE", False)

More information can be found at: http://msdn2.microsoft.com/en-us/library/ms156493.aspx

Categories:  |  |  | 
Monday, October 09, 2006 12:43:24 PM (Central Standard Time, UTC-06:00) #    Comments [0]  | 

 

Convert a String to a Byte Array in VB.Net#

I had a snippet on my site for converting a byte array to a string, but I didn't have anything for going the other way.

This function should do the trick.

Public Shared Function StringByByteArray(ByVal s As String) As Byte()
    Return System.Text.Encoding.UTF8.GetBytes(s)
End Function


Categories:  |  | 
Wednesday, October 04, 2006 2:44:23 PM (Central Standard Time, UTC-06:00) #    Comments [0]  | 

 

Regular Expressions Tutorial#

This is really a great tutorial on using regular expressions.

http://www.regular-expressions.info/tutorial.html

The information is broken down into sections, which appear on the left hand side.

 

Categories:  | 
Tuesday, October 03, 2006 2:50:20 PM (Central Standard Time, UTC-06:00) #    Comments [0]  | 

 

Upload Multiple Files w/ Progress Bar Using Flash#

This is a pretty neat example of using Flash and ASP.NET, 2 technologies that I have expreience with.

http://www.codeproject.com/aspnet/FlashUpload.asp

I will need to try this in one of my projects.

Categories:  | 
Tuesday, October 03, 2006 2:48:56 PM (Central Standard Time, UTC-06:00) #    Comments [0]  | 

 

Getting the Access Default Menu Back#

I know Access is old news, but I have recently been asked to take a look at an old Access app.

This application replaces the existing menu at the top with a custom one, which really limits what you can do.

The solution to getting the menu back is to right click in the menu area, select customize, highlight "Menu Bar" and select properties, and change "Allow hide/show..." checkbox.  After you do this, you can then add it back into your form.

Categories:  | 
Tuesday, October 03, 2006 2:47:04 PM (Central Standard Time, UTC-06:00) #    Comments [0]  | 

 

All content © 2008, Christopher May, Inc
Open Job Positions
On this page
Google Ads
This site
Calendar
<August 2008>
SunMonTueWedThuFriSat
272829303112
3456789
10111213141516
17181920212223
24252627282930
31123456
Archives
Sitemap
Blogroll OPML