# Printing issues and Page Setup

**URL:** <https://forums.toadworld.com/t/printing-issues-and-page-setup/30920>\
**Category:** Toad for SQL Server\
**Created:** [September 10, 2014, 6:11pm UTC](https://forums.toadworld.com/t/printing-issues-and-page-setup/30920 "2014-09-10T18:11:00Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![fernando.olmos2013](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/fernando.olmos2013/32/188_2.png) [@fernando.olmos2013](https://forums.toadworld.com/u/fernando.olmos2013)\
**Post date:** [September 10, 2014, 6:11pm UTC](https://forums.toadworld.com/t/printing-issues-and-page-setup/30920/1 "2014-09-10T18:11:00Z")

</div>

Here are a few weird ones!

**PROBLEM ONE**  
Go to a large store procedure in your database. Ideally one that has several pages of code.

Right click and select the “Alter Stored Procedure in Editor” option.

A new editor window is opened with the entire script for your stored procedure.

Now go to File -\> Page Setup

Change the margins to all be 5mm (or anything other than the default)

Click OK

Now go back to File -\> Page Setup

Do you see the same margins you set before or something completely different?

I see very different margin settings

**PROBLEM TWO**

Do the same steps above to open a stored procedure in a new editor window

Go to File -\> Print Preview

Looks ok right?

What about the Page number on the top right hand side?

Is it showing or starting on Page 1 or Page X?

It should start on **Page 1**.

By the way, printing from the **Print Preview** works, BUT… onto our last problem …

**PROBLEM THREE**

Close the previous TOAD sessions (I suspect this is what’s causing the problem)

Open a stored procedure but in VIEW IN A NEW WINDOW (not in the editor)

Go File -\> Print

Print to a real printer or PDF

Do you see a screen dump of the stored procedure’s first page OR do you see a printout of the entire code in the stored procedure?

We see only a screen dump.

It should print the entire code in the stored procedure just like it does when you view the code using a new editor window.

---

<div class="post-metadata">

**Author:** ![Bitter.Zhang2013](https://avatars.discourse-cdn.com/v4/letter/b/7bcc69/32.png) [@Bitter.Zhang2013](https://forums.toadworld.com/u/Bitter.Zhang2013)\
**Post date:** [September 14, 2014, 7:17pm UTC](https://forums.toadworld.com/t/printing-issues-and-page-setup/30920/2 "2014-09-14T19:17:42Z")

</div>

Thanks for your soppurt. I have create issue TSS-675 for this. We will reply this if we have decision.

Bitter
