Showing posts with label specify. Show all posts
Showing posts with label specify. Show all posts

Friday, March 30, 2012

Report Designer Sorting in Details Group?

Can you specify the Sorting in the Details group in reports designed with Report Designer? If so how?

I know that I can set the Sorting in the Details group in reports generated with Report Builder (the Sorting element is a child of the Details element).

Thanks!!!

-Brian

You can edit the Sorting in Details Group by using the Sorting tab of the Table Properties dialog in Report Designer.

-Albert

|||I don't see a Sorting tab on the Details group dialog...where is the Table Properties dialog in the Report Designer?|||To display the Table Properties dialog:

1. Click the table so that column and row handles appear above and next to the table.
2. Right-click in the upper-left hand corner where the column and row handles intersect.
3. Select Properties from the drop-down menu.

-Albert|||

Ah...they make that tough to get to don't they...

Thanks!

-Brian

Report Designer Sorting in Details Group?

Can you specify the Sorting in the Details group in reports designed with Report Designer? If so how?

I know that I can set the Sorting in the Details group in reports generated with Report Builder (the Sorting element is a child of the Details element).

Thanks!!!

-Brian

You can edit the Sorting in Details Group by using the Sorting tab of the Table Properties dialog in Report Designer.

-Albert

|||I don't see a Sorting tab on the Details group dialog...where is the Table Properties dialog in the Report Designer?|||To display the Table Properties dialog:

1. Click the table so that column and row handles appear above and next to the table.
2. Right-click in the upper-left hand corner where the column and row handles intersect.
3. Select Properties from the drop-down menu.

-Albert|||

Ah...they make that tough to get to don't they...

Thanks!

-Brian

sql

Wednesday, March 28, 2012

Report Designer - deploying to a specific directory

Hi - When creating a report without using the report wizard, how does one
specify the directory on the RS server that each SPECIFIC report is to be
deployed to? I know that the report project has a "Deployment Folder"
property but that is project-wide. We want to do it for each specific
report. Do I need separate projects for multiple folders?
thanksUnfortunately, you can only designate one folder per solution currently. A
possible alternative is to use an rs script to publish them to desired
folders. See
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsamples/htm/rss_sampleapps_v1_1apd.asp
for an example.
--
-- "This posting is provided 'AS IS' with no warranties, and confers no
rights."
jhmiller@.online.microsoft.com
"ISGADMIN" <isgadmin@.newsgroup.nospam> wrote in message
news:BB9F0755-7F44-4507-B86F-B8691615BE59@.microsoft.com...
> Hi - When creating a report without using the report wizard, how does one
> specify the directory on the RS server that each SPECIFIC report is to be
> deployed to? I know that the report project has a "Deployment Folder"
> property but that is project-wide. We want to do it for each specific
> report. Do I need separate projects for multiple folders?
> thanks|||Just a slight correction, you specify per project, not per solution.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"John H. Miller" <jhmiller@.online.microsoft.com> wrote in message
news:41813be2$1@.news.microsoft.com...
> Unfortunately, you can only designate one folder per solution currently.
A
> possible alternative is to use an rs script to publish them to desired
> folders. See
>
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsamples/htm/rss_sampleapps_v1_1apd.asp
> for an example.
> --
> -- "This posting is provided 'AS IS' with no warranties, and confers no
> rights."
> jhmiller@.online.microsoft.com
> "ISGADMIN" <isgadmin@.newsgroup.nospam> wrote in message
> news:BB9F0755-7F44-4507-B86F-B8691615BE59@.microsoft.com...
> > Hi - When creating a report without using the report wizard, how does
one
> > specify the directory on the RS server that each SPECIFIC report is to
be
> > deployed to? I know that the report project has a "Deployment Folder"
> > property but that is project-wide. We want to do it for each specific
> > report. Do I need separate projects for multiple folders?
> >
> > thanks
>|||Yes - thanks Bruce! It is per project.
--
-- "This posting is provided 'AS IS' with no warranties, and confers no
rights."
jhmiller@.online.microsoft.com
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:usX7J6RvEHA.1984@.TK2MSFTNGP14.phx.gbl...
> Just a slight correction, you specify per project, not per solution.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "John H. Miller" <jhmiller@.online.microsoft.com> wrote in message
> news:41813be2$1@.news.microsoft.com...
>> Unfortunately, you can only designate one folder per solution currently.
> A
>> possible alternative is to use an rs script to publish them to desired
>> folders. See
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsamples/htm/rss_sampleapps_v1_1apd.asp
>> for an example.
>> --
>> -- "This posting is provided 'AS IS' with no warranties, and confers
>> no
>> rights."
>> jhmiller@.online.microsoft.com
>> "ISGADMIN" <isgadmin@.newsgroup.nospam> wrote in message
>> news:BB9F0755-7F44-4507-B86F-B8691615BE59@.microsoft.com...
>> > Hi - When creating a report without using the report wizard, how does
> one
>> > specify the directory on the RS server that each SPECIFIC report is to
> be
>> > deployed to? I know that the report project has a "Deployment Folder"
>> > property but that is project-wide. We want to do it for each specific
>> > report. Do I need separate projects for multiple folders?
>> >
>> > thanks
>>
>|||Hi John, thanks much for the info.
Matt
"John H. Miller" wrote:
> Unfortunately, you can only designate one folder per solution currently. A
> possible alternative is to use an rs script to publish them to desired
> folders. See
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsamples/htm/rss_sampleapps_v1_1apd.asp
> for an example.
> --
> -- "This posting is provided 'AS IS' with no warranties, and confers no
> rights."
> jhmiller@.online.microsoft.com
> "ISGADMIN" <isgadmin@.newsgroup.nospam> wrote in message
> news:BB9F0755-7F44-4507-B86F-B8691615BE59@.microsoft.com...
> > Hi - When creating a report without using the report wizard, how does one
> > specify the directory on the RS server that each SPECIFIC report is to be
> > deployed to? I know that the report project has a "Deployment Folder"
> > property but that is project-wide. We want to do it for each specific
> > report. Do I need separate projects for multiple folders?
> >
> > thanks
>
>

