SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Database Diagram printing problems


Database Diagram printing problems

Author
Message
Kurt W. Zimmerman
Kurt W. Zimmerman
UDP Broadcaster
UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)

Group: General Forum Members
Points: 1450 Visits: 1398
Greetings all;
I have seen this issue/problem for a number of releases now and I have not been able to resolve it. I will admit I may be missing something here.

When I design a database I typically create subject area database diagrams. Something I've done for quite some time and is essential when designing complex data structures.

The problem that I have is printing the diagrams. I will spend a fair amount of time to insure I have my tables lined up and not overlapping the page. However when I go to print my entire ER diagram will shift causing tables to overlap pages. This is so annoying!

1) Has anyone else experience this?
2) Does anyone have a resolution for this?
3) Is there something that I'm doing wrong? or is this a known issue?

Thanks in advance.
Kurt

Kurt W. Zimmerman
SR DBA
Lefrak Organization
New York, NY

http://www.linkedin.com/in/kurtwzimmerman
Michael Valentine Jones
Michael Valentine Jones
SSCertifiable
SSCertifiable (6.1K reputation)SSCertifiable (6.1K reputation)SSCertifiable (6.1K reputation)SSCertifiable (6.1K reputation)SSCertifiable (6.1K reputation)SSCertifiable (6.1K reputation)SSCertifiable (6.1K reputation)SSCertifiable (6.1K reputation)

Group: General Forum Members
Points: 6076 Visits: 11771
Did you set the database diagram to preview the page breaks so that you could see if they overlay page breaks? (Right-click on the back ground and click view page breaks)


You would probably be better off with a third-pary tool for the diagrams if this is very important to you.
Kurt W. Zimmerman
Kurt W. Zimmerman
UDP Broadcaster
UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)

Group: General Forum Members
Points: 1450 Visits: 1398
Yes, in fact I tried everything. What I noticed is when I simply go to print the page breaks shift (or maybe the entities move to the to the center of the diagram.

Unfortunately budgets are tight to purchase a 3rd party tool like ERWin. Any open source solutions you can suggest?

Kurt

Kurt W. Zimmerman
SR DBA
Lefrak Organization
New York, NY

http://www.linkedin.com/in/kurtwzimmerman
@SQLFRNDZ
@SQLFRNDZ
SSC Eights!
SSC Eights! (945 reputation)SSC Eights! (945 reputation)SSC Eights! (945 reputation)SSC Eights! (945 reputation)SSC Eights! (945 reputation)SSC Eights! (945 reputation)SSC Eights! (945 reputation)SSC Eights! (945 reputation)

Group: General Forum Members
Points: 945 Visits: 1217
I guess quest software have some toddler beta free tool?

Check it out


--SQLFRNDZ

Evil Kraig F
Evil Kraig F
SSCrazy Eights
SSCrazy Eights (9K reputation)SSCrazy Eights (9K reputation)SSCrazy Eights (9K reputation)SSCrazy Eights (9K reputation)SSCrazy Eights (9K reputation)SSCrazy Eights (9K reputation)SSCrazy Eights (9K reputation)SSCrazy Eights (9K reputation)

Group: General Forum Members
Points: 9039 Visits: 7660
Set zoom to visible level (75%-100%).
Database Diagram menu, copy diagram to clipboard.
MSPaint - Paste - Print.

Perfect? No. But it works.


- Craig Farrell

Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

For better assistance in answering your questions | Forum Netiquette
For index/tuning help, follow these directions. |Tally Tables

Twitter: @AnyWayDBA
Kurt W. Zimmerman
Kurt W. Zimmerman
UDP Broadcaster
UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)

Group: General Forum Members
Points: 1450 Visits: 1398
You have to admit that is so lame.... FYI I've posted this bug on the Microsoft support website. Thanks for your suggestion.

Kurt

Kurt W. Zimmerman
SR DBA
Lefrak Organization
New York, NY

http://www.linkedin.com/in/kurtwzimmerman
grant-616287
grant-616287
Forum Newbie
Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)

Group: General Forum Members
Points: 7 Visits: 22
I appreciate you submitting a bug to Microsoft on this issue. I hope you will post anything you find back to this forum as I too am suffering from this problem.

I have been having this problem for well over a year and it is beyond annoying. I am very diligent in how I put my database diagrams together, and I refer to them regularly throughout the software development process.

I've attached a BEFORE and AFTER jpg so that it is completely clear to anyone what is happening. In the BEFORE screen shot, you can see the entities all carefully placed within the page breaks. In the AFTER screen shot, all I have done is choose to PRINT the diagram. You can see the print dialog box open in this screen shot, and you can also see how ALL of the entities have mysteriously shifted down by about 1/2 a page.

I've tried to "outsmart" the shift, thinking OK, if it wants to shift 1/2 a page, I'll choose PRINT a 2nd time to see if it will shift again. Problem now is that it doesn't shift anymore. It stays "perfectly" misaligned.
Attachments
BEFORE.jpg (44 views, 131.00 KB)
AFTER.jpg (48 views, 220.00 KB)
Jeff Moden
Jeff Moden
SSC Guru
SSC Guru (91K reputation)SSC Guru (91K reputation)SSC Guru (91K reputation)SSC Guru (91K reputation)SSC Guru (91K reputation)SSC Guru (91K reputation)SSC Guru (91K reputation)SSC Guru (91K reputation)

Group: General Forum Members
Points: 91336 Visits: 41151
It's certainly not a fix but there IS a work around...

The "problem" is that the printed version treats all 6 pages as if it were a "single page" and tries to center the entire diagram on that "single page". The work around is to put one item close to the top of that "single page" and one item near the bottom. It doesn't even have to be anything significant... a sparsley filled text box with the date and the author's name (you DO do such things, don't you? ;-)) wil suffice.

--Jeff Moden

RBAR is pronounced ree-bar and is a Modenism for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column.
If you think its expensive to hire a professional to do the job, wait until you hire an amateur. -- Red Adair

Helpful Links:
How to post code problems
How to post performance problems
Forum FAQs
Mike Bourgeois
Mike Bourgeois
SSChasing Mays
SSChasing Mays (630 reputation)SSChasing Mays (630 reputation)SSChasing Mays (630 reputation)SSChasing Mays (630 reputation)SSChasing Mays (630 reputation)SSChasing Mays (630 reputation)SSChasing Mays (630 reputation)SSChasing Mays (630 reputation)

Group: General Forum Members
Points: 630 Visits: 958
Are you going into File / Page Setup to set the correct paper size while you're using the diagram?

I've had my page breaks move when previewing them using my default "Letter" size & then selecting 11 x 17 in the printer preferences when actually printing.

My apologies if you're well past this point.
paul.jones
paul.jones
Old Hand
Old Hand (386 reputation)Old Hand (386 reputation)Old Hand (386 reputation)Old Hand (386 reputation)Old Hand (386 reputation)Old Hand (386 reputation)Old Hand (386 reputation)Old Hand (386 reputation)

Group: General Forum Members
Points: 386 Visits: 731
My work-around is,

Zoom to 100%
right-click on the diagram
select "Copy Diagram to Clipboard"
Paste into MS Word or similar
Print it from there.

If the diagram needs to span multiple pages I've also tried pasting into Excel so I can set the page breaks.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search