Showing posts with label inch. Show all posts
Showing posts with label inch. Show all posts

Friday, March 30, 2012

Margin rendering

When running a SSRS 2005 Report on local machines (running Windows XP) A certain Textbox Label is not wrapping and is sized with .25 inch blank spacing at the end of the text. When running thru a datadriven Subscription this label is wrapping to next line on the PDF file that is produced.

We went to the SSRS 2005 server( Windows server 2003) and opened the report and it shows this label wrapping and the text is not fitting in the label box. But on every client box that we open this report on it shows it not wrapping. Is there a setting on the Server that we need to set for this report to render correctly.

Hi Brad,

A couple questions for you:

1) Are all machines running the same version of SSRS?

2) Are you exporting to PDF in all cases?

3) Do the various servers on which the different reports run have differing DPI settings?

Many thanks,

Chris

Margin and Paper Orientation programmatically

Hello.

I have a report but by default it prints Portrait and 1.0inch Margin. I would like to programmatically set the values of my report to 0.2 inch margin and Landscape. I am using RDLC (Local Report).

Does anyone has an idea how to achieve this?

Jose

Pls try, Report ->properties ->layout.

Over here u cans et margins as well as width and height of the report.

|||

Report -> Properties -> Layout does not exists.

i don't think it has something to do with the report itself, but the PrintDoc related to the Report Control.

Based on my analysis, The Report Control MIGHT create a PrintDoc on the fly and set the Rendered Report to it. So, i guess we could try to trap that PrintDoc before is sent to Printer.

But, so far... i can't find the "way" to "meet up" with this PrintDoc chic.

Any other suggestion?

|||

Ok. I see what you mean now. Those Margins and Padding are related to the Control itself. For example, any other control inside the Reprt Control. It's like <Table> in HTML. You can set Margins and Paddings of its cells for other controls inside.

Well... i keep on looking a solution.... I trapped the Print Event but nothing about any hint to set Printing Margin and Orientation... Sad

|||

I found this solution but still is not what i am looking for. So far this solution only works with IMAGE output and it's really messy. So, i'll try to figure out what to do.

http://blogs.msdn.com/bryanke/articles/71491.aspx

Nobody can help please?

Wednesday, March 7, 2012

Managing Permissions

I am having trouble managing permission and am looking for a solution. My
databases has 150 tables, 5 Roles and ~40 logins. And I have a 2 inch by 3
inch window to check and uncheck table/Column permissions. This is
frustrating!!! Is this data held in one of the system tables? Is there som
e
additional software to handle this?Hi,
See "GRANT" and "REVOKE" commands in SQL Server Books online.
Thanks
Hari
SQL Server MVP
"Matt Sonic" <MattSonic@.discussions.microsoft.com> wrote in message
news:3F3DE2FD-C2F3-4DA3-849F-1F7BC167B87F@.microsoft.com...
>I am having trouble managing permission and am looking for a solution. My
> databases has 150 tables, 5 Roles and ~40 logins. And I have a 2 inch by
> 3
> inch window to check and uncheck table/Column permissions. This is
> frustrating!!! Is this data held in one of the system tables? Is there
> some
> additional software to handle this?|||Check out http://www.agileinfollc.com DataStudio
"Matt Sonic" <MattSonic@.discussions.microsoft.com> wrote in message
news:3F3DE2FD-C2F3-4DA3-849F-1F7BC167B87F@.microsoft.com...
>I am having trouble managing permission and am looking for a solution. My
> databases has 150 tables, 5 Roles and ~40 logins. And I have a 2 inch by
> 3
> inch window to check and uncheck table/Column permissions. This is
> frustrating!!! Is this data held in one of the system tables? Is there
> some
> additional software to handle this?