How to display the exact caption name for that condition in report studio?

[vignesvar]

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.

[akp]

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

[vignesvar]

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.

[akp]

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

[vignesvar]

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.

[akp]

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

[vignesvar]

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.