Dundas Web Chart Control

I'm having trouble understanding how to build my bar chart. I have a column of info called Issue and then I'm coutning the record.

I bascially need to alter my query into time periods. I need a series for quarter 1 (1/1/2006 - 3/1/2006), one for quarter 2, 3, 4 and the entire year as a whole.

Can this data all be organized in a single select query?

Here is my current query getting the year as a whole data only:

SELECT

Issue,COUNT(*)AS NumRecordsFROM CSP_Item CI

INNER

JOIN CSP_ProblemNotification CPON CP.ID= CI.CSPNum

WHERE

CP.PNDateBETWEEN'01/01/2007'AND'01/31/2007'

GROUP

BY IssueORDERBY NumRecordsASC

Maybe...

SelectDatePart(quarter, theDate) as Quarter.

group byDatePart(quarter, theDate)

Dundas help topic missing: 'Start from Zero' property

I searched the Dundas help for this property but found nothing. I've been
experimenting with a stacked bar chart trying to work around another issue
related to sorting the bars from left to right with a zero line and having
the same order in the legend. I don't see that the property affects the
outcome of the chart. Anyone able to shed some light on what this property
is intended for?
Thanks,
Steve MunLeeuwHi Steve,
The StartFromZero property is not applicable to any chart type that
originates at the Axis, like a bar or column chart. This would be used
for a chart type that is not attached like a line, stock, gantt (or any
of the other range charts), etc. When set to true, the axis will
originate from zero regardless of data value. When set to false, the
chart will find a 'best' origin to focus the view to your data.
For example, take a stock chart when the security typically trades from
$100-103 daily. Viewing this with an axis starting from zero will make
the variations not noticeable. Setting StartFromZero to false will
make the trade range be focused in the chart area by having the minimum
value closer to 100 -- you will now be able to see the changes over
time.
If you would like help with your sorting problem please send the
request to our support dept and ask them to forward it to me.
Andrew Bryan
Dundas Software
Steve MunLeeuw wrote:
> I searched the Dundas help for this property but found nothing. I've been
> experimenting with a stacked bar chart trying to work around another issue
> related to sorting the bars from left to right with a zero line and having
> the same order in the legend. I don't see that the property affects the
> outcome of the chart. Anyone able to shed some light on what this property
> is intended for?
> Thanks,
> Steve MunLeeuwsql

Dual Y-Axes

Greetings,

I'm wondering if it is possible to have two independent y-axes on a single chart?

I am wanting to plot data using a hybrid bar/line chart and have the values for the vertical bars show on the left y-axis and the values for the points on the line show on the right y-axis.

I've seen this sort of thing done on other platforms before, but don't know if it is possible with SQL Reporting. We are using SQL RS 2000 by the way.

Thanks
--
AnthonyI think RS can't do it out of the box. Have a look at Dundas Charts.|||I was afraid you would say that. I will see if Dundas Charts has anything that will work, but I don't know that we are going to get that in our budget, so if anyone else knows of a way to rig RS to do it without Dundas, that would be great.

Also, from looking at the Dundas site, it appears they are only offering Dundas Charts for RS 2005 at this point. Whether it would still work with RS 2000, I don't know.
|||I know Dundas definately supports it, I use it quite regularly.|||

Keep in mind that the CustomReportItem-based extensibility (such as "Dundas Charts for Reporting Services" or similar offers from other third parties) are available for SSRS 2005 only in Standard, Enterprise, or Developer Editions.

It is not available for SSRS 2000.

-- Robert