Incorrect data in webi report in Infoview; showing correctly in rich client report

[former_member1164714]

Hi Team,

For some reason we noticed that Infoview is behaving weird. The report when opened in Infoview shows some unwanted data for some fields but when open in Rich Client shows correct data

One of the example for such is below

I created a report in Infoview and found that Revenue field is showing unwanted data for a particular Request ID where actually it should be blank as per the database. When I opened the same report in Rich Client it shows correctly

For security reasons I cannot attach the files to show this but some thing like below is generated in Infoview

Request_ID Revenue

R0000094452 44$

R0000094452 100$

But in Rich Client it shows as blank for revenue which is correct

Request_ID Revenue

R0000094452

I checked below things but no luck

1) Clearing cache from browser

2) Creating new report in Infoview

3) Scheduling the Infoview report

4) No column level security applied

5) Compared both the SQL and are same

6) Not overridden server name in local host file. I checked and both are pointing to same database. I executed both the SQLs on the database and both query show no data for Revenue column

Users are constantly escalating on this issue. Your help is highly appreciated.

Thanks,

Mayuresh

[amitrathi239]

Is there any scheduled instance of the report? How users are opening the report by double click or right click view?

Have you tried with purging data and refresh again

[former_member203533]

Hello Mayuresh,

What are exaclty the sp and patch versions of both dHTML and rich clients?

My question is because recently I faced a similar problem.

The server was BO 4.1 SP10 FP2 and the rich client was BO 4.1 SP10 only, without the FP. The layout and computation values were very different.

Marcos

[former_member185603]

What is the DB for this report? The reason I am asking, When you execute the report from Rich Client, it uses your local TNS entries(In case of Oracle), where as in Infoview, it uses your server TNS entries. Make sure both the entries are same.