Extend search function

Hello

In my website I have a textbox to search some products, but it would like to extend my search-function so that it could find special characters.

For example:

When I search Mexico, I would like to find México.

Is there an easy way to do this?

Thanks in Advance
Wesley

Hi Wesley,

As far as I know, there is no way to achieve this automatically. The only way is write custom code to substitute the characters and search again.

expressions

Maybe I just have my eyes closed as I search for how to do this, but can you refer to a textbox value in an expression?

something like;

Value of textbox1

= textbox2.value

Use this syntax:

=ReportItems!TextboxName.Value

However, keep in mind that for instance you cannot refer to a textbox that is contained within a data region (list, table, etc.) from somewhere outside that data region. Additional restrictions apply.

-- Robert

Expression Constants

When I edit an expression for a textbox, I notice a 'Constants' node in the
tree along with Globals, etc. How/Where do i define the constants that will
show up here? For example, i would like to define a path to a server in a
constant, be able to use it for various expressions, and only have to change
it in one place when i move my report from dev/staging/production.JeffW wrote:
> When I edit an expression for a textbox, I notice a 'Constants' node
in the
> tree along with Globals, etc. How/Where do i define the constants
that will
> show up here? For example, i would like to define a path to a server
in a
> constant, be able to use it for various expressions, and only have to
change
> it in one place when i move my report from dev/staging/production.
You can't define constants to show up in this area. This is for
pre-defined constants. To create a constant to use, you can create one
with the VB.NET syntax in the code section. To see constants in this
area, you can (for example) go to the properties of a text box and
click on the expression button (fx) of a property that uses constants,
for example most of the alignment properties have constants that you
can use here.
Dan|||Thanks Dan. That clears it up
"dan" wrote:
> JeffW wrote:
> > When I edit an expression for a textbox, I notice a 'Constants' node
> in the
> > tree along with Globals, etc. How/Where do i define the constants
> that will
> > show up here? For example, i would like to define a path to a server
> in a
> > constant, be able to use it for various expressions, and only have to
> change
> > it in one place when i move my report from dev/staging/production.
> You can't define constants to show up in this area. This is for
> pre-defined constants. To create a constant to use, you can create one
> with the VB.NET syntax in the code section. To see constants in this
> area, you can (for example) go to the properties of a text box and
> click on the expression button (fx) of a property that uses constants,
> for example most of the alignment properties have constants that you
> can use here.
> Dan
>

expression based on multiple values in a dataset

