Interested to Buy Any Domain ? << Click Here >> for more details...
why less number of records in loop?
why more number of records in traps?
- 1 Answers
- 3420 Views
- Wipro, I also Faced
- E-Mail Answers
Answer / manveer
More no of records in trap because:
For example:
A >- B -< C
( Employees >-- Showroom --< Salary)
- Each showroom has many employees
- Each showroom has many annual salary figures
The number of employee records should not impact the total salary on the report.
If a query is written that spanned all three of those tables the data from table A and C, there would be duplicated and the measure values would be exaggerated. For example,
- X rows on the left
- Y rows on the right
- X * Y rows in the combined set
Less no of records in loop as there is an extra join in a loop, that means one more restriction to the data. That extra join filter out the data and restrict the no of rows retrieved
| Is This Answer Correct ? | 0 Yes | 0 No |
Tow tables is there employee, projects . (many to many) one employee has different projects and one project has different employees . how we can achive the data from both
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
As im new to BO, tel me 1.How to do migration from BO6.5 to BOXIR2? 2.whats the difference b/w BO6.5 to BOXIR2. 3. whats the way both BO 6.5 n BOXIR2 file storge varies.
i want to hide a chart in reporting level? i want to hide a prompt in designer level?
What are the difference between merge,auto merge and extended merge ?
how to create a derived table in designer? i need steps regarding derived table
Explain the SQL Queries activated to data base from Data provider in BO ?
what is the different between link and join ?
What is report template in b.o?
What is the difference between the public object&schema object?
Explain what is the difference between business requirement document and use case document.
I am trying to save the XI report to CSV format. the csv file not displaying columns in order. all the columns are misplaced. the report size is 12MB Can any one tell me why the columns are incorrect position when XI report converted into CSV format?
Teradata 
