Rudy,

I'm not sure what you are looking for here. Do you want to have ALL the data (parameter lists included) for a main report and subreports to come...

If you are doing this from work, does the corporate email server allow email to these addresses? Does the corporate firewall allow it out?

I don't think you can enable/disable parameters in SSRS. You could set the parameter values to a specific values like 'N/A' or something like that.

It sounds like you want the value in the child table to match one of the columns in the parent table. Can you explain the business case for this?...

Assuming that there are 2 values for IsNew (1, 0) you could use:

=IIF(Max(Fields!IsNew.value) = 1, color, other_color)

Select Convert(varchar(10), count(*)) from table

works for me.

Is the data in different datasets? What controls are you using on the report?

It looks to me that the reason is that the view has to materialize all the rows and then apply the filter, while the TVF is applying the filter as...

Both of these queries return the results you expect for the sample data provided.

SELECT

*

FROM

dbo.Temp_Models AS M INNER JOIN

dbo.Temp_Attributes AS...

Can you post the C# code calling the report?

Well, logically you can't AND the criteria together where you would like to do it. You can't have attributeid = 7 AND attributeid = 29. attributeid can only...

I am not in a java shop so I am not aware of any java plug-ins for SSRS.

Lynn Pettis (5/22/2009)

---

Jan Van der Eecken (5/22/2009)

---

Lynn Pettis (5/22/2009)

---

Plus, position and angles plays a role. People in the stands may see something that an AR or Referee can't simply...

Duh, why...

ason (5/22/2009)

---

CROSS APPLY is for table-valued functions. Function I use is scalar-valued. Problem is following:

query selects rows based join with orders table without user function; if user function is...