I have a requirement to create report merging web application.Users will be able to upload 2 identical budget reports. These users come from 2 different department where each department might have update the data (e.g. description), or might have a bit different description for the same Activity ID.

In this webapp we expect that they should be able to see the differences, and select the data from which report they will use to generate a final integrated document. Fyi, I am planning to store data from both report into database tables (each has its own table) before displaying on the UI. Data Example:

enter image description here

I am looking for a UX/UI solution/idea to display data differences, and an option for user to select data from which report, and there is a possibility that user will be able to modify the value.

What i am thinking is to have 1 big html table like the screenshot below, with inline-editting, data selection, and row/column highlight when there is a difference. Other option perhaps to display it with 2 tables side-by-side? Do you have any suggestions or better solutions?

enter image description here

Tech stacks that we will use: Spring Boot, Thymeleaf + JS + jQuery, Bootstrap, Hibernate, JaVers for Diffing

Please advice..

Regards, Hendry

  • I recommend you add a short user profile to the question. This sort of thing is very different for normal users than for power users. Also, how often are users expected to use this specific tool during their working day? – Peter Aug 15 '19 at 5:53
  • 1
    Hi @MichaelLai thanks for replying, i have editted the question. please let me know if that covers. at the moment i do not have a complete info whether they need a mobile view. – Adrianus Hendry Aug 15 '19 at 6:32
  • Hi @Peter, thanks for replying, true.. this is for internal users where they have their own system. I dont have complete info on how often they use, but i think it should be use for Annual reporting. And Fyi, after this process, the final report will go into BPM process for approvals. Do you have any suggestion what the form should look like? – Adrianus Hendry Aug 15 '19 at 6:35

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.