How to control the report export to a pdf in Landscape mode?

hi,
I have a report and becuase of too many fields, I want to export pdf in
landscape mode. Is there any way to control this?

Thanks

oh, got it.
To do this, need to set the width of the page to 11inchs. And the width of body mostly should be 10 inchs or less. It will export the pdf document as landscape mode automatically.|||

While I am happy to hear that you set portrait and landscape in the width and height properties, it does not work.

I changed my L and R margins to about .2 and put in the width and height as 11 X 8.5.

I set my Body to at least 1/2 inch smaller that my margins to the paper size, and when I preview it, it's landscape. When I view it in PDF, it's portrait and I either have to set the printer or the pdf everytime. It also prints portrait directly to my printer, unless I change the printer setup.

It doesn't work at all with my installed PDF Writer, I have to Export to PDF thru the RS print preview.

Halp!

How to control the report export to a pdf in Landscape mode?

hi,
I have a report and becuase of too many fields, I want to export pdf in
landscape mode. Is there any way to control this?

Thanks

oh, got it.
To do this, need to set the width of the page to 11inchs. And the width of body mostly should be 10 inchs or less. It will export the pdf document as landscape mode automatically.|||

While I am happy to hear that you set portrait and landscape in the width and height properties, it does not work.

I changed my L and R margins to about .2 and put in the width and height as 11 X 8.5.

I set my Body to at least 1/2 inch smaller that my margins to the paper size, and when I preview it, it's landscape. When I view it in PDF, it's portrait and I either have to set the printer or the pdf everytime. It also prints portrait directly to my printer, unless I change the printer setup.

It doesn't work at all with my installed PDF Writer, I have to Export to PDF thru the RS print preview.

Halp!

|||same problem.plz plz help !!!!!!!!!!!!!!!!!!!!|||to solve this you should set PageHeight and PageWidth for element Report in *.rdlc file like this:

<PageHeight>8.5in</PageHeight>
<PageWidth>11in</PageWidth>
</Report>

How to control the report export to a pdf in Landscape mode?

hi,
I have a report and becuase of too many fields, I want to export pdf in
landscape mode. Is there any way to control this?I agree. They should also have a SendTo right from the preview and
hopefully add XPS format before next product.
--
William Stacey [MVP]
"Nick" <nick_1394@.yahoo.com.cn> wrote in message
news:1137696432.086601.318380@.g43g2000cwa.googlegroups.com...
| hi,
| I have a report and becuase of too many fields, I want to export pdf in
| landscape mode. Is there any way to control this?
||||Have you tried changing the Report's Page Size? Change the Height to 21cm (8
Inches?) and WIdth to 29,7 (11?) and you get landscape. It will render as
"landscape" in your Report Manager too, but usually the users' screens are
wide enough so it's not really a problem.
Kaisa M. Lindahl
"Nick" <nick_1394@.yahoo.com.cn> wrote in message
news:1137696432.086601.318380@.g43g2000cwa.googlegroups.com...
> hi,
> I have a report and becuase of too many fields, I want to export pdf in
> landscape mode. Is there any way to control this?
>|||That works. Did not see those. Thanks.
--
William Stacey [MVP]
"Kaisa M. Lindahl" <kaisaml@.hotmail.com> wrote in message
news:uqY6ylTHGHA.2064@.TK2MSFTNGP09.phx.gbl...
| Have you tried changing the Report's Page Size? Change the Height to 21cm
(8
| Inches?) and WIdth to 29,7 (11?) and you get landscape. It will render as
| "landscape" in your Report Manager too, but usually the users' screens are
| wide enough so it's not really a problem.
|
| Kaisa M. Lindahl
|
| "Nick" <nick_1394@.yahoo.com.cn> wrote in message
| news:1137696432.086601.318380@.g43g2000cwa.googlegroups.com...
| > hi,
| > I have a report and becuase of too many fields, I want to export pdf in
| > landscape mode. Is there any way to control this?
| >
|
|

How to connect the remote SQL 2005 using different user name?

Hi,
I am using the SQL 2005 management studio and trying to connect a remote SQL
2005 standard edition server in the mix authentication mode. I need to pick
up a different windows user name which existing in remote Server but is not
the one I am using to login my local. By default, the connection pick up the
user name and password which is using for local login and gray out, it
doesn’t allow to make any changes, does anyone have the idea how to make the
change?
Thanks
Wendy
One thing to try is to create a windows account and password
that is exactly the same (password, user name) and add it to
whatever PC, server you are connecting from. Then try
logging in with that login or do a Run As to run SSMS and
run as the windows account that matches the remote server
account.
-Sue
On Mon, 13 Mar 2006 13:13:28 -0800, Wendy
<Wendy@.discussions.microsoft.com> wrote:

