In 2005, lrosini's suggestion to check Repeat header rows on each page, should help.

In the XML, look for /Header and between /Header and /TableRows, make sure you have this element...

for SSRS 2008,

If a report with a table is created using the wizard feature (In Solution Explorer, right click on Reports --> Add New Report) Table Headers will repeat...

=format(Fields!FieldName.Value,"MM/dd/yyyy")

Just add another row above the details row and drag the column heading fields from the dataset.

Assuming the SP contains columns for both headers(labels) and detail rows, you could even...

No you can't.

Just ignore the warning. It is just that two text boxes in a rdl overlap. Or identify the ovelapping controls in the report and arrange them accordingly.

For the parameter that you need the Calendar control, set its data type to Datetime and you should see the Calendar to pick dates.

Fields!Signature.Value should work.

Please refer to Product Catalog RDL in Adv works 2005/2008. There is a Image control called ProdPhoto and do refer to the properties for MIMEType,Source,Value and Parent.

Also you...

Under Properties for a report you should see a link called History on the left, below the link for Data sources and Executionusing which you can store a copy of...

You cannot get row num as a calc field in the data set because at this stage data set does not have the record. It is available only when rendering.

If...

working it out at the SQL DB end is ideal. If that is not possible, then expression below should work.

=switch(S_PID = 1005 or S_PID = 1458 or S_PID = ...

Credit goes to the authors. Not me, I just googled.

http://blogs.msdn.com/carloshm/archive/2005/10/18/482022.aspx

http://sharepointblogs.com/kwanl/archive/2007/05/03/writing-a-rendering-extension-for-reporting-services-2005.aspx

This is solution at the back end within SQL DB and not at the rendering Report

Adding the time Zone to the table and resolving it at the stored proc or...

Under Chart Properties

Data Tab, in Values click Add

Edit Chart Value, Values Tab, give a name to the Series Label, e.g, Value 5

In the Value box specify =5, click OK

Return...

Under Report Data, please note there is a menu bar under Report Data with New, Edit, Delete icon and two arrows. We will come to these arrows later.

Expand Parameters node.

Click...