Then your textbox is not named textbox1. Check to see what it is named.

I think you may have posted in the wrong forum as this is a 2000 forum, but you should try this:

DECLARE @var XML

SET @var = '' -- '<test>test</test>'

SELECT @var.exist('/test')

IF...

You need to use the ReportItems collection like this:

=ReportItems.textbox1.Value + ReportItems.textbox2.Value

Thanks for posting the solution.

Because you are using the Format function you need to specify a user-defined format. Try checking out this article.

I think you want something like this:

=Iif(Fields!Data1.Value="String1",Format(Fields!Data2.Value,"#.###,###"),Format(Fields!Data2.Value,"#.###,##"))

I think this will work (please note how I supplied some test data):

DECLARE @inventory_history table(itm_code INT, tran_type VARCHAR(15), itm_qty INT, doc_date datetime)

DECLARE @date DATETIME

SET @date = '3/31/2009'

INSERT INTO @inventory_history (

itm_code,

tran_type,

itm_qty,

doc_date

)...

To my knowledge there are 2 ways to do this.

1. Use a configuration file to store the variable values and use the same configuration file for each package.

2. ...

I think this expression will do what you want, but, as always, there may be a better way, such as returning a grouping column in the dataset.

=IIF(RowNumber(Nothing) Mod 5 =...

If you used the default install you should not need the "$" at the end of the URL. Try http://localhost/reports

Steve Jones - Editor (4/6/2009)

---

Nice list, Meredith.

Feel free to use the "report button" to let me know about misposted items. Also dups, I tend to close them out if...

Exactly! I don't drink but posts like these could drive me...

Chris Morris (4/6/2009)

---

I reckon this is what you are looking for

DROP TABLE #Temp

CREATE TABLE #Temp (col1 CHAR(1), col2 CHAR(1), col3 CHAR(1), col4 CHAR(1), col5 CHAR(1))

INSERT INTO #Temp (col1, col2, col3,...

Okay, I think I understand what is going on. The X locks are actually on different objects because they are Key-range locks on the index. The range is...

Please don't qualify the results in the data I presented, just answer what your requirements require you to return based on the data provided. It seems you keep changing...

Based on this data:

ID Col1 Col2 Col3 ...