CODEWITHSUNDEEP
sqlsql-servert-sqlreporting-services
Alex Gordon
Alex Gordon

Reputation: 60691

why is my chart showing only errors?

here's my SSRS chart::

enter image description here

I've checked the sql statements from which this chart is generated. i've run the statements in SSMS, and they return data without errors.

also, i've used sql profiler to intercept the exact statements that is being sent to sql server, and i've re-run these statements without problems.

what might be some other causes of error in the expression of the source of a chart on ssrs 2008 r2?

this is in design mode:

enter image description here

these are called chart series labels

Upvotes: 0

Views: 116

Answers (1)

glh
glh

Reputation: 4972

There is nothing wrong with your SQL otherwise you would not see a report, let a lone a chart on the report. The issue is then in the expression.

The best method for putting in data labels is to use the pre-defined keywords. I suggest you enter #VALY as text in the properties box. For more keywords see MSDN.

Add guide:

  1. Open the label properties dialog box.
  2. Under the label text, see below, change the «Expr» to #VALY.

Dialog box example from google and SearchSQLServer

Dialog box example from google and SearchSQLServer

Upvotes: 1

Related Questions