#Multivalue and # error in all reports.

Hello friends,
I have two same database and content on database is also same but whenever I point my both databse to BO server ,one of the database gives me #multivaiue and #error in all reports of Bo but another database doesn’t give me any error when i run the BO reports.So, I am not able understand its a formula related problem or database related.

Thanks


sudhirsilwal23 (BOB member since 2009-11-13)

Extract the SQL, wrap it in

SELECT COUNT(*) FROM ()

And check that the data in the two databases is really identical.


Damocles :uk: (BOB member since 2006-10-05)