Monday, March 26, 2012

Report connection fails with DNS name

Hi,

I am facing problem while setting connection string in Report Service project.
Problem is when I specify DNS name instead of machine name as the Server in the connection string.

When I specify DNS name in the connection string it gives error that "A connection cannot be made.Ensure that the server is running" on click of "Test Connection"
Also I am not able to view reports directly through IE. I.e. http://<DNS_NAME>/Reports.
When I access Reports, it prompts me to enter username/password. Even after specifying valid username, it shows me the prompt again n again.

Is there some known issue with Reporting Service or with IIS setting not able to connect to a DNS name? I did not face with any issue when
I specified DNS name in the connection string of Analysis Service project.

Did anyone encountered DNS related problem with SQL Server 2005 Reporting Service?

We also verified that:
1: Ping with both machine name and DNS name returns same result.
2: nslookup with both machine name and DNS name resolves to same IP.

3: Tried putting the DNS name in the hosts file.

Eagerly awaiting some positive reply.

Note: I am working with SQL Server 2005 Standard Edition.

No replies yetSad

We are stuck up with this issue since quite some time.

still waiting for some positive inputs.

|||

After doing some investigation, I have found that the issue is with Analysis server not able to connect using the DNS name (Note: my Reporting Service proj is connecting to Analysis services datasource). When I connect to Analysis server through SQL Server management studio (by def which uses Win authentication), and specify machine name (ABC) in Server then it connects but if I give DNS name (XYZ.PWR.COM) it gives me the following error:

************************************************************************************************************
A connection cannot be made. Ensure that the server is running. (Microsoft.AnalysisServices.AdomdClient)


Program Location:

at Microsoft.AnalysisServices.AdomdClient.XmlaClient.Connect(ConnectionInfo connectionInfo, Boolean beginSession)
at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.XmlaClientProvider.Microsoft.AnalysisServices.AdomdClient.AdomdConnection.IXmlaClientProviderEx.ConnectXmla()
at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.ConnectToXMLA(Boolean createSession, Boolean isHTTP)
at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.Open()
at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ObjectExplorer.ValidateConnection(UIConnectionInfo ci, IServerType server)
at Microsoft.SqlServer.Management.UI.ConnectionDlg.Connector.ConnectionThreadUser()

===================================

Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host. (System)


Program Location:

