[B][SIZE="5"]Background[/SIZE][/B]\r\nMost Java web reporting tools, especially those have some BI characteristics, often claim to end users that their products are simple to use. [B]Some reporting tools promise that they can allow end users to make various statistical reports follow their own inclinations, and evenmake a report just by drag and drop.[/B]\r\n\r\n[B]Has web report development become so easily?![/B]\r\n\r\n[B]The fact is that programmers are still struggling against various reports.[/B] Both web reporting softwares and OLAP products seldom allow end users to use them directly, therefore, end users are still using Excel.\r\n\r\nFor end users, [B]making a simple Web report[/B] (with row grouping or simple cross) with these common reporting softwares [B]is ok[/B], as they can do with the wizard and the semantic layer. However, end users [B]can not make most complex reports[/B] by dragging and dropping the relations of data structure which they do not understood. Therefore, it is impossible for end users to make all the report with these common reporting softwares.\r\n\r\n[B]Drag and drop can only set the positions of data items, but they even can not do this very well.[/B] As current reporting tools’ editing styles are commonly based on controls, and it is a general editing proposal of graphical primitive, it absolutely does not show the regularity of table. However, real successful table products like Excel are not based on controls. For summary conditions, grouping rules and operation formulas, which have to be dealt with in complex reports, drag and drop can do nothing at all. Therefore, end users have to understand the operation model of report first, and then, write abstract expressions. This is not much easier than coding.\r\n\r\n[B][SIZE="5"]Solution[/SIZE][/B]\r\nThen, [B]is it impossible for end users to make Web reports by themselves?[/B]\r\n\r\nYes, it is possible of course!\r\n\r\nHowever, they can only make those simple reports with universal web reporting tools. In order to make complex industry reports, they must use reporting tools with industry characteristics. In other words, programmers must add industry experience into some technical reporting tools, and set the styles and templates of report. Then, end users only need to input parameters and indicators to make various complex reports. The degree of difficulty is determined by the functions and integration of the reporting tool.\r\n\r\n[B]To sum up, it is not easy to make complex web reports by drag and drop as others said.[/B]\r\n\r\nThis post is from freezea's blog. You are welcomed cc it anywhere, and please indicate the source.\r\n\r\nIf you would like to read more articles about reporting tool, you are also welcome to refer to my blog.