Thanx for your suggestions,

I think its better to go for sub report here and i cant implement sql functions,

data source is microsoft dynamic CRM.

Actually i have to use this data...

thanx for your reply but i have to do changes in SSRS only not in Data base.

when we compare all the fields of result set it is unique

from there i...

Yes i have done the same.

Thanq I got Your point.

Thanks for u r prompt response,

Here my time dimension table columns are given below

Date_ID

Date

Julian_Date

Calendar_Year

Financial_Year

Calendar_Quarter

Calendar_Quarter_ID

Calendar_Quarter_Name

Financial_Quarter

Financial_Quarter_ID

Financial_Quarter_Name

Season

Calendar_Month_ID

Calendar_Month_Number

Month_Name

Month_Abbreviation

Financial_Month_ID

Financial_Month_Number

Calendar_Week_ID

Calendar_Week

Financial_Week_ID

Financial_Week

Day_of_Calendar_Year

Day_of_Financial_Year

Day_of_Month

Week_Day_Number

Week_Day_Name

Week_Day_Abbreviation

Is_a_Weekend_day

Is_a_Public_Holiday

Is_a_Leap_Year

Is_a_Special_day

Days_In_Calendar_Year

Days_In_Financial_Year

Weekdays_In_Calendar_Year

Weekdays_In_Financial_Year

Workdays_In_Calendar_Year

Workdays_In_Financial_Year

Days_In_Calendar_Year_Sofar

Days_In_Financial_Year_Sofar

Weekdays_In_Calendar_Year_Sofar

Weekdays_In_Financial_Year_Sofar

Workdays_In_Calendar_Year_Sofar

Workdays_In_Financial_Year_Sofar

Days_In_Month

Weekdays_In_Month

Workdays_In_Month

Days_In_Month_Sofar

Weekdays_In_Month_Sofar

Workdays_In_Month_Sofar

in this Date_ID column is unique id.

now i have to join with fact table having column start_date.

for...

correct answer is :

Create Table MyTable

(

mainkey int not null identity (0,1)

)