Print ER diagram for a database in SQL Server

Hi there,
I am a newbie to SQL Server so please bear with me if I happen to ask a
stupid question.
I am trying to print the ER diagram for our database in SQL server. In
Enterprise Manager we have an option to create the ER Diagram and then to
print it. But the problem is it prints into several pages.
I want in to print on a large paper so I could stick it to my wall. We have
a 36'x36' plotter that could print huge diagrams.
Do I have to convert it into PDF to print in on page.
Please give me some ideas.
thanks,
UdayUday,
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)

Preview only returning one record of report

I'm new to reporting services so I assume this is a stupid question however here it goes.

I created a report that will produce a simple customer invoice. I use a stored procedure to return the data. When I run the dataset in the data section it returns 5 records. When I run the report in preview mode it only returns the first record of data in the report. I did notice that when I drag and drop the dataset fields into a report it appends the record with "First(Fields!..." I assume that this will only return the first record which it appears to do. When I remove the "First" it only returns the last record in the report. How do I return all 5 of the records in the preview pane. The paging section in the preview pane in all scenerios always says 1of1 with the next page arrow grayed out.

Thanks in advance..

Hi,

use tables in stead of text boxes to visualize tabular data.

Cheers,

Yani

|||

I don't want tabular data.

I want Name, Address, City State Zip of customer #1 on Page 1 Followed by detail (I use tabular data here) for that customer

Name, Address, City State Zip of customer #2 on Page 2 Followed by detail for that customer

All I get is Customet #1 (Or #5 if I remove the first stated in the original question..)

Etc..

|||

Okay,

did u try setting up all controls related to a customer into aListControl.

The contained info by a List Control is repeated for reach data row, this way you could achieve your need.

Cheers

|||

I'm totally lost at your suggestion??

I want to produce 5 invoices.

The Stored procedure returns data for those 5 invoices.( Name, address, city, state, zip etc..)

The report should return 5 pages with a customer invoice on each page so I can print them.

I'm not sure where a list control come into play here.

|||

If You don't want ur report in a tabular form then you will have to use list control.Drop textboxes into

the list control .

|||

Thank you,

I think I got it now.

One additional question I have with Formatting and Printing. Is there any type of formatting control for printing. In my research so far It appears that printing directly from the control is not an option. For now I will print to a PDF and then print. The problem I have is the PDF is creating what appears to be about a 1" margin on the page. I need the reports to print with about a .25" margin. Is there any place to control this. I will be doing checks next and the positiong will become more critical.

Thanks in advance.

|||

Go to Report Menu->Report properties -> Layout Tab.

I think this will help.

May