Glad I could help.

I have seen this before, and it was correctecd by checking the Side Margins checkbox on the axis property tab.

On your Y-axis tab check to see if you have any values in the Cross At field. I would suggest either putting in a zero or leaving it blank....

sql-oholic (2/19/2009)

---

hi there,

I am using a table control in my report. Here, For one of the fields, I want to get following:

This field shows overAge indicator for students for...

I guess it depends upon which labels you are wanting to change the color on. If it is the labels on the X or Y axis, then JAck's post...

OK, if I follow you correctly you have a data set in which one of the fields is City, and you have a parameter that is a drop-down list of...

In the expression for the URL, try something like this -

="http://dir.myinsanelylargecompany.com/staff.asp?txtFirst=" + Fields!FirstName.Value + "&txtLast=" + Fields!LastName.Value

You can reference fields from a different dataset than the one your table is associated with, by specifying the dataset name when you reference the field. Like so -...

Well I suppose the obvious thing to check for is that your field used to toggle the visibility for the details is not located in the group footer instead of...

How about this.

Instead of doing the =IIF logic in the text box on the Layout tab, manually add a calculated field to the dataset on the Data tab, using your...

If you are only concerned about how the data is displayed, and are not looking to only use the two decimal place value for calculations, then I would suggest simply...

Try this.

=IIF(Weekday(Today())=1,DateAdd("D",1,Today()),

IIF(Weekday(Today())=2,Today(),

DateAdd("D",-1*(Weekday(Today())-2),Today())))

It assumes Sunday as the first day of the week. If that is different from what you use, then you will need to change the format of the...

Glad I could be of assistance, and that it is working for you now.

Sorry, should have seen this before.

In your Stored Proc, do not DECLARE @Manager, just list it. That is, simply remove the word DECLARE from that line.

Also place that...

For your dataset that pulls the list of Managers for the parameter, go into the edit screen for it (using the ... button) and check the Parameters tab to make...