Hello,

Go to this link will Help you to pass multiple or All parameter value

http://www.bi-rootdata.com/2012/09/efficient-way-of-using-all-as-parameter.html

Hello,

Go to this link efficent way to pass All, Null , multiple value

http://www.bi-rootdata.com/2012/09/efficient-way-of-using-all-as-parameter.html

Hello ,

Look into this link common properties of charts

http://www.bi-rootdata.com/2012/10/chart-common-properties.html

Hello ,

Yes you can use fields from two datasets and merge into one report, For this SSRS 2008R2 and onward version provide us a function Lookuo, Multilookup and Lookupset...

Hello,

You can use lookupset function of SSRS for more detail see this link

http://www.bi-rootdata.com/2012/10/lookup-function-in-ssrs.html

Hi,

yes you can use two datasource SSAS and TSQL see these two links

http://www.bi-rootdata.com/2012/09/execute-mdx-query-with-tsql.html

http://www.bi-rootdata.com/2012/10/passing-multi-value-tsql-parameter-to.html

Hi,

Go to this link

http://www.bi-rootdata.com/2012/10/drilldown-dashboard-in-ssrs.html

Hi ,

Go to this link explained Look with example

http://www.bi-rootdata.com/2012/10/lookup-function-in-ssrs.html

Hi,

Go to this link look up explained with example

http://www.bi-rootdata.com/2012/10/lookup-function-in-ssrs.html

Hi,

Go to this link efficent ways to pass multivalued paramete using All

http://www.bi-rootdata.com/2012/09/efficient-way-of-using-all-as-parameter.html

Hi,

See this link might be helpfull to you

http://www.bi-rootdata.com/2012/10/lookup-function-in-ssrs.html

Hi,

See this link efficent way to pass the multivalue parameter

http://www.bi-rootdata.com/2012/09/efficient-way-of-using-all-as-parameter.html

Hi,

Try to to use Lookup() in SSRS

Hi ,

If you are using SSRS Reports you have to create two data source one for Cube and one for TSQL,

For more detail you can have look into this...

Hi,

Go through this link how to pass Multivalue parameter efficently

http://www.bi-rootdata.com/2012/09/efficient-way-of-using-all-as-parameter.html