cross tab

[system]

We have a report requirement where the user wants to see all the rows in crosstab irrespective of associated data availability

---

vasanth (BOB member since 2008-06-05)

[system]

Hi,

If I understand your requirement then this Reporter’s FAQ will help you:

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]

for example, will create object with if else statements and display some text depending on the conditions.
if we dont have data which satisfies conditions still we need to get all texts mentioned in object

---

vasanth (BOB member since 2008-06-05)