Let's Talk about .. Excel 2007-Freeze the panes

You may got the problem to read when your spreadsheet is too large. You will not be able to know that what the column is. The way to solve this problem is freezing the panes.

The instruction to freeze the panes

• If you would like to freeze the selected panes,
  Go to View->Freeze Panes-> Freeze Panes


• If you wolld like to freeze the top row,
  Go to View->Freeze Panes-> Freeze Top Row


• If you would like to freeze the first column,
  Go to View->Freeze Panes-> Freeze First Column

• For the example, I selected Freeze Top Row. The result is here. The Top Row is freezed so I can see what each column is.

Let's Talk about .. SQL Server 2005-Reporting Services

Because next year I will have to use the Reporting Services for the project at my office, thus I need to know about it. I read from some resources from the internet. And it's summarized that the Reporting Services is a server-based solution for creating management, and delivery of traditional, paper-based report, and interactive, web-based reports.The Full Reporting Write Cycle Support contains 4 steps:-

1. Report Authoring: Report Developers create report by using Report Definition Report (RDL) design tools.
2. Report Management: Administrators use SQL Server Management Studio to organize report and data sources, schedule report execution and delivery, and track reporting history.
3. Report Delivery: Users view reports in Web-based format or in E-mail.
4. Report Security: It implements a flexible, role-based security model to protect reports and reporting resources.

Ref. http://www.microsoft.com/sql/technologies/reporting/overview.mspx

Let's Talk about .. Word 2007-Insert File Object

My friend, Net, just told me how to insert the file as an object to the document. It's also possible to do the same method in other office applications.

1. Go to Insert->Object->Object...


2. You can Create the new one or insert your exist file.


3. For my case, I inserted my exist file named DropDownList Excel file.


4. Tick Display as Icon if you would like to show your file as the icon. You can also change your icon to be other image.


5. The file appears in the document.

Let's Talk about .. Microsoft Innovation Days-Software + Services

I went to Microsoft Innovations Day on November 13, 2007 at InterContinental Hotel, Bangkok. The main topic was about Software + Services.

This is a little summazation from this seminar. In the seminar, they talked mostly about Software + Services and Office Business Applications (OBA)

Services Transformation consists of

• Service Delivery (SaaS)
• Service Composition (SOA)
• Service Experience (Web2.0)
• Other Services

If we are asked which one should we choose, the answer is all of them.
And that's the new trend of application.. SOFTWARE+SERVICES. What we get when software meets services are Consistent across multiple clients + On-premise & hosted + Extending tools & Platform to cloud + Expanded monetization opps

Building Applications consists of 2 main parts:-

1. Composition
   a. Multiple layers of the stack
   b. Mash-ups
   c. Office Business Applications
2. Building for service
   a. Scale
   b. Customization
   c. Billing
   d. Federation
   

Application Classes can be classified into three types:-

1. Office Business Application
2. Windows Applications
3. Rich Interactive Applications

What I understand about the OBAs is they are applications, that are calling some services, added on to Office programs such as Word, Excel, SharePoint, Access, etc.

Let's Talk about .. MOSS2007-Create New Task

Task is one of the Component come with MOSS2007. It's used to assign the task for whom.
The Instruction to create the Task

1. Go to Site Actions->Create
2. Click Tasks
3. Type the Name of Task, Description, and E-Mail Notification
4. The Task appears.
5. You can set the list upon your requirement. For example, change some properties of column, etc. Go to Setting->List Setting
6. If you want to modify the view, you can go to View:, then select Modify this View. However, if you would like to create new view, you can create if by select Create View.
7. For this example, I selected the Calendar view because I want to create the Schedule Time Table Task.
8. The view is changed.