If you are unable to create a new account, please email support@bspsoftware.com

 

Any explanation for different results of Cut/Paste vs Drag/Drop of data items?

Started by FerdH4, 23 Jan 2019 01:55:28 PM

Previous topic - Next topic

FerdH4

In testing some JOINs today, I found that I get VERY different results in the third query's joined result set depending on whether I (a) Copy-and-Paste data items from either of the primary and secondary queries into the third/JOIN query versus if I instead (b) use Drag-and-Drop to populate those same data items between queries.

When I Copy-and-Paste data items between queries, the JOIN results are wrong.  The results include too many and unintended rows.

With the exact same JOIN and cardinality defined, the results are correct when the data items are instead Drag-and-Drop between queries.

I've thrown my results away and started from scratch to recreate the results.  I'm convinced there is somehow a difference between the Copy/Paste and Drag/Drop actions.

Anyone have any experiences of same?  Anyone have any explanation for the difference?

Thanks All.

CognosPaul

Are you joining the queries locally in report studio?

Look at the expressions of the items when you drag them in versus when you copy them in. My guess is they're not exactly the same objects. Can you post the report XML with both queries (one with the dragged items and one with the copied)?


FerdH4

Yes, the join is happening inside the report.  In this instance, the data is not joined in the framework data model.

Thank you for the hint CP.  And, thank you too for the offer to look into the XML for me.  Let me see what I can learn alone - using your hint - and I'll take you up on that answer if I am stumped or my findings are in same way contrary.