Showing posts with label manager. Show all posts
Showing posts with label manager. Show all posts

Monday, March 26, 2012

PDF Fit to Page

I have reports being accessed through report manager in the UK and USA.
The reports were created to fit on an A4 page size which works fine in
UK but because the standard paper size in USA is Letter the export to
PDF is producing reports that are rendering to multiple pages.
Is there anyway I can set the PDF to fit to page either in the report
itself or in report manager?
If this isn't possible can I create a custom renderer that inherits the
standard PDF renderer but allows me to set the fit to page?In the report you will need to set the correct size, in the layout tab, in
report proeperties, to pen this dialog, just right click(or left depends ond
you configuration), and select properties, then move to the layout tab, and
set the correct paper size, adjust the margins as you need it, do the same
with the report's body, but you have to be carefull,
the body width must be less or equal than the
Page Width(the one in layou) - the sum of the margins if you do not meet
this requirements, you'll have pagebreaks in pdfs.
You can find more information for this at the following link:
http://blogs.msdn.com/chrisbal/
--
Eduardo Fonseca
"Nathan" wrote:
> I have reports being accessed through report manager in the UK and USA.
> The reports were created to fit on an A4 page size which works fine in
> UK but because the standard paper size in USA is Letter the export to
> PDF is producing reports that are rendering to multiple pages.
> Is there anyway I can set the PDF to fit to page either in the report
> itself or in report manager?
> If this isn't possible can I create a custom renderer that inherits the
> standard PDF renderer but allows me to set the fit to page?
>

pdf export credentials required

I have a report on my development server which opens fine in report manager
from MyComputer. I am not asked for credentials until I try to export it to
pdf. At that point, no matter what uid and pwd I enter the pdf will not come
up. When exporting the same report to Excel or HTML I am not asked for
credentials and the report comes up in those formats fine.
I need to get the report into a pdf. Please help. TIAHave you made any modifications to the config files? It sounds like
something broke or a permissions configuration got changed in your PDF
rendering extension.
--
Cheers,
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"pdschuller" <pdschuller@.discussions.microsoft.com> wrote in message
news:1D476EAD-75E4-46A4-85C4-D5014BB6AAAD@.microsoft.com...
>I have a report on my development server which opens fine in report manager
> from MyComputer. I am not asked for credentials until I try to export it
> to
> pdf. At that point, no matter what uid and pwd I enter the pdf will not
> come
> up. When exporting the same report to Excel or HTML I am not asked for
> credentials and the report comes up in those formats fine.
> I need to get the report into a pdf. Please help. TIA|||Looks like you're basically correct. I installed SP1 for Reporting Services
and the report exports to a pdf fine now. Thanks.
"Jeff A. Stucker" wrote:
> Have you made any modifications to the config files? It sounds like
> something broke or a permissions configuration got changed in your PDF
> rendering extension.
> --
> Cheers,
> '(' Jeff A. Stucker
> \
> Business Intelligence
> www.criadvantage.com
> ---
> "pdschuller" <pdschuller@.discussions.microsoft.com> wrote in message
> news:1D476EAD-75E4-46A4-85C4-D5014BB6AAAD@.microsoft.com...
> >I have a report on my development server which opens fine in report manager
> > from MyComputer. I am not asked for credentials until I try to export it
> > to
> > pdf. At that point, no matter what uid and pwd I enter the pdf will not
> > come
> > up. When exporting the same report to Excel or HTML I am not asked for
> > credentials and the report comes up in those formats fine.
> >
> > I need to get the report into a pdf. Please help. TIA
>
>sql

Wednesday, March 21, 2012

pb odbc error

>"[Microsoft][ODBC Driver Manager] Program Type out of Range"Data type issue. But you didn't really post much for details
so the best we can offer is check the following:
PRB: ODBC Driver Manager Error "Program Type out of Range"
http://support.microsoft.com/?id=238774
-Sue
On 16 Sep 2006 04:08:45 -0700, "powerbuilder99"
<kannraj88@.gmail.com> wrote:
[vbcol=seagreen]

