19 Mei 2010

Collapse/Toggle SSRS Matrix Group

I had sensed trouble when I want to show the collapse / toggle group in SSRS 2005, but after I finally find the way it works.
The following are easy steps:



if the column group is a group of row like the picture above, then, right click on the group you want to show collapse / toggle and select edit....as in the following figure
*then on the menu tabs 'visibility' select 'hidden' if the initial report view to hide, select the 'textbox' which will be the control. in the case below the textbox control is 'NameAgent'
#if the group is a group of columns, such as the following picture
then the way is the same as above



===========================================================================

08 Mei 2010

Prepare.... for the future

you want to get married? if you're ready, then prepare the things that the marriage requirement. one thing that must be prepared is a requirement of the KUA. The following are examples given KUA conditions in one area in Indonesia.
---------------------------------------------------------------------------------

Marriages TERMS IN SOUTH PONTIANAK

Certificate for the marriage model N1, N2 and N4 of the local headman (Prospective bridegroom and women).
Each 1 (one) sheet of photocopy of identity card, family card, and a special for brides TT1 photocopy of immunization injections.
Each six (6) color photographs size 2x3 cm blue background.
Especially for members of the TNI / police commander attach license.
For Widow / widower Divorced attach the original deed from the Court if a divorce life, and Death Certificate Husband / Wife N6 model, from the village chief, if divorced dead.
For the bride who is not territory of South KUA Kecamatan Pontianak attach a letter of recommendation from local KUA (according to domicile ID).
Following the guidance of a marriage that is conducted every Wednesday by KUA Kecamatan Pontianak BP4 South.
Implementation of Covenant of Marriage after 10 (ten) working days from the date of the registration / submission requirements file of wedlock, or attach a letter of dispensation Camat when less than 10 (ten) working days, because something important reasons.
For foreigners attach photocopy of passport / visa and a letter of recommendation from the Embassy of the State concerned which has been translated into Indonesian, and letters from the country of origin requirements for marriage.
For full information please contact Mr. H. ERNAN, S.Ag. (HP No. 081 345 113 372).

More information on Pontiac District South KUA

Marriage IN TERMS OTHER PONTIANAK

To the Indonesian Citizen (WNI):
* A letter from the village to marry.
* Letter of introduction from RT / RW.
* Certificate of origin of the bride brokers.
* Parents certificate stating that the true parent signature are the parents of prospective brides.
Marriage license * Letter from parents to their brides under the age of 21 years.
* Death certificate / divorce for widows / widowers.
* License for the commander for the Army / Police.
* Letter of dispensation from the local district for the bride who is getting married but the marriage register less than 10 (ten) working days before the wedding is held.
* 4 (four) pieces of photograph size 2 x 3.

For couples fellow citizen:
1. A letter from the village to marry.
2. Cover letter RT / RW.
3. Certificate of origin of the prospective bride.
4. Certificate of parents (which states that the true parents are the parents of the bride).
5. Letters from parents for permission to marry a bride of less than 21 years of age.
6. Death certificate / divorce for widows / widowers.
7. Permit the commander for the Army / Police.
8. Letter of dispensation from the local district for the bride who is getting married but the marriage register when less than 10 working days before the wedding is held.
9. Photo 2x3cm, 4 lbr.

I hope your marriage into a happy marriage of the world and the hereafter. become a harmonious family, the family of sakinah Mawaddah and warohmah.

Congratulations for the new life!
:D

05 Mei 2010

Bilangan Fibonacci [SQL programming]

this is simple logic query in sequel to handle the fibonacci problem.
hope this help u :)

menentukan tahun kabisat [SQL programming]

----------------------------------------------------------------------------------
CREATE PROCEDURE  sp_GetKabisatYear
(
@input int
)

AS
BEGIN
if @input % 400 = 0 ----jika tahun tersebut habis dibagi 400
print 'kabisat'
else if @input % 100 = 0 ----jika tahun tersebut habis dibagi 100
print 'bukan kabisat'
else if @input % 4 = 0 ----jika tahun tersebut habis dibagi 4
print 'kabisat'
else ----selainnya
print 'bukan kabisat'
END

----------------------------------------------------------------------------------

logikanya seperti ini:
  1. jika tahun tersebut habis dibagi 400 maka ia pasti tahun kabisat
  2. jika tahun tersebut habis dibagi 100 maka ia sudah pasti bukan tahun kabisat
  3. jika tahun tersebut tidak habis dibagi 400, tetapi habis dibagi 4 maka ia tahun kabisat
  4. jika tahun tersebut tidak habis dibagi 400, tidak juga habis dibagi 4 maka sudah pasti ia bukan tahun kabisat....

Source: pglmn test...