| Groups | Blog | Home |
sql server reporting services : A couple of beginner's questions about reporting services
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
On May 9, 4:13 pm, B. Chernick <BChern...@discussions.microsoft.com>
[quoted text, click to view] 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? [quoted text, click to view] "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. >
[quoted text, click to view]
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 [quoted text, click to view] "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 >> >>
Actually no, I need a way to program the visibility based on content.
Clicking on a field won't do. [quoted text, click to view] "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.) [quoted text, click to view] "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 [quoted text, click to view] "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.htm Posted via DevelopmentNow.com Groups
Don't see what you're looking for? Try a search.
|
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
| home · blog · groups | Questions? Comments? Contact the dn |