Databases
StackOverflow2013
Postsdbo
POComplex graph in Reporting Services?
Body
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POComplex graph in Reporting Services?
    text
    copied!<p>I'm trying to imitate this graph, or get as close as feasible:</p> <p><a href="http://img193.imageshack.us/img193/1748/graphu.png" rel="nofollow noreferrer">http://img193.imageshack.us/img193/1748/graphu.png</a></p> <p>Features:</p> <ul> <li>Codes at the bottom (Need to have)</li> <li>Rate at the side (Need to have)</li> <li>Both this year's dataset and last year's dataset (Need to have)</li> <li>Up-bars and downbars to indicate improvement / deterioration (Nice to have)</li> </ul> <p>I know how to create it in Excel:</p> <ul> <li>Create a line graph for the two datasets</li> <li>In the graph's properties, remove lines</li> <li>Insert then format the up bars and down bars as appropriate</li> </ul> <p>I've managed to get this close in the Layout view of Reporting Services: <a href="http://img686.imageshack.us/img686/5730/layoutt.png" rel="nofollow noreferrer">http://img686.imageshack.us/img686/5730/layoutt.png</a></p> <p>It's a line graph with the trend lines disabled. No up-bars / down-bars, but that's acceptable.</p> <p>The problem is, when I switch to Preview / Publish view, this is what it becomes: <a href="http://img37.imageshack.us/img37/6824/previewyb.png" rel="nofollow noreferrer">http://img37.imageshack.us/img37/6824/previewyb.png</a></p> <p>The lines all appear for no apparent reason.</p> <p>I posted an earlier (now deleted) question for advice on this, and received the suggestion of using a scatter graph. But unless I'm missing something, the scatter graph requires two numeric axes? When I try to drop the "Rate" value on the "Y value" field, I get the error "Value cannot be null. Parameter name: value" (There is no report parameter "Value".) It also doesn't seem to be able to have two datasets on the one axis?</p> <p>So, what should I be doing? Is there some way to get the trendlines to go away in the preview / publish view? Alternatively, is there some way to get scatter plots to do what I'm after? Or some other graph that would do it simply?</p> <p>EDIT: This is in Reporting Services 2005, so you know.</p>
 

Querying!

 
Guidance
An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload