Please post your T-SQL query if possible ?

And also try to use SQL Server profiler to get the exact query being passed along with parameter values selected to the database...

Lucky's (10/4/2012)

---

Hi,

I have a multi value parameter in SSRS report which has a list of values around 600..When the user selects 'SELECT ALL',its passing the long list of values

to...

Please refer to this post created by you:

http://www.sqlservercentral.com/Forums/Topic1370073-150-1.aspx

cnirosky (10/8/2012)

---

From my reading of the Report Definition Language Specification, tag nesting down to the Body element should look like the following

<Report>

<ReportSections>

...

kothakeerthi (10/8/2012)

---

1. can I take 1 source from table and other source from SSAS cube and do the "Report Server Project"

2. can I take 1 source from table and other...

I followed the exact same steps to achieve the required output.

But i was trying to do the same thing as you mentioned of achieving it 'without using a staging table'.

I don't know how to do it.

If...

Maybe the value of "Fields!AppointmentLetterStage.Value" changes within the rows of the tablix.

Check for its value which maybe includes integers as 1,2,3,....

It's set in the subreport properties in the master report.

Can you share the sql query and maybe screenshot of the matrix report you have created ?

That may help to suggest the sql query.

ByronOne (9/20/2012)

---

Hi

I have a Matrix table in SSRS 2008 which shows sales data for the past ten financial years. The table consists of Financial years across the top (columns), sales...

It depends on what you need to do.

There are two different cases as follows and also in my earlier post:

Case 1) You can use the lookup/lookupset function in SSRS 2008...

Here's what I have in the hidden property for each sub report:

Sub report 1: =(Fields!field.Value <> 1)

Sub report 2: =(Fields!field.Value = 1)

The field is an int field and can...

You can use the lookup/lookupset function in SSRS 2008 to access data from different data sets.

Also you can get aggregated data from different data sets using aggregation function like this:

=Sum(Fields!Balance.value,...

Maybe this is silly but i only knew the following way to do it :

Suppose there are prompts called 'Year', 'Half Year', 'Quarter', 'Month' and 'Week'.

So the dependency of prompts...