Can Use Fieids of diffirent datasets in a matrix ?

Can Use Fieids of diffirent datasets in a matrix ? SUM(Fields!a.value) is invalid?
Field a is in the other dataset!No, fields from multiple datasets are not allowed in a single dataregion. This would require a cross-dataset join, which is not supported. It is something we would like to add at some point in the future.|||The last message on this thread is from late 2005. Has this feature (cross-dataset join) being supported now? Thanks|||This relates to a similar post of mine...

Is it not possible to dynamically decide which dataset a table will use ?

sql

Can Use Fieids of diffirent datasets in a matrix ?

Can Use Fieids of diffirent datasets in a matrix ? SUM(Fields!a.value) is invalid?
Field a is in the other dataset!No, fields from multiple datasets are not allowed in a single dataregion. This would require a cross-dataset join, which is not supported. It is something we would like to add at some point in the future.|||The last message on this thread is from late 2005. Has this feature (cross-dataset join) being supported now? Thanks|||This relates to a similar post of mine...

Is it not possible to dynamically decide which dataset a table will use ?

Can someone please explain this to me...

why do the following return the same datasets?

select * from myTable where myData = ''

select * from myTable where myData = ' '

in the first I'm specifically searching empty strings, in the second a sequence of five spaces. Yet both return any and all white character matches? Is this a "feature" of SQL...

P.S. I'm using T-SQL

This should work. Check it out

select * from myTable where myData = '';

select * from myTable where myData = SPACE(5);

|||

Yes, trailing spaces are not significant (nor stored) in varchar fields.