PDF Formatting Problem

Dear All,
I have written a database application in SQL and am using SQL Reporting
Services (for the first time) to generate the reports. I have come across a
problem to which I cannot see a solutions.
As part of the database application we store 'Visit Reports' which sales
people use to record information about customer that they have visited. I
have written a report which should display each record on a seperate page.
However, when someone has written a particularly long report and this spans 2
or more pages the report formats correctly on the screen, but when you export
to pdf you have the header information on 1 page (let's say the top 1/3 of
the page) and the detail of the report moves on to the next page. What I
want to happen is for the report to move on to a new page when appropriate
(i.e. when the 1st page is full).
Has anyone come across this? Is there a solution?
Thanks in advance,
Mike SwannIt looks like your report is either wider than 8½" or taller than 11".
Remember to take into account the body of your report, and the height of
header and footer (if there are any). I keep a safety margin of ½" to 1" to
avoid such issues.
Alain Quesnel
alainsansspam@.logiquel.com
www.logiquel.com
"Mike Swann" <MikeSwann@.discussions.microsoft.com> wrote in message
news:C806740E-EE41-4E99-9F71-4D0610E6B7F2@.microsoft.com...
> Dear All,
> I have written a database application in SQL and am using SQL Reporting
> Services (for the first time) to generate the reports. I have come across
> a
> problem to which I cannot see a solutions.
> As part of the database application we store 'Visit Reports' which sales
> people use to record information about customer that they have visited. I
> have written a report which should display each record on a seperate page.
> However, when someone has written a particularly long report and this
> spans 2
> or more pages the report formats correctly on the screen, but when you
> export
> to pdf you have the header information on 1 page (let's say the top 1/3 of
> the page) and the detail of the report moves on to the next page. What I
> want to happen is for the report to move on to a new page when appropriate
> (i.e. when the 1st page is full).
> Has anyone come across this? Is there a solution?
> Thanks in advance,
> Mike Swann|||Thanks for your response.
However, this is a UK A4 format and that is all correct. It is purely when
the report data forces it on to 2 pages. If there is only enough data for 1
page then it will convert to a pdf perfectly well.
Any other ideas?
Thanks
Mike
"Alain Quesnel" wrote:
> It looks like your report is either wider than 8½" or taller than 11".
> Remember to take into account the body of your report, and the height of
> header and footer (if there are any). I keep a safety margin of ½" to 1" to
> avoid such issues.
>
> Alain Quesnel
> alainsansspam@.logiquel.com
> www.logiquel.com
>
> "Mike Swann" <MikeSwann@.discussions.microsoft.com> wrote in message
> news:C806740E-EE41-4E99-9F71-4D0610E6B7F2@.microsoft.com...
> >
> > Dear All,
> >
> > I have written a database application in SQL and am using SQL Reporting
> > Services (for the first time) to generate the reports. I have come across
> > a
> > problem to which I cannot see a solutions.
> >
> > As part of the database application we store 'Visit Reports' which sales
> > people use to record information about customer that they have visited. I
> > have written a report which should display each record on a seperate page.
> > However, when someone has written a particularly long report and this
> > spans 2
> > or more pages the report formats correctly on the screen, but when you
> > export
> > to pdf you have the header information on 1 page (let's say the top 1/3 of
> > the page) and the detail of the report moves on to the next page. What I
> > want to happen is for the report to move on to a new page when appropriate
> > (i.e. when the 1st page is full).
> >
> > Has anyone come across this? Is there a solution?
> >
> > Thanks in advance,
> >
> > Mike Swann
>|||You say that your header occupies 1/3 of the page. Did you try a smaller
header? Or no header at all?
Alain Quesnel
alainsansspam@.logiquel.com
www.logiquel.com
"Mike Swann" <MikeSwann@.discussions.microsoft.com> wrote in message
news:D41B4154-8BDA-4534-9B60-3619D81E995E@.microsoft.com...
> Thanks for your response.
> However, this is a UK A4 format and that is all correct. It is purely
> when
> the report data forces it on to 2 pages. If there is only enough data for
> 1
> page then it will convert to a pdf perfectly well.
> Any other ideas?
> Thanks
> Mike
>
> "Alain Quesnel" wrote:
>> It looks like your report is either wider than 8½" or taller than 11".
>> Remember to take into account the body of your report, and the height of
>> header and footer (if there are any). I keep a safety margin of ½" to 1"
>> to
>> avoid such issues.
>>
>> Alain Quesnel
>> alainsansspam@.logiquel.com
>> www.logiquel.com
>>
>> "Mike Swann" <MikeSwann@.discussions.microsoft.com> wrote in message
>> news:C806740E-EE41-4E99-9F71-4D0610E6B7F2@.microsoft.com...
>> >
>> > Dear All,
>> >
>> > I have written a database application in SQL and am using SQL Reporting
>> > Services (for the first time) to generate the reports. I have come
>> > across
>> > a
>> > problem to which I cannot see a solutions.
>> >
>> > As part of the database application we store 'Visit Reports' which
>> > sales
>> > people use to record information about customer that they have visited.
>> > I
>> > have written a report which should display each record on a seperate
>> > page.
>> > However, when someone has written a particularly long report and this
>> > spans 2
>> > or more pages the report formats correctly on the screen, but when you
>> > export
>> > to pdf you have the header information on 1 page (let's say the top 1/3
>> > of
>> > the page) and the detail of the report moves on to the next page. What
>> > I
>> > want to happen is for the report to move on to a new page when
>> > appropriate
>> > (i.e. when the 1st page is full).
>> >
>> > Has anyone come across this? Is there a solution?
>> >
>> > Thanks in advance,
>> >
>> > Mike Swann
>>