>Hi,
>I am using the SQL 2005 management studio and trying to connect a remote SQL
>2005 standard edition server in the mix authentication mode. I need to pick
>up a different windows user name which existing in remote Server but is not
>the one I am using to login my local. By default, the connection pick up the
>user name and password which is using for local login and gray out, it
>doesnt allow to make any changes, does anyone have the idea how to make the
>change?
>Thanks
>Wendy
|||Hi Sue,
Thanks for your replay.
I manage all multiple SQL servers from one remote management studio, looks
like the only way works is using SQL authentication. That means the windows
authentication is very limited.
Wendy
"Sue Hoegemeier" wrote:

> One thing to try is to create a windows account and password
> that is exactly the same (password, user name) and add it to
> whatever PC, server you are connecting from. Then try
> logging in with that login or do a Run As to run SSMS and
> run as the windows account that matches the remote server
> account.
> -Sue
> On Mon, 13 Mar 2006 13:13:28 -0800, Wendy
> <Wendy@.discussions.microsoft.com> wrote:
>
>
sql

How to connect the remote SQL 2005 using different user name?

Hi,
I am using the SQL 2005 management studio and trying to connect a remote SQL
2005 standard edition server in the mix authentication mode. I need to pick
up a different windows user name which existing in remote Server but is not
the one I am using to login my local. By default, the connection pick up the
user name and password which is using for local login and gray out, it
doesn’t allow to make any changes, does anyone have the idea how to make t
he
change?
Thanks
WendyOne thing to try is to create a windows account and password
that is exactly the same (password, user name) and add it to
whatever PC, server you are connecting from. Then try
logging in with that login or do a Run As to run SSMS and
run as the windows account that matches the remote server
account.
-Sue
On Mon, 13 Mar 2006 13:13:28 -0800, Wendy
<Wendy@.discussions.microsoft.com> wrote:

>Hi,
>I am using the SQL 2005 management studio and trying to connect a remote SQ
L
>2005 standard edition server in the mix authentication mode. I need to pick
>up a different windows user name which existing in remote Server but is not
>the one I am using to login my local. By default, the connection pick up th
e
>user name and password which is using for local login and gray out, it
>doesnt allow to make any changes, does anyone have the idea how to make th
e
>change?
>Thanks
>Wendy|||Hi Sue,
Thanks for your replay.
I manage all multiple SQL servers from one remote management studio, looks
like the only way works is using SQL authentication. That means the windows
authentication is very limited.
Wendy
"Sue Hoegemeier" wrote:

> One thing to try is to create a windows account and password
> that is exactly the same (password, user name) and add it to
> whatever PC, server you are connecting from. Then try
> logging in with that login or do a Run As to run SSMS and
> run as the windows account that matches the remote server
> account.
> -Sue
> On Mon, 13 Mar 2006 13:13:28 -0800, Wendy
> <Wendy@.discussions.microsoft.com> wrote:
>
>

How to connect the remote SQL 2005 using different user name?

Hi,
I am using the SQL 2005 management studio and trying to connect a remote SQL
2005 standard edition server in the mix authentication mode. I need to pick
up a different windows user name which existing in remote Server but is not
the one I am using to login my local. By default, the connection pick up the
user name and password which is using for local login and gray out, it
doesnâ't allow to make any changes, does anyone have the idea how to make the
change?
Thanks
WendyOne thing to try is to create a windows account and password
that is exactly the same (password, user name) and add it to
whatever PC, server you are connecting from. Then try
logging in with that login or do a Run As to run SSMS and
run as the windows account that matches the remote server
account.
-Sue
On Mon, 13 Mar 2006 13:13:28 -0800, Wendy
<Wendy@.discussions.microsoft.com> wrote:
>Hi,
>I am using the SQL 2005 management studio and trying to connect a remote SQL
>2005 standard edition server in the mix authentication mode. I need to pick
>up a different windows user name which existing in remote Server but is not
>the one I am using to login my local. By default, the connection pick up the
>user name and password which is using for local login and gray out, it
>doesn?t allow to make any changes, does anyone have the idea how to make the
>change?
>Thanks
>Wendy|||Hi Sue,
Thanks for your replay.
I manage all multiple SQL servers from one remote management studio, looks
like the only way works is using SQL authentication. That means the windows
authentication is very limited.
Wendy
"Sue Hoegemeier" wrote:
> One thing to try is to create a windows account and password
> that is exactly the same (password, user name) and add it to
> whatever PC, server you are connecting from. Then try
> logging in with that login or do a Run As to run SSMS and
> run as the windows account that matches the remote server
> account.
> -Sue
> On Mon, 13 Mar 2006 13:13:28 -0800, Wendy
> <Wendy@.discussions.microsoft.com> wrote:
> >Hi,
> >
> >I am using the SQL 2005 management studio and trying to connect a remote SQL
> >2005 standard edition server in the mix authentication mode. I need to pick
> >up a different windows user name which existing in remote Server but is not
> >the one I am using to login my local. By default, the connection pick up the
> >user name and password which is using for local login and gray out, it
> >doesnâ't allow to make any changes, does anyone have the idea how to make the
> >change?
> >
> >Thanks
> >
> >Wendy
>

