How can I get the count of a Group?

 

1. How to get the count of the Group?

A. cumulativeSum (if (group column name [-1] = group column name [0], 0, 1) for all)

B. GetRow ()-First (GetRow () for Group 1) + 1

C. count (grouping field for all distinct)

2. How to get the row number of the Group?

CumulativeSum (1 for group 1)

3. How to pass parameters to a subdata window?

Datawindowchild ldwc_name

Ldwc_name = dw_name.getchild ('column ', ldwc_name)

// If you do not know what the search parameters of dddw are, you can fool dddw and let him think that the data already exists:

Ldwc_name.insertrow (0)

Dw_name.retrieve ()

// If you know the search parameters:

Ldwc_name.settransobject (sqlca)

Ldwc_name.retrieve (arguments)

Dw_name.settransobject (sqlca)

Dw_name.retrieve ()

4. How to compare the days of data difference between two time (date) types?

Date ld_date1, ld_date2

Long ll_diff

Ll_diff = daysafter (ld_date1, ld_date2)

5. In DW, each row of data is displayed in different colors.

Background. Color Express:

If (mod (getrow (), 2) = 0, RGB (0,255, 0), RGB (255,255,255 ))

6. Operation of the visible attribute in the window

Way1: select option from the design menu of the window canvas, and click the show invisible check box.

Way2: select control list from the edit menu, select the button you want to find, and click the visible check box in the property.