Hi
I am trying to seth the background colour of a textbox to either red or
green depending on the multiple values in my dataset.
Each row of my dataset has a boolean value for Pass. The background colour
of the text box needs to be green if all rows in my dataset have a Pass
value of True but if only one row in the dataset has a Pass value of False,
the background colour needs to be set to red.
I have tries the obvious expression =IIF(Fields!Pass.Value = True, "Green",
"Red") but this will set the background to green again if their is a row in
the dataset with a Pass value of True after the row which had the Pass value
of False.
I have also tried counting the number of rows with a specific value but this
does not seem to work.
=IIF(count(Fields!Pass.Value = False) = 0, "Green", "Red")
Does anyone have any ideas how to get what I want?
Thanks
Lewis Holmes
eNateTry this for multiple values:
=iif(Sum(iif(Fields!Pass.Value, 1, 0)) > 0, "Green", "Red")
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"l.holmes" <enate@.newsgroups.nospam> wrote in message
news:uMp0e%23J2FHA.3816@.TK2MSFTNGP14.phx.gbl...
> Hi
> I am trying to seth the background colour of a textbox to either red or
> green depending on the multiple values in my dataset.
> Each row of my dataset has a boolean value for Pass. The background colour
> of the text box needs to be green if all rows in my dataset have a Pass
> value of True but if only one row in the dataset has a Pass value of
> False, the background colour needs to be set to red.
> I have tries the obvious expression =IIF(Fields!Pass.Value = True,
> "Green", "Red") but this will set the background to green again if their
> is a row in the dataset with a Pass value of True after the row which had
> the Pass value of False.
> I have also tried counting the number of rows with a specific value but
> this does not seem to work.
> =IIF(count(Fields!Pass.Value = False) = 0, "Green", "Red")
> Does anyone have any ideas how to get what I want?
> Thanks
> Lewis Holmes
> eNate
>|||Hi Robert
Thanks for the reply.
I do not think this will work still. For example say my dataset has three
rows which have Pass values of True, False and True.
As i understand, using this expression for the first row, the expression
will evaluate to Green as Value is True. Then for the second row the
expression will evaluate to Red as value is False (this is all correct).
However, my problem is that now after evaluating the expression for third
row, the value returned will be Green as Value is true and so sum returns 1.
This is not the behaviour I want as the background colour should be Red if
one or more of the Pass values is false.Using this expression, the result
from the third row is setting the background colour back to green.
Hope this explains the problem better.
Kind Regards
Lewis Holmes
eNate
"Robert Bruckner [MSFT]" <robruc@.online.microsoft.com> wrote in message
news:eO1NksR2FHA.3880@.TK2MSFTNGP12.phx.gbl...
> Try this for multiple values:
> =iif(Sum(iif(Fields!Pass.Value, 1, 0)) > 0, "Green", "Red")
> -- Robert
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>
> "l.holmes" <enate@.newsgroups.nospam> wrote in message
> news:uMp0e%23J2FHA.3816@.TK2MSFTNGP14.phx.gbl...
>> Hi
>> I am trying to seth the background colour of a textbox to either red or
>> green depending on the multiple values in my dataset.
>> Each row of my dataset has a boolean value for Pass. The background
>> colour of the text box needs to be green if all rows in my dataset have a
>> Pass value of True but if only one row in the dataset has a Pass value of
>> False, the background colour needs to be set to red.
>> I have tries the obvious expression =IIF(Fields!Pass.Value = True,
>> "Green", "Red") but this will set the background to green again if their
>> is a row in the dataset with a Pass value of True after the row which had
>> the Pass value of False.
>> I have also tried counting the number of rows with a specific value but
>> this does not seem to work.
>> =IIF(count(Fields!Pass.Value = False) = 0, "Green", "Red")
>> Does anyone have any ideas how to get what I want?
>> Thanks
>> Lewis Holmes
>> eNate
>|||Hi Lewis,
In you case, I understood if there is one backgroup to be Red (false), you
want all following backgroup to be shown as Red (false). If I have
misunderstood your concern, please feel free to point it out.
I am afraid there won't be an easy to accomplish this. You may try using
.net assembly to identify the color according to row number with custom
function.
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================This posting is provided "AS IS" with no warranties, and confers no rights.

Expression - Visibility