How to collapsible a column when the report was designed in table mode?

Hi folks, I'm trying to collapse a column on a report that's designed in table mode. I was trying to mimick what happens in a matrix where you have a column that has a '+' in it that makes toggles the visibility of a column to its immediate right (The reason I'm not using Matrix mode is I continually get "out of memory" errors on the report I'm generating.).

When I select the column and mark visible to 'false' in the properties, it of course asks me for a TextBox. My problem is that I am unable to find a scenario where the textbox is "in the proper group". Is this something that's supported, and if so, I'd appreciate some pointers to lead me in the right direction.

Thanks.bump.. anyone have any clues?|||

I was able to get this to work fine in RS 2005. Where is the textbox that you are setting as the ToggleItem for the table column? I selected the textbox in the table header cell immediately to the left of the column that I wanted to toggle. What is the exact error you are seeing?

-Chris

|||Chris, thanks for your reply. My problem is I was selecting the whole column and trying to toggle the visibility on that. You can't do that; you've got to set the visibility on each portion individually (column header, group, detail). Thanks again.|||

Hi Aquineas..

I needed to do the same and managed to get it to work...

Create a text box outside of the table in the mainreport - with suitable text... Show / Hide Detail

and name the text box = ToggleColumns

Now highlight the column in the table and select the ToggleItem under Visibility and type ToggleColumns.

It works for me - even though the ToogleColumns isn't available in the list.

Cheers

Michael

|||I am having the same problem as Aquineas, I took Michael's suggestion but it doesn't seem to work for me. Having done what Micheal has suggested, I hides the column period and there is no way of getting it back on run time. I think I follow the instruction carefully. I am still looking for more suggestion.

How to collapsible a column when the report was designed in table mode?

Hi folks, I'm trying to collapse a column on a report that's designed in table mode. I was trying to mimick what happens in a matrix where you have a column that has a '+' in it that makes toggles the visibility of a column to its immediate right (The reason I'm not using Matrix mode is I continually get "out of memory" errors on the report I'm generating.).

When I select the column and mark visible to 'false' in the properties, it of course asks me for a TextBox. My problem is that I am unable to find a scenario where the textbox is "in the proper group". Is this something that's supported, and if so, I'd appreciate some pointers to lead me in the right direction.

Thanks.bump.. anyone have any clues?|||

I was able to get this to work fine in RS 2005. Where is the textbox that you are setting as the ToggleItem for the table column? I selected the textbox in the table header cell immediately to the left of the column that I wanted to toggle. What is the exact error you are seeing?

-Chris

|||Chris, thanks for your reply. My problem is I was selecting the whole column and trying to toggle the visibility on that. You can't do that; you've got to set the visibility on each portion individually (column header, group, detail). Thanks again.|||

Hi Aquineas..

I needed to do the same and managed to get it to work...

Create a text box outside of the table in the mainreport - with suitable text... Show / Hide Detail

and name the text box = ToggleColumns

Now highlight the column in the table and select the ToggleItem under Visibility and type ToggleColumns.

It works for me - even though the ToogleColumns isn't available in the list.

Cheers

Michael

|||I am having the same problem as Aquineas, I took Michael's suggestion but it doesn't seem to work for me. Having done what Micheal has suggested, I hides the column period and there is no way of getting it back on run time. I think I follow the instruction carefully. I am still looking for more suggestion.

how to clear up log file in primary database in log shipping ?

