Ah that's it then. I used cdbl. Thanks.

Did you try out with the sample data?

When i tried that method it came up with #error for the non numeric item....

Without changing the stored procedure, it is a bit messy but possible.

1) In the Cell where you want to display the value, remove any existing textbox and insert a Rectangle.

2)...

It looks like you have dates stored in strings in your database, and an implicit conversion that is failing.

If you can modify the database to store dates in date type...

You haven't...

KGJ-Dev (7/10/2014)

---

Hi Micky,

Appreciate your time on this and you sample works fine. but i need to call the procedure instead of this logic because before inserting i will have some...

KGJ-Dev (7/9/2014)

---

Hi mister,

Thanks for the reply. i tried the way you suggested, no hope,

OLE DB provider "SQLNCLI10" for linked server "(null)" returned message "Deferred prepare could not be completed.".

Msg 8180,...

I haven't tested this myself, but I wonder if you have seen this post about the same issue?

http://serverfault.com/questions/258088/minimum-access-rights-for-generating-schema-creation-scripts

Unfortunately the Generate Scripts Wizard looks at sys.sql_expression_dependencies to find out what columns...

Try this:

Create Procedure TestInsert(@IdEmployee int, @Name varchar(20))

as

BEGIN

Insert into Emp(IdEmployee,Name)

output inserted.IdEmployee, inserted.Name

values(@IdEmployee,@Name);

END

to output the inserted row.

Jeff Moden (7/9/2014)

---

sqldriver (7/7/2014)

---

Jeff Moden (7/7/2014)

---

Luis Cazares (7/7/2014)

---

david.holley (7/7/2014)

---

Jeff Moden (7/7/2014)

---

jfogel (7/7/2014)

---

Great, just great. A year ago I wrote something that has to break down a CSV-style parameter string and...

What is the data source for the report ? (Thinking - why not just take your copy of the data directly from the data source)

That's fine, just checking that wasn't the problem.

Now the other question is based on me noticing that you had a login prompt for connecting to the report server right at...

Hi, so I had a look at the video and noticed one difference.

At about 1:30 into the video, you set up the credentials for the data source and "Use as...

How are you logging in to SQL via SSMS - Is it SQL Authentication or Windows Authentication?

Is it the same sql user for both SSMS sessions?

Is this problem happening...

What do you mean by "lock the tablix"?

How do you want it to behave when two more people get added?