What's the easiest way to pass the results of a multi-select parameter to a SP? If this was as straightforward as it is with an embedded text query, I'd...

Thanks for attaching examples - that was helpful.

If I were faced with this requirement, particularly having to use SSRS 2005, I would probably do all the subtotaling and totaling in...

Hi Krishna, try this:

Chart Properties > Values: select dataset > Click Edit button > Appearance tab > Series Style button > Fill tab > in Color textbox, enter expression such...

What about SELECT LEN(column1) AS totalCharacters FROM table1 ?

Can you use =Len(Fields!Cell1.Value) ?

Robert Livermore (3/8/2010)

---

Becareful following the CASE statement syntax in the examples provided in the article. A string enclosed in quotation marks used as a column alias for an expression in...

Hi Mikey,

One option, though not sure how pretty, would be to set Boolean-valued report parameters for the visibility of the tables, then set the Visiblility > Hidden property on the...

WardyWonderland (1/27/2010)

---

The user can then select a value from each of the dropdown boxes depending upon what action they have taken with that account. That value should then kick off...

Go to chart properties > Data tab > select values group from Values list > Edit button > Action tab > Jump to report > select drillthrough report > Parameters...

Provided the dataset for Parameter 3 is driven by the selections for Parameters 1 and 2, probably all you need to do is make Parameter 3 a multi-value parameter, and...

Hi Scott,

Would it work if you use =GetAvgDurationAsHHMMSS(secs, CountDistinct(Fields!LOAD_ID.Value)) as the expression in your textbox at the group level, and then something like this in the Code:

Function GetAvgDurationAsHHMMSS(ByVal TOTALSECS As...

Hi Gugan,

There are several approaches to this type of requirement - you may find it most maintainable to build the custom aggregate into your SQL query (if possible). Martin...

Yes you're right, in SSRS 2008 it is the PageBreak property on the tablix. If that is set to Start it would explain the behavior you're experiencing. Otherwise, I...

Maybe someone else can help you there - I am learning SSRS through doing it.

Glad to help though!

Hi Bart,

Do you have the KeepTogether property set to True on your table? If so, that could be what's causing the table to start on a new page. You could...