What are your goals? Those will define where you should go next.

I have both the 2005 and 2008 BI certification books. They're basically the same thing,...

adam spencer (9/10/2009)

---

Thanks, I will try that. So its not me, its SSIS.

so as a whole, do SSIS users like SSIS ?

I want to think so, I am excited to...

My solution would entail database-level alterations that would only be necessary if dynamic SQL was completely out of the question. I'm glad you found a better solution.

SSRS is passing the string to the procedure such that it's looking for a state value of 'IL,KS,MI '. Since that state doesn't exist, you're getting nothing.

I find that...

Is the multi-value parameter a predecessor in a series of cascading parameters, or is it the last parameter you have to select?

In any event, if your drop-down is selecting 24...

There was a great set of reports for the Execution Log included in the Microsoft Press Step by Step book for SSRS. It had an accompanying SSIS package that...

Are they parameters? If so, use the parameters object (Parameters! .Value).

You can determine the color of the row in the query, and return it as a field in the dataset. Then set the color property of the cell/row to...

I just wanted to...

Yes, it is possible in SSRS 2008. You will do it using textbox placeholders. I don't have 2008 in front of me to walk through it, but you'll...

Assuming you have a SQL data source, you can create a dataset using this query:

selectdateadd(mm,datediff(mm,0,getdate())-1,0) [FirstDate],

dateadd(dd,-1,dateadd(mm,datediff(mm,0,getdate()),0)) [LastDate]

It will return the first and last day of the previous month. Tie...

Check the width of your report, and any subreports you have. I've experienced the problem with random blank pages when the width of the report layout was more than...

It's interesting that the page break options on the group aren't working. That would be worth looking at.

But if you don't find anything, you can put your...

It's likely that your misspelling of 'Silver' is causing the report to show no formatting.

Is the parameter you're sending multi-select, and does its available values depend on another parameter? If so, set the default value of the parameter to non-queried, with a value...