Showing posts with label sizes. Show all posts
Showing posts with label sizes. Show all posts

Friday, March 30, 2012

Print ER diagram for a database in SQL Server

Uday,
right-click on the white background on the database
diagram and select Page Setup. You can select different
page sizes and scale ratios on this form.
Rgds,
Paul Ibison (SQL Server MVP)
You might also want to create "subject" areas by creating several individual
diagrams for the functional areas of the database instead of the entire
thing in one.
Sincerely,
Anthony Thomas

"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:02af01c4dc3c$1ce5b0a0$a601280a@.phx.gbl...
Uday,
right-click on the white background on the database
diagram and select Page Setup. You can select different
page sizes and scale ratios on this form.
Rgds,
Paul Ibison (SQL Server MVP)
sql

Saturday, February 25, 2012

Preview <> PrintPreview

Hi,
i created a report that works fine, in preview it shows 3 pages, but in
print preview it shows 4, i allready checked the sizes, Report.PageWidth is
21cm, left and right Margins are both with 1cm and body width is 18.75cm ...
so 21-1-1 = 19 that is great then 18.75... what i miss ?
rgards
JFRYou may want to check your object sizes in the layout view. I have found that
if the report layout is larger than the set pagesize that it will move the
extra space onto a blank page. In this case, make sure that the width of the
report in the layout view is 19 cm or less, preferably a little less. You
might also want to check the length and make sure that its not running over
there.
"JFR" wrote:
> Hi,
> i created a report that works fine, in preview it shows 3 pages, but in
> print preview it shows 4, i allready checked the sizes, Report.PageWidth is
> 21cm, left and right Margins are both with 1cm and body width is 18.75cm ...
> so 21-1-1 = 19 that is great then 18.75... what i miss ?
> rgards
> JFR