A couple of beginner's questions about reporting services

I'm writing my first RS report.
1. Is there any way to program a field to clear, or even hide, under certain
conditions?
2. Is there any way to simulate a check box, to display boolean values? (I
don't see anything in the toolbox.)On May 9, 4:13 pm, B. Chernick <BChern...@.discussions.microsoft.com>
wrote:
> I'm writing my first RS report.
> 1. Is there any way to program a field to clear, or even hide, under certain
> conditions?
> 2. Is there any way to simulate a check box, to display boolean values? (I
> don't see anything in the toolbox.)
1. Yes. Many of the controls on SSRS are expression based. In your
scenario, expressions can be used to manipulate the Hidden property of
a textbox based on other data, constants, etc.
2. Assuming you're talking about the body of the report. I have used
images in the past to simulate an X or a checkmark.|||I don't think I really understand what you mean by expressions yet. Are you
talking about writing what appears to be a vb command in the format field?
If so, I haven't been able to get that to work yet. What I'd like to do is
something like this:
iif(instr(Fields!SomeValue.Value, "A String") > 0,"",Fields!SomeValue.Value)
In other words, if the value of the incoming string does contain a
particular pattern, blank the box, otherwise display it. Or have I
completely misunderstood the concept?
"Potter" wrote:
> On May 9, 4:13 pm, B. Chernick <BChern...@.discussions.microsoft.com>
> wrote:
> > I'm writing my first RS report.
> >
> > 1. Is there any way to program a field to clear, or even hide, under certain
> > conditions?
> >
> > 2. Is there any way to simulate a check box, to display boolean values? (I
> > don't see anything in the toolbox.)
>
> 1. Yes. Many of the controls on SSRS are expression based. In your
> scenario, expressions can be used to manipulate the Hidden property of
> a textbox based on other data, constants, etc.
> 2. Assuming you're talking about the body of the report. I have used
> images in the past to simulate an X or a checkmark.
>|||On May 10, 11:38 am, Potter <drewpot...@.gmail.com> wrote:
> On May 9, 4:13 pm, B. Chernick <BChern...@.discussions.microsoft.com>
> wrote:
> > I'm writing my first RS report.
> > 1. Is there any way to program a field to clear, or even hide, under certain
> > conditions?
> > 2. Is there any way to simulate a check box, to display boolean values? (I
> > don't see anything in the toolbox.)
> 1. Yes. Many of the controls on SSRS are expression based. In your
> scenario, expressions can be used to manipulate the Hidden property of
> a textbox based on other data, constants, etc.
> 2. Assuming you're talking about the body of the report. I have used
> images in the past to simulate an X or a checkmark.
hi there
In the properties box - there is a visibility property - you can use
this and toggle it depending on other fields.
hope that helps
jewel|||Actually no, I need a way to program the visibility based on content.
Clicking on a field won't do.
"jewelfire" wrote:
> On May 10, 11:38 am, Potter <drewpot...@.gmail.com> wrote:
> > On May 9, 4:13 pm, B. Chernick <BChern...@.discussions.microsoft.com>
> > wrote:
> >
> > > I'm writing my first RS report.
> >
> > > 1. Is there any way to program a field to clear, or even hide, under certain
> > > conditions?
> >
> > > 2. Is there any way to simulate a check box, to display boolean values? (I
> > > don't see anything in the toolbox.)
> >
> > 1. Yes. Many of the controls on SSRS are expression based. In your
> > scenario, expressions can be used to manipulate the Hidden property of
> > a textbox based on other data, constants, etc.
> > 2. Assuming you're talking about the body of the report. I have used
> > images in the past to simulate an X or a checkmark.
> hi there
> In the properties box - there is a visibility property - you can use
> this and toggle it depending on other fields.
> hope that helps
> jewel
>|||In the visibility property, hidden can be set to true, false or expression.
Pick expression and put the appropriate expression there.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"B. Chernick" <BChernick@.discussions.microsoft.com> wrote in message
news:6211D77E-5C9B-4206-B823-CE6273331547@.microsoft.com...
> Actually no, I need a way to program the visibility based on content.
> Clicking on a field won't do.
> "jewelfire" wrote:
>> On May 10, 11:38 am, Potter <drewpot...@.gmail.com> wrote:
>> > On May 9, 4:13 pm, B. Chernick <BChern...@.discussions.microsoft.com>
>> > wrote:
>> >
>> > > I'm writing my first RS report.
>> >
>> > > 1. Is there any way to program a field to clear, or even hide, under
>> > > certain
>> > > conditions?
>> >
>> > > 2. Is there any way to simulate a check box, to display boolean
>> > > values? (I
>> > > don't see anything in the toolbox.)
>> >
>> > 1. Yes. Many of the controls on SSRS are expression based. In your
>> > scenario, expressions can be used to manipulate the Hidden property of
>> > a textbox based on other data, constants, etc.
>> > 2. Assuming you're talking about the body of the report. I have used
>> > images in the past to simulate an X or a checkmark.
>> hi there
>> In the properties box - there is a visibility property - you can use
>> this and toggle it depending on other fields.
>> hope that helps
>> jewel
>>|||Missed that! That's what I was looking for.
Just to play safe, here is my code.
=IIf (InStr(me.Value,"1/1/1753") > 0, True ,False)
I'm assuming that 'Me' in this context, refers to the current text field.
As I mentioned elsewhere, this is legacy code with '1/1/1753' indicating a
blank date. (No nulls, period. Company rules.)
"Bruce L-C [MVP]" wrote:
> In the visibility property, hidden can be set to true, false or expression.
> Pick expression and put the appropriate expression there.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "B. Chernick" <BChernick@.discussions.microsoft.com> wrote in message
> news:6211D77E-5C9B-4206-B823-CE6273331547@.microsoft.com...
> > Actually no, I need a way to program the visibility based on content.
> > Clicking on a field won't do.
> >
> > "jewelfire" wrote:
> >
> >> On May 10, 11:38 am, Potter <drewpot...@.gmail.com> wrote:
> >> > On May 9, 4:13 pm, B. Chernick <BChern...@.discussions.microsoft.com>
> >> > wrote:
> >> >
> >> > > I'm writing my first RS report.
> >> >
> >> > > 1. Is there any way to program a field to clear, or even hide, under
> >> > > certain
> >> > > conditions?
> >> >
> >> > > 2. Is there any way to simulate a check box, to display boolean
> >> > > values? (I
> >> > > don't see anything in the toolbox.)
> >> >
> >> > 1. Yes. Many of the controls on SSRS are expression based. In your
> >> > scenario, expressions can be used to manipulate the Hidden property of
> >> > a textbox based on other data, constants, etc.
> >> > 2. Assuming you're talking about the body of the report. I have used
> >> > images in the past to simulate an X or a checkmark.
> >>
> >> hi there
> >>
> >> In the properties box - there is a visibility property - you can use
> >> this and toggle it depending on other fields.
> >>
> >> hope that helps
> >> jewel
> >>
> >>
>
>|||I haven't used Me in RS (I've used it in VB). It is easy to test. Most
errors are picked up when you try to preview it.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"B. Chernick" <BChernick@.discussions.microsoft.com> wrote in message
news:52FB048B-27B0-436A-A269-8B1CC83E12AA@.microsoft.com...
> Missed that! That's what I was looking for.
> Just to play safe, here is my code.
> =IIf (InStr(me.Value,"1/1/1753") > 0, True ,False)
> I'm assuming that 'Me' in this context, refers to the current text field.
> As I mentioned elsewhere, this is legacy code with '1/1/1753' indicating a
> blank date. (No nulls, period. Company rules.)
> "Bruce L-C [MVP]" wrote:
>> In the visibility property, hidden can be set to true, false or
>> expression.
>> Pick expression and put the appropriate expression there.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "B. Chernick" <BChernick@.discussions.microsoft.com> wrote in message
>> news:6211D77E-5C9B-4206-B823-CE6273331547@.microsoft.com...
>> > Actually no, I need a way to program the visibility based on content.
>> > Clicking on a field won't do.
>> >
>> > "jewelfire" wrote:
>> >
>> >> On May 10, 11:38 am, Potter <drewpot...@.gmail.com> wrote:
>> >> > On May 9, 4:13 pm, B. Chernick <BChern...@.discussions.microsoft.com>
>> >> > wrote:
>> >> >
>> >> > > I'm writing my first RS report.
>> >> >
>> >> > > 1. Is there any way to program a field to clear, or even hide,
>> >> > > under
>> >> > > certain
>> >> > > conditions?
>> >> >
>> >> > > 2. Is there any way to simulate a check box, to display boolean
>> >> > > values? (I
>> >> > > don't see anything in the toolbox.)
>> >> >
>> >> > 1. Yes. Many of the controls on SSRS are expression based. In
>> >> > your
>> >> > scenario, expressions can be used to manipulate the Hidden property
>> >> > of
>> >> > a textbox based on other data, constants, etc.
>> >> > 2. Assuming you're talking about the body of the report. I have
>> >> > used
>> >> > images in the past to simulate an X or a checkmark.
>> >>
>> >> hi there
>> >>
>> >> In the properties box - there is a visibility property - you can use
>> >> this and toggle it depending on other fields.
>> >>
>> >> hope that helps
>> >> jewel
>> >>
>> >>
>>|||You can also hide the field using an expression like this (instead of an iif statement):
Click your field, go to your properties box and scroll down to Visibility. Under that you have a hidden option--select Expression.
In the expression paste in a TRUE statement for what you want hidden
=Fields!Dates.Value= "1753"
That will hide the field just under certain conditions.
Hope that also gives you some flexibility
From http://www.developmentnow.com/g/115_2007_5_0_0_968676/A-couple-of-beginners-questions-about-reporting-services.ht
Posted via DevelopmentNow.com Group
http://www.developmentnow.com

7619 error message when you run a full text query that contains certain Turkish character

I receive a 7619 error message when I run a full text query that
contains certain Turkish character strings on an instance of SQL Server
2000 that is running on a Windows 2000-based computer. How can I solve
this problem?
The parser is interpreting these characters as noise or noise words. Which
word breaker are you using? I am assuming you are using the neutral word
breaker.
If this is the case the problem could be in your code page setting in the
web page. You should set the session.codepage to match the lcid for Turkish.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Ismail H. AYDIN" <dicisay@.hotmail.com> wrote in message
news:1117203863.089340.322710@.g49g2000cwa.googlegr oups.com...
>I receive a 7619 error message when I run a full text query that
> contains certain Turkish character strings on an instance of SQL Server
> 2000 that is running on a Windows 2000-based computer. How can I solve
> this problem?
>
|||I am running the query from SQL Query Analyzer and then error occurs.
Not from asp.net or asp page. The noise word is 'Ak'. And the other
noise charactes are '', '', ''.
*** Sent via Developersdex http://www.codecomments.com ***