I want to create the fiscal week for the date.In my case the starting month of the fiscal year keep change it depends on user.

For that i need help. Above...

Msg 103, Level 15, State 4, Line 106

The identifier that starts with 'Dir Sales mACHOCodeLatestClear, mAC1CODELATESTCLEAR, mACDICodeLatestClear, mACSTCodeLatestClear, mPR3CodeLatestClear, mPR2CodeLa' is too long. Maximum length is 128.

Msg 105, Level 15,...

This what they designed in crystal report. If the column reaches the end on one side the next values is goes to the right side. After ending the page it...

This the formula they have written in crystal reports.How to implement this one in SSRS2008R2?

Formula:

Shared StringVar sNewBranch;

StringVar sPrintMe := "yy";

if sNewBranch = {@BName-BID} then

(

...

This the formula they have written in crystal reports.How to implement this one in SSRS2008R2?

Formula:

Shared StringVar sNewBranch;

StringVar sPrintMe := "yy";

if sNewBranch = {@BName-BID} then

(

...

can i use this with out using the first function? or This first function will take values for each group?

because on each group the value is displaying.

Mr. Green,The problem is it not showing the fields values in the header, Is coming under dataset,If i take from dataset it give the values with aggricate functions.

=iif(Parameters!Additional_Info.Value="Show",True,

iif(First(Fields!Control.Value, "CallSummaryGeneral")="G1",True,False))

This is showing error, It is taking in aggrecated like First(Fields!Control.Value,CallSummaryGeneral")="G1".