Charts for RS 2000

Hi all,

maybe this is the wrong forum or company to post, but I'm looking for an answer, which I can't find at Dundas' Website.

Is there a Version of Dundas Charts for Reporting Services 2000? All I find is the Version for 2005...

And if there is such a version, are there differences concerning the possibility of usinig 2 Y-axis?

One more thing. What would be the arguments for using 2005 instead of 2000?

Replies are very much appreciated! Thanks in advance!

ME

This link should provide an overview on a few the new features in RS 2005 compared to the previous version: http://www.microsoft.com/technet/prodtechnol/sql/2005/2005ssrs.mspx

The integration of third party components (e.g. as used by the Dundas controls in RS 2005) requires the new CustomReportItem feature specifically added in RS 2005.

-- Robert

|||

Have you looked into Chart FX at http://www.softwarefx.com/SfxSqlProducts/cfxReportingServices/

From their website:
"Chart FX for Reporting Services leverages the charting features from the award winning Chart FX charting engine. Plus it's just as easy to add this powerful technology to your reporting projects.
Here are some features.

Ease of Use & Integration

? Chart Wizard

? Data Wizard

? Property Grid

? Resource Center

? Comprehensive Support

Advanced Features

? Multiple Gallery Types

? Gauge Chart Types

? 2D/3D Rendering

? Per Series Attributes

? Axis Sections

? Multiple Axes

? Logarithmic Axes

? Smart DateTime Axes

? Multiple Panes

? Grid Lines

? Conditional Attributes

? Data Compacting

? Artistic Borders

? Background Images

? Gradients

? Color Palettes

? Titles

? Rich Text Titles

? Point Labels

? Collision Detection

? Data Grid

? Legends "

Good luck.

Charts for Reporting Services

I'm having problem with Charts
any good website or books i can read up on
just can't anything good on charts
I need to use 2 pie chart and 1 bar chart but i can't get it to work like i wanted to

I'm not sure what Series and Category is used and how to stack the fields in the Charts

For a standard bar chart, the Category is what goes on the X axis (i.e. might be the month, or product, or whatever). Using the Series will group the bars, a typical grouping might be by year.

These three links (especially the last one) may be of some assistance:

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

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

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

Charindex

I have atable where i store visitor data (from a website).
In table i have a column LanguageData
Typical entries are:
no
en-us
no,en-us
en; en-us; no
...
So i am trying to do a select where i remove every thing after the ,.
Like this:
LEFT(LanguageData, CHARINDEX(',',
REPLACE(RTRIM(LTRIM(LanguageData)), ';', ',')))
That result in
no,
en,
So i do not get:
no
en-us
no
en
Is there a way i can do a select so that i only get languagecode or the
first languagecode where the user has many (like no, en-us)
I am trying to do this so that i can join it to a table later and show the
full language name.
Best regards
TrondHi
Hi
May be one of
SELECT CASE WHEN Length > 1 THEN LEFT([language],Length-1)
ELSE [language]
END AS [language]
FROM ( SELECT CHARINDEX(',',REPLACE([language],';',','
)) AS LENGTH,
[language]
FROM (
SELECT 'no' as [language]
UNION ALL SELECT 'en-us'
UNION ALL SELECT 'no,en-us'
UNION ALL SELECT 'en; en-us; no' ) A ) B
or
SELECT LEFT([language],ISNULL(Length-1,LEN([Language]))) AS [language]
FROM (
SELECT NULLIF(CHARINDEX(',',REPLACE([language],
';',',')),0) AS LENGTH,
[language]
FROM (
SELECT 'no' as [language]
UNION ALL SELECT 'en-us'
UNION ALL SELECT 'no,en-us'
UNION ALL SELECT 'en; en-us; no' ) A ) B
You may also want to check out:
http://www.users.drew.edu/skass/sql...unction.sql.txt
John
"Trond" <thoiberg@.broadpark.no> wrote in message
news:42629435$1@.news.broadpark.no...
>I have atable where i store visitor data (from a website).
> In table i have a column LanguageData
> Typical entries are:
> no
> en-us
> no,en-us
> en; en-us; no
> ...
> So i am trying to do a select where i remove every thing after the ,.
> Like this:
> LEFT(LanguageData, CHARINDEX(',',
> REPLACE(RTRIM(LTRIM(LanguageData)), ';', ',')))
> That result in
> no,
> en,
> So i do not get:
> no
> en-us
> no
> en
> Is there a way i can do a select so that i only get languagecode or the
> first languagecode where the user has many (like no, en-us)
> I am trying to do this so that i can join it to a table later and show the
> full language name.
> Best regards
> Trond
>