Desktop Intelligence 12.1.0.882 - Show Fields in Report

[system]

Good morning together,

I generated a report which shows me the throughput and further KPI of a set of machines for a specified timeframe. The report is arranged as cross-table-report, showing the machines in vertical and KPI in horizontal alignment. All KPI base on throughput.

Now I got the problem that machines, which did not provide throughput within the regarded timeframe, are not shown in the report. I would like to see these machines anyhow, stating a value of zero for the throughput.

Can anyone help me to solve this problem? How can a fix the stated machines for this report?

Thanks in advance.

---

Bisar (BOB member since 2008-02-25)

[system]

Hi,

This reporter FAQ entry describes it:

FAQ: Reporter

How can I include data for all months in a crosstab, even if a particular month has no data? One way to do this is to create a second data provider using only the months. Then link (or “merge”) the second data provider (query) with the first data provider. Use the month column from the second data provider in the cross tab. This should bring in all months even if there were no data for that month. However this technique does not work if you have sections in your report. Dave Rathb…

---

Marek Chladny (BOB member since 2003-11-27)

[system]

Hi Marek,

thank you for your hint. The hint solved my problem.

---

Bisar (BOB member since 2008-02-25)