Hi,
I have to create a report with multiple data provider and I have questions:
I am linking the 2 with Account #.
One data provider has detaila bout the account and the other has details about the orders. So When I select all the account details in DP1, I cannot seelct everything I want in DP2. Why is that. The objects are greyed out.
Can someone help me with this?
I know it is basic but I need to get these greyed out values out.
There’s a lot of information about this in the archives. For more details do a search on linking data providers. Basically you have to create variables in the report that are equal to the grayed out ones and create them as details rather than dimensions and link them to account # as a dimension. Then you can put them in your report.
Thanks!
but the problem is that if I tried to create these objects as description it is not going to work with I have more than 1 value per dimension. Like for ex I have an account # that has 2 products. If created product number has a description of the Account #, it is only going to give me one product#, not 2, right?