PDF EXPORT

Dear All

I use sql server reporting services..in visual studio 2005..

when exporting report to pdf in the report viewer alignment varies..

single table report split up in to two pages not in proper manner..

how to tackle this export to pdf event in report viewer..

did anyone can help me in this.

Regards

Senthil

You need to do adjust the table correctly. just decrease the width of the table and other objects.

if width of the objects does not fit in a page than it will be divided into two pages in pdf. so try to adjust the width of the objects.

|||

I had the same problem and this is what I found. If the report is defined as an 11 x 8.5 (landscape) report with .5 margins (defined in report properties) all around your report data cannot exceed 10".

10" + .5 left margin + .5 right margin = 11.

If you exceed this the page will split.

|||

Thnx jhaberer

its working fine!...

sql

Payroll Security

Dear all,
I want to use SQL 2005 as back end for payroll software.
If I want the administrator can not see the employee salary, how to use the
built in encryption feature ?
Thanks.
VensiaOne of the ways to do this would to use a trigger on the table that contains
the information. In this CLR Trigger, call the native encryption functions.
Shaun McDonnell

> Dear all,
> I want to use SQL 2005 as back end for payroll software.
> If I want the administrator can not see the employee salary, how to
> use the
> built in encryption feature ?
> Thanks.
> Vensia
>

Payroll Database Security

Dear all,
I have a payroll database and only payroll user can see the data. Can I
prevent the SQL server administrator accessing the database ?
Thanks before.
Regards,
VensiaHi
No, not natively. Get your vendor to support SQL Server 2005 when it is
released 7 November 2005 and then each column can be encrypted in the DB.
--
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Vensia" wrote:

> Dear all,
> I have a payroll database and only payroll user can see the data. Can I
> prevent the SQL server administrator accessing the database ?
> Thanks before.
> Regards,
> Vensia
>
>|||Currently, how payroll software vendor protect the database from being
accessed by administrator except the HR user ?
Thx.
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:FCB592B0-6112-4567-8B01-EB7DA1150331@.microsoft.com...[vbcol=seagreen]
> Hi
> No, not natively. Get your vendor to support SQL Server 2005 when it is
> released 7 November 2005 and then each column can be encrypted in the DB.
> --
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
>
> "Vensia" wrote:
>

Pay Attention Please...

