Well I found an answer in this forum (and others as well)that instaed of using Table I should use a rectangle:

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=150&messageid=130983&edit=failed

But stil there's a problem:

The report is with table...

Thanks u all.

Every day we learn something new

a sample of use with rs utility In BOL:

ms-help://MS.RSBOL80.1033/RSAMPLES/htm/rss_sampleapps_v1_1apd.htm

Thanks

Thanks,but still I didn't understand How can i deploy the RS files without the visual studio ???

Well I didn't try it but check the field visibilty...

Well to number your list u can use RowNumber & RunningValue Functions as shown in this forum:

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=150&messageid=212522

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=150&messageid=213425

Well,couse no one hellped me i did the hard work myself.

here the steps for this mission:

1) create ds with the all the mission for the week(each mission has a field...

Instead of 'Nothing' in the RowNumber function put the name of the group in the matrix as the error msg tell u...

I'm afraid 2 ask but did u wrote the fields of the ds in the table?

Well u can create a table row with the massege u want and add to the visibility property this code:

=iif(Fields!Group3.Value is nothing,False,True)

and for the other table rows the...

Well u can do it with Stored procedure ->send the db name as parameter.

+ in the sp use dynamic sql like: "SELECT * FROM " + @DB + ".tbl_name" ....

Well,I test it and the correct format is:

RunningValue ( Fields!Group2Something.Value , CountDistinct, "Group1_Name") & ". Fields!Group2Something.Value"

Note:

if u want 2 index group2 u shuold write the RowNumber("group1_name")

thanks

find refernce in:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSCREATE/htm/rcr_creating_expressions_v1_3quq.asp

Is there a trick in the RS himself 2 it???