Thank you all.

I added another lookup transformation on "Matched output". That resolved the issue.

Thanks all for your suggestions. Here is more information on the table design etc:

I will need to create a report on below tables.

Order Facts Table has below columns:

ID bigint ...

Thanks.

Thanks a lot! This solution resolved my issue.

Adding this expression "=iif(Fields!FieldName.Value="All","Bold","Default")" helped resolving the issue. Thanks.:-)

When I tried to delete the items from code it gives me the following error:

Index was out of range. Must be non-negative and less than the size of the collection....

I used the following for the above requirement but it gives this error when I run the report : The DefaultValue expression for the report parameter ‘Month’ contains an...

Thanks.I'll read them.

That works!! Thank you

SELECT NON EMPTY { [Measures].[Sale Amount], [Measures].[Sale Reported], [Measures].[Avg Sale $], [Measures].[Upsell Count], [Measures].[Avg Serviced $], [Measures].[Avg Secs Triaged], [Measures].[Route Attempts], [Measures].[Inbound Call], [Measures].[Serviced], [Measures].[Answered], [Measures].[Short Call CC], [Measures].[Avg Secs...

can I use WTD function for getting weekly data? If yes can I pass date parameter such that I get that week's data?

Thanks for your reply but how would I set the formula to get weekly data and monthly data for a given date.

Sorry for not posting the question properly...I merged all the newly added fields with the old ones and aligned the header to centre. It solves my problem.

Thanks for your prompt answer. I'll will now work on setting up SSRS on my machine.

Thanks a lot , It works !