copy of a group on same page

hi everyone, i was just wondering if there is a solution to a couple of problems i am having. I am designing a report for checks and have a group header with the details at the top of the page and want to duplicate the exact group with details in the middle of the page, is this possible? everytime i add another group, it embeds it in the first group.

also, i want to add an underlay with "VOID" on the checks at the page footer after the fist page. any ideas?

JosoCan you show us the expected report format?sqlsql

Copy database from SQL 2k to 2005?

I'm able to use SQL 2005's VB management page to import the tables and views from a database in SQL 2000 on another server, but how do I get all of the data like stored procedures, etc...?

you were better off backing up the database from sql 2000 (right click db, all tasks > backup database), then restoring in from device on 2005, that would have kept all your data
|||

if you want the entire dbs data you can perform backup and restore in sql 2005........for certain objects you can script them and execute the script in sql 2k5.......

Converting text to numeric

I have a database table with 2 numeric fields. The values to be inserted into these fields come from text boxes in an ASP.NET page. So in the parameters to add into these fields I simply use 'textbox1.text' & textbox2.text'.

One of the fields accepts the data within the text box and adds it into the appropriate numeric data field in the table. However on the other text box I get an error message 'Error converting data type nvarchar to numeric.'

Does anyone know why this occurs just on the one entry and not the other?, and if anyone has any suggestions on how to get around this please let me know.

Many ThanksWhat are the values of textbox1 and textbox2? If you have "fred" in textbox2, of course it cannot be converted to a numeric value.