at System.Net.Sockets.NetworkStream.Read(Byte[] buffer, Int32 offset, Int32 size)
at System.IO.BufferedStream.Read(Byte[] array, Int32 offset, Int32 count)
at Microsoft.AnalysisServices.AdomdClient.DimeRecord.ForceRead(Stream stream, Byte[] buffer, Int32 length)
at Microsoft.AnalysisServices.AdomdClient.DimeRecord.ReadHeader()
at Microsoft.AnalysisServices.AdomdClient.DimeRecord..ctor(Stream stream)
at Microsoft.AnalysisServices.AdomdClient.DimeReader.ReadRecord()
at Microsoft.AnalysisServices.AdomdClient.TcpStream.GetResponseDataType()


************************************************************************************************************

If I connect to Reporting Service using DNS name then I get the following error:


************************************************************************************************************
===================================

Cannot connect to XYZ.PWR.COM.

===================================

A connection to the report server failed. Most likely, you do not have permission to connect to the computer. You should either try to connect using a report server URL for the Server name, or if the Distributed COM Users group exists on the remote computer, verify that you are a member. (Microsoft.SqlServer.Management.UI.RSClient)


Program Location:

at Microsoft.SqlServer.Management.UI.RSClient.RSConnectionInfo.ParseServerName(String serverName)
at Microsoft.SqlServer.Management.UI.RSClient.RSConnectionInfo.RSTypeImpl.CreateSqlOlapConnectionInfoBase(UIConnectionInfo ci)
at Microsoft.SqlServer.Management.UI.RSClient.RSConnectionInfo.RSTypeImpl.GetConnectionObject(UIConnectionInfo ci)
at Microsoft.SqlServer.Management.UI.ConnectionDlg.RSType.GetConnectionObject(UIConnectionInfo ci)
at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ObjectExplorer.ValidateConnection(UIConnectionInfo ci, IServerType server)
at Microsoft.SqlServer.Management.UI.ConnectionDlg.Connector.ConnectionThreadUser()
************************************************************************************************************

When I ping with machine name (ABC) and DNS name (XYZ.PWR.COM), both resolves to the same IP.
C:\Documents and Settings\Administrator>ping ABC

Pinging ABC.corp.abctech.com [xx.x.xx.xx] with 32 bytes of d


C:\Documents and Settings\Administrator>ping XYZ.PWR.COM

Pinging XYZ.PWR.COM [xx.x.xx.xx] with 32 bytes of data:


Is this problem because of the kerberos authentication that Analysis server uses to authenticate?

I am able to connect to the Database engine using DNS name (but using SQL Server authentication).
Also I was able to view the reportserver and reports page by changing the IIS authentication to NTLM.
But finally I am not able to view the reports.

Can anyone please help me in solving this issue.

Awatiitng some positive reply.

Report connection fails with DNS name

Hi,

I am facing problem while setting connection string in Report Service project.
Problem is when I specify DNS name instead of machine name as the Server in the connection string.

When I specify DNS name in the connection string it gives error that "A connection cannot be made.Ensure that the server is running" on click of "Test Connection"
Also I am not able to view reports directly through IE. I.e. http://<DNS_NAME>/Reports.
When I access Reports, it prompts me to enter username/password. Even after specifying valid username, it shows me the prompt again n again.

Is there some known issue with Reporting Service or with IIS setting not able to connect to a DNS name? I did not face with any issue when
I specified DNS name in the connection string of Analysis Service project.

Did anyone encountered DNS related problem with SQL Server 2005 Reporting Service?

We also verified that:
1: Ping with both machine name and DNS name returns same result.
2: nslookup with both machine name and DNS name resolves to same IP.

3: Tried putting the DNS name in the hosts file.

Eagerly awaiting some positive reply.

Note: I am working with SQL Server 2005 Standard Edition.

No replies yetSad

We are stuck up with this issue since quite some time.

still waiting for some positive inputs.

|||

After doing some investigation, I have found that the issue is with Analysis server not able to connect using the DNS name (Note: my Reporting Service proj is connecting to Analysis services datasource). When I connect to Analysis server through SQL Server management studio (by def which uses Win authentication), and specify machine name (ABC) in Server then it connects but if I give DNS name (XYZ.PWR.COM) it gives me the following error:

************************************************************************************************************
A connection cannot be made. Ensure that the server is running. (Microsoft.AnalysisServices.AdomdClient)


Program Location:

