I found an answer from another Microsoft forum.

http://social.msdn.microsoft.com/Forums/sqlserver/en-US/54f694c9-4d69-4607-8156-e3afd8257d5e/report-builder-30-how-to-display-all-months-in-xasis?forum=sqlreportingservices

sorry

Thanks Mr. Jack you are right on the money.

That solved my issue.

Thank you all I will try this tomorrow. I was getting ride of the (0), but I guess it should be (3)

for open/completed/closed.

I am having the same issue here.

my parameter list is from a dataset and I do have 'Allow multiple values' selected.

I do have the parameter filtered by the dataset field....

I have solve my issue. I did not need Execute SQL Task. I used sqlcommand

day 1 will be 2 January since 1 is a holiday. I have already updated the table with all US holidays and my company holidays.

Thanks

Thank you sir, All I want to do is just populate the [BusinessDay] column on my table sequentially(1234...) if a day qualify as a business day or workday(MTWTF). Thanks

Thank you all it was all helpful

I think I solved my issue, it was from my data it needed some clean up

do you really need to debug the CLR? No

All I want is to test it.

why not just deploy the project, then test it in q window for known...

Thanks will look into it. The first one seems good for me

i found a help here Thanks

http://www.sqlservercentral.com/scripts/Date/68389/

maybe that is the best way to go, yearly. can you please guide me through it.