Double Byte Character Support?

I have a Point of Sale System which uses SQL (MSDE or SQL
2000) as the back end database. We have a client that
wants to buy a Chinese version of the Point of Sale
System...so my question is, does SQL 2000 or MSDE support
the double byte character set? Is there anything special I
need to do to accomplish this, or is there a special
version of SQL to buy?Hi Ray
SQL Server supports double byte character sets ("unicode")
Types NCHAR, NVARCHAR NTEXT are unicode (double byte)
Types CHAR, VARCHAR, TEXT are single byte.
There are also collations which cover language character sets & sort orders
as well.
This applies to all editions of SQL Server.
HTH
Regards,
Greg Linwood
SQL Server MVP
"Ray" <rkano@.adctech.com> wrote in message
news:0f9601c38dfc$b9366290$a001280a@.phx.gbl...
> I have a Point of Sale System which uses SQL (MSDE or SQL
> 2000) as the back end database. We have a client that
> wants to buy a Chinese version of the Point of Sale
> System...so my question is, does SQL 2000 or MSDE support
> the double byte character set? Is there anything special I
> need to do to accomplish this, or is there a special
> version of SQL to buy?

don't want to hard-code the base URL in the RDL

We need to have links in a report that point to a web application that is located on the same box as the SSRS web service. We don't want to hard-code the base URL in the RDL because this will change from development to staging to production. Where can we store this base URL? Can an RDL access a config file?

Hi !

YOu could use a custom component for this, but this is for me a classical thing of storing the information in a database and pulling it out to a textbox which displays the data.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

don't want to hard-code base URL

We need to have links in a report that point to a web application that is
located on the same box as the SSRS web service. We don't want to hard-code
the base URL in the RDL because this will change from development to staging
to production. Where can we store this base URL? Can an RDL access a config
file?All you have to do is create a "config" table in a database then create a
datasource to read the data from the table.
hth
"Jason Camp" <JasonCamp@.discussions.microsoft.com> wrote in message
news:B2BBCFDC-BCCA-499B-9DFB-2A8936A206A8@.microsoft.com...
> We need to have links in a report that point to a web application that is
> located on the same box as the SSRS web service. We don't want to
> hard-code
> the base URL in the RDL because this will change from development to
> staging
> to production. Where can we store this base URL? Can an RDL access a
> config
> file?|||can you keep it in a view'
-Aaron
Michael Morisoli wrote:
> All you have to do is create a "config" table in a database then create a
> datasource to read the data from the table.
> hth
> "Jason Camp" <JasonCamp@.discussions.microsoft.com> wrote in message
> news:B2BBCFDC-BCCA-499B-9DFB-2A8936A206A8@.microsoft.com...
> > We need to have links in a report that point to a web application that is
> > located on the same box as the SSRS web service. We don't want to
> > hard-code
> > the base URL in the RDL because this will change from development to
> > staging
> > to production. Where can we store this base URL? Can an RDL access a
> > config
> > file?

Don't show point labels if value is zero

Hey, I have a stacked column chart. It shows headcount per month. The headcount is split up into employees and contractors.

I added point labels to the chart to display the exact headcount value per month. (=Sum(Fields!HeadCount.Value)) Now here is the problem: Some months don't have contractors so there is a 0 displayed at the bottom of the X-axis. I don't want this to happen!

I already tried to change the expression of the point labels to this:
=IIF(Sum(Fields!HeadCount.Value,"chart1_SeriesGroup1") > 0,Round(Sum(Fields!HeadCount.Value),1)," ")

But this keeps displaying the 0. Even if the last parameter in the previous expression is 'nothing' it is still displayed.

I hope it is possible to remove them ...

Some additional info:
series field is: Contractor: which is a boolean that determines if the employee is contractor or not
category field is: Month (a month representation like ... January 2006, February 2006 ...)
Data field is: headcount (the headcounts of the employees).

You can use the datavalue to compare with 0. You don't have to compare the total of the chart1_SeriesGroup1 to 0.

Is your case: =IIF(Sum(Fields!HeadCount.Value) > 0,Round(Sum(Fields!HeadCount.Value),1)," ")