at Microsoft.AnalysisServices.AdomdClient.XmlaClient.Connect(ConnectionInfo connectionInfo, Boolean beginSession)
at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.XmlaClientProvider.Microsoft.AnalysisServices.AdomdClient.AdomdConnection.IXmlaClientProviderEx.ConnectXmla()
at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.ConnectToXMLA(Boolean createSession, Boolean isHTTP)
at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.Open()
at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ObjectExplorer.ValidateConnection(UIConnectionInfo ci, IServerType server)
at Microsoft.SqlServer.Management.UI.ConnectionDlg.Connector.ConnectionThreadUser()

===================================

Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host. (System)


Program Location:

at System.Net.Sockets.NetworkStream.Read(Byte[] buffer, Int32 offset, Int32 size)
at System.IO.BufferedStream.Read(Byte[] array, Int32 offset, Int32 count)
at Microsoft.AnalysisServices.AdomdClient.DimeRecord.ForceRead(Stream stream, Byte[] buffer, Int32 length)
at Microsoft.AnalysisServices.AdomdClient.DimeRecord.ReadHeader()
at Microsoft.AnalysisServices.AdomdClient.DimeRecord..ctor(Stream stream)
at Microsoft.AnalysisServices.AdomdClient.DimeReader.ReadRecord()
at Microsoft.AnalysisServices.AdomdClient.TcpStream.GetResponseDataType()


************************************************************************************************************

If I connect to Reporting Service using DNS name then I get the following error:


************************************************************************************************************
===================================

Cannot connect to XYZ.PWR.COM.

===================================

A connection to the report server failed. Most likely, you do not have permission to connect to the computer. You should either try to connect using a report server URL for the Server name, or if the Distributed COM Users group exists on the remote computer, verify that you are a member. (Microsoft.SqlServer.Management.UI.RSClient)


Program Location:

at Microsoft.SqlServer.Management.UI.RSClient.RSConnectionInfo.ParseServerName(String serverName)
at Microsoft.SqlServer.Management.UI.RSClient.RSConnectionInfo.RSTypeImpl.CreateSqlOlapConnectionInfoBase(UIConnectionInfo ci)
at Microsoft.SqlServer.Management.UI.RSClient.RSConnectionInfo.RSTypeImpl.GetConnectionObject(UIConnectionInfo ci)
at Microsoft.SqlServer.Management.UI.ConnectionDlg.RSType.GetConnectionObject(UIConnectionInfo ci)
at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ObjectExplorer.ValidateConnection(UIConnectionInfo ci, IServerType server)
at Microsoft.SqlServer.Management.UI.ConnectionDlg.Connector.ConnectionThreadUser()
************************************************************************************************************

When I ping with machine name (ABC) and DNS name (XYZ.PWR.COM), both resolves to the same IP.
C:\Documents and Settings\Administrator>ping ABC

Pinging ABC.corp.abctech.com [xx.x.xx.xx] with 32 bytes of d


C:\Documents and Settings\Administrator>ping XYZ.PWR.COM

Pinging XYZ.PWR.COM [xx.x.xx.xx] with 32 bytes of data:


Is this problem because of the kerberos authentication that Analysis server uses to authenticate?

I am able to connect to the Database engine using DNS name (but using SQL Server authentication).
Also I was able to view the reportserver and reports page by changing the IIS authentication to NTLM.
But finally I am not able to view the reports.

Can anyone please help me in solving this issue.

Awatiitng some positive reply.

Friday, March 23, 2012

report builder... click-through to a standard report (not a report builder based report)?

