All data not showing when variable is added.

[system]

I made a report that shows a list of records and everything showed up just fine. Then I wanted to add another variable that does not always have data in it. The problem is that when the new variable is added, the whole report only shows records that have data in that new variable when I want to see all of them regardless if there is data or not.

Does anybody have a solution?

Thanks

---

Brandon (BOB member since 2005-09-12)

[system]

Hi did you try searching in this board regarding this. You have plenty of posts for this. Try using additional data provider(text file of excel whcih contains all the values for the “New Variable”) and link them. Check these posts it might be helpful.

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------…

---

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

[system]

Brandon – another suggestion. This General Discussion forum is for discussing topics that don’t quite fit into one of the many other more specific forums.

I suspect you are asking a question about a particular reporting tool. You will get better answers if you tell us which tool and which version – and we move this topic to the correct “Building Reports” sub-forum.

---

Bobarella (BOB member since 2004-02-12)