I thought you couldn't use Report Manager when Reporting Services is integrated with SharePoint.

We are building web apps to be used for our enterprise that will be integrated within SharePoint. Meaning, we will use .net code, web parts, event handlers and the...

We were considering creating table in SQL and handing permissions that way.

Yes, I am aware that SharePoint uses different accounts. It could be handled the same way in SQL. The problem we are having is configuration management and maintenance issues. There...

I don't know how to modify the query to add a where clause because it is in XML. Again, I have one parameter. That parameter appears in a drop down...

I am connecting to a SharePoint list for the y-axis values. I have the parameter added and it points to the appropriate column in the SharePoint list. To me, it...

😎 I'll have to do it on the client side. Thanks!

You're right! No need for the table variables. Your query works fine and I will replace mine. Is there a way to change the color when I replace the null...

I'm sure I'd be pushing my luck if I could also change the color of the text when the value was null! It would be nice.

I got it! Somehow something was misplaced when I tested it. But you had it right!!!! Thanks so much!

Lmred

I get the following error message:

The isnull function requires 2 argument(s).

YESSSSSSSS! 😀 I got it! I added select statements under the inserts as you said! This has been a pain in my neck! Thank you guys so much!

The problem is that I will not actually know what the data is. The data I gave was just sample data to give an idea what it would look like.