Can someone please help correct this expression for me, I'm trying to change
a value based on the visibility of another textbox.
=IIf(ReportItems!GrowerNameTB.Visibility.Hidden = True,
Fields!FieldName.Value, Fields!OriginalField.Value)
ThanksLet me know if this doesn't work for you:
Tutorial: Changing the Visibility Objects in Reporting Services
http://www.sqlservercentral.com/columnists/bknight/reportingservicesrowvisibility.asp
"Kershni Chetty" <support@.sqrsoftware.com> wrote in message
news:OeDpvJOaEHA.644@.tk2msftngp13.phx.gbl...
> Can someone please help correct this expression for me, I'm trying to
> change
> a value based on the visibility of another textbox.
> =IIf(ReportItems!GrowerNameTB.Visibility.Hidden = True,
> Fields!FieldName.Value, Fields!OriginalField.Value)
> Thanks
>
>
>
>|||This is not natively supported. You can get pretty close to this behavior by
dynamically show/hide items in a report. The sample at the end of this post
should point you in the right direction
--
Bruce Johnson [MSFT]
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Kershni Chetty" <support@.sqrsoftware.com> wrote in message
news:OeDpvJOaEHA.644@.tk2msftngp13.phx.gbl...
> Can someone please help correct this expression for me, I'm trying to
change
> a value based on the visibility of another textbox.
> =IIf(ReportItems!GrowerNameTB.Visibility.Hidden = True,
> Fields!FieldName.Value, Fields!OriginalField.Value)
> Thanks
Simulated Dynamic Visibility.rdl
----
--
<?xml version="1.0" encoding="utf-8"?>
<Report
xmlns="http://schemas.microsoft.com/sqlserver/reporting/2003/10/reportdefini
tion"
xmlns:rd="">http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">
<RightMargin>1in</RightMargin>
<Body>
<ReportItems>
<Table Name="table1">
<Height>0.875in</Height>
<Style />
<Header>
<TableRows>
<TableRow>
<Height>0.25in</Height>
<TableCells>
<TableCell>
<ReportItems>
<Textbox Name="textbox1">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>11</ZIndex>
<rd:DefaultName>textbox1</rd:DefaultName>
<CanGrow>true</CanGrow>
<Value />
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox2">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>10</ZIndex>
<rd:DefaultName>textbox2</rd:DefaultName>
<CanGrow>true</CanGrow>
<Value />
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox3">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>9</ZIndex>
<rd:DefaultName>textbox3</rd:DefaultName>
<CanGrow>true</CanGrow>
<Value />
</Textbox>
</ReportItems>
</TableCell>
</TableCells>
</TableRow>
</TableRows>
</Header>
<Details>
<TableRows>
<TableRow>
<Height>0.25in</Height>
<TableCells>
<TableCell>
<ReportItems>
<Rectangle Name="rectangle2">
<ZIndex>8</ZIndex>
<ReportItems>
<Image Name="image1">
<ZIndex>2</ZIndex>
<Width>0.125in</Width>
<Visibility>
<Hidden>=iif(Fields!Quantity.Value >= 10,
false, true)</Hidden>
</Visibility>
<Source>Embedded</Source>
<Style />
<Value>arrowup</Value>
<Sizing>Fit</Sizing>
</Image>
<Textbox Name="textbox11">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>1</ZIndex>
<CanGrow>true</CanGrow>
<Value>=(Fields!Quantity.Value/10) & " % "
& iif(Fields!Quantity.Value < 10, "Below", "Above")</Value>
<Left>0.125in</Left>
</Textbox>
<Image Name="image2">
<Width>0.125in</Width>
<Visibility>
<Hidden>=iif(Fields!Quantity.Value >= 10,
true, false)</Hidden>
</Visibility>
<Source>Embedded</Source>
<Style />
<Value>arrowdn</Value>
<Sizing>Fit</Sizing>
</Image>
</ReportItems>
<Style />
</Rectangle>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox10">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>7</ZIndex>
<rd:DefaultName>textbox10</rd:DefaultName>
<CanGrow>true</CanGrow>
<Value />
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox6">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>6</ZIndex>
<rd:DefaultName>textbox6</rd:DefaultName>
<CanGrow>true</CanGrow>
<Value />
</Textbox>
</ReportItems>
</TableCell>
</TableCells>
</TableRow>
<TableRow>
<Height>0.125in</Height>
<TableCells>
<TableCell>
<ReportItems>
<Textbox Name="textbox4">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>2</ZIndex>
<rd:DefaultName>textbox4</rd:DefaultName>
<CanGrow>true</CanGrow>
<Value />
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox12">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>1</ZIndex>
<rd:DefaultName>textbox12</rd:DefaultName>
<CanGrow>true</CanGrow>
<Value />
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox13">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<rd:DefaultName>textbox13</rd:DefaultName>
<CanGrow>true</CanGrow>
<Value />
</Textbox>
</ReportItems>
</TableCell>
</TableCells>
</TableRow>
</TableRows>
</Details>
<Top>1in</Top>
<Width>5.70833in</Width>
<Footer>
<TableRows>
<TableRow>
<Height>0.25in</Height>
<TableCells>
<TableCell>
<ReportItems>
<Textbox Name="textbox7">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>5</ZIndex>
<rd:DefaultName>textbox7</rd:DefaultName>
<CanGrow>true</CanGrow>
<Value />
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox8">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>4</ZIndex>
<rd:DefaultName>textbox8</rd:DefaultName>
<CanGrow>true</CanGrow>
<Value />
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox9">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>3</ZIndex>
<rd:DefaultName>textbox9</rd:DefaultName>
<CanGrow>true</CanGrow>
<Value />
</Textbox>
</ReportItems>
</TableCell>
</TableCells>
</TableRow>
</TableRows>
</Footer>
<TableColumns>
<TableColumn>
<Width>1.375in</Width>
</TableColumn>
<TableColumn>
<Width>2.16667in</Width>
</TableColumn>
<TableColumn>
<Width>2.16667in</Width>
</TableColumn>
</TableColumns>
</Table>
</ReportItems>
<Style />
<Height>2.625in</Height>
</Body>
<TopMargin>1in</TopMargin>
<DataSources>
<DataSource Name="Northwind">
<rd:DataSourceID>9f29cda9-5388-4d45-9672-8480f8677b4d</rd:DataSourceID>
<ConnectionProperties>
<DataProvider>SQL</DataProvider>
<ConnectString>data source=localhost;initial
catalog=Northwind</ConnectString>
<IntegratedSecurity>true</IntegratedSecurity>
</ConnectionProperties>
</DataSource>
</DataSources>
<Width>6.5in</Width>
<DataSets>
<DataSet Name="DataSet1">
<Fields>
<Field Name="Quantity">
<DataField>Quantity</DataField>
<rd:TypeName>System.Int16</rd:TypeName>
</Field>
</Fields>
<Query>
<DataSourceName>Northwind</DataSourceName>
<CommandText>SELECT Quantity
FROM [Order Details]</CommandText>
</Query>
</DataSet>
</DataSets>
<EmbeddedImages>
<EmbeddedImage Name="arrowdn">
<MIMEType>image/png</MIMEType>
<ImageData>iVBORw0KGgoAAAANSUhEUgAAAAoAAAAMCAIAAADUCbv3AAAAAXNSR0IArs4c6QAAA
ARnQU1BAACxjwv8YQUAAAAgY0hSTQAAeiYAAICEAAD6AAAAgOgAAHUwAADqYAAAOpgAABdwnLpRP
AAAAIpJREFUKFNjNHSM+sHAcG3fUgZUoOUUzQEUcQotdkpsMfRM/o8ENB2jgIJOkdUMQEEgBVLhG
gVRAJcDskHSCBWeyUC7IPog4lBpuApkORRpIMcytBiIkB3BALQSaCCyENwFQKUMQIzd5bE4XA5yH
VgOyeWxIL8BvQTyFUwO1eVgW4AI2XUIj2F1OQByceaujVk1oQAAAABJRU5ErkJggg==</ImageDa
ta>
</EmbeddedImage>
<EmbeddedImage Name="arrowup">
<MIMEType>image/png</MIMEType>
<ImageData>iVBORw0KGgoAAAANSUhEUgAAAAoAAAAMCAIAAADUCbv3AAAAAXNSR0IArs4c6QAAA
ARnQU1BAACxjwv8YQUAAAAgY0hSTQAAeiYAAICEAAD6AAAAgOgAAHUwAADqYAAAOpgAABdwnLpRP
AAAAJhJREFUKFN1jzEOgCAMRfE4jo66QeLgATSRxIF4BN1YGT2JB/Fa+GuxMGhTEtL/+X1UMUb1V
jftuF7nIRMFmasdN+MC9bjJMMlm9mYJtbZociyeHSSz1mjLo6Z/HDM5lLyTQHIMKxxYp3AQWGopQ
1vEZDSmQ5fWLNMWJn+2ZrRE54iOt4rjJXf0qx/yQksOzgA5Aj/JMYR0Aztu4wOw2uP3AAAAAElFT
kSuQmCC</ImageData>
</EmbeddedImage>
</EmbeddedImages>
<LeftMargin>1in</LeftMargin>
<rd:SnapToGrid>true</rd:SnapToGrid>
<rd:DrawGrid>true</rd:DrawGrid>
<rd:ReportID>b85de8b2-b11d-40cd-a911-1b01da08b61c</rd:ReportID>
<BottomMargin>1in</BottomMargin>
<Language>en-US</Language>
</Report>|||Is there any way to get the borders and background color to stay
visible regardless of the hidden state of the field?
Thanks,
A. Mitchell
"Bruce Johnson [MSFT]" <brucejoh@.online.microsoft.com> wrote in message news:<#E#zVZSaEHA.3716@.TK2MSFTNGP11.phx.gbl>...
> This is not natively supported. You can get pretty close to this behavior by
> dynamically show/hide items in a report. The sample at the end of this post
> should point you in the right direction
> --
> Bruce Johnson [MSFT]
> Microsoft SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Kershni Chetty" <support@.sqrsoftware.com> wrote in message
> news:OeDpvJOaEHA.644@.tk2msftngp13.phx.gbl...
> > Can someone please help correct this expression for me, I'm trying to
> change
> > a value based on the visibility of another textbox.
> >
> > =IIf(ReportItems!GrowerNameTB.Visibility.Hidden = True,
> > Fields!FieldName.Value, Fields!OriginalField.Value)
> >
> > Thanks
>
> Simulated Dynamic Visibility.rdl
> ----
> --
> <?xml version="1.0" encoding="utf-8"?>
> <Report
> xmlns="http://schemas.microsoft.com/sqlserver/reporting/2003/10/reportdefini
> tion"
> xmlns:rd="">http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">
> <RightMargin>1in</RightMargin>
> <Body>
> <ReportItems>
> <Table Name="table1">
> <Height>0.875in</Height>
> <Style />
> <Header>
> <TableRows>
> <TableRow>
> <Height>0.25in</Height>
> <TableCells>
> <TableCell>
> <ReportItems>
> <Textbox Name="textbox1">
> <Style>
> <PaddingLeft>2pt</PaddingLeft>
> <PaddingBottom>2pt</PaddingBottom>
> <PaddingTop>2pt</PaddingTop>
> <PaddingRight>2pt</PaddingRight>
> </Style>
> <ZIndex>11</ZIndex>
> <rd:DefaultName>textbox1</rd:DefaultName>
> <CanGrow>true</CanGrow>
> <Value />
> </Textbox>
> </ReportItems>
> </TableCell>
> <TableCell>
> <ReportItems>
> <Textbox Name="textbox2">
> <Style>
> <PaddingLeft>2pt</PaddingLeft>
> <PaddingBottom>2pt</PaddingBottom>
> <PaddingTop>2pt</PaddingTop>
> <PaddingRight>2pt</PaddingRight>
> </Style>
> <ZIndex>10</ZIndex>
> <rd:DefaultName>textbox2</rd:DefaultName>
> <CanGrow>true</CanGrow>
> <Value />
> </Textbox>
> </ReportItems>
> </TableCell>
> <TableCell>
> <ReportItems>
> <Textbox Name="textbox3">
> <Style>
> <PaddingLeft>2pt</PaddingLeft>
> <PaddingBottom>2pt</PaddingBottom>
> <PaddingTop>2pt</PaddingTop>
> <PaddingRight>2pt</PaddingRight>
> </Style>
> <ZIndex>9</ZIndex>
> <rd:DefaultName>textbox3</rd:DefaultName>
> <CanGrow>true</CanGrow>
> <Value />
> </Textbox>
> </ReportItems>
> </TableCell>
> </TableCells>
> </TableRow>
> </TableRows>
> </Header>
> <Details>
> <TableRows>
> <TableRow>
> <Height>0.25in</Height>
> <TableCells>
> <TableCell>
> <ReportItems>
> <Rectangle Name="rectangle2">
> <ZIndex>8</ZIndex>
> <ReportItems>
> <Image Name="image1">
> <ZIndex>2</ZIndex>
> <Width>0.125in</Width>
> <Visibility>
> <Hidden>=iif(Fields!Quantity.Value >= 10,
> false, true)</Hidden>
> </Visibility>
> <Source>Embedded</Source>
> <Style />
> <Value>arrowup</Value>
> <Sizing>Fit</Sizing>
> </Image>
> <Textbox Name="textbox11">
> <Style>
> <PaddingLeft>2pt</PaddingLeft>
> <PaddingBottom>2pt</PaddingBottom>
> <PaddingTop>2pt</PaddingTop>
> <PaddingRight>2pt</PaddingRight>
> </Style>
> <ZIndex>1</ZIndex>
> <CanGrow>true</CanGrow>
> <Value>=(Fields!Quantity.Value/10) & " % "
> & iif(Fields!Quantity.Value < 10, "Below", "Above")</Value>
> <Left>0.125in</Left>
> </Textbox>
> <Image Name="image2">
> <Width>0.125in</Width>
> <Visibility>
> <Hidden>=iif(Fields!Quantity.Value >= 10,
> true, false)</Hidden>
> </Visibility>
> <Source>Embedded</Source>
> <Style />
> <Value>arrowdn</Value>
> <Sizing>Fit</Sizing>
> </Image>
> </ReportItems>
> <Style />
> </Rectangle>
> </ReportItems>
> </TableCell>
> <TableCell>
> <ReportItems>
> <Textbox Name="textbox10">
> <Style>
> <PaddingLeft>2pt</PaddingLeft>
> <PaddingBottom>2pt</PaddingBottom>
> <PaddingTop>2pt</PaddingTop>
> <PaddingRight>2pt</PaddingRight>
> </Style>
> <ZIndex>7</ZIndex>
> <rd:DefaultName>textbox10</rd:DefaultName>
> <CanGrow>true</CanGrow>
> <Value />
> </Textbox>
> </ReportItems>
> </TableCell>
> <TableCell>
> <ReportItems>
> <Textbox Name="textbox6">
> <Style>
> <PaddingLeft>2pt</PaddingLeft>
> <PaddingBottom>2pt</PaddingBottom>
> <PaddingTop>2pt</PaddingTop>
> <PaddingRight>2pt</PaddingRight>
> </Style>
> <ZIndex>6</ZIndex>
> <rd:DefaultName>textbox6</rd:DefaultName>
> <CanGrow>true</CanGrow>
> <Value />
> </Textbox>
> </ReportItems>
> </TableCell>
> </TableCells>
> </TableRow>
> <TableRow>
> <Height>0.125in</Height>
> <TableCells>
> <TableCell>
> <ReportItems>
> <Textbox Name="textbox4">
> <Style>
> <PaddingLeft>2pt</PaddingLeft>
> <PaddingBottom>2pt</PaddingBottom>
> <PaddingTop>2pt</PaddingTop>
> <PaddingRight>2pt</PaddingRight>
> </Style>
> <ZIndex>2</ZIndex>
> <rd:DefaultName>textbox4</rd:DefaultName>
> <CanGrow>true</CanGrow>
> <Value />
> </Textbox>
> </ReportItems>
> </TableCell>
> <TableCell>
> <ReportItems>
> <Textbox Name="textbox12">
> <Style>
> <PaddingLeft>2pt</PaddingLeft>
> <PaddingBottom>2pt</PaddingBottom>
> <PaddingTop>2pt</PaddingTop>
> <PaddingRight>2pt</PaddingRight>
> </Style>
> <ZIndex>1</ZIndex>
> <rd:DefaultName>textbox12</rd:DefaultName>
> <CanGrow>true</CanGrow>
> <Value />
> </Textbox>
> </ReportItems>
> </TableCell>
> <TableCell>
> <ReportItems>
> <Textbox Name="textbox13">
> <Style>
> <PaddingLeft>2pt</PaddingLeft>
> <PaddingBottom>2pt</PaddingBottom>
> <PaddingTop>2pt</PaddingTop>
> <PaddingRight>2pt</PaddingRight>
> </Style>
> <rd:DefaultName>textbox13</rd:DefaultName>
> <CanGrow>true</CanGrow>
> <Value />
> </Textbox>
> </ReportItems>
> </TableCell>
> </TableCells>
> </TableRow>
> </TableRows>
> </Details>
> <Top>1in</Top>
> <Width>5.70833in</Width>
> <Footer>
> <TableRows>
> <TableRow>
> <Height>0.25in</Height>
> <TableCells>
> <TableCell>
> <ReportItems>
> <Textbox Name="textbox7">
> <Style>
> <PaddingLeft>2pt</PaddingLeft>
> <PaddingBottom>2pt</PaddingBottom>
> <PaddingTop>2pt</PaddingTop>
> <PaddingRight>2pt</PaddingRight>
> </Style>
> <ZIndex>5</ZIndex>
> <rd:DefaultName>textbox7</rd:DefaultName>
> <CanGrow>true</CanGrow>
> <Value />
> </Textbox>
> </ReportItems>
> </TableCell>
> <TableCell>
> <ReportItems>
> <Textbox Name="textbox8">
> <Style>
> <PaddingLeft>2pt</PaddingLeft>
> <PaddingBottom>2pt</PaddingBottom>
> <PaddingTop>2pt</PaddingTop>
> <PaddingRight>2pt</PaddingRight>
> </Style>
> <ZIndex>4</ZIndex>
> <rd:DefaultName>textbox8</rd:DefaultName>
> <CanGrow>true</CanGrow>
> <Value />
> </Textbox>
> </ReportItems>
> </TableCell>
> <TableCell>
> <ReportItems>
> <Textbox Name="textbox9">
> <Style>
> <PaddingLeft>2pt</PaddingLeft>
> <PaddingBottom>2pt</PaddingBottom>
> <PaddingTop>2pt</PaddingTop>
> <PaddingRight>2pt</PaddingRight>
> </Style>
> <ZIndex>3</ZIndex>
> <rd:DefaultName>textbox9</rd:DefaultName>
> <CanGrow>true</CanGrow>
> <Value />
> </Textbox>
> </ReportItems>
> </TableCell>
> </TableCells>
> </TableRow>
> </TableRows>
> </Footer>
> <TableColumns>
> <TableColumn>
> <Width>1.375in</Width>
> </TableColumn>
> <TableColumn>
> <Width>2.16667in</Width>
> </TableColumn>
> <TableColumn>
> <Width>2.16667in</Width>
> </TableColumn>
> </TableColumns>
> </Table>
> </ReportItems>
> <Style />
> <Height>2.625in</Height>
> </Body>
> <TopMargin>1in</TopMargin>
> <DataSources>
> <DataSource Name="Northwind">
> <rd:DataSourceID>9f29cda9-5388-4d45-9672-8480f8677b4d</rd:DataSourceID>
> <ConnectionProperties>
> <DataProvider>SQL</DataProvider>
> <ConnectString>data source=localhost;initial
> catalog=Northwind</ConnectString>
> <IntegratedSecurity>true</IntegratedSecurity>
> </ConnectionProperties>
> </DataSource>
> </DataSources>
> <Width>6.5in</Width>
> <DataSets>
> <DataSet Name="DataSet1">
> <Fields>
> <Field Name="Quantity">
> <DataField>Quantity</DataField>
> <rd:TypeName>System.Int16</rd:TypeName>
> </Field>
> </Fields>
> <Query>
> <DataSourceName>Northwind</DataSourceName>
> <CommandText>SELECT Quantity
> FROM [Order Details]</CommandText>
> </Query>
> </DataSet>
> </DataSets>
> <EmbeddedImages>
> <EmbeddedImage Name="arrowdn">
> <MIMEType>image/png</MIMEType>
> <ImageData>iVBORw0KGgoAAAANSUhEUgAAAAoAAAAMCAIAAADUCbv3AAAAAXNSR0IArs4c6QAAA
> ARnQU1BAACxjwv8YQUAAAAgY0hSTQAAeiYAAICEAAD6AAAAgOgAAHUwAADqYAAAOpgAABdwnLpRP
> AAAAIpJREFUKFNjNHSM+sHAcG3fUgZUoOUUzQEUcQotdkpsMfRM/o8ENB2jgIJOkdUMQEEgBVLhG
> gVRAJcDskHSCBWeyUC7IPog4lBpuApkORRpIMcytBiIkB3BALQSaCCyENwFQKUMQIzd5bE4XA5yH
> VgOyeWxIL8BvQTyFUwO1eVgW4AI2XUIj2F1OQByceaujVk1oQAAAABJRU5ErkJggg==</ImageDa
> ta>
> </EmbeddedImage>
> <EmbeddedImage Name="arrowup">
> <MIMEType>image/png</MIMEType>
> <ImageData>iVBORw0KGgoAAAANSUhEUgAAAAoAAAAMCAIAAADUCbv3AAAAAXNSR0IArs4c6QAAA
> ARnQU1BAACxjwv8YQUAAAAgY0hSTQAAeiYAAICEAAD6AAAAgOgAAHUwAADqYAAAOpgAABdwnLpRP
> AAAAJhJREFUKFN1jzEOgCAMRfE4jo66QeLgATSRxIF4BN1YGT2JB/Fa+GuxMGhTEtL/+X1UMUb1V
> jftuF7nIRMFmasdN+MC9bjJMMlm9mYJtbZociyeHSSz1mjLo6Z/HDM5lLyTQHIMKxxYp3AQWGopQ
> 1vEZDSmQ5fWLNMWJn+2ZrRE54iOt4rjJXf0qx/yQksOzgA5Aj/JMYR0Aztu4wOw2uP3AAAAAElFT
> kSuQmCC</ImageData>
> </EmbeddedImage>
> </EmbeddedImages>
> <LeftMargin>1in</LeftMargin>
> <rd:SnapToGrid>true</rd:SnapToGrid>
> <rd:DrawGrid>true</rd:DrawGrid>
> <rd:ReportID>b85de8b2-b11d-40cd-a911-1b01da08b61c</rd:ReportID>
> <BottomMargin>1in</BottomMargin>
> <Language>en-US</Language>
> </Report>