pb odbc error

>"[Microsoft][ODBC Driver Manager] Program Type out of Range"
Data type issue. But you didn't really post much for details
so the best we can offer is check the following:
PRB: ODBC Driver Manager Error "Program Type out of Range"
http://support.microsoft.com/?id=238774
-Sue
On 16 Sep 2006 04:08:45 -0700, "powerbuilder99"
<kannraj88@.gmail.com> wrote:
[vbcol=seagreen]

Friday, March 9, 2012

Password Property in ConnectionManager

I'm developing a custom manager in SSIS that has several properties defined. One property is a password string that is visible in clear text in the properties pane. I'm trying to figure out how to create a masked field in the properties pane that will mask the text and not present this in clear text. Can someone send me instructions or code samples in C# for doing this? BOL doesn't provide any information on doing this.Hi,

we're facing the same problem, but haven't found any helpful information about it.

This post doesn't really help with the issue not displaying pwds as plain text.
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=887558&SiteID=1

Hope you guys can help.
F.|||I believe you need to implement a UITypeEditor (http://msdn2.microsoft.com/en-us/library/system.drawing.design.uitypeeditor(VS.71).aspx) to handle this type of functionality.

Password Property in ConnectionManager

I'm developing a custom manager in SSIS that has several properties defined. One property is a password string that is visible in clear text in the properties pane. I'm trying to figure out how to create a masked field in the properties pane that will mask the text and not present this in clear text. Can someone send me instructions or code samples in C# for doing this? BOL doesn't provide any information on doing this.Hi,

we're facing the same problem, but haven't found any helpful information about it.

This post doesn't really help with the issue not displaying pwds as plain text.
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=887558&SiteID=1

Hope you guys can help.
F.

|||I believe you need to implement a UITypeEditor (http://msdn2.microsoft.com/en-us/library/system.drawing.design.uitypeeditor(VS.71).aspx) to handle this type of functionality.

Saturday, February 25, 2012

PASSWORD

I forgot my "sa" password for SQL2000. Is there some place to look to get
it back? (Enterprise Manager or Query Analizer) please help?This is a multi-part message in MIME format.
--=_NextPart_000_0167_01C3A9CF.CEBC57C0
Content-Type: text/plain;
charset="Windows-1252"
Content-Transfer-Encoding: 7bit
Unless you removed the BUILTIN\Administrators group from the sysadmin role,
you can connect as a local Windows administrator on the server and use
Windows authentication to log into SQL Server. At that time, you can reset
the sa password.
--
Tom
---
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com/sql
"matta25" <matta125work@.hotmail.com> wrote in message
news:#1wbjkfqDHA.2820@.TK2MSFTNGP10.phx.gbl...
I forgot my "sa" password for SQL2000. Is there some place to look to get
it back? (Enterprise Manager or Query Analizer) please help?
--=_NextPart_000_0167_01C3A9CF.CEBC57C0
Content-Type: text/html;
charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&

Unless you removed the =BUILTIN\Administrators group from the sysadmin role, you can connect as a local Windows =administrator on the server and use Windows authentication to log into SQL =Server. At that time, you can reset the sa password.
-- Tom
---T=homas A. Moreau, BSc, PhD, MCSE, MCDBASQL Server MVPColumnist, SQL =Server ProfessionalToronto, ON Canadahttp://www.pinnaclepublishing.com/sql">www.pinnaclepublishing.com=/sql
"matta25" = wrote in message news:#1wbjkfqDHA.2820=@.TK2MSFTNGP10.phx.gbl...I forgot my "sa" password for SQL2000. Is there some place to look =to getit back? (Enterprise Manager or Query Analizer) please help?

--=_NextPart_000_0167_01C3A9CF.CEBC57C0--