Realize default value/sequential number with reporting tool

Background

Default value is commonly used in the data input interface of Web report. With it, some fields of newly added record can be generated automatically. Sometimes it is for the convenience of users. Sometimes, it is used when users aren't allowed to input these fields.

Sequential number is a particular case of default value. It has a steady increment or decrement, while complex default values don't have this rule.

Difficulty

For a Web report without dynamic addition and deletion, it may be not very difficult to realize default value/sequential number in input interface.

However, for a Web report with dynamic addition or deletion, it will be very difficult, especially for sequential number.

One of the most important characteristics of sequential number is that it is non-repetitive. But under B/S mode, in the condition of concurrent access, users’ browsers don't need to interact with server for addition or deletion of row. Otherwise, the interaction cost is too must huge. Therefore, it is very difficult to keep sequential number non-repetitive in every browser in B/S mode.

Solution

For users' convenience, RAQ Report provides thoughtful function of default value/sequential number. With RAQ Report, client-side browser can dynamically compute the starting value of sequential number by expression, and realize perfect sequential number function through flexible rules of steady increment or decrement.

Easy Operation

1. Set Report style as Row report and set Input type as Input Report. As shown below:

2. Write starting value expression and define rules for steady increment or decrement. As shown below:

Graphic Illustration

RAQSOFT: Innovative Techology Makes Progress.

This post is from freezea's blog. You are welcomed cc it anywhere, and please indicate the source.
If you would like to read more articles about reporting tool, you are also welcome to refer to my blog.