our database system is runninig in log shipping mode.
currently, primary database log file get much more bigger,
but I dare not shrink log file in primary database ,
because do this will affect log shipping.
any way reslove this?
regards!Backup Log has Active and Inactive Portions. To Truncate Inactive
portion user the following command in SQL Query Analyser
USE The following Command
BACKUP LOG { database_name | @.database_name_var }
WITH TRUNCATE_ONLY|||That would break the log shipping!
AFAIK, shrinking of log file should be OK in a log shipping scenario...
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Rex" <r.ghodasara@.gmail.com> wrote in message
news:1143808657.133001.205870@.u72g2000cwu.googlegroups.com...
> Backup Log has Active and Inactive Portions. To Truncate Inactive
> portion user the following command in SQL Query Analyser
> USE The following Command
> BACKUP LOG { database_name | @.database_name_var }
> WITH TRUNCATE_ONLY
>|||thanks ,
but according to your point
as time goes, the logfile will get bigger and bigger,
shrinking logfile is not the best way?
do you think so ?
I meant how to clear up logfile and don't affect log shipping?|||The log file is emptied each time you do backup of the transaction log. So, it will grow until it
has the size needed to accommodate the modifications you do between two log backups, so just let it
be the size it need to be. If you see it grow beyond that, you can perhaps have had a long running
transaction in the log preventing the file to be emptied to a high degree. See
http://www.karaszi.com/SQLServer/info_dont_shrink.asp for more information.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
<lovexueer@.gmail.com> wrote in message news:1143814572.962154.266770@.g10g2000cwb.googlegroups.com...
> thanks ,
> but according to your point
> as time goes, the logfile will get bigger and bigger,
> shrinking logfile is not the best way?
> do you think so ?
> I meant how to clear up logfile and don't affect log shipping?
>

how to clear up log file in primary database in log shipping ?

our database system is runninig in log shipping mode.
currently, primary database log file get much more bigger,
but I dare not shrink log file in primary database ,
because do this will affect log shipping.
any way reslove this?
regards!
Backup Log has Active and Inactive Portions. To Truncate Inactive
portion user the following command in SQL Query Analyser
USE The following Command
BACKUP LOG { database_name | @.database_name_var }
WITH TRUNCATE_ONLY
|||That would break the log shipping!
AFAIK, shrinking of log file should be OK in a log shipping scenario...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Rex" <r.ghodasara@.gmail.com> wrote in message
news:1143808657.133001.205870@.u72g2000cwu.googlegr oups.com...
> Backup Log has Active and Inactive Portions. To Truncate Inactive
> portion user the following command in SQL Query Analyser
> USE The following Command
> BACKUP LOG { database_name | @.database_name_var }
> WITH TRUNCATE_ONLY
>
|||thanks ,
but according to your point
as time goes, the logfile will get bigger and bigger,
shrinking logfile is not the best way?
do you think so ?
I meant how to clear up logfile and don't affect log shipping?
|||The log file is emptied each time you do backup of the transaction log. So, it will grow until it
has the size needed to accommodate the modifications you do between two log backups, so just let it
be the size it need to be. If you see it grow beyond that, you can perhaps have had a long running
transaction in the log preventing the file to be emptied to a high degree. See
http://www.karaszi.com/SQLServer/info_dont_shrink.asp for more information.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
<lovexueer@.gmail.com> wrote in message news:1143814572.962154.266770@.g10g2000cwb.googlegr oups.com...
> thanks ,
> but according to your point
> as time goes, the logfile will get bigger and bigger,
> shrinking logfile is not the best way?
> do you think so ?
> I meant how to clear up logfile and don't affect log shipping?
>

how to clear up log file in primary database in log shipping ?

our database system is runninig in log shipping mode.
currently, primary database log file get much more bigger,
but I dare not shrink log file in primary database ,
because do this will affect log shipping.
any way reslove this?
regards!Backup Log has Active and Inactive Portions. To Truncate Inactive
portion user the following command in SQL Query Analyser
USE The following Command
BACKUP LOG { database_name | @.database_name_var }
WITH TRUNCATE_ONLY|||That would break the log shipping!
AFAIK, shrinking of log file should be OK in a log shipping scenario...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Rex" <r.ghodasara@.gmail.com> wrote in message
news:1143808657.133001.205870@.u72g2000cwu.googlegroups.com...
> Backup Log has Active and Inactive Portions. To Truncate Inactive
> portion user the following command in SQL Query Analyser
> USE The following Command
> BACKUP LOG { database_name | @.database_name_var }
> WITH TRUNCATE_ONLY
>|||thanks ,
but according to your point
as time goes, the logfile will get bigger and bigger,
shrinking logfile is not the best way?
do you think so ?
I meant how to clear up logfile and don't affect log shipping?|||The log file is emptied each time you do backup of the transaction log. So,
it will grow until it
has the size needed to accommodate the modifications you do between two log
backups, so just let it
be the size it need to be. If you see it grow beyond that, you can perhaps h
ave had a long running
transaction in the log preventing the file to be emptied to a high degree. S
ee
http://www.karaszi.com/SQLServer/info_dont_shrink.asp for more information.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
<lovexueer@.gmail.com> wrote in message news:1143814572.962154.266770@.g10g2000cwb.googlegroup
s.com...
> thanks ,
> but according to your point
> as time goes, the logfile will get bigger and bigger,
> shrinking logfile is not the best way?
> do you think so ?
> I meant how to clear up logfile and don't affect log shipping?
>