Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

Database Diagram printing problems Expand / Collapse
Author
Message
Posted Friday, October 29, 2010 10:08 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Wednesday, July 16, 2014 8:52 AM
Points: 980, Visits: 1,324
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
Post #1013196
Posted Friday, October 29, 2010 10:17 AM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Today @ 5:52 PM
Points: 3,116, Visits: 11,387
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.

Post #1013202
Posted Friday, October 29, 2010 10:38 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Wednesday, July 16, 2014 8:52 AM
Points: 980, Visits: 1,324
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
Post #1013216
Posted Friday, October 29, 2010 2:17 PM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Wednesday, July 16, 2014 12:40 AM
Points: 463, Visits: 1,022
I guess quest software have some toddler beta free tool?

Check it out



--SQLFRNDZ
Post #1013316
Posted Friday, October 29, 2010 4:03 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 5:23 PM
Points: 6,131, Visits: 7,170
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
Post #1013372
Posted Saturday, October 30, 2010 6:02 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Wednesday, July 16, 2014 8:52 AM
Points: 980, Visits: 1,324
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
Post #1013446
Posted Sunday, September 25, 2011 7:22 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, March 19, 2013 1:43 PM
Points: 5, 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.



  Post Attachments 
BEFORE.jpg (28 views, 131.69 KB)
AFTER.jpg (20 views, 220.52 KB)
Post #1180703
Posted Sunday, September 25, 2011 8:21 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Today @ 2:50 PM
Points: 36,711, Visits: 31,159
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."

(play on words) "Just because you CAN do something in T-SQL, doesn't mean you SHOULDN'T." --22 Aug 2013

Helpful Links:
How to post code problems
How to post performance problems
Post #1180709
Posted Monday, September 26, 2011 7:54 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Thursday, July 17, 2014 4:01 PM
Points: 517, Visits: 784
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.



Post #1180988
Posted Wednesday, September 28, 2011 9:39 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Monday, January 7, 2013 2:22 AM
Points: 376, Visits: 728
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.
Post #1182586
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse