u201CCannot drop here. Incompatible Objectu201D
To start out I should mention that I am new to Data Analyzer and not all that proficient in SQL. We just stated using this as part of our association management software. Anyway here is the problem I am having:
A couple times when I try to add a query and then try and combine the two queries I drop the field I want into the original table and nothing happens. I noticed that when I hold it over that table a box appears that says u201CCannot drop here. Incompatible Objectu201D. I first created a query in the meeting universe by displaying the u201Cproduct codeu201D, u201Cregistrant master customer IDu201D, and u201Cregistrant last first nameu201D and I filtered it by the product code. The second one I built in the committee universe by displaying the u201CCommittee Label Nameu201D, u201CCommittee Member Master Customer IDu201D, and u201CLast First Nameu201D and filtering on committee class code to pull out all of our committee members. I ran the query so that both tables are in the same tab. Now what I want to accomplish is to show all of the people who registered for the meeting and what committees they are in. Since some of them may be in more than one committee I wanted to drag the u201Cproduct codeu201D field from the meeting universe so that it would display the code next to the members name for each committee he is in. It is when I try to do this that I get the above error message. I know I need to link the ID fields because they have different names but it doesn't matter if I do this before or after trying to add the field to the table.
As part of this same query I also want to do the same thing with the membership universe to find out what sections they belong to. I received the same error when trying this except when I tried moving the field for u201Cbase unit priceu201D rather than the u201Cproduct codeu201D from the meeting universe and that worked. I was then able to identify all the section members because they had a $ amount next to their name. Since there are no $ associated with committees though I need to be able to do it another way.
I appreciate any help that you can offer.
Edited by: Scott Golonka on Sep 12, 2008 10:11 PM
Object incompatibility can be resolved by creating a variable equal to the universe objects but you need to change the type to Details. Then you can use this variable objects in the report. This is often used when you don't have objects to merge. And can help avoid the usage of a second data provider.