Expression

Hi,
Is it possible to use the content of à Textbox in an expression '
For example
In a textbox called "myTextBox" , i set the value of this textbox to "Red"
In an other textbox in the report, i want to set the value of this
textbox, to an expression checking the content of a field of the dataset
against the content of "myTextBox":
iif(Fields!theColor.Value = myTextxBox.value , "Color Red", "Not red")
Merci
Philippe=iif(Fields!theColor.Value = ReportItems!myTextBox.Value, "Color Red", "Not
red")
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Philippe" <ph.boussaroque@.Espace-NTIC.com> wrote in message
news:%23X9mQexZEHA.2444@.tk2msftngp13.phx.gbl...
> Hi,
> Is it possible to use the content of à Textbox in an expression '
> For example
> In a textbox called "myTextBox" , i set the value of this textbox to
> "Red"
> In an other textbox in the report, i want to set the value of this
> textbox, to an expression checking the content of a field of the dataset
> against the content of "myTextBox":
> iif(Fields!theColor.Value = myTextxBox.value , "Color Red", "Not red")
> Merci
> Philippe
>|||Ok it works
Merci beaucoup
Philippe
"Lev Semenets [MSFT]" <levs@.microsoft.com> a écrit dans le message de news:
#WBDGRyZEHA.2944@.TK2MSFTNGP11.phx.gbl...
> =iif(Fields!theColor.Value = ReportItems!myTextBox.Value, "Color Red",
"Not
> red")
> --
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
> "Philippe" <ph.boussaroque@.Espace-NTIC.com> wrote in message
> news:%23X9mQexZEHA.2444@.tk2msftngp13.phx.gbl...
> > Hi,
> >
> > Is it possible to use the content of à Textbox in an expression '
> >
> > For example
> > In a textbox called "myTextBox" , i set the value of this textbox to
> > "Red"
> > In an other textbox in the report, i want to set the value of this
> > textbox, to an expression checking the content of a field of the
dataset
> > against the content of "myTextBox":
> >
> > iif(Fields!theColor.Value = myTextxBox.value , "Color Red", "Not red")
> >
> > Merci
> >
> > Philippe
> >
> >
>