Automatically print multiple copies of the same report with different label on letter size p

Hi,

I am new to reporting services and I'm really stuck on a design problem. Can someone please help me?

I would like to design my own print function. When a user clicks on the print icon (preferably the one that came with reporting services), the report is automatically printed twice, once with "For Person A" and the second time with "For Person B" on it. It doesn't matter where these two labels are placed on the page. These two reports need to be printed on letter-size paper regardless of user's selection. How do I do this with minimum amount of code?

Any help would be greatly appreciated!

Depending on how the names of person A and person B actually get onto the report, you could add a grouping by person with a page break and actually make the report have 2 pages, 1 per person.|||

Hi

Thanks for your help.

The names are constant - ie they can be hardcoded.

If I make the report 1 page per person, does that mean the user will see two copies of the report in preview? Is there a way so that the user sees one copy but can print multiple copies with a single click?

Thanks!

|||

Hi

If there is a field with "Person A" and "Person B" you can add
a grouping by that field and set 'Page Break at end' on the grouping to true.

If this is a static value that has to be hard coded I cannot think of anything.

Problem when using the group by person approach is that the report will display
twice in the browser, each seperated by a pagebreak.

G

|||More specifically, the report will indicate that it has multiple pages (hence allowing the user to browse to the next page) but by default only the first page will show. When you export or print, all pages will be outputted.|||

Is there a way to do this without showing multiple copies (show one copy of the report in preview but prints two)?

Ideally I would like to create a print function that can be used across all reports, instead of changing all existing reports.

Thanks

|||

In that case your only other option is write your own rendering extension. That's quite involved and probably not how far you would want to go in this case.

You can't override the default print function.

|||Ok, got it. Thanks for your help :)

Automatically migratring metadata between instances of SQL Server

I want to move meta data between two copies of the same database running
on different machines. I do most of my work on one machine, but
sometimes have to work on a slow laptop. If I need to migrate metadata
(updated or new Stored Procedures and tables) from one machine to my
laptop, or back, is there a way I can automate the process? Is there
some way to say: hey sync this stored procedure definition in one
instance of SQL server with that in another instance?
Another way of asking the same question, but in more specific terms, is
whether there is a good way of backing up the metadata for a Stored
procedure or Table to a text file that can be placed in a source control
tool such as StarTeam or CVS? I know I can click on this and select that
and save the metadata, and then load that in on the other machine by
clicking on that and selecting this. But I want to get away from all
that laborious clicking and just run a script that automates the
process. For instance, how can I script the process of right clicking on
a table and then selecting "All Tasks | Generate SQL Script".
Thanks for your help or any hints you can offer.
- Charlie
Hi,
Try dbMaestro. It's a product that allows comparison, migration and archiving of database schema and data.
You can find it here:
http://www.extreme.co.il
"mark baekdal" wrote:

> check out www.dbghost.com for comparison, updating
> straight from your source code.
> database running
> machine, but
> migrate metadata
> machine to my
> process? Is there
> definition in one
> specific terms, is
> for a Stored
> a source control
> and select that
> other machine by
> away from all
> automates the
> right clicking on
> Script".
>
|||Hi,
Try dbMaestro. It's a product that allows comparison, migration and archiving of database schema and data.
You can find it here:
http://www.extreme.co.il
"mark baekdal" wrote:

> check out www.dbghost.com for comparison, updating
> straight from your source code.
> database running
> machine, but
> migrate metadata
> machine to my
> process? Is there
> definition in one
> specific terms, is
> for a Stored
> a source control
> and select that
> other machine by
> away from all
> automates the
> right clicking on
> Script".
>
sql

automatically copy database to another pc

When I create a setup program for my vb.net 1.0 app which has embedded sql express database, it successfully copies the database to the new machine alone with the upgraded app.

However, if I just copy the vb.exe app to the other pc and also copy the mdf, ldf files, I get an error opening the sql database.

I am presuming that the setup program does some kind of backup restore or detach, attach to copy in the .mdf.

If the user cannot do this from the management studio (or if they do not have the management studio installed), is there any way I can create some method to have this copying done automatically via some code by the user?

Thanks

SM Haig

Yes, you can run a restore script using the sqlcmd program. You can read more about the restore command here:

http://msdn2.microsoft.com/en-us/library/ms186858.aspx

Buck Woody

Automatic client redirect in SQL Server 2005

Will this work with replication too. I see it with a mirror database, but could it work if I was keeping two copies of the database and wanted to transparently reroute the connection to a surviving server?We will support such redirection on the publication database, when DB mirroring becomes a supported feature later.|||* If the publication DB is mirrored, client can do automatic redirection between the database on principal server and database on mirror server. BOL has a topic called "Replication and Database Mirroring" on this. As Li said, it will be supported once DB mirroring becomes supported feature.

* If you question is to do automatic redirection between publication DB and subscription DB, the answer is NO for SQL 2005.

automate copying access table to sql server 2005 db

I have a table in MS Access that I would like to copy/import into SQL Server 2005. I would like to automate this process so that it copies the table over on a daily basis. Can someone tell me how this can be done?
Thank you in advance.Take a look at DTS packages which you can schedule as a job - nice and easy ;)|||Take a look at DTS packages which you can schedule as a job - nice and easy ;)
I'm sure you meant SSIS :)|||SSIS? I've not come across that acronym before...
I figured for someone new at SQL Server, a scheduled DTS would be the easiest solution...|||DTS is with 2000,
SSIS is with 2005|||In 2005 (Server Management Studio)
Select database
> Management
> Legact
> Data Transformation Services
*confused*|||key word is "Legacy" here. the new ETL component in 2005 is SSIS, it's been completely re-architected.|||How do I use SSIS exactly to accomplish my task (see orig question posted).

Thanks.|||How do I use SSIS exactly to accomplish my task (see orig question posted).

Thanks.

Use SSMS. Right-click the database to which you want the data imported. Select Tasks | Import Data. Follow through the wizard and be sure to save the SSIS package to your DB server.

Then you will need to create a scheduled job to run the SSIS package on whatever schedule you want.

Notes:
If the Access db is located on a server other than the DB server, you'll need to use UNC paths (and probably an ODBC link, but it's been a while since I've had to use Access)

SSIS is a separate component of the SQL 2005 installation. If you have not installed it, it won't be available to you.

Regards,

hmscott|||That was the answer I was looking for. I created a SSIS Package and created a job for it. Seems to work nicely. Thanks again!