add the column in crosstab

[system]

Hi,

We have a requirement in our project i.e we have taken Pole name object in the cross-tab the values are coming.

But those columns whaich are having values are displaying , I need the columns which are not having values are also should display in the report with blank cells.

Is it possible in xi/R3? Give me the sol.

Thanks,
Akki.

---

gowri.akkiraju79 (BOB member since 2010-05-12)

[system]

Hi,

This entry in the Reporter’s FAQ should get you started:

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)