Or hide the column instead of the whole group. Right click the column header and select Column Visibility.

Maybe instead of expressions to hide the columns based on the param value, leave the columns visible but set the field expression to only display data based on the parameter....

It'll do that -...

Cool! Thanks!

You should be able to query the ReportServer database to find what you need. I don't have access to a report server right now so I can't give you...

Never give up! The entertainment value is priceless! 😀

Edit: In retrospect I realize this probably sounded snotty and/or demoralizing. What I meant to convey is that...

Mebbe just join on the LEFT 12?

select left(Sub, 12), P_NAME

from dbo.mydb (nolock)

where left(Sub, 12) = @SUB

or if the parameter is longer than 12...

where left(Sub, 12) = left(@SUB,12)

im_lanie (5/10/2012)

---

You might want to try using a group expression that groups by Month if the Year is current year Else group by Year. Your dataset would have a...

The data sources must also be deployed to the report server.

It is most likely a divide by zero error.

Add custom code to rdl (report properties --> code pane):

Public Function DivideBy(ByVal Numerator, ByVal Denominator)

If Denominator = 0 Then

DivideBy =...

pdanes (5/10/2012)

---

I tried it and I do get only three rows, but what determines which one is returned by the RowNumber function? Or rather, what does the RowNumber function mean?...

Take a look at the Stairways - Stairway to Reporting services on this site

http://www.sqlservercentral.com/stairway/72382/

Books on line are pretty good for this subject

Add custom code to rdl (report properties --> code pane):

Public Function DivideBy(ByVal Numerator, ByVal Denominator)

If Denominator = 0 Then

...

Looks like the Gurae have not responded, so you're stuck with me.. 😛

To show a list of the selected parameters, you'd use field expression:

=Join(Parameters!Project.Value,", ")

or to show the labels:

=Join(Parameters!Project.Label,",...

Might be a divide by zero error. See the 3rd response (from Toolman) in this post:

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