crostab with missing columns after setting a master

[system]

i have developed a report using a crosstab, i my crosstab i have set
a master to group the results,unfortunately some columns do not seem
to appear in some groups(master) just because there are no related data in the group

would it be possible for me to have all columns irrespective of data being available or not

any help???

---

Frederick (BOB member since 2009-05-28)

[system]

Welcome to B:bob:B!

Which BO tool do you use - DeskI, Webi? So the topic could be moved to appropriate forum.

Thanks.

---

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

[system]

well, i actully use the Desktop Intelligence

---

Frederick (BOB member since 2009-05-28)

[system]

[Moderator Note: Moving to Desktop Intelligence - Jansi]

---

Jansi (BOB member since 2008-05-12)

[system]

Hi,

This is only possible if you can do it on the SQL level, it means some kind of left/right join.

Doing it on the report level is not possible. There is one workaround, have a look here:

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…

But unfortunately it does not work if you use filters of sections in the report. You understand that you do use sections, right?

---

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