Upside down question marks

building reports desktopintelligence
1

We are seeing upside down question marks in a field that do not appear in the database. We originally first experienced this issue when testing the report in version 6.5.1. When upgrading our full client environment from 5.1.6 to 5.1.8, the issue has also appeared. This is a critical problem as it affects personnel report.

B…

bobjkb :india: (BOB member since 2004-03-19)

2

could you be more precise about your “Upside down question marks”.

when it occurs exactly ? what is the question ? could you add a screen cap in attachment ?

bernard timbal :fr: (BOB member since 2003-05-26)

3

I am attaching the report so that the problem would be clear.

Thanks in advance.
B…

[Moderator Edit: Note that you can only view this document if you have version 6.x of BusinessObjects. So don’t bother to download the attachment and virus-scan it if you only have version 5.x - AMC]

bobjkb :india: (BOB member since 2004-03-19)

4

Any insights on this … need urgent help regarding this.

B…

bobjkb :india: (BOB member since 2004-03-19)

5

hi babbu,

how is the data stored in the database ? did you do a direct query on the database and check if you get the same results ?

regards
B D’souza

bdsouza :australia: (BOB member since 2004-11-10)

6

The query at the database gives the correct values and the problem is only with the report.

B…

bobjkb :india: (BOB member since 2004-03-19)

7

Try to run the SQL query which is generated by BO in Free hand SQL. Then check if you are getting the same problem.

venira :india: (BOB member since 2004-12-07)

8

Is it a particular character got converted to" ¿ " Or randomly it got appeared ?

What is the desrciptiuon of the Dimension “”

mada :denmark: (BOB member since 2004-11-25)

9

Is it only nulls being changed to ¿'s? Only 0’s?

Check Number Format in the cell formatting to see if ¿ is being used at all.

Paul Williams :uk: (BOB member since 2002-07-10)

10

Hey all

Thanks for all your suggestions. i was able to resolve the issue by changing the datatype at the database end.

Thanks
B…

bobjkb :india: (BOB member since 2004-03-19)

11

babbu,

just for information, what was the previous data type and the present?

xen :india: (BOB member since 2004-11-13)

12

Hi,

Same issue here. Thought the universe is internationalized to the dutch, we are getting inverted question mark in the report for the non-english dutch characters.

Please let me know how to do this without changing the DB schema.

Regards,
Gurum

gurum (BOB member since 2010-07-14)

13

Perhaps this article can shed some light on the issue ?

Peter

pderop (BOB member since 2010-10-27)