Using Advanced View Report to display external Data associated with SBM items
We are running SBM v11.2. We have an external database that is linked to primary SBM items in a workflow. Using the new reporting capabilities, I have been able to link these 2 databases for reporting. I can join from the advanced view table to the primary table using a relational field. However, I'd like to filter the results based on something in the primary table (State for example). I am unable to do this. The filter only works on the primary reporting table which is the view table. Does anyone have experience with this? I can provide further info if needed. Thanks!
Re: Using Advanced View Report to display external Data associated with SBM items
Can you add more columns (like TS_STATE) from the SBM primary table to the XML advanced view?