Hi,
In the administration page of RS2005, I see that its possible to specify a
target report for a click-through action.
but, does this report can be a standard reporting services report? (not a
report builder based report)
if yes, how this report must be configured to allow this type of
interaction?
thanks.
Jerome.ok, not sure i've understood your question as your english isn't that great
so i'll try and answer it.
i think you want to use the drill through function. So right click on the
item/text box/graph or whatever you want to drill through from and select
properties > Advanced > navigation > jump to report > pick a report to jump
to > parameters and assign the parameters.
right hope that answers your question, although this is a solution based on
rs2000 but can't imagine it is much differnt for rs2005.
Greg
"Jéjé" <willgart_A_@.hotmail_A_.com> wrote in message
news:e$MbEhlAGHA.912@.TK2MSFTNGP11.phx.gbl...
> Hi,
> In the administration page of RS2005, I see that its possible to specify a
> target report for a click-through action.
> but, does this report can be a standard reporting services report? (not a
> report builder based report)
> if yes, how this report must be configured to allow this type of
> interaction?
> thanks.
> Jerome.
>|||no and yes ;-)
yes my english is bad...
no, I really mean CLICK through NOT drill through.
The Click through feature is a report builder capability ("infinite click
through") which allow a user to navigate in the data without having to
create a new report by himself.
When the user click (for example) on the # Sales, the system automatically
display the list of these sales with the customer name for example. then the
user click on the customer name and a new report is automatically created to
display the complete detail information of this particular customer. then
the user can click and click etc... number of created report only 1! the
first, all the other reports are created automatically.
but... the administrator can play a little around this by adding information
in the model to open a specific report instead-of the automatically
generated, but this feature appear to works only with a report created with
report builder.
so my question is: can I setup a report builder model to open a standard
reporting services report instead-of the report builder auto-generated one?
and this is a 2005 feature, not a 2000 one.
if you have never tested this, try it now!!!! its really a excellent
feature.
"Greg" <Greg.conn@.nospam.nospam> wrote in message
news:uPbXLfVBGHA.2356@.tk2msftngp13.phx.gbl...
> ok, not sure i've understood your question as your english isn't that
> great so i'll try and answer it.
> i think you want to use the drill through function. So right click on the
> item/text box/graph or whatever you want to drill through from and select
> properties > Advanced > navigation > jump to report > pick a report to
> jump to > parameters and assign the parameters.
> right hope that answers your question, although this is a solution based
> on rs2000 but can't imagine it is much differnt for rs2005.
> Greg
>
> "Jéjé" <willgart_A_@.hotmail_A_.com> wrote in message
> news:e$MbEhlAGHA.912@.TK2MSFTNGP11.phx.gbl...
>> Hi,
>> In the administration page of RS2005, I see that its possible to specify
>> a target report for a click-through action.
>> but, does this report can be a standard reporting services report? (not a
>> report builder based report)
>> if yes, how this report must be configured to allow this type of
>> interaction?
>> thanks.
>> Jerome.
>>
>|||sounds like a cool feature. might have a go at it and let you know how i
get on.
"Jéjé" <willgart@.BBBhotmailAAA.com> wrote in message
news:OHpClAcBGHA.3984@.TK2MSFTNGP14.phx.gbl...
> no and yes ;-)
> yes my english is bad...
> no, I really mean CLICK through NOT drill through.
> The Click through feature is a report builder capability ("infinite click
> through") which allow a user to navigate in the data without having to
> create a new report by himself.
> When the user click (for example) on the # Sales, the system automatically
> display the list of these sales with the customer name for example. then
> the user click on the customer name and a new report is automatically
> created to display the complete detail information of this particular
> customer. then the user can click and click etc... number of created
> report only 1! the first, all the other reports are created automatically.
> but... the administrator can play a little around this by adding
> information in the model to open a specific report instead-of the
> automatically generated, but this feature appear to works only with a
> report created with report builder.
> so my question is: can I setup a report builder model to open a standard
> reporting services report instead-of the report builder auto-generated
> one?
> and this is a 2005 feature, not a 2000 one.
> if you have never tested this, try it now!!!! its really a excellent
> feature.
>
> "Greg" <Greg.conn@.nospam.nospam> wrote in message
> news:uPbXLfVBGHA.2356@.tk2msftngp13.phx.gbl...
>> ok, not sure i've understood your question as your english isn't that
>> great so i'll try and answer it.
>> i think you want to use the drill through function. So right click on
>> the item/text box/graph or whatever you want to drill through from and
>> select properties > Advanced > navigation > jump to report > pick a
>> report to jump to > parameters and assign the parameters.
>> right hope that answers your question, although this is a solution based
>> on rs2000 but can't imagine it is much differnt for rs2005.
>> Greg
>>
>> "Jéjé" <willgart_A_@.hotmail_A_.com> wrote in message
>> news:e$MbEhlAGHA.912@.TK2MSFTNGP11.phx.gbl...
>> Hi,
>> In the administration page of RS2005, I see that its possible to specify
>> a target report for a click-through action.
>> but, does this report can be a standard reporting services report? (not
>> a report builder based report)
>> if yes, how this report must be configured to allow this type of
>> interaction?
>> thanks.
>> Jerome.
>>
>>
>