Needed to place the text boxes inside a list. DUH!!!

Thanks Jack Corbett

I knew it was something stupid.

Thanks

I attached a file with the DataSet, the report and the webpage.

Thanks

Made a mistake on the title. It should have been: "Report only printing last ROW". Cannot change it so I'm adding this reply 😉

Alright, alright. Lets just forget about the numbers. I just need a query that will distribute the rows from one table evenly between the rows from another table trying to...

I'm sorry for being vague in my post.

I need the query to make this distribution only once per day. This means that all available (not previously assigned) cases will be...

Found out that I generated the problem myself when I ran the script to create the login BEFORE restoring the databases.

Databases have to be restored first (even having all logins...

Guys thanks for your prompt reply.

I've been trying to move the logins but I'm stuck with finding all of the logins created with no database mappings. I executed sp_change_users_login 'Report'...

Trigger will work if the input is by record, however for bulk input then you might have to use REPLACE(MyValue,',','') in the SQL that stores the info.

trigger will check for every row inserted

Greg, thanks a lot for pointing me in the right direction!

CREATE TABLE tmp_test (

   recid  smallint

      IDENTITY(1,1)

      PRIMARY KEY CLUSTERED,

   mycolumn        varchar(50)     NOT NULL )

create trigger tmp_test_trigger on tmp_test

for insert as

declare @id int

declare @index smallint

select @id = recid, @index =...

Thanks guys...

It actually is veru useful. I've created some sp with dynamic sql and have been dealing with that 'where used' problem....

It's a lot easier this way.

Thanks for your reply.

Right, it returns the whole table, but a select without a where clause does the same thing. So what is it then for? It doesn't make...

I did. Read about it and did use it on my testings. You are right. This is what must be used.

Thanks for posting it.