OK the loop is causing the problem.

Taking a look at the original logic, you would like to return the rows from the #SampleData table where the trandate is between a...

Try this...I have assumed that @PToDate and @PFromDate are parameters set within SSRS. If so then they cannot be set within the query text.

Workaround : create two additional TSQL...

As you are using TSQL at that point :

@PFromDate=@PFromDate -1

@PToDate=@PToDate-1

needs...

The best way would be to not have hard-coded charts but to dynamically add the charts dependednt upon the data. To do this create a subreport which contains the...

If you want to see all teachers with the courses they teach by default, then your report parameter should all for a ALL COURSES or ANY option. The teachers...

As Ray M stated the report you need to run first (main report) is to select all teachers who perform a selected course:

Select T.* from

Teachers T

inner join PerformsCourse...

Thanks for question. Easy one on a lazy morning.

Fitz

Which tool are you using to view the XML? As stated before the cr and lf should not be there, but also should not matter.

I have reproduced the effect...

Remove the bing larr unless your server allows web access directly or via a proxy.

Did you select the bing layer option? If yes then your server must have a link to the bing web service.

Investigate using the join and split functions.

=Join(Parameters!ParamName.Value,"#")..creates a single string of the multiple values with # between

=Split(Parameters!ParamName.Value,"#")..splits the single string into multiple values

Fitz

Check your data type for the expression.

It would be better to use the category properties and filter the categories (x axis items) where the condition is true. Hiding the label will still leave a gap.

Add...

Below is an example using the AdventureworksDW2008 demo database where the productname language could be chosen. Given that the parameter @Source is a column name in the table and...

So sometimes...