Dear Sir,
Actually i want to ask, how to install the SQL Server Desktop Edition
2000 Client Tools only from the Command Prompt ? i have gone through the
internet but all the responds were about SQL Server Desktop Edition
2005, and it does not work for SQL Server Desktop Edition 2000.
I just could find the below command to install the full package:
setup.exe sapwd=abc123 sequritymode=sql
disablenetworkprotocols=0
Could you please help me to get this done,
Appreciate your kind consideration,
Best Regards,
Feri.
*** Sent via Developersdex http://www.codecomments.com ***
First, I would put something less like a junk mail subject in the subject. I
suggest: "SQL Server Desktop 2000 Installation".
Next, I would post this on the right newsgroup. This group focuses on
Connecting to SQL Server. You have an installation issue so I suggest using
microsoft.public.sqlserver.msde...
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant, Dad, Grandpa
Microsoft MVP
INETA Speaker
www.betav.com
www.betav.com/blog/billva
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
------
"Feri Sh" <far.sharifi@.gmail.com> wrote in message
news:uwMDZQM2HHA.1168@.TK2MSFTNGP02.phx.gbl...
> Dear Sir,
> Actually i want to ask, how to install the SQL Server Desktop Edition
> 2000 Client Tools only from the Command Prompt ? i have gone through the
> internet but all the responds were about SQL Server Desktop Edition
> 2005, and it does not work for SQL Server Desktop Edition 2000.
> I just could find the below command to install the full package:
> setup.exe sapwd=abc123 sequritymode=sql
> disablenetworkprotocols=0
> Could you please help me to get this done,
> Appreciate your kind consideration,
>
> Best Regards,
> Feri.
> *** Sent via Developersdex http://www.codecomments.com ***
sql

Pay Attention Please...

Dear Sir,
Actually i want to ask, how to install the SQL Server Desktop Edition
2000 Client Tools only from the Command Prompt ? i have gone through the
internet but all the responds were about SQL Server Desktop Edition
2005, and it does not work for SQL Server Desktop Edition 2000.
I just could find the below command to install the full package:
setup.exe sapwd=abc123 sequritymode=sql
disablenetworkprotocols=0
Could you please help me to get this done,
Appreciate your kind consideration,
Best Regards,
Feri.
*** Sent via Developersdex http://www.codecomments.com ***First, I would put something less like a junk mail subject in the subject. I
suggest: "SQL Server Desktop 2000 Installation".
Next, I would post this on the right newsgroup. This group focuses on
Connecting to SQL Server. You have an installation issue so I suggest using
microsoft.public.sqlserver.msde...
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant, Dad, Grandpa
Microsoft MVP
INETA Speaker
www.betav.com
www.betav.com/blog/billva
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
----
---
"Feri Sh" <far.sharifi@.gmail.com> wrote in message
news:uwMDZQM2HHA.1168@.TK2MSFTNGP02.phx.gbl...
> Dear Sir,
> Actually i want to ask, how to install the SQL Server Desktop Edition
> 2000 Client Tools only from the Command Prompt ? i have gone through the
> internet but all the responds were about SQL Server Desktop Edition
> 2005, and it does not work for SQL Server Desktop Edition 2000.
> I just could find the below command to install the full package:
> setup.exe sapwd=abc123 sequritymode=sql
> disablenetworkprotocols=0
> Could you please help me to get this done,
> Appreciate your kind consideration,
>
> Best Regards,
> Feri.
> *** Sent via Developersdex http://www.codecomments.com ***

Password Change

Dear Friends
I have installed MSDE version on my pc but for the same
it have asked me to change the password of SA now i want
to change the password of SA with OSQL utility as i do
not have the Enterprise mangaer. Plese suggest how i can
change the same.
Your earlier reply will be helpful.
Best regards
ShaileshIn Osql you can use the sp_password system SP. Do please check the syntax in
Books OnLine.
Dejan Sarka, SQL Server MVP
Associate Mentor
Solid Quality Learning
More than just Training
www.SolidQualityLearning.com
"shailesh" <anonymous@.discussions.microsoft.com> wrote in message
news:7a0d01c3e8d5$a3d6fe80$a101280a@.phx.gbl...

quote:

---

> Dear Friends
> I have installed MSDE version on my pc but for the same
> it have asked me to change the password of SA now i want
> to change the password of SA with OSQL utility as i do
> not have the Enterprise mangaer. Plese suggest how i can
> change the same.
> Your earlier reply will be helpful.
> Best regards
> Shailesh

---

|||Hi,
From command prompt execute
OSQL -Usa -Ppassword -Sservername -Q"sp_password oldpassword,newpassword,sa"
Thanks
Hari
MCDBA
"Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@.avtenta.si> wrote in
message news:eVhRceN6DHA.1804@.TK2MSFTNGP12.phx.gbl...

quote:

---

> In Osql you can use the sp_password system SP. Do please check the syntax

---

in

quote:

---

> Books OnLine.
> --
> Dejan Sarka, SQL Server MVP
> Associate Mentor
> Solid Quality Learning
> More than just Training
> www.SolidQualityLearning.com
> "shailesh" <anonymous@.discussions.microsoft.com> wrote in message
> news:7a0d01c3e8d5$a3d6fe80$a101280a@.phx.gbl...
>

---