Yes the rectangle was originally at Is the rectangle at position (0,0). I tried to change the location to (0.5, 0.5) and had the same problem. Thus I put...

When I try: PATINDEX('%[0-9][0-9][0-9]%', CalendarId), I get the error message, "Msg 8116, Level 16, State 1, Line 2

Argument data type int is invalid for argument 2 of patindex function."

Thus...

The textbook that I am asking about is located in a summary row. I do not another column to a detail report when it is not needed.

So you are saying that I can not hide the column, but I can keep from showing any values in the column, correct?

What do you want to see from the dataset? I have supplied the sql that I am planning to use.

I tried to use the following in the visibility property of the tablix:

=iif(CountDistinct(Fields!AdminGrade.Value,"Main") > 0, true, false)

and

=iif(RowCounts(Fields!AdminGrade.Value,"Main") > 0, true, false), I am getting the opposite results of what...

thanks

found answer

After I saw your answer, I split the ssrs report apart. I found that I had set the body border properties incorrectly.

got the sql to work

Thank you very much for your answer! It works fine.

Can you tell me what is wrong with the cte that I was trying to use?

I read the article. I am not certain what else you are looking for. Can you point me to a post that is well written so I can understand what...

Here is the additional info you wanted to see:

1. here is the Inventory table with some data.

SELECT [InventoryID]

,[personID]

...

can you explain what you mean by "IIF(Parameters!hairProduct.value = "", "", " and hairproduct in (@hairproduct);"

How does this solve the question when there are no hairProducts and when there is...

The user wants me to display 'NO State' if the value is null. There are cases where the value is NULL since this is based upon vendor software application.