The invention discloses a method, a
system and a terminal for generating a dynamic report through visual configuration, and the method comprises the following steps:
metadata configuration: defining a report name and a code through a
visual interface, and establishing a mapping relation between a query condition attribute name and a
display name; engine binding is executed, wherein an
SQL mode and a storage process mode are included; the
SQL mode comprises the step of automatically replacing an
SQL script containing an attribute name placeholder with an actual parameter value; the storage process mode comprises the steps of performing
standardization processing on an interface attribute name and a storage process parameter name, and matching parameters by adopting an editing distance
algorithm allowing 1-2 character differences; and multi-table rendering: independently rendering the master table and the slave table according to the bound query result serial number, and configuring a column display rule and an exclusive script. According to the method, the development efficiency and the parameter matching accuracy are improved, and complex structures such as listing are supported; configuration takes effect in real time, and the operation and maintenance cost of restarting service in a traditional scheme can be avoided.