Which expert helped me solve this problem

dirate2000

The client asked me to display the data in the database (the data is generated in real time) on the form (in the form of a graph), so that I can intuitively observe the dynamic changes of the data and better analyze the data. It is also required that these graphs can be displayed in the report and printed; also, these graphs must be able to be saved in Word or Excel format for data analysis.

The amount of data is relatively large, and it is impossible to display all the curves on a form. The customer requested to display a batch of data on the coordinate axis and then immediately display the next batch of data from the starting point of the coordinate axis. This is like an oscilloscope. After the entire X coordinate display is full, it is displayed from 0.) How can I achieve these requirements?
Which control is better? Hope you can provide examples or code!

Of course, I can draw points one by one in the form, but how can I display the data in the form of a graph on the report and Word, and Excel? How can I use a control and data instead of drawing the points one by one myself Source binding When the real-time data in the table itself is displayed in the control? What if the X-axis and Y-axis values ​​are not stored in the database but in an array?

trampzz

Coordinate axes, data points, etc. can be drawn by yourself.
For example, the user can drag to zoom in and draw in time.

660158

mark

linxiaoga

Hehe, help me upstairs and I will give you a mark immediately!

660158

I have never done it, but I have seen the sample that comes with the crystal report, and there are solutions

tcandjoy

what! You, the client, are more verbose than mine ...

yyzjxpx

It's easy to use a crystal report

ganglq

Crystal report with push mode

spookfox

Mark it, never done it, Bangding

closerbaby

If you have such a curve drawing control, you should make it yourself
Generally, you should first create a PictureBox, and then draw the curve you want in PictureBox.
The method of drawing a graph generally determines the information of the x and y axes, such as the value of the axis apex, the major and minor scales, etc., and then the coordinates of each point can be analyzed and drawn in the PictureBox.
This also contains some questions
1. Such as curve fitting: polyline, least square method, spline, etc.
2. Whether the curve should be adaptive in real time, which means that the curve always occupies 2/3 of the vertical axis, etc.
Regarding the oscilloscope display, you can set up a buffer queue, such as 100 points. If a new point enters, the last point is discharged. The queue always maintains 100 points, so that it can be made into an oscilloscope-like function
Regarding storage, you can store it as a Bitmap so that users can use it for analysis.
Regarding the storage of excel, can all the data of these points be stored in excel?