In addition to Weibo, there is also WeChat
Please pay attention
WeChat public account
Shulou
2025-01-18 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Internet Technology >
Share
Shulou(Shulou.com)06/01 Report--
This article analyzes "how to achieve the fixed header effect when big data report is displayed". The content is detailed and easy to understand. Friends who are interested in "how to achieve the fixed header effect when big data report is displayed" can follow the editor's train of thought to read it slowly and deeply. I hope it will be helpful to everyone after reading. Next, follow the editor to learn the knowledge of "how to achieve the fixed header effect when big data report is displayed".
For a website, the user experience will involve many aspects, including whether the page layout is reasonable, whether the navigation view is clear, whether the loading speed is fast enough, and even the size of buttons or fonts, and so on.
User experience is the subjective feeling of the user, which, in popular terms, is "is it convenient for you to use this thing?"
In addition to website design, a good user experience can also be applied to reports made with reporting tools. For example, data monitoring, reports support highlighting data to provide early warning; in order to improve the readability of reports, detail report data support interlaced heterochromatic display and so on.
Here, we focus on another typical user experience problem: if a page of data in a report exceeds the height of a screen (as does its width), how can you ensure that the lower row or column data always sees the corresponding title for each column? Always can not let the comrades looking at the report frequently scroll the mouse back and forth to find the comparison repeatedly, if this does not scold you, no wonder.
To solve this problem, friends who often use excel should know a "freeze" function. After freezing, the title part is locked in the window. When you scroll the mouse or drag the scroll bar, only the data area scrolls, so it is convenient to view the data.
The question is, can the dry report be done? ! There is no doubt that it will work.
For example, "Statistics the sales situation of each salesperson according to the product name", as shown in the following figure
How to dry the report to lock the header row (blue bottom), then take a look at the implementation process (take the designer's own demo database as an example).
First, design the cross report as shown in the above figure
Among them
The dataset sql is:
SELECT products. Product name, order details. Unit price * order details. Quantity * order details. Discount as sales, employees. Last name + employee. Name as name FROM order details, orders, products, employee WHERE orders. Order ID = order details. Order ID AND order. Employee ID = employee. Employee ID AND order details. Product ID = product. Product IDSELECT product. Product name, order details. Unit price * order details. Quantity * order details. Discount as sales, employees. Last name + employee. Name as name FROM order details, orders, products, employee WHERE orders. Order ID = order details. Order ID AND order. Employee ID = employee. Employee ID AND order details. Product ID = product. Product ID
A3 expression: = ds1.group (product name; product name: 1)
B1 expression: = ds1.group (name; name: 1)
B3 expression: = ds1.sum (sales)
Note: in rows 1 and 2, the row property is set to "header"
At this point, publish the report to the web side and display it normally, but the header is not locked, such as dragging the scroll bar to
At the bottom, there is only a data area on the screen, as shown in the figure
Transform! You only need to add the needScroll attribute to the tag of the report display page to achieve the function of locking the header, as follows
Note: red needScroll, whether to fix the upper header and the left header, the default is no. In addition, scrollWidth
After the header is fixed, the display width of the report; scrollHeight is the display height.
After the transformation, see the effect (still drag the scroll bar to the bottom)
As you can see, when the scroll bar is dragged to the bottom, the header is still attached to the data area.
About big data report show how to achieve fixed header effect to share here, I hope that the above content can improve everyone. If you want to learn more knowledge, please pay more attention to the editor's updates. Thank you for following the website!
Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.
Views: 279
*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.
Continue with the installation of the previous hadoop.First, install zookooper1. Decompress zookoope
"Every 5-10 years, there's a rare product, a really special, very unusual product that's the most un
© 2024 shulou.com SLNews company. All rights reserved.