Submit data to multi-dataset/multi-source with web-based reporting too - Programmers Heaven

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

Welcome to the new platform of Programmer's Heaven! We apologize for the inconvenience caused, if you visited us from a broken link of the previous version. The main reason to move to a new platform is to provide more effective and collaborative experience to you all. Please feel free to experience the new platform and use its exciting features. Contact us for any issue that you need to get clarified. We are more than happy to help you.

Submit data to multi-dataset/multi-source with web-based reporting too

wayne_zjwwayne_zjw Posts: 19Member
Background

When developing data input module based on web, users always have to provide a data submission solution. The complexity of the solution is determined by the complexity of the input web-page.

Some conditions in an increasingly complex order are showed below:

1. There is only one record on the web-page.

2. Records correspond to a table of a database.

3. Records correspond to many tables of a database.

4. Records correspond to many tables of different databases.

Difficulty

1. Keep the transactional database consistency, especially when there are several databases.

2. Convert data type. The type of submitted data from web page is unrecognized; as a result, it has to be converted to proper type in database in the background.

3. Update the mapping relationship between field and the input cell on web page, especially a record corresponds to several cells indifferent expansion regions, or a field corresponds to a expression composed by several cells.

Someone may say that all these difficulties can be solved by writing program. However, the program has no commonality, and the workload will be huge.

Solution

RAQ Report is a professional web-based reporting tool. For users
Sign In or Register to comment.