Skip to main content

Posts

Showing posts from July, 2008

Invalid Report Source

The error message appears because the incorrect versions of the Crystal DLL files are referenced.

To correct this behavior reference the correct version of Crystal DLL files.


Adding the Correct References
-----------------------------

1. Open the VS .NET project.

2. In the 'Solution Explorer' window, right-click the 'References' folder and choose the 'Add Reference' command. The 'Add Reference' window appears.

3. Verify the References for all Crystal DLLs are version 9.1.5000. If they are not version 9.1.5000, select the 9.1.5000 version DLLs and click the 'Select' button.

4. Click the 'OK' button.

5. Save and run your application.


If running the application you find the DLLs revert to the version observed prior to your updates, complete the following steps:


Reverting DLLs Back to Version 9.1.5000
---------------------------------------

1. Right-click the project name in the solution explorer and select the 'Properties' command. The 'Pro…

.NET ACCESS MODIFIERS

There are Five Access Modifiers available in .NET. Following are the functionalities of these Modifiers.


TermUsed With…VisibilityPublicVariables/Properties/Methods/TypesAnywhere in or outside of a project


PrivateVariables/Properties/Methods/TypesOnly in the block where defined


ProtectedVariables/Properties/MethodsCan be used in the class where defined. Can be used within any inherited class.


FriendVariables/Properties/MethodsCan only be accessed by code in the same project/assembly.


ProtectedFriendVariables/Properties/MethodsCombination of Protected and Friend

HOW TOGET SECOND MINIMUM VALUES FROM TABLE IF VALUE HAVE MULTIPLE OCCURENCES.

I have build this query to get the 2nd minimum amount (salary) of employees no matter how much occurrences they have. I want to retrieve each occurrence of 2nd minimum amount. The following query gives me my desired result.


Select amount
From table2
where amount = ( Select distinct top 1 amount
from (Select top 2 amount
from table2
order by amount asc) a
order by amount desc )

FAILED TO LOAD CRYSTL32.OCX

Description:
This error is displayed when you have used reports in your projects and your reports are builds in Crystal Reports 8.5.

Reason:
Error is because of Crystal Report Viewer.

Solution:
Install Crystal Report 8.5 and problem solved

BC30560: 'CrystalReportViewer' is ambiguous in the namespace 'CrystalDecisions.Web'.

This error drove me crazy but I found the fix if anyone is interested:

On the HTML Behind the Form there are duplicate declarations for the Prefix tag:
<%@ Register TagPrefix="cr" Namespace="CrystalDecisions.Web" Assembly="CrystalDecisions.Web, Version=10.0.3300.0, Culture=neutral, PublicKeyToken=692fbea5521e1304" %>

My error was caused by having one for version 10.x and this one for version 9.x
I deleted the one for version 10.x and the error went away.

What is a favicon?

What is a favicon?Notice the red “Y!” symbol that appears in the left-most area of the address bar in Internet Explorer graphic below. Look familiar? Yep, that’s Yahoo’s favicon. These favicons (favorites icons), sometimes called “bookmark icons,” appear after adding a website with a favicon to the favorites menu in Internet Explorer and certain other browsers.Favicons also appear in the favorites menu after a page is added. Most anyone who’s roamed the Internet and bookmarked sites of interest has noticed favicons showing up in the favorites menu like this:They also often appear in the Windows Start menu after installing a program as shown here:Creating a faviconA favicon should be 16 X 16 pixels with 16 colors and the file name should be favicon.ico. IconEdit32 is a good freeware program that allows you to create favicons as well as icons of other sizes and color depths. IrfanView is an excellent freeware image viewer that supports the icon (.ico) image format. You can use it to shr…