This becomes handy when having to enter a time range with a start and end date (week, month, quarter, year, etc). The trick is to make always sure that the to-date cannot lie below the from-date. This can be done via a check and a message afterwards...

In this case a LISTBOX is read and a filter is set on DS_1 data source. Also an extra text item is being filled with the chosen values to be displayed elsewhere on the canvas.On Startup script code.LISTBOX_REGION.setItems(DS_1.getMemberList("0REGION"...

Sometimes you'd like to see details based on a row selection from a crosstab.This requires a main data source and one or more extra (detail) data sources. All must be based on the same query. The UID code from the query is used.Looking in the origina...

Report-to-report (RRI) inside Design Studio. The restriction is that it works only when the details are in the same query. The getSelection() function reads the UID code and applies this to the filter on the other data source(s). When using another q...

A multi-selection listbox with a fixed number of years.   Make a global variable called gv_Year as an integer and a number of extra global variables year1 - n as string. In this example 6 years were used. On Startup script code;   gv_Year = C...