Showing posts with label page. Show all posts
Showing posts with label page. Show all posts

Sunday, March 11, 2012

Diagrams not visible in EM in Terminal Server

Hi,
I cannot see the content of diagrams when opening the Enterprise Manager in
a RemoteDesktop session on a Terminal Server. The page is simply empty. I can
however create new diagrams which remain visible after closing an re-opening.
They are again not visible if modified in the Enterprise Manager on another
machine not logged on to the Terminal Server.
Any ideas are appreciated.
TIA,
Norbert Meiss
I just tried the same thing, and the diagrams opened fine for me.
Simon Worth
"Norbert Meiss" <NorbertMeiss@.discussions.microsoft.com> wrote in message
news:220AFBB0-43D5-44D7-A429-AD2D8B140E60@.microsoft.com...
> Hi,
> I cannot see the content of diagrams when opening the Enterprise Manager
in
> a RemoteDesktop session on a Terminal Server. The page is simply empty. I
can
> however create new diagrams which remain visible after closing an
re-opening.
> They are again not visible if modified in the Enterprise Manager on
another
> machine not logged on to the Terminal Server.
> Any ideas are appreciated.
> TIA,
> Norbert Meiss

Diagrams not visible in EM in Terminal Server

Hi,
I cannot see the content of diagrams when opening the Enterprise Manager in
a RemoteDesktop session on a Terminal Server. The page is simply empty. I can
however create new diagrams which remain visible after closing an re-opening.
They are again not visible if modified in the Enterprise Manager on another
machine not logged on to the Terminal Server.
Any ideas are appreciated.
TIA,
Norbert MeissI just tried the same thing, and the diagrams opened fine for me.
--
Simon Worth
"Norbert Meiss" <NorbertMeiss@.discussions.microsoft.com> wrote in message
news:220AFBB0-43D5-44D7-A429-AD2D8B140E60@.microsoft.com...
> Hi,
> I cannot see the content of diagrams when opening the Enterprise Manager
in
> a RemoteDesktop session on a Terminal Server. The page is simply empty. I
can
> however create new diagrams which remain visible after closing an
re-opening.
> They are again not visible if modified in the Enterprise Manager on
another
> machine not logged on to the Terminal Server.
> Any ideas are appreciated.
> TIA,
> Norbert Meiss

Diagrams not visible in EM in Terminal Server

Hi,
I cannot see the content of diagrams when opening the Enterprise Manager in
a RemoteDesktop session on a Terminal Server. The page is simply empty. I ca
n
however create new diagrams which remain visible after closing an re-opening
.
They are again not visible if modified in the Enterprise Manager on another
machine not logged on to the Terminal Server.
Any ideas are appreciated.
TIA,
Norbert MeissI just tried the same thing, and the diagrams opened fine for me.
Simon Worth
"Norbert Meiss" <NorbertMeiss@.discussions.microsoft.com> wrote in message
news:220AFBB0-43D5-44D7-A429-AD2D8B140E60@.microsoft.com...
> Hi,
> I cannot see the content of diagrams when opening the Enterprise Manager
in
> a RemoteDesktop session on a Terminal Server. The page is simply empty. I
can
> however create new diagrams which remain visible after closing an
re-opening.
> They are again not visible if modified in the Enterprise Manager on
another
> machine not logged on to the Terminal Server.
> Any ideas are appreciated.
> TIA,
> Norbert Meiss

Diagram keeps resetting page breaks

I am using SQL Server 2005. I have created a database diagram and using page setup, I have set the page to 100% scale. On the diagram, I display page breaks. When I go to print the diagram (or click reset page breaks), all of the diagram objects shift down about half a page. Is anyone else having this problem? Does anyone have a fix? This is getting really frustrating! I am trying to avoid having tables span accross pages as fields tend to get lost due to margin issues.

Thanks in advance!

-Julie

I have found the Diagramming tool to be a very frustrating tool to create acceptable printouts.

So I recommend using Visio to create your Diagrams. And with Visio, you have full control of the printouts (I often use continuous Size D paper on a plotter.)

Friday, March 9, 2012

DeviceInfo StartPage not working

