Now you need to add the where clause to the query (or queries) that serve your report, not the query that populates the drop down.

You've created a circular reference. Your parameter is based on a query that needs the parameter value to run. Using just

Select districtname,districtcode from district

should do the trick.

Here's a great link from Brent Ozar's blog that's full of good information for a fresh DBA. 🙂 There's also lots for a not so fresh one.

http://www.brentozar.com/sql/becoming-a-dba/

They can have local ones that they can use with their credentials. When deploying a report, however, ensure that the properties in the reporting project show OverwriteDatasource = False. Then...

Start reading about Kerberos security and hope that you have an admin who can help you out with this. The problem you are experiencing is called the double hop problem....

Not sure this will make any difference, but have you recreated the datasources?

Also, are you sure that when the olap database was recreated the user account was created and...

If it was me, I would probably add a little logic to the query producing the data that orders the values the way you would like (ie adds a field...

Just wondering if a rebuild of the package resolved the issue for you? I've had 2 instances where processing fails with a similar error.

Border colours were nothing, i recreated the table within one table instead of several tables sitting adjacent, all the same problem. Just out of curiousity, I changed the row heights...

Thanks Jack.

I actually tried running the report again to see what was actually throwing up the 100% CPU usage. What I got was the results back in 3 seconds...

I'm just guessing that there is something in your count measure in SSAS that isn't just a straight count. If it was, then I would assume that adding the...

defaultstartdate and defaultenddate need to be calculated in a separate data set from your report data set. What you have defined in your query is that the parameters you...

Do you mean:

IIF(Fields!ID4.Value = Fields!Three.Value and Fields!ID4.Value = Fields!Two.Value,"YELLOW","BLACK")

What about Report Builder?

Awesome. Thanks for that. Much appreciated.

Michelle