There are 100 typical Chinese-style reports, how to do it, what to use, and how long does it take?

ptrooper

As the title:
VB language + access database
About 40 tables of the human resources management system to be done first (more than 100 in total) are all typical Chinese-style manual reports, which need to be produced by programs, and already have an excel table format. What report tool should be used?
Is it feasible to fill the cells after reading the table format directly with the excle control? How difficult is it?
How long does it take to do it alone?

A simple description of the most complicated format report: the classification level of the row and column items is 2-4, including the relationship, the total classification of each level. Total. Please note that the rows and columns have multiple levels of classification.
The contents of the lines are not inconsistent with the scope or condition. For example:
Column 1, Column 2, ...
Class A
Class B
Class B (Conditional: Excellent)
Class C
For larger reports, such as reports with 100 columns, it is divided into 1, 2, 3, and 4 sub-tables. Of course, each sub-table has row and column headings, but the table content has some differences (such as the first (There are rows on the sub-table, others do not.)
Of course, it is not the most complicated.

Looking forward to your suggestions and opinions. Thank you.

ptrooper

For the report of the following form mentioned upstairs, I call it horizontal paging of the report. There is also vertical paging.
For larger reports such as 100-column content, it is divided into 1, 2, 3, and 4 sub-tables. Of course, each sub-table has row and column headings, but the table content has some differences (such as the first (There is a row total on the sub-table, others do not)

The case of vertical paging is as follows: (It is not like the automatic paging of reports like binding data sources)
For example, there are 100 items of content divided into 2 levels, and each page fixedly displays those first-level and corresponding second-level content.
      a1 subcategory
      a2 subcategory
Category A a3 Subcategory
      a4 subcategory
      b1 subclass
Category B Category b2
      b3 subclass
............
This should be controlled such as: the first page fixedly displays the A, B, C categories and corresponding subcategories, and the second page fixedly displays the E, F, G, H categories and corresponding subcategories,,,,,,,,

I sincerely look forward to your suggestions and comments. Thank you.

shiliang42

In fact, it is more convenient to directly call the Excel output, but if each table style is different, there will be as many implementation functions as there are reports. Because the specific writing position is different.
Complex reports can only be controlled by the program. There is no other way.
Cell can, he can read Excel to fill in the data and then output the report.

entwine

There are not so many reports in our personnel compensation management system
It's mainly about wage slips and summary data
Use an ActiveReport directly
Some use Excel is also very convenient

ptrooper

Thank you, even if I do a general civil servant plus a public institution, isn't it just the salary system, involving 120 to 150 tables for reporting. Ha ha... tired, just about 40 now. How long does it take?

ptrooper

Let me ask you another question:
In terms of personnel files, there is a person's basic information file, and then there are various related information content 10 aspects such as learning experience (multiple content, multiple records), work experience, training experience, etc...
Such as the processing of this kind of basic information and its related 10 or more other information records, do you focus on one interface in interface processing, or do you handle each separately?What will you do if you do it?
Thank you.

entwine

The basic information, learning experience, training experience, social relations, rewards and punishments of idiots are all handled in one interface
No training
Separated by tab pages, some can be edited, etc.

snowmanzf

One: I have always used Execl to implement reports. Its function is too strong. It is seamlessly integrated with VB and can reduce your development time. You can use Execl to make all the tables first, that is, templates, and then fill in the data. It is very simple to implement.


Two: It depends on the complexity and frequency of the 10 other pieces of information for specific analysis. If these pieces of information are not commonly used, I don’t think they should be put in an interface. If these items are always used, And can be accommodated in an interface (you can use Tab or other controls when too many), then it should be built in the same interface. In short, I think a good program must not only be free of bugs, but more importantly, it is more convenient to use, more in line with people's usual habits, and brings higher efficiency to the operators.

ptrooper

First backentwineboss
   If the content is within 5,6, you can still use paging. I now have a total of 14 items. If you want to paging, it is not impossible, but the 14 page labels are definitely not displayed on one screen, and I feel not very good. I use the toolbar --dropdown button, and then use the picturebox container to display, suspended above the main file window. For data editing, I used truedbgrid. Picturebox basically contains a truedbgrid, an add button, a save, a delete, a return button. A label display title.
   Set a little more picturebox color. It feels a bit ugly (the boss said). Depressed...

Back tosnowmanzfboss
   I also want to use excel because the report format is available, and it is unified by the country, and it cannot be changed by itself, so this can save the work of drawing and debugging positions 40 and even more than 120 reports. I feel that I want to draw 40 This report will not work in less than a month.
   These 10 other pieces of information are all related to each specific person. When browsing the information of a person's master file, other information may have to be read, so I want to put it in an interface. I like vb most Everything can be arrayed, and there can be unified events and methods after the array.

Thank you both.

wdh66f

Reports that can be implemented in Excel can basically be implemented in VB
I do not know what the report format of the landlord looks like