Hi,
I try to make a custom toolbar that navigates like the HTML toolbar.
This should support going to next page etc.
I'm trying to set the page in the deviceInfo string to pass it to the
rs.Render method.
I used the code like in ms-
help://MS.RSBOL80.1033/RSPROG/htm/rsp_prog_soapapi_dev_8x5u.htm
Although I set startpage to 2 I only get the first page or the whole
report depending if I set the toolbar to true or false.
Also, the streamIds string always is Nothing or has length 0.
My report has 2 pages when I look at it in the Reports folder.
Code is below
Thanks in advance !
'create the ReportingService object
Dim rs As New ReportingService
'set the credentials to be passed to Reporting Services
rs.PreAuthenticate = True
rs.Credentials = System.Net.CredentialCache.DefaultCredentials
Dim cache As CredentialCache = New CredentialCache
cache.Add(New Uri(rs.Url), "Negotiate", New NetworkCredential
(System.Configuration.ConfigurationSettings.AppSettings.Get
("ReportUserName"),
System.Configuration.ConfigurationSettings.AppSettings.Get
("ReportUserPassword"),
System.Configuration.ConfigurationSettings.AppSettings.Get
("ReportServer")))
'Assign CredentialCache to the Web service Client Proxy(myProxy)
Credetials property.
rs.Credentials = cache
Dim parameters As ParameterValue()
Dim encoding As String
Dim parametersUsed As ParameterValue()
Dim warnings As Warning()
Dim streamIDs As String() = Nothing
parameters = passParameters()
'render the report
Dim historyID As String = Nothing
Dim devInfo As String = "<StartPage>2</StartPage></DeviceInfo>"
Me.data = rs.Render(m_path, m_format, historyID, devInfo,
parameters, _
Nothing, Nothing, encoding, Me.mimeType, parametersUsed, _
warnings, streamIDs)
'determine if format is rendered to the web or a file.
Dim extension As String = GetExtension(Me.mimeType)
Dim reportName As String = m_path.Substring(m_path.LastIndexOf
("/") + 1)
Me.fileName = reportName & "." & extensionStartPage is only used for Image and PDF formats. For HTML, use the device
info <Section>.
--
Bryan Keller
Developer Documentation
SQL Server Reporting Services
A friendly reminder that this posting is provided "AS IS" with no
warranties, and confers no rights.
"Roel" <sig@.sig.com> wrote in message
news:Xns9549A61C42BC6sigsigcom@.207.46.248.16...
> Hi,
> I try to make a custom toolbar that navigates like the HTML toolbar.
> This should support going to next page etc.
> I'm trying to set the page in the deviceInfo string to pass it to the
> rs.Render method.
> I used the code like in ms-
> help://MS.RSBOL80.1033/RSPROG/htm/rsp_prog_soapapi_dev_8x5u.htm
> Although I set startpage to 2 I only get the first page or the whole
> report depending if I set the toolbar to true or false.
> Also, the streamIds string always is Nothing or has length 0.
> My report has 2 pages when I look at it in the Reports folder.
> Code is below
> Thanks in advance !
>
> 'create the ReportingService object
> Dim rs As New ReportingService
> 'set the credentials to be passed to Reporting Services
> rs.PreAuthenticate = True
> rs.Credentials = System.Net.CredentialCache.DefaultCredentials
> Dim cache As CredentialCache = New CredentialCache
> cache.Add(New Uri(rs.Url), "Negotiate", New NetworkCredential
> (System.Configuration.ConfigurationSettings.AppSettings.Get
> ("ReportUserName"),
> System.Configuration.ConfigurationSettings.AppSettings.Get
> ("ReportUserPassword"),
> System.Configuration.ConfigurationSettings.AppSettings.Get
> ("ReportServer")))
> 'Assign CredentialCache to the Web service Client Proxy(myProxy)
> Credetials property.
> rs.Credentials = cache
> Dim parameters As ParameterValue()
> Dim encoding As String
> Dim parametersUsed As ParameterValue()
> Dim warnings As Warning()
> Dim streamIDs As String() = Nothing
> parameters = passParameters()
> 'render the report
> Dim historyID As String = Nothing
> Dim devInfo As String = "<StartPage>2</StartPage></DeviceInfo>"
> Me.data = rs.Render(m_path, m_format, historyID, devInfo,
> parameters, _
> Nothing, Nothing, encoding, Me.mimeType, parametersUsed, _
> warnings, streamIDs)
> 'determine if format is rendered to the web or a file.
> Dim extension As String = GetExtension(Me.mimeType)
> Dim reportName As String = m_path.Substring(m_path.LastIndexOf
> ("/") + 1)
> Me.fileName = reportName & "." & extension
>|||"Bryan Keller [MSFT]" <bryanke@.online.microsoft.com> wrote in
news:O7ry#VVhEHA.712@.TK2MSFTNGP09.phx.gbl:
> StartPage is only used for Image and PDF formats. For HTML, use the
> device info <Section>.
>
Thanks! works perfect.
Is there any way to know what the last section is ? I want to have a button
to jump to the last page of the report. It is possible to set the section
to MAXINT or so, but that's ugly code :)
thanks in advance,
Roel

Friday, February 17, 2012

Dev/Learning Environment

I haven't used RS yet as we have leaned on Crystal Reports but I want to
learn and design in RS. We already have a live intranet RS page or two
developed by former employees hence I want to fill that gap of knowledge.
My questions :
While playing and designing, is it better to take my SQL dev box and add RS,
IIS, .net etc or should I just to tap into the live server that's already set
up? Any risks to running dev on the live box?
The data would reside on a third sql server.
Thanks for any best practice advice you can spare.
--
Mike
If data falls in the woods and nobody is there to see it ...... ?One gotcha that I had was getting SharePoint to use RS. Apparenlty I needed
to install some additional DLL to allow SharePoint to display RS as web
parts and for about an hour I had production SP down as things didn't go
smoothly.
I know you didn't mention SP - but in case you are gong to look forward to
it as your web portal.
"Tigermikefl" <Tigermikefl@.discussions.microsoft.com> wrote in message
news:23619A8F-2482-4CAA-9241-9C854FCE7898@.microsoft.com...
>I haven't used RS yet as we have leaned on Crystal Reports but I want to
> learn and design in RS. We already have a live intranet RS page or two
> developed by former employees hence I want to fill that gap of knowledge.
> My questions :
> While playing and designing, is it better to take my SQL dev box and add
> RS,
> IIS, .net etc or should I just to tap into the live server that's already
> set
> up? Any risks to running dev on the live box?
> The data would reside on a third sql server.
> Thanks for any best practice advice you can spare.
> --
> Mike
> If data falls in the woods and nobody is there to see it ...... ?