Interested to Buy Any Domain ? << Click Here >> for more details...
How to solve the following errors coming in report development?
1.Syntax 2.multi value 3. #Error 4.computation and 5.Objects
are not compatible
- 2 Answers
- 7157 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Syntax error: As the name indicates, check the syntax of
the formula used.
Multivalue error: Use some aggregate functions such as Max
(), Min(), Sum(), etc... (but that mainly depends on the
requirement)
#Error: This can be solved by checking the formula. For
e.g. If one has a UserResponse function like this.
UserRepsonse("DP1","Enter a date") and if the date format
id mm/dd/yyyy, then the following formula will lead to
#Error.
ToDate(UserRepsonse("DP1","Enter a date"),"dd/mm/yyyy")
This can be solved by using "mm/dd/yyyy" instead
of "dd/mm/yyyy"
Computation error: This error occurs if we don't have a
required object in the block. Sometimes we don't want a
particular object to be visible. In that case, to avoid
computation error, just include that object in the block
and hide it.
Objects not compatible: In this case, try creating detail
objects and associate them with the necessary dimensions
and instead of placing the objects, place the newly created
detail objects.
| Is This Answer Correct ? | 6 Yes | 2 No |
Answer / vidya
Multivalue Error: while connecting from dimension to fact
it should always be one-to-many only, if this logice is
handled improperly we may come across this error.
Objects are not compatible: This error occurs when
connecting more than one dataprovider,datatypes of both the
objects(dimensions) to be joined or linked to produce a
single report should be same.
| Is This Answer Correct ? | 0 Yes | 0 No |
What is the difference between Thin client & thick client?
Explain how to schedule the report in b.o?
what is confirm dimension ?
how can i add two different reports in the same document?
What is metrics?
Did you face any problems while creating reports? Name? Solutions?
hi,in crystal report xI after select stantderd report Data window appear when ever i click Repository folder it ask me system/user name and p/w and when ever i put my info it says:Tranport falier :comunication error,can any body tell me what to do i already reinstall this s/w 3 times(every thing is working with same user name and p/w like xcelsois,webi,deski,desinger,cmc u name it..thanks
Can we create universe with no cache??
how to do scheduling in desktop intelligence in BO XI R2
how to creat 2 way drilling mode.can any one know this
TILL WHAT LEVEL OF SECURITY BO SUPPORTS?
IN THE REPORT I WANNA APPLY HYPERLINK FOR A CELL IN THE COLUMN/ROW HOW TO ACHIEVE THIS? EG: YEAR COLUMN : 2001,2002,2003,2004 I WANNA APPLY FOR 2001 ONLY
2 Answers Accenture, Rolta, TCS,
Teradata 
