Use sql to get the next id

eg as part of your update statement

insert into table 1 ( (PK column 1) , column 2, etc

Values (

(Select TOP 1 (PK_COLUMN) from...

This can happen if there are other connections or processes accessing the database\database server at the same time that you are.

Typically queries will execute quicker against a database...

Read up on OPENQUERY + LINKEDSERVERS IN SQL SERVER 2005. This basically allows you add linked database which you can manipulate in SQL SERVER.

The great thing about it is that...

Robert,

Thanks for the reply but i am happy with the solution i have now.

i also feel that by doing it the way you suggest it may very well...

This is now working. When i checked how it was rendering on my report server it is working fine. In VS it is doing the extra page breaks, but...

I have tried this and it works to some extent, the problem now is the list of records in the subreport, If they can not be fitted on a page,...

Robin,

Thanks for the reply

I would not hold my breath this is Microsoft dont forget.

i have used other reporting tools such as crystal, access and active reports and page breaks...