on 04-24-2014 7:05 AM
Hie Guys,
I'm running into a strange situation in my report. The report has 2 columns - Department Name & No. of employees. All the rows have values for no. of employees but some rows do not have values for department name. Any idea why this could be happening? Thanks.
Hi Jeewan,
As some of our experts said, it could be the issue with few of database records itself having no dept name.. Check with your source data first..
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Jewan, Firstly check your query in database.
If DEPT_NAME values are NULL in database, Just apply filter on DEPT_NAME at your report level and select all DEPT_NAME except NULL.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Jewan can you run your query in DB and see how many records you are getting , as you have the values at DB or not .
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Pandey,
I think Department name have null values... try filter on department and apply "is not null"..
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.