Showing posts with label pdf. Show all posts
Showing posts with label pdf. Show all posts

Thursday, March 29, 2012

Drawing error when rendering report in PDF

Hi
We had run SQL Server Report Services Service PAck2 and after installing that we are not able to open reports in PDF format. it gives drawing error .

Any help in this regard is appreciated.What the exact error message ?

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de|||Hi Jens
The exact error message would be "A Drawing Error Occured"

As I had told we are having SQL Server 2000, SQL Server 2000 Reporting Services. Somebody in the forum suggested to install service pack2 which we did for earlier another issue where it was printing extra pages in both Excel and PDF. So after installing sp2 the PDF got messed up.

Any help in this regard is appreciated

Thanks|||

Hi,

This is probably an error in SP2, you can get a fix from Microsoft by contacting them on the mentioned ways here: http://support.microsoft.com/kb/912424/en-us

This is a PDF Error, probably a ressources not reachable or an out-of-memory error.

http://support.microsoft.com/kb/912424/en-us

HTH, jens Suessmeyer.

http://www.sqlserver2005.de

|||Hi
Thanks Jens the link helped us solve the issue.There is another related issue which if you could show us a little direction in solving it. Here is the issue

We are working on SQL Server Reporting Services 2000. We designed a

report and exported the same into excel. The original report has lets

say one page information, then before printing when we see print

preview it shows up an extra blank page and similarly if the there are

two pages in the report ,in the preview we are seeing 4 pages ie two

extra blank pages. Any help to solve this issue would be appreciated.

The same thing we are exporting in PDF format also and here to same

issue.

We are in need of a solution. It would be of great help if you could help us in getting a solution to this issue.
We have SQL Server 2000 and SQL Server 2000 Reporting services and Microsoft Office 2003

Thanks
|||Thats a really common problem. You defined the report margins to big. If the report exceeds the page format it will break the report to multiple pages. So make sure that the visible area of your report (and the additional borders) does not exceed the format specified on the report properties. Sizing the report will let you keep your report on one page per report page. Its something like playing around with the margins and sizes to fit all your data on one page.

HTH, jens Suessmeyer.

http://www.sqlserver2005.de

Tuesday, March 27, 2012

DPI of PDF

Is there a way to increase the dpi of the actual pdf itself when exported
from the .NET IDE? Currently Adobe Acrobat reports the dpi of the pdf as 72
dpi. I need it to be at least 300 dpi.Sandy,
The PDF extension supports additional device settings (DpiX and DpiY) which
allows you to change the PDF resolution. Please look at the "PDF Device
information settings" topics in the RS documentation.
--
Hope this helps.
---
Teo Lachev, MVP [SQL Server], MCSD, MCT
Author: "Microsoft Reporting Services in Action"
Publisher website: http://www.manning.com/lachev
Buy it from Amazon.com: http://shrinkster.com/eq
Home page and blog: http://www.prologika.com/
---
"sandy" <sandy@.discussions.microsoft.com> wrote in message
news:1AB58DD1-609D-4235-95D6-F8C5F277A641@.microsoft.com...
> Is there a way to increase the dpi of the actual pdf itself when exported
> from the .NET IDE? Currently Adobe Acrobat reports the dpi of the pdf as
72
> dpi. I need it to be at least 300 dpi.|||Before I posted, I read the documentation regarding device settings specific
to pdf. I saw where I can change the dpi, but the documentation also states
that the default is 300 dpi. If this is the case, why are the pdf's at a
lower resolution than expected?
"Teo Lachev [MVP]" wrote:
> Sandy,
> The PDF extension supports additional device settings (DpiX and DpiY) which
> allows you to change the PDF resolution. Please look at the "PDF Device
> information settings" topics in the RS documentation.
> --
> Hope this helps.
> ---
> Teo Lachev, MVP [SQL Server], MCSD, MCT
> Author: "Microsoft Reporting Services in Action"
> Publisher website: http://www.manning.com/lachev
> Buy it from Amazon.com: http://shrinkster.com/eq
> Home page and blog: http://www.prologika.com/
> ---
> "sandy" <sandy@.discussions.microsoft.com> wrote in message
> news:1AB58DD1-609D-4235-95D6-F8C5F277A641@.microsoft.com...
> > Is there a way to increase the dpi of the actual pdf itself when exported
> > from the .NET IDE? Currently Adobe Acrobat reports the dpi of the pdf as
> 72
> > dpi. I need it to be at least 300 dpi.
>
>

Sunday, March 25, 2012

download pdf

I was wondering if there is any online user reference/manual for
transact sql (SQL Server) in PDF format? Download links? I know about
online help but I would like to have something locally.
Thanks.If you have sql server installed , then this has BOL installed automatically

--

Jack Vamvas
___________________________________
The latest IT jobs - www.ITjobfeed.com
<a href="http://links.10026.com/?link=http://www.itjobfeed.com">UK IT Jobs</a>

<othellomy@.yahoo.comwrote in message
news:1173785538.156525.107820@.h3g2000cwc.googlegro ups.com...

Quote:

Originally Posted by

>I was wondering if there is any online user reference/manual for
transact sql (SQL Server) in PDF format? Download links? I know about
online help but I would like to have something locally.
Thanks.
>

Friday, March 9, 2012

Double Byte Characters scrambled in PDF Output

Does anybody know how I can Clean up some European Characters such as "?"
in a text field:
"45000 m² new office project designed by Arquitectonica. Revised proposal
and clarifications issued to client on 26 Aug: 1239K? for MOEX, 985K for
Synthese as option. Ten competitors, including Coteba. Contract award
expected by 15 Sept 04."
Is there a certain data type to use or is there a conversion fucntion to
use?
HelpWhat you can do in this case is :
write custom code for all the clean up.
You can write code tab of the Report Properties in the Report tab under main menu.
Write your own VB.NET code.
>--Original Message--
>Does anybody know how I can Clean up some European Characters such as "?"
>in a text field:
>"45000 m=B2 new office project designed by Arquitectonica. Revised proposal
>and clarifications issued to client on 26 Aug: 1239K? for MOEX, 985K for
>Synthese as option. Ten competitors, including Coteba. Contract award
>expected by 15 Sept 04."
>Is there a certain data type to use or is there a conversion fucntion to
>use?
>Help
>
>.
>