Happy Anniversary day of the Republic of Indonesia.
Merdeka…..! Merdeka……! Merdeka……!
Archive for August, 2009
64 Years Indonesia Independence Day
August 17th, 2009Making group in Reporting Service
August 15th, 2009I was recently try to make sample grouping in report using reporting service. I working with Sql Server Management Studio (2005) and Microsoft Visual Studio 2005.
First Step : I working with with Sql Server Management Studio (2005)
In SQL Server 2005 I create a table, entry data to the table and make Store Procedure as the link to Reporting Services to view report. For example I will create my own table, Employee Table.
This is the content of Employee Table
And then make simple Store Procedure, I make SP_ViewEmployees procedure. This is the script:
Second Step : Working with Microsof Visual Studio 2005
The step to create reporting service are as below:
- I start with open this menu : File - New - Project, In the New Project Window I choose Other Project Types, and then choose Visual Studio Solution.
- I give Report01 as the solution name, Right click the solution and then Add New Project from this menu : Add - New Project.
- In New Project window I choose Business Intelligence Project, and the click Report Server Project.And I give Report01 as the project name.
- Right click Share Data Sources Folder in Report01 Project, choose Add New Data Source
To set the properties, click button Edit and follow the below picture to set Connection String properties base on your database connection setting.
- Right click Reports Folder in Report01 Project, choose Add - New Item and then click Report, I give rptGrouping as the report Name
- In Data tab see Dataset drop down list. Click the drop down list - choose DataSet and entry all requirement as the below picture
- In the report Layout tab you can make the design as below picture by using table and in the detail rows insert groups
Set the Group properties as picture below, uncheck include group header and include group footer
To set the value of each column you can right click in the column detail and choose expression.To Employee ID, Name, Gender and Group No value follow this step. For example Employee ID column, right click in the Employee ID detail and then choose expression,after edit expression window appears,choose Fields (Dataset1) double click Employee_ID Fields (DataSet1) and then click button OK.
I make the grouping in the column No, so right click in the No column detail and then choose expression.
And give the expression value as below picture.
- In the preview tab you will see the result like this, before insert the year value. For example 2008
Hope you enjoyed trying this!
Get this day and month in Indonesia Fomat with Excel
August 2nd, 2009In my new client, somebody ask me “how to get this day and month in excel?” (I make the format in Indonesia because I’m Indonesian) . He ask me because he is newbie in IT and he study excel autodidact. Although I’m an IT worker but my excel is bad (Hehehehe… :) ), And I try to solve his problem and search “today” as keyword in the help Excel (kekekekeke 
).
I try for some minutes and finally I get the ways. This the solution, But before I write the solution I’d give some lesson for Indonesia language :). This the name of day and month in Indonesia.
If you want to learn Indonesian language for a bit you can read this.
First Step: How to get the date,weekday, month, and year in this day
Use the function as show below:
- To get weekday use weekday() function and insert today() function as the serial number
- To get the date use day() function and insert today() function as the serial number
- To get the month use month() function
- To get the year use year() function
This is the result from weekday, day, month, and year sequentially :
Second Step : How to get the name of days and months in Indonesia
You must understand how to use choose() function and this the way:
- To get the name of days in Indonesia
- To get the name of month in Indonesia
The last step : Join all function to view the date format in Indonesia
- Use function concatenate()
Concatenate joins several text strings into one text string.
Type the function like this in the formula bar
And the final result is
