Wednesday, August 30, 2006

Opacity property of WinForms is not working

The Opacity property of WinForm will not work for MDI Child forms due to some problems in form paintings. Infact, it is designed ONLY for top level windows.

Read @ http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vbcon/html/vbtskCreatingMDIChildForms.asp

Sunday, August 20, 2006

Integrate SQL Reporting Service 2005 with Sharepoint Portal 2003 with Web Part

Reporting Service rendering web part for share point is available at %\Program Files\Microsoft SQL Server\90\Tools\Reporting Services\SharePoint when SQL Reporting Service 2005 is installed.

Install the above web part in share point with stsadm.exe. It consists of two web parts, Report Explorer and Report Viewer. Report Explorer is basically for listing the reports available in the reporting service in the specified folder (configuration of web part) and Report Viewer web part is for rendering report. Drag both web part in one of the sharepoint pages

Configuration
Enter the report manager url in the "Report Manager URL" property of Report Explorer web part.
Enter the folder name in the "Startpath" property of Report Explorer web part so that it will list only those reports in that folder. (It can remain empty)

In design mode of the page, go to properties of Report Viewer web part and select
Connections - > Get report from -> Report Explorer.

Now, click one of the reports in the Report Explorer web part listing and find the report rendered in the report viewer web part

Zm

Saturday, August 19, 2006

SQL Reporting Service 2005 Express and Business Intelligence Development Studio - How to install and configure ?

SQL Reporting Service 2005 Express is available when you install the SQL Server 2005 Express Edition with Advanced Services SP1 edition. This is frely downloadable at http://msdn.microsoft.com/vstudio/express/sql/download/. Keep the servicing component selected while installing.

To install the Business Intelligence Development Studio, download Microsoft SQL Server 2005 Express Edition Toolkit SP1 from the same URL http://msdn.microsoft.com/vstudio/express/sql/download/

Wednesday, August 16, 2006

Display Mail Inbox, Tasks and Calendar from MS Outlook in Sharepoint Sites with web parts

You can do this in two better ways.

1. Drag "Content Editor Web Part" and paste the following script into the Source Editor

<object classid="clsid:0006F063-0000-0000-C000-000000000046" id="ViewCtlFolder" width="100%" height="400px" codetype= "application/x-oleobject"
codebase="http://activex.microsoft.com/
activex/controls/office/outlctlx.CAB#ver=9,0,0,3203">

<param name="Namespace" value="MAPI">
<param name="Folder" value="Inbox">
<param name="Restriction" value="">
<param name="DeferUpdate" value="0">
</object>



2. Create a generic web part using VS.Net and rewrite the function RenderWebPart like below

protected override void RenderWebPart(HtmlTextWriter output)
{
string str = "--above written script--";
output.Write(str);
}



Note that, to view Calender or Tasks instead of inbox, you can replace the term "Inbox" in the script with corresponding item.

Zm

Monday, August 14, 2006

How to install SQL Server Business Intelligence Development Studio along with SQL 2005 Express and SQL 2005 Reporting Service

SQL Server 2005 Reporting Service is version dependant on SQL Server. If you install SQL 2005 Express, you can only install express edition of SQL Server 2005 Reporting Service (RS).

Business Intelligence Development Studio is the default report designer of SQL Reporting Serivce. It is an addin for VS.Net 2005 with templates for "Report Projects"

How to install the express editions ?
  • Downlaod SQL Server 2005 Express with Advanced Service (this includes the reporting services) and install. While installing keep the item "Reporting Service" checked
  • Download SQL Server 2005 Express Toolkit ( http://www.microsoft.com/downloads/details.aspx?FamilyID=3c856b93-369f-4c6f-9357-c35384179543&DisplayLang=en). The kit includes the business intelligent development studio
  • Now, go to Start - Settings - Control Panel and click Add remove programs
  • Click the "Change" button of MS SQL Server 2005
  • Click the link "To install a new component, click here"
  • Locate the new .exe file of Express Toolkit by clicking the "Browse" button
  • Proceed the installations with "Next" button clicks.

-Zm

Not able to connect Sql Server 2005 Express remotely

"An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) "

By default, when you install Sql Server 2005 Express Edition, it will not allow the applications or clients to connect remotely as like OracleXE. This causes the sytem to throw the above error message.

To enable the remote connection,
  • Go to Start - Programs - Microsoft SQL Server 2005 - Configuration Tools - SQL Server Surface Area Configuration
  • Click the link "Surface Area Configuration for Services and Connections"
  • Now expand the tree SQLEXPRESS - Database Engine - Remote Connections in the "View by Instance" tab
  • Select "Local and remote connections" and "Using both TCP/IP and named pipes" and apply the changes
~Zm

Tuesday, August 08, 2006

Body onLoad() event in content pages - ASP.net 2.0

How we can use the onLoad() event in ASP.Net 2.0 content pages ?

Simple !.
A content page is basicall a page inherited from a MasterPage (.master) in .net framework 2.0. This can be adhieved by either two ways.

1. Javascript function override

Add body onLoad() event in the master page and override the function used in the event in the inherited content pages.

Say,

in master page
<html>
<head>
<script language=" javascript" type=" text/javascript">
function testonload(){ //an empty function
var x = 'empty';
}
</script>
</head>


.
..
...
....
.....



in content page

<asp:content id="Content1" runat="Server" contentplaceholderid="ContentPlaceHolder1">
<script language="javascript" type="text/javascript">
function testonload(prodid, div) {
//client script logic goes here..!!
}
</script>


2. Bind client script to body in code behind

Give an id to the body tag of the masgter page and add runat="server" sot that it is available in the code behind.

Now in content pages, add the following code in the page_load event


HtmlGenericControl body = (HtmlGenericControl)Page.Master.FindControl("bodyMaster");
body.Attributes.Add("onload", "toggle('parameters');");


Keep coding,