Discussions
Categories
- 196.7K All Categories
- 2.2K Data
- 235 Big Data Appliance
- 1.9K Data Science
- 449.8K Databases
- 221.6K General Database Discussions
- 3.8K Java and JavaScript in the Database
- 31 Multilingual Engine
- 549 MySQL Community Space
- 477 NoSQL Database
- 7.9K Oracle Database Express Edition (XE)
- 3K ORDS, SODA & JSON in the Database
- 532 SQLcl
- 4K SQL Developer Data Modeler
- 186.9K SQL & PL/SQL
- 21.3K SQL Developer
- 295.4K Development
- 17 Developer Projects
- 138 Programming Languages
- 292.1K Development Tools
- 104 DevOps
- 3.1K QA/Testing
- 645.9K Java
- 28 Java Learning Subscription
- 37K Database Connectivity
- 153 Java Community Process
- 105 Java 25
- 22.1K Java APIs
- 138.1K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 17 Java Essentials
- 158 Java 8 Questions
- 85.9K Java Programming
- 79 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.2K Java SE
- 13.8K Java Security
- 203 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 395 LiveLabs
- 37 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.6K Other Languages
- 2.3K Chinese
- 170 Deutsche Oracle Community
- 1.1K Español
- 1.9K Japanese
- 230 Portuguese
Report - Analysis - When I add new criterium, shown record would multiply
Hi, I am using Analysis in Report and Analytics to create a report, that uses data from two subject areas (Sales - CRM Account Relationship and Sales - CRM Contacts). I connected it according to documentation. It works, but there is one problem. When I need to add some of the fields from the second subject area as a new criterium, the records will multiply and it creates more rows than before adding new criterium.
I need to add another criterium, it should add chosen value from fixed choice list, but it will create a record for every value of this fixed choice list. Same goes for checkbox and even text field, but not for every field.
So it left me with something like this.
id - name - date - job title
033 - Peter - 130220 - sales rep
033 - Peter - 130220 - configurator
033 - Peter - 130220 - manager
033 - Peter - 130220 - developer
033 - Peter - 130220 - director
But when i look into contacts, there is one chosen value "developer". So it should be only one record in report just like this:
033 - Peter - 130220 - developer