Problem Displaying Header

[system]

Hello

i have created a report with prompts. The header of the table depends on the prompt value selected. the report looks good when there are all values. But when the column values are empty the header is also empty. can anyone help me with this. I need the header even if the value in the column is empty. Plz let me know if the question is not clear.
Thank you all

Regards
Jason

---

jasonclaude (BOB member since 2010-12-22)

[system]

Hi,

This Reporter’s FAQ can help:

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]

In the Column header put this formula

=If(isnull([userresponsevalue]);"some default column name";[userresponsevalue])

try with this formula

---

av_deepu (BOB member since 2010-08-11)

[system]

Hi

Thank you for your reply. But i would like to mention one more thing.
The header is the same for that table in all the section but it is not being displayed when there is no column value. I can manually enter the header name in the column but it is just for one report when i use this template and change the value of the filter i need to change the header according to it again in the report. So i want to know if there is any possible way to do this. I am really sorry if it sounds silly i dont know how else can i explain my issue better

Regards
Jason

---

jasonclaude (BOB member since 2010-12-22)