Hi chaps,
I'm using cognos 10.2 for creating reports. Getting correct result while performing resource wise report. But when i create a report based on client wise getting client name from data base in sorting order wise "a-z" not for that particular filter. Even I got a client name who was expired in our organization. How to resolve this issue to display name with suitable condition?
Reply quickly Thank you in advance.
Hi Vigneswar,
There are two things in your query, if I understood properly.
1. You may be getting expired clients because you have not filtered that out in your query. Add a filter to remove all unwanted clients.
2. You can override the sorting, whatever data is coming from the db. Add desired sorting on the required column.
--
Sapp
Hi Sapp, Thank you for your response. I put a filter for yesterday report only. Then applied sorting for that results. Even I forgot to mention that I got a report were correctly. I got wrong result recently. Even I got exact result resource wise applied same filter and sorting. I was checked my properties too both resource and client but I got a exact result in resource not in client. Help me.
Hi Vignesvar,
If you think you have added filters correctly and have applied the correct sorting order, then I will need some more details on what you have done, what is the actual output and what is desired. If you can provide some test data to illustrate your issue, I will be more than happy to help.
Thanks,
--
Sapp
Hi sapp,
I am getting yesterday report like x as a person working for a company xyz for activity as 12 in 4 hours, person y worked 5 hours for activity 13 for company xyz. now my report will be
company activity hours
xyz 12 4
13 5
This is my expected report but i'm getting like
company activity hours
abc 12 4
abd 13 5
...
xyz - -
I got my expected report early but recently i'm getting wrong report. It is happening only my client wise report not for resource wise report. I have using 3 more report based on client everything as display as wrong report. Thank you sapp.
Your issue looks normal and putting a single filter on Company = XYZ should give you correct results.
Pls check if you have made any other change that is impacting the existing filter. Any other filter on the query which is over-riding this filter.
Thanks,
--
Sapp
Hi sapp,
I clearly made only one filter active till now. If that above condition is satisfied only that client. I need overall week performance by client wise. One more thing I was create exact resulted report based on client wise. But now that file too getting wrong report. Help me Thank you.