Not exactly sure where your issue is cause I cannot see what the issues is, but here's a guess.

In your report I think you need to create a row group.

(Right...

I could be wrong but I believe the answer to this question is Nope..

The CanGrow and CanShrink properties on any textbox only affects the Vertical Size of the text box....

Do you mean for example your showing sales of products last month. and If no Red bikes were sold its not showing up on the report, but you would like...

ReportItems are individual items.

You need to be summarizing the values in that textbox

IE SUM(Fields!MyValue.Value)

Are you using the image control from the toolbox?

the Image source should be external.

The Expression should be something like.

="/Images/" + Fields!EmployeeID.Value + ".jpg"

The reference to the image cannot be a...

For start date to always get Previous Month Use

=Datetime.Today.AddDays(-Day(Datetime.Today)+1).AddMonths(-1)

For End Date to get Last Date of Previous Month

=Datetime.Today.AddDays(-Day(Datetime.Today))

There are a few ways to handle this.

You can leave the report with StartDate and EndDate Parameters.

Edit the report and give the Parameters Default Values.

StartDate will be =Datetime.Today.AddDays(-Day(Datetime.Today.AddDays(-1)))

Will be the...

I do not believe there is a way to create a table variable dynamically.

Can you elaborate more on what problem your trying to solve?

Try the setting the Rowcount.

DECLARE @t INT

SET @t = 1

SET ROWCOUNT @t

SELECT *

FROM MyTable

DECLARE @t INT

SET @t = 220

SET ROWCOUNT @t

SELECT *

FROM MyTable

Sorry, I didn't run this

SET DATEFORMAT dmy

Change the date strings to follow your dmy format,

Or run this.

SET DATEFORMAT ymd

Try using a table of dates.

Code posted here Creates a table variable with dates in it, however you can/Should have a table of dates,

They are great at helping solve problems...

=Iif(Left(Fields!summary_name.Value, 3) = "CH_" AND Fields!MY.value < 0.9850), "RED","BLACK")

My $.02.

If your tables are modeled and indexed correctly then joins are a necessary evil.

Your sample 2 uses a correlated subquery, and I believe this is more costly than a...

You cannot sum in this manner,

So you should do the sum in a derived table.

and Once again you were trying to left join to t2 but if you have a...

2 possible things

The query is returning multiple rows, and the 'N' is being returned because of the last row.

OR/AND

Your performing a Left Join,

But you referencing T2.[Date Period] in your Where...