Problem in Charting

I am dynamically generating the RDL for a chart,but i am not able to show markers on the X-Axis when the report is generated.

FYI ,I am creating a orthographic column chart.

Any ideas?

Markers can be turned on using the Chart properties dialog in VS.NET.

In the Data tab, Select the Values you want to display makers. Cick "Edit". Then on the Appearance tab, click the Show markers checkbox.

-Chris

|||

Hi,

I suppose u didnt read my question fully..I am dynamically generating the RDL wherein I need to show the labels (Markers) on the X-Axis.

|||

You can always lookup the RDL specification available here: http://www.microsoft.com/sql/technologies/reporting/rdlspec.mspx

Here is an example of what you would need to generate to get tickmarks on the x-axis (depending on major and minor interval settings or automatic intervals if omitted):

<CategoryAxis>
<Axis>
<Title />
<Visible>true</Visible>
<MajorTickMarks>Outside</MajorTickMarks>
<MinorTickMarks>Outside</MinorTickMarks>
<MajorInterval>5</MajorInterval>
<MinorInterval>1</MinorInterval>
<MajorGridLines>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</MajorGridLines>
<MinorGridLines>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</MinorGridLines>
<Margin>true</Margin>
<Scalar>true</Scalar>
</Axis>
</CategoryAxis>

-- Robert

Problem in Chart

Hai all,

I am generating chart using the Sql Reporting services.I have done 2 charts. when i am clicking one chart it will navigate to another chart.It is happened in reports.

when i used in UI page(web Page). when click the chart it is not navigating to another chart.The same chart will appear when i click the chart.

Can u guys help me soon to solve this problem..

Thanks In advance.

Double click the original chart and right click the field that you want to navigate to the other chart. Click properties. Click the action tab. Select the Jump to report radio button. In the drop down menu, select the second chart that you would like the original chart to navigate to.

Problem designing Chart

I am trying to create a bar chart that looks like this:

http://www.webfound.net/chart3.jpg (sketch from a user).

ignore the first set of bars in the above, I'm just trying to create the rest for AZ and IL..the other 2 sets of bars in my chart in SSRS 2005

I have created a dataset that runs a stored proc and resturns the following values:

http://www.webfound.net/values1.jpg

My bar chart looks like this in layout mode:

http://www.webfound.net/chart_layout.jpg

And my results do not look like what I want:

http://www.webfound.net/chart_results.jpg

Questions

1) Why is it not giving me just 3 bars for IL and 3 bars for AZ based on the series groups GrossGoal, InHouse2, and ProjFee? It's instead just showing one bar for all 3 fields - as seen in the legend

I should be getting 3 columns per category...see below

http://msdn2.microsoft.com/en-us/library/ms160349.aspx

"Series groups are optional. The series group list is used to provide dynamic groups of data in the chart. For example, in a column chart, data from the categories list will result in a column for each series group, in each category."

http://msdn2.microsoft.com/en-us/library/ms155847.aspx

2) How can I get this to work for both IL and AZ? this is more complicated than originally thought

Was able to resolve this with the help of Jon http://weblogs.sqlteam.com/jhermiz/category/197.aspx

I had to do 2 things to get this to work:

1) do not use any fields in series

2) add GrossGoal, InHouse, and ProjFee fields into the Data section of the bar chart

3) Add the Category field that contains the group names (which I was already doing)