Displaying all LOV's

[system]

Hi there

I am using Full Client BO6.5.1.

I am trying to produce a report for all departments in my org. however because there are no figures for Governance, the Governance report comes up blank and in my Summary report, Governance does not appear at all.

I would like the heading (Governance) and zero’s showing.

Does anyone know how I can get this to display?

Thanks in advance
Michelle

---

micboy (BOB member since 2005-06-08)

[system]

Hi Michelle,

You can use additional dataprovider displaying all the departments in your organizations. To be more specific, create a data provider using perosnal file like excel which has all the department names of your organization. Now like this with the data provider you have in the report.

try searching in the BOB for words like “Displaying Null Values”.
Also try this link if it helps…

Need Help on Null Values.....

hi everyone, I have a report where i display the "Count" of submissions done everyday. So what i have done is, i have created a group with options "for each day". (ie) Sample Data, [i:97509e68f0][b:97509e68f0]Date---------Submission[/b:97509e68f0][/i:97509e68f0] 1-Mar-05--------------4 1-Mar-05--------------5 1-Mar-05--------------2 2-Mar-05--------------1 2-Mar-05--------------4 2-Mar-05--------------15 3-Mar-05--------------1 3-Mar-05--------------21 3-Mar-05--------------2 4-Mar-05------…

hope this helps.

---

Raja Saripalli (BOB member since 2005-12-14)

[system]

Thanks for your response. I will give it a go!

Cheers
Michelle

---

micboy (BOB member since 2005-06-08)