Whether we are talking Bar charts, Pie charts, Curve charts, or Grid charts, they all have some common fundamentals that are required to work. These fundamentals are:
The type of the chart must be registered within the Reporting.tDiagramTypes table:
Then, in Reporting.tDiagrams, you can add a row that will translate into a chart in Link. In this row, you define which type of chart(diagram) the data will be represented by, what the chart will say in its header and Y-axis, which dataowner the chart will appear on, and what stored procedure provides the data for this chart.
In order to provide data to the given chart, a custom stored procedure must be created which provides data output in a format fitting the target chart type. Let us use the Grid chart type as an example with this sample custom stored procedure: It accepts 2 pieces of data per row, defined as 'Name' and 'Value.' This stored procudure is named "Custom.pDiagramGrid_Simple." Notice that this was the name defined in the image example earlier as the stored procedure assigned to that row.
Note: It is important to create these specific chart stored-procedures in the "custom" schema. Otherwise they might be overwritten/deleted in an upgrade of Link.
Content on this page:
Please note, these errors can depend on your browser setup.
If this problem persists, please contact our support.