Chart in Reporting Services

hey all

I am using RS 2005

I have a report with chart

parameters = value1, value2, value3, all

How can I make the chart only show when all is selected?

cheers

jewel

Hi,

The chart component has a Visibility property.

In this property you can use an expression which checks the value of the parameter.
For example: when setting the Visibility.Hidden property to

=IIF(Parameters!MyParameter.Value = "All", false, true)

The chart will only be displayed when the value of the MyParameter is All.

Greetz,

Geert

Geert Verhoeven
Consultant @. Ausy Belgium

My Personal Blog

|||

thanks for your answer Geert but

when I add that line I get this error

[rsParameterReference] The Hidden expression for the 'chart1' refers to a non-existing report parameter 'MyParameter'.

I also tried with 'Select All' which is the actual wording of my parameter but still get the same message.

These values are specified in the available values - non queried part of the report parameters.

not sure what I am missing here?

thanks

jewel

|||

The MyParameter refers to a report parameter. This was just an example. You need to change the name of to one of your report parameters.

Greetz,

Geert

Geert Verhoeven
Consultant @. Ausy Belgium

My Personal Blog

|||

sorry about that Geert

Must be a slow reaction to being back at work after a break. Absolutely right!

cheers for this

jewel

Charset from asp.net page

Hi all!
I have problem and dont know how to solve it. I'm from Croatia and charset
for my country is "Windows-1250" (codepage = 1250)
I made some pages that write text from textboxes in SQL database that is
international. After reading that data I dont get special characters in that
codepage.
On every page I have this in the beggining
--
<%@. Page Language="vb" AutoEventWireup="false"
Codebehind="kategorija.aspx.vb" Inherits="marti.finesa.kategorija"
culture="hr-HR" responseEncoding="windows-1250"%>
--
Special characters in that codepage are Ю. After reading that, I
get ?d?cc?CC.
What I need to do.
PLEASE HELP!Bubbi wrote:

> Special characters in that codepage are Ю. After reading
that, I
> get ?d?cc?CC.
Use the default UTF-8 encoding. This is a form of Unicode that will
properly render your characters. It can be set for the whole application
in the web.config file, and is set there by default to UTF-8.
The next step is to make sure you are storing the data in way that
preserves the unicode data (fields in database are unicode data types),
and that your client browser properly interprets the encoding of the
page (do you have a specific character set selected in the View Encoding
menu of IE, instead of letting it autodetect?).
Hope that helps.

Charset from asp.net page

Hi all!
I have problem and dont know how to solve it. I'm from Croatia and charset
for my country is "Windows-1250" (codepage = 1250)
I made some pages that write text from textboxes in SQL database that is
international. After reading that data I dont get special characters in that
codepage.
On every page I have this in the beggining
<%@. Page Language="vb" AutoEventWireup="false"
Codebehind="kategorija.aspx.vb" Inherits="marti.finesa.kategorija"
culture="hr-HR" responseEncoding="windows-1250"%>
Special characters in that codepage are Ю. After reading that, I
get ?d?cc?CC.
What I need to do.
PLEASE HELP!
Bubbi wrote:

> Special characters in that codepage are Ю. After reading
that, I
> get ?d?cc?CC.
Use the default UTF-8 encoding. This is a form of Unicode that will
properly render your characters. It can be set for the whole application
in the web.config file, and is set there by default to UTF-8.
The next step is to make sure you are storing the data in way that
preserves the unicode data (fields in database are unicode data types),
and that your client browser properly interprets the encoding of the
page (do you have a specific character set selected in the View Encoding
menu of IE, instead of letting it autodetect?).
Hope that helps.

Changing year in field

Hi all:
I need to change the year to many records that, by mistake, were put with a 2007 date, but they should be still with 2006, can anyone help me ?
I use Sql Server 2000 and the field is of type datetime
Thanks:eek:first make a backup.

then write a select statement for the rows that need to be updated, and make sure it's correct (that is, it contains all the rows that need fixing, and no others):

select * from mytable where <some criteria>

then you can apply an update.

update mytable
set mycol=dateadd(year, -1, mycol)
where <some criteria>