I get the following error when running the RSActivate utility:
"Unable to find Reporting Services WMI namespace = on <machinename>. Reporting Services may not be installed"
This is an urgent problem so any suggestions would be welcomed.
*****************************************
* This message was posted via http://www.sqlmonster.com
*
* Report spam or abuse by clicking the following URL:
* http://www.sqlmonster.com/Uwe/Abuse.aspx?aid=d737907db3624cb18a4c69da471c4572
*****************************************Double-check that that WMI Service is started in the Services Manager/MMC.
Edgar,
"Jared Smith via SQLMonster.com" wrote:
> I get the following error when running the RSActivate utility:
> "Unable to find Reporting Services WMI namespace => on <machinename>. Reporting Services may not be installed"
> This is an urgent problem so any suggestions would be welcomed.
> *****************************************
> * This message was posted via http://www.sqlmonster.com
> *
> * Report spam or abuse by clicking the following URL:
> * http://www.sqlmonster.com/Uwe/Abuse.aspx?aid=d737907db3624cb18a4c69da471c4572
> *****************************************
>
Showing posts with label report. Show all posts
Showing posts with label report. Show all posts
Tuesday, March 27, 2012
Can not find report server on the machine
I installed SQL Server 2005 which include report server but got this error: no report servers were found on this server when trying to configure report server. Am I missing something?
Thanks
Moving to SSRS forum.|||You need to check to see if IIS is up and running. What version is the OS? HTH|||
Go to Services and make sure SQL Server Reporting Services (MSSQLSERVER) service is started.
Shyam
can not expand table group in internet explorer
Hey all
I hope one of you encountered this problem..
I have grouped fields on one table object in some report.
In visual studio all is well i can expand the grouping fields to see thier
children and thier data.
The problem appears in internet explorer - under no sircumstances will this
group expand there!
I am left with the upper most grouping field and can not drill down to its
members!
I have tried both to define these aggregating fields by my self
and by the vs wizard . Also i tried the matrix component instead of the
table one.
One interesting fact is that once exported to excell, things return to
normal again..
I can expand groups and drill down correctly.
I have installed sp1 for reporting services and use ie6 on winxp
professional (both client and server).
If you did not encounter this before where will you start looking'
Thanks for your attention
ReaThe driil down capability requires Session cookies be enabled. Change the
Internet Explorer setting to "Allow Session Cookies" and it should work
"Rea Peleg" <rea_p@.afek.co.il> wrote in message
news:uQfy2B8bEHA.1764@.TK2MSFTNGP10.phx.gbl...
> Hey all
> I hope one of you encountered this problem..
> I have grouped fields on one table object in some report.
> In visual studio all is well i can expand the grouping fields to see thier
> children and thier data.
> The problem appears in internet explorer - under no sircumstances will
this
> group expand there!
> I am left with the upper most grouping field and can not drill down to its
> members!
> I have tried both to define these aggregating fields by my self
> and by the vs wizard . Also i tried the matrix component instead of the
> table one.
> One interesting fact is that once exported to excell, things return to
> normal again..
> I can expand groups and drill down correctly.
> I have installed sp1 for reporting services and use ie6 on winxp
> professional (both client and server).
> If you did not encounter this before where will you start looking'
> Thanks for your attention
> Rea
>
>
I hope one of you encountered this problem..
I have grouped fields on one table object in some report.
In visual studio all is well i can expand the grouping fields to see thier
children and thier data.
The problem appears in internet explorer - under no sircumstances will this
group expand there!
I am left with the upper most grouping field and can not drill down to its
members!
I have tried both to define these aggregating fields by my self
and by the vs wizard . Also i tried the matrix component instead of the
table one.
One interesting fact is that once exported to excell, things return to
normal again..
I can expand groups and drill down correctly.
I have installed sp1 for reporting services and use ie6 on winxp
professional (both client and server).
If you did not encounter this before where will you start looking'
Thanks for your attention
ReaThe driil down capability requires Session cookies be enabled. Change the
Internet Explorer setting to "Allow Session Cookies" and it should work
"Rea Peleg" <rea_p@.afek.co.il> wrote in message
news:uQfy2B8bEHA.1764@.TK2MSFTNGP10.phx.gbl...
> Hey all
> I hope one of you encountered this problem..
> I have grouped fields on one table object in some report.
> In visual studio all is well i can expand the grouping fields to see thier
> children and thier data.
> The problem appears in internet explorer - under no sircumstances will
this
> group expand there!
> I am left with the upper most grouping field and can not drill down to its
> members!
> I have tried both to define these aggregating fields by my self
> and by the vs wizard . Also i tried the matrix component instead of the
> table one.
> One interesting fact is that once exported to excell, things return to
> normal again..
> I can expand groups and drill down correctly.
> I have installed sp1 for reporting services and use ie6 on winxp
> professional (both client and server).
> If you did not encounter this before where will you start looking'
> Thanks for your attention
> Rea
>
>
Can not Depoloy Report
Hi,
I am having a problem to deploy reports; every time I try to deploy a
report the build stage is finishing and I get this Error:
A connection could not be made to report server http://
localhost/reports/ pages/folder.aspx
However, when I try entering http:// localhost/reports/
pages/folder.aspx from the browser I can see the report manager
without any problem ( and without my reports...).
Does anyone knows has a solution?
Thank you.
Avi.You may not have permissions, can you use the Report Manager web interface
to show details on the folder and reports from there?
Steve MunLeeuw
"AB" <savi176@.yahoo.com> wrote in message
news:1160605034.061779.42970@.m7g2000cwm.googlegroups.com...
> Hi,
> I am having a problem to deploy reports; every time I try to deploy a
> report the build stage is finishing and I get this Error:
> A connection could not be made to report server http://
> localhost/reports/ pages/folder.aspx
> However, when I try entering http:// localhost/reports/
> pages/folder.aspx from the browser I can see the report manager
> without any problem ( and without my reports...).
> Does anyone knows has a solution?
>
> Thank you.
> Avi.
>|||The report Manager is still empty, this is the first time I use it on
my home comuter.
How can I give myself permissions?
Steve MunLeeuw =D7=9B=D7=AA=D7=91:
> You may not have permissions, can you use the Report Manager web interface
> to show details on the folder and reports from there?
> Steve MunLeeuw
> "AB" <savi176@.yahoo.com> wrote in message
> news:1160605034.061779.42970@.m7g2000cwm.googlegroups.com...
> > Hi,
> > I am having a problem to deploy reports; every time I try to deploy a
> > report the build stage is finishing and I get this Error:
> >
> > A connection could not be made to report server http://
> > localhost/reports/ pages/folder.aspx
> >
> > However, when I try entering http:// localhost/reports/
> > pages/folder.aspx from the browser I can see the report manager
> > without any problem ( and without my reports...).
> >
> > Does anyone knows has a solution?
> >
> >
> > Thank you.
> >
> > Avi.
> >|||.Thank you for your answer but evev after I define my user I still got
this message
?Any suggestions
AB =D7=9B=D7=AA=D7=91:
> The report Manager is still empty, this is the first time I use it on
> my home comuter.
> How can I give myself permissions?
>
>
> Steve MunLeeuw =D7=9B=D7=AA=D7=91:
> > You may not have permissions, can you use the Report Manager web interf=ace
> > to show details on the folder and reports from there?
> >
> > Steve MunLeeuw
> >
> > "AB" <savi176@.yahoo.com> wrote in message
> > news:1160605034.061779.42970@.m7g2000cwm.googlegroups.com...
> > > Hi,
> > > I am having a problem to deploy reports; every time I try to deploy a
> > > report the build stage is finishing and I get this Error:
> > >
> > > A connection could not be made to report server http://
> > > localhost/reports/ pages/folder.aspx
> > >
> > > However, when I try entering http:// localhost/reports/
> > > pages/folder.aspx from the browser I can see the report manager
> > > without any problem ( and without my reports...).
> > >
> > > Does anyone knows has a solution?
> > >
> > >
> > > Thank you.
> > >
> > > Avi.
> > >|||You need to be logged into you computer as a local admin to the machine.
This will automatically make you part of the RS admin role. Also, if you
have by any chance messed around with IIS and turned anonymous access on
then you will be considered anonymous and hence not have the rights to
deploy.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"AB" <savi176@.yahoo.com> wrote in message
news:1160640060.505189.232900@.b28g2000cwb.googlegroups.com...
.Thank you for your answer but evev after I define my user I still got
this message
?Any suggestions
AB ?:
> The report Manager is still empty, this is the first time I use it on
> my home comuter.
> How can I give myself permissions?
>
>
> Steve MunLeeuw ?:
> > You may not have permissions, can you use the Report Manager web
> > interface
> > to show details on the folder and reports from there?
> >
> > Steve MunLeeuw
> >
> > "AB" <savi176@.yahoo.com> wrote in message
> > news:1160605034.061779.42970@.m7g2000cwm.googlegroups.com...
> > > Hi,
> > > I am having a problem to deploy reports; every time I try to deploy a
> > > report the build stage is finishing and I get this Error:
> > >
> > > A connection could not be made to report server http://
> > > localhost/reports/ pages/folder.aspx
> > >
> > > However, when I try entering http:// localhost/reports/
> > > pages/folder.aspx from the browser I can see the report manager
> > > without any problem ( and without my reports...).
> > >
> > > Does anyone knows has a solution?
> > >
> > >
> > > Thank you.
> > >
> > > Avi.
> > >|||Make sure you do not have anonymous enabled in IIS.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"AB" <savi176@.yahoo.com> wrote in message
news:1160605034.061779.42970@.m7g2000cwm.googlegroups.com...
> Hi,
> I am having a problem to deploy reports; every time I try to deploy a
> report the build stage is finishing and I get this Error:
> A connection could not be made to report server http://
> localhost/reports/ pages/folder.aspx
> However, when I try entering http:// localhost/reports/
> pages/folder.aspx from the browser I can see the report manager
> without any problem ( and without my reports...).
> Does anyone knows has a solution?
>
> Thank you.
> Avi.
>
I am having a problem to deploy reports; every time I try to deploy a
report the build stage is finishing and I get this Error:
A connection could not be made to report server http://
localhost/reports/ pages/folder.aspx
However, when I try entering http:// localhost/reports/
pages/folder.aspx from the browser I can see the report manager
without any problem ( and without my reports...).
Does anyone knows has a solution?
Thank you.
Avi.You may not have permissions, can you use the Report Manager web interface
to show details on the folder and reports from there?
Steve MunLeeuw
"AB" <savi176@.yahoo.com> wrote in message
news:1160605034.061779.42970@.m7g2000cwm.googlegroups.com...
> Hi,
> I am having a problem to deploy reports; every time I try to deploy a
> report the build stage is finishing and I get this Error:
> A connection could not be made to report server http://
> localhost/reports/ pages/folder.aspx
> However, when I try entering http:// localhost/reports/
> pages/folder.aspx from the browser I can see the report manager
> without any problem ( and without my reports...).
> Does anyone knows has a solution?
>
> Thank you.
> Avi.
>|||The report Manager is still empty, this is the first time I use it on
my home comuter.
How can I give myself permissions?
Steve MunLeeuw =D7=9B=D7=AA=D7=91:
> You may not have permissions, can you use the Report Manager web interface
> to show details on the folder and reports from there?
> Steve MunLeeuw
> "AB" <savi176@.yahoo.com> wrote in message
> news:1160605034.061779.42970@.m7g2000cwm.googlegroups.com...
> > Hi,
> > I am having a problem to deploy reports; every time I try to deploy a
> > report the build stage is finishing and I get this Error:
> >
> > A connection could not be made to report server http://
> > localhost/reports/ pages/folder.aspx
> >
> > However, when I try entering http:// localhost/reports/
> > pages/folder.aspx from the browser I can see the report manager
> > without any problem ( and without my reports...).
> >
> > Does anyone knows has a solution?
> >
> >
> > Thank you.
> >
> > Avi.
> >|||.Thank you for your answer but evev after I define my user I still got
this message
?Any suggestions
AB =D7=9B=D7=AA=D7=91:
> The report Manager is still empty, this is the first time I use it on
> my home comuter.
> How can I give myself permissions?
>
>
> Steve MunLeeuw =D7=9B=D7=AA=D7=91:
> > You may not have permissions, can you use the Report Manager web interf=ace
> > to show details on the folder and reports from there?
> >
> > Steve MunLeeuw
> >
> > "AB" <savi176@.yahoo.com> wrote in message
> > news:1160605034.061779.42970@.m7g2000cwm.googlegroups.com...
> > > Hi,
> > > I am having a problem to deploy reports; every time I try to deploy a
> > > report the build stage is finishing and I get this Error:
> > >
> > > A connection could not be made to report server http://
> > > localhost/reports/ pages/folder.aspx
> > >
> > > However, when I try entering http:// localhost/reports/
> > > pages/folder.aspx from the browser I can see the report manager
> > > without any problem ( and without my reports...).
> > >
> > > Does anyone knows has a solution?
> > >
> > >
> > > Thank you.
> > >
> > > Avi.
> > >|||You need to be logged into you computer as a local admin to the machine.
This will automatically make you part of the RS admin role. Also, if you
have by any chance messed around with IIS and turned anonymous access on
then you will be considered anonymous and hence not have the rights to
deploy.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"AB" <savi176@.yahoo.com> wrote in message
news:1160640060.505189.232900@.b28g2000cwb.googlegroups.com...
.Thank you for your answer but evev after I define my user I still got
this message
?Any suggestions
AB ?:
> The report Manager is still empty, this is the first time I use it on
> my home comuter.
> How can I give myself permissions?
>
>
> Steve MunLeeuw ?:
> > You may not have permissions, can you use the Report Manager web
> > interface
> > to show details on the folder and reports from there?
> >
> > Steve MunLeeuw
> >
> > "AB" <savi176@.yahoo.com> wrote in message
> > news:1160605034.061779.42970@.m7g2000cwm.googlegroups.com...
> > > Hi,
> > > I am having a problem to deploy reports; every time I try to deploy a
> > > report the build stage is finishing and I get this Error:
> > >
> > > A connection could not be made to report server http://
> > > localhost/reports/ pages/folder.aspx
> > >
> > > However, when I try entering http:// localhost/reports/
> > > pages/folder.aspx from the browser I can see the report manager
> > > without any problem ( and without my reports...).
> > >
> > > Does anyone knows has a solution?
> > >
> > >
> > > Thank you.
> > >
> > > Avi.
> > >|||Make sure you do not have anonymous enabled in IIS.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"AB" <savi176@.yahoo.com> wrote in message
news:1160605034.061779.42970@.m7g2000cwm.googlegroups.com...
> Hi,
> I am having a problem to deploy reports; every time I try to deploy a
> report the build stage is finishing and I get this Error:
> A connection could not be made to report server http://
> localhost/reports/ pages/folder.aspx
> However, when I try entering http:// localhost/reports/
> pages/folder.aspx from the browser I can see the report manager
> without any problem ( and without my reports...).
> Does anyone knows has a solution?
>
> Thank you.
> Avi.
>
Can not deploy to the report server.
Hello, when I try to deploy a report server project to the server, it gets me this popup; I put my username and password and it keeps me asking for user and password, (and I havent forgotten my username and password of couse)
http://www.avansoft.net/~levalencia/1.gif
When I go to the following url from my machine, not the server.
http://agamenon:90/Reports/Pages/Folder.aspx
I can see all without problems.
My user is administrator on that machine too.
As the server also had sharepoint services I Created another website on another disk, and I configured with reporting services configuration tool to create reportserver and report virtual directories in that website.
WHen I saw those folders, they are empty, but they have 2 folders inside, reportserver and reports, those virtual folders point to something like this.
C:\Archivos de programa\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer
and this.
C:\Archivos de programa\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportManager
The only way I have to do, is to upload the reports manually but I hate that.
Please feel free to ask me anything.
reportserver.serverpath=http://localhost/reportserverreportviewer1.reportpath="/FileName/ReportName.rdl"
reportviewer1.serverreport.refresh;
can not deploy a report to ReportServer sub folders
I am trying to deploy my report to somthing like https://SERVERNAME/ReportServer/BrianHome/
but i keep getting an error saying
"A connection could not be made to the reportserver https://SERVERNAME/ReportServer/BrianHome/"
Then under aditional information i get:
"Client found response content type of " , but expected text/xml
The request failed with an empty responce. ( system.web.services)
Try setting your TargetServerURL to: https://SERVERNAME/ReportServer
and your TargetReportFolder to: /MainFolder/SubFolder
This works for me.
|||That works !!!!
I can not thank you enough!!!!
sqlSunday, March 25, 2012
Can not create New Subscription
Hi, I have a report that I would like to send out to users automatically every day at 10AM. For some reason on reporting server under the report I would to email, I see 3 folders...Data Source, History & Subscription but I am not able to click on "New Subscription" option in order to create new subscription.
First I created "Shared Schedule" specifing day, time etc information. And then I am tring to create Subscription but the option is disabled.
Is there any service pack I am missing or I am following the wrong procedure.
Please advice.
- Payal
Hi,
Can make sure that you have provided an account to run the report and not use the Integrated Security? To be able to use Subscriptions, Reporting Services requires you to provide a fixed account.
Greetz,
Geert
Geert Verhoeven
Consultant @. Ausy Belgium
My Personal Blog
Can not create a connection to Oracle data source when report is processing
hello,
I am getting following error message when I try to view a report from reporting services. The report runs fine but after while i get the following error message. The error message will go away if i open the report manage from the server and run the report once. The report will run fine for a while from anywhere but afterwhile i get following error message.
An error has occurred during report processing. (rsProcessingAborted) Get Online Help
Cannot create a connection to data source 'OracleConnProc'. (rsErrorOpeningConnection)
Error while trying to retrieve text for error ORA-12154
can someone please help me.
Most likely there is a problem with the file system permissions of your Oracle client installation on the report server machine. The file system permissions probably prevent the account configured to run the RS Web Service to load certain Oracle client configuration files.
Have you looked at the following KB article? http://support.microsoft.com/default.aspx?scid=kb;en-us;870668
-- Robert
|||
Hello Robert,
I followed steps from your suggested article. I am still having same problem, but at the same time I could not verify my changes as suggested in the article.
Note To verify the configured account for the Reporting Services Web Service, you can open the RSReportServer.config file. You will find informaiton that is similar to the following:
<WebServiceAccount>NT Authority\NetworkService</WebServiceAccount>
I was thinking to reinstall oracle client on my reporting server, but please let me know if you have any other suggestion.
Thanks,
Vimal
Thursday, March 22, 2012
Can not connect to some tables with seagate crystal report
Seagate crystal reports:
When i am trying to attach a table to seagate crystal report i am getting
this error:
Database Error: [Microsoft][ODBC SQL Server Driver][SQL
Server][DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or
access denied.
I can connect to other tables in same database. One thing that is different
in the tables which i can not connect is that its name is like (Application
Name.dbo.samplecounty-etp.etp.Emp_Qualifications). Can naming syntex of table
cause connection issue or its a permission issue?
ontario, canada
SQL server 2000 enterprise edition. The problem is with the table name.
Somehow crystal report does not accept table name with "."
Does anyone know a wayaround.
ontario, canada
"db" wrote:
> Seagate crystal reports:
> When i am trying to attach a table to seagate crystal report i am getting
> this error:
> Database Error: [Microsoft][ODBC SQL Server Driver][SQL
> Server][DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or
> access denied.
> I can connect to other tables in same database. One thing that is different
> in the tables which i can not connect is that its name is like (Application
> Name.dbo.samplecounty-etp.etp.Emp_Qualifications). Can naming syntex of table
> cause connection issue or its a permission issue?
>
> --
> ontario, canada
|||"db" <db@.discussions.microsoft.com> wrote in message
news:6013B66D-ECA6-4B76-8480-B72E5ED7DC47@.microsoft.com...
> SQL server 2000 enterprise edition. The problem is with the table name.
> Somehow crystal report does not accept table name with "."
> Does anyone know a wayaround.
> --
> ontario, canada
Rename the table? Create/use a view with a name that Crystal likes? Or
perhaps post on a newsgroup that is specific to crystal reports. You do
know that Seagate is no longer involved with Crystal Reports and hasn't been
for some years - that would indicate you are using an old (and perhaps
unsupported) version.
|||Views works.
Thanks
"Scott Morris" wrote:
> "db" <db@.discussions.microsoft.com> wrote in message
> news:6013B66D-ECA6-4B76-8480-B72E5ED7DC47@.microsoft.com...
> Rename the table? Create/use a view with a name that Crystal likes? Or
> perhaps post on a newsgroup that is specific to crystal reports. You do
> know that Seagate is no longer involved with Crystal Reports and hasn't been
> for some years - that would indicate you are using an old (and perhaps
> unsupported) version.
>
>
When i am trying to attach a table to seagate crystal report i am getting
this error:
Database Error: [Microsoft][ODBC SQL Server Driver][SQL
Server][DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or
access denied.
I can connect to other tables in same database. One thing that is different
in the tables which i can not connect is that its name is like (Application
Name.dbo.samplecounty-etp.etp.Emp_Qualifications). Can naming syntex of table
cause connection issue or its a permission issue?
ontario, canada
SQL server 2000 enterprise edition. The problem is with the table name.
Somehow crystal report does not accept table name with "."
Does anyone know a wayaround.
ontario, canada
"db" wrote:
> Seagate crystal reports:
> When i am trying to attach a table to seagate crystal report i am getting
> this error:
> Database Error: [Microsoft][ODBC SQL Server Driver][SQL
> Server][DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or
> access denied.
> I can connect to other tables in same database. One thing that is different
> in the tables which i can not connect is that its name is like (Application
> Name.dbo.samplecounty-etp.etp.Emp_Qualifications). Can naming syntex of table
> cause connection issue or its a permission issue?
>
> --
> ontario, canada
|||"db" <db@.discussions.microsoft.com> wrote in message
news:6013B66D-ECA6-4B76-8480-B72E5ED7DC47@.microsoft.com...
> SQL server 2000 enterprise edition. The problem is with the table name.
> Somehow crystal report does not accept table name with "."
> Does anyone know a wayaround.
> --
> ontario, canada
Rename the table? Create/use a view with a name that Crystal likes? Or
perhaps post on a newsgroup that is specific to crystal reports. You do
know that Seagate is no longer involved with Crystal Reports and hasn't been
for some years - that would indicate you are using an old (and perhaps
unsupported) version.
|||Views works.
Thanks
"Scott Morris" wrote:
> "db" <db@.discussions.microsoft.com> wrote in message
> news:6013B66D-ECA6-4B76-8480-B72E5ED7DC47@.microsoft.com...
> Rename the table? Create/use a view with a name that Crystal likes? Or
> perhaps post on a newsgroup that is specific to crystal reports. You do
> know that Seagate is no longer involved with Crystal Reports and hasn't been
> for some years - that would indicate you are using an old (and perhaps
> unsupported) version.
>
>
Can not connect to some tables with seagate crystal report
Seagate crystal reports:
When i am trying to attach a table to seagate crystal report i am getting
this error:
Database Error: [Microsoft][ODBC SQL Server Driver][SQL
Server][DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not ex
ist or
access denied.
I can connect to other tables in same database. One thing that is different
in the tables which i can not connect is that its name is like (Application
Name.dbo.samplecounty-etp.etp.Emp_Qualifications). Can naming syntex of tabl
e
cause connection issue or its a permission issue?
ontario, canadaSQL server 2000 enterprise edition. The problem is with the table name.
Somehow crystal report does not accept table name with "."
Does anyone know a wayaround.
--
ontario, canada
"db" wrote:
> Seagate crystal reports:
> When i am trying to attach a table to seagate crystal report i am getting
> this error:
> Database Error: [Microsoft][ODBC SQL Server Driver][SQL
> Server][DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not
exist or
> access denied.
> I can connect to other tables in same database. One thing that is differen
t
> in the tables which i can not connect is that its name is like (Applicatio
n
> Name.dbo.samplecounty-etp.etp.Emp_Qualifications). Can naming syntex of ta
ble
> cause connection issue or its a permission issue?
>
> --
> ontario, canada|||"db" <db@.discussions.microsoft.com> wrote in message
news:6013B66D-ECA6-4B76-8480-B72E5ED7DC47@.microsoft.com...
> SQL server 2000 enterprise edition. The problem is with the table name.
> Somehow crystal report does not accept table name with "."
> Does anyone know a wayaround.
> --
> ontario, canada
Rename the table? Create/use a view with a name that Crystal likes? Or
perhaps post on a newsgroup that is specific to crystal reports. You do
know that Seagate is no longer involved with Crystal Reports and hasn't been
for some years - that would indicate you are using an old (and perhaps
unsupported) version.|||Views works.
Thanks
"Scott Morris" wrote:
> "db" <db@.discussions.microsoft.com> wrote in message
> news:6013B66D-ECA6-4B76-8480-B72E5ED7DC47@.microsoft.com...
> Rename the table? Create/use a view with a name that Crystal likes? Or
> perhaps post on a newsgroup that is specific to crystal reports. You do
> know that Seagate is no longer involved with Crystal Reports and hasn't be
en
> for some years - that would indicate you are using an old (and perhaps
> unsupported) version.
>
>
When i am trying to attach a table to seagate crystal report i am getting
this error:
Database Error: [Microsoft][ODBC SQL Server Driver][SQL
Server][DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not ex
ist or
access denied.
I can connect to other tables in same database. One thing that is different
in the tables which i can not connect is that its name is like (Application
Name.dbo.samplecounty-etp.etp.Emp_Qualifications). Can naming syntex of tabl
e
cause connection issue or its a permission issue?
ontario, canadaSQL server 2000 enterprise edition. The problem is with the table name.
Somehow crystal report does not accept table name with "."
Does anyone know a wayaround.
--
ontario, canada
"db" wrote:
> Seagate crystal reports:
> When i am trying to attach a table to seagate crystal report i am getting
> this error:
> Database Error: [Microsoft][ODBC SQL Server Driver][SQL
> Server][DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not
exist or
> access denied.
> I can connect to other tables in same database. One thing that is differen
t
> in the tables which i can not connect is that its name is like (Applicatio
n
> Name.dbo.samplecounty-etp.etp.Emp_Qualifications). Can naming syntex of ta
ble
> cause connection issue or its a permission issue?
>
> --
> ontario, canada|||"db" <db@.discussions.microsoft.com> wrote in message
news:6013B66D-ECA6-4B76-8480-B72E5ED7DC47@.microsoft.com...
> SQL server 2000 enterprise edition. The problem is with the table name.
> Somehow crystal report does not accept table name with "."
> Does anyone know a wayaround.
> --
> ontario, canada
Rename the table? Create/use a view with a name that Crystal likes? Or
perhaps post on a newsgroup that is specific to crystal reports. You do
know that Seagate is no longer involved with Crystal Reports and hasn't been
for some years - that would indicate you are using an old (and perhaps
unsupported) version.|||Views works.
Thanks
"Scott Morris" wrote:
> "db" <db@.discussions.microsoft.com> wrote in message
> news:6013B66D-ECA6-4B76-8480-B72E5ED7DC47@.microsoft.com...
> Rename the table? Create/use a view with a name that Crystal likes? Or
> perhaps post on a newsgroup that is specific to crystal reports. You do
> know that Seagate is no longer involved with Crystal Reports and hasn't be
en
> for some years - that would indicate you are using an old (and perhaps
> unsupported) version.
>
>
can not connect to Report server from SQL SERVER 2005 Management studio
Hi All,
I have a brand new install of sql server 2005 on brand new WINDOWS SERVER2003 with latest versions. Every thing works fine excepting I get a 404 when I connect to report server from management studio..
I am even able to publish reports and all the
url://localhost/reportserver
url://localhost/reports
url://localhost/reportserver/reportbuilder/reportbuilder.application
all work fine on local machine and with in the network behind the fire wall.
But when I try to connect to report server using management studio on the local server or remote server, I get the following error.
"
TITLE: Microsoft SQL Server Management Studio
The attempt to connect to the report server failed. Check your connection information and that the report server is a compatible version. (Microsoft.SqlServer.Management.UI.RSClient)
ADDITIONAL INFORMATION:
The request failed with HTTP status 404: Not Found. (Microsoft.SqlServer.Management.UI.RSClient)
"
More techinal details
"===================================
Cannot connect to xxxxxxxxxxxx.
===================================
The attempt to connect to the report server failed. Check your connection information and that the report server is a compatible version. (Microsoft.SqlServer.Management.UI.RSClient)
Program Location:
at Microsoft.SqlServer.ReportingServices2005.RSConnection.MissingEndpointException.ThrowIfEndpointMissing(WebException e)
at Microsoft.SqlServer.ReportingServices2005.RSConnection.ValidateConnection()
at Microsoft.SqlServer.Management.UI.RSClient.RSClientConnection.CreateConnection(String connectionString)
at Microsoft.SqlServer.Management.UI.RSClient.RSConnectionInfo.CreateConnectionObject()
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()
===================================
The request failed with HTTP status 404: Not Found. (Microsoft.SqlServer.Management.UI.RSClient)
Program Location:
at Microsoft.SqlServer.ReportingServices2005.RSConnection.GetSecureMethods()
at Microsoft.SqlServer.ReportingServices2005.RSConnection.IsSecureMethod(String methodname)
at Microsoft.SqlServer.ReportingServices2005.RSConnection.ValidateConnection()
"
Any help would be greatly appreciated.
Bob
What are you passing in as the server name to Management Studio?
You can connect several ways
http://localhost/reportserver
servername
servername\instance
|||I passed both the servername and the servername\instance to the management studio.
My IIS and uses port 80. I can access Reportserver, report manager and report bilder thru the Internet. I just can not connect to Report server from Management studio.
I will try connecting to RS is Management studo using http://localhost/reportserver.
Regards
Bobba
|||Hi Brad Syputa,
Thank you for the suggestion. I worked. I was not able to try your suggestion immediatly as I was out of town.
Now I have this big question:
Why am I only able to connect to "report server" from "management studio" using
1. http://localhost/reportserver
and not using
2. servername
3. servername\instance.
Your help would save me a lot of time
Regards
Bobba(Bob)
||||||bobba wrote:
Hi Brad Syputa,
Thank you for the suggestion. I worked. I was not able to try your suggestion immediatly as I was out of town.
Now I have this big question:
Why am I only able to connect to "report server" from "management studio" using
1. http://localhost/reportserver
and not using
2. servername
3. servername\instance.
Your help would save me a lot of time
Regards
Bobba(Bob)
Indeed, I am very interested in disvoering the answer. We had a developer in our organization with the same problem and could only connect by enterting http://localhost/reportserver. The DBA team is fine using servername\instance.
Is this a bug that will be resolved?
thanks in advance,
Jason Wall
|||You should be able to connect using machine\instance. This method uses WMI to get the url for SOAP calls. Will you try opening the report server config tool? Can this tool connect to the machine? Are you specifying the same instance name listed in the config tool connection dialog?|||I have the same problem.
I can connect to the reporting service by using machine\instance in report server config tool.
But I cannot connect to the reporting service through managment studio by providing machine\instance, instead, if I use http://localhost/reportserver, I can connect to the report server through management studio.
I even tried to uninstall the report service, and reinstall it again. This problem still exists.
But the same thing does not happen on my colleague's machine.
I think it is better to look into this issue...
|||I managed to solve this problem...
If you want to use machine\instance to connect Management studio.
You need to make sure in rsreportservice.config, element <UrlRoot>http://localhost/reportserver</UrlRoot> is correctly configured. (You can test this by visit this url)
I guess, the machine\instance will eventurally be translated to the <UrlRoot>. If the <UrlRoot> is not correct, then you will not be able to use machine\instance to connect report service.
|||the attempt to connect to the report server failed. check your connection information and that the report server is a compatible version(.Net 2003 version)|||I am try to solve this problem i give for this error"i have SQL 2205 with SP1 installed on my machine.
and i m not bale to connect to Report Server using SQL management studio as well as from web.
i have installed reporting server and database on same machine. i tried using
"http://localhost/reportserver"
"http://localhost/reports"
"http://localhost/reportmanager"
but i am not bale to connect i am getting "Service Unavailable" page.
and when i try to connect using SQL Management Studio with "servername/instance" as well as "http://localhost/reportserver" i am getting a error saying.
===================================
Cannot connect to http://localhost/reportserver.
The request failed with HTTP status 503: Service Unavailable. (Microsoft.SqlServer.Management.UI.RSClient)
===================================
but if i try and connect to other reporting server on other machine using web http://servername/reportserver i m able to connect it.
but dont know whats the problem on my machine.
do i need to start any services for this...
so anybody knows how to troubleshoot this issue.
Thanks in advance...
|||
Hi,
Any solution for the above mentioned problem?
have SQL 2005 without SP1 installed on my machine.
and i m not bale to connect to Report Server using SQL management studio as well as from web.
i have installed reporting server and database on same machine. i tried using
"http://localhost/reportserver"
"http://localhost/reports"
"http://localhost/reportmanager"
but i am not bale to connect i am getting "Service Unavailable" page.
and when i try to connect using SQL Management Studio with "servername/instance" it says, "No connection could not be made because the target machine actively refused it"
===================================
Cannot connect to http://localhost/reportserver.
The request failed with HTTP status 503: Service Unavailable. (Microsoft.SqlServer.Management.UI.RSClient)
Please post your suggestion, if you resolved it already.
Regards,
Bhuvana
|||i tried visiting this URL. it says 503, service un available error. Please give me the solution.|||Something to try:
I had the same issue, what I did to fix is goto C:\Program Files\Microsoft SQL Server\MSSQL.1\Reporting Services and ensure that the ASPNET user has read,read&Execute and List Folder security permissions applied to all the subdirectories also ensure that you click the 'Advance' button when applying the permissions to ensure the security settings are applied to all child objects. During my installation for some reason it did not assign the proper permissions to the ASPNET user (aspnet_wp account). It couldn't even read the config files.
good luck
sqlcan not connect to Report server from SQL SERVER 2005 Management studio
Hi All,
I have a brand new install of sql server 2005 on brand new WINDOWS SERVER2003 with latest versions. Every thing works fine excepting I get a 404 when I connect to report server from management studio..
I am even able to publish reports and all the
url://localhost/reportserver
url://localhost/reports
url://localhost/reportserver/reportbuilder/reportbuilder.application
all work fine on local machine and with in the network behind the fire wall.
But when I try to connect to report server using management studio on the local server or remote server, I get the following error.
"
TITLE: Microsoft SQL Server Management Studio
The attempt to connect to the report server failed. Check your connection information and that the report server is a compatible version. (Microsoft.SqlServer.Management.UI.RSClient)
ADDITIONAL INFORMATION:
The request failed with HTTP status 404: Not Found. (Microsoft.SqlServer.Management.UI.RSClient)
"
More techinal details
"===================================
Cannot connect to xxxxxxxxxxxx.
===================================
The attempt to connect to the report server failed. Check your connection information and that the report server is a compatible version. (Microsoft.SqlServer.Management.UI.RSClient)
Program Location:
at Microsoft.SqlServer.ReportingServices2005.RSConnection.MissingEndpointException.ThrowIfEndpointMissing(WebException e)
at Microsoft.SqlServer.ReportingServices2005.RSConnection.ValidateConnection()
at Microsoft.SqlServer.Management.UI.RSClient.RSClientConnection.CreateConnection(String connectionString)
at Microsoft.SqlServer.Management.UI.RSClient.RSConnectionInfo.CreateConnectionObject()
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()
===================================
The request failed with HTTP status 404: Not Found. (Microsoft.SqlServer.Management.UI.RSClient)
Program Location:
at Microsoft.SqlServer.ReportingServices2005.RSConnection.GetSecureMethods()
at Microsoft.SqlServer.ReportingServices2005.RSConnection.IsSecureMethod(String methodname)
at Microsoft.SqlServer.ReportingServices2005.RSConnection.ValidateConnection()
"
Any help would be greatly appreciated.
Bob
What are you passing in as the server name to Management Studio?
You can connect several ways
http://localhost/reportserver
servername
servername\instance
|||I passed both the servername and the servername\instance to the management studio.
My IIS and uses port 80. I can access Reportserver, report manager and report bilder thru the Internet. I just can not connect to Report server from Management studio.
I will try connecting to RS is Management studo using http://localhost/reportserver.
Regards
Bobba
|||Hi Brad Syputa,
Thank you for the suggestion. I worked. I was not able to try your suggestion immediatly as I was out of town.
Now I have this big question:
Why am I only able to connect to "report server" from "management studio" using
1. http://localhost/reportserver
and not using
2. servername
3. servername\instance.
Your help would save me a lot of time
Regards
Bobba(Bob)
||||||Hi Brad Syputa,
Thank you for the suggestion. I worked. I was not able to try your suggestion immediatly as I was out of town.
Now I have this big question:
Why am I only able to connect to "report server" from "management studio" using
1. http://localhost/reportserver
and not using
2. servername
3. servername\instance.
Your help would save me a lot of time
Regards
Bobba(Bob)
Indeed, I am very interested in disvoering the answer. We had a developer in our organization with the same problem and could only connect by enterting http://localhost/reportserver. The DBA team is fine using servername\instance.
Is this a bug that will be resolved?
thanks in advance,
Jason Wall
|||You should be able to connect using machine\instance. This method uses WMI to get the url for SOAP calls. Will you try opening the report server config tool? Can this tool connect to the machine? Are you specifying the same instance name listed in the config tool connection dialog?|||I have the same problem.
I can connect to the reporting service by using machine\instance in report server config tool.
But I cannot connect to the reporting service through managment studio by providing machine\instance, instead, if I use http://localhost/reportserver, I can connect to the report server through management studio.
I even tried to uninstall the report service, and reinstall it again. This problem still exists.
But the same thing does not happen on my colleague's machine.
I think it is better to look into this issue...
|||I managed to solve this problem...
If you want to use machine\instance to connect Management studio.
You need to make sure in rsreportservice.config, element <UrlRoot>http://localhost/reportserver</UrlRoot> is correctly configured. (You can test this by visit this url)
I guess, the machine\instance will eventurally be translated to the <UrlRoot>. If the <UrlRoot> is not correct, then you will not be able to use machine\instance to connect report service.
|||the attempt to connect to the report server failed. check your connection information and that the report server is a compatible version(.Net 2003 version)|||I am try to solve this problem i give for this error"i have SQL 2205 with SP1 installed on my machine.
and i m not bale to connect to Report Server using SQL management studio as well as from web.
i have installed reporting server and database on same machine. i tried using
"http://localhost/reportserver"
"http://localhost/reports"
"http://localhost/reportmanager"
but i am not bale to connect i am getting "Service Unavailable" page.
and when i try to connect using SQL Management Studio with "servername/instance" as well as "http://localhost/reportserver" i am getting a error saying.
===================================
Cannot connect to http://localhost/reportserver.
The request failed with HTTP status 503: Service Unavailable. (Microsoft.SqlServer.Management.UI.RSClient)
===================================
but if i try and connect to other reporting server on other machine using web http://servername/reportserver i m able to connect it.
but dont know whats the problem on my machine.
do i need to start any services for this...
so anybody knows how to troubleshoot this issue.
Thanks in advance...
|||
Hi,
Any solution for the above mentioned problem?
have SQL 2005 without SP1 installed on my machine.
and i m not bale to connect to Report Server using SQL management studio as well as from web.
i have installed reporting server and database on same machine. i tried using
"http://localhost/reportserver"
"http://localhost/reports"
"http://localhost/reportmanager"
but i am not bale to connect i am getting "Service Unavailable" page.
and when i try to connect using SQL Management Studio with "servername/instance" it says, "No connection could not be made because the target machine actively refused it"
===================================
Cannot connect to http://localhost/reportserver.
The request failed with HTTP status 503: Service Unavailable. (Microsoft.SqlServer.Management.UI.RSClient)
Please post your suggestion, if you resolved it already.
Regards,
Bhuvana
|||i tried visiting this URL. it says 503, service un available error. Please give me the solution.|||Something to try:
I had the same issue, what I did to fix is goto C:\Program Files\Microsoft SQL Server\MSSQL.1\Reporting Services and ensure that the ASPNET user has read,read&Execute and List Folder security permissions applied to all the subdirectories also ensure that you click the 'Advance' button when applying the permissions to ensure the security settings are applied to all child objects. During my installation for some reason it did not assign the proper permissions to the ASPNET user (aspnet_wp account). It couldn't even read the config files.
good luck
can not connect to Report server from SQL SERVER 2005 Management studio
Hi All,
I have a brand new install of sql server 2005 on brand new WINDOWS SERVER2003 with latest versions. Every thing works fine excepting I get a 404 when I connect to report server from management studio..
I am even able to publish reports and all the
url://localhost/reportserver
url://localhost/reports
url://localhost/reportserver/reportbuilder/reportbuilder.application
all work fine on local machine and with in the network behind the fire wall.
But when I try to connect to report server using management studio on the local server or remote server, I get the following error.
"
TITLE: Microsoft SQL Server Management Studio
The attempt to connect to the report server failed. Check your connection information and that the report server is a compatible version. (Microsoft.SqlServer.Management.UI.RSClient)
ADDITIONAL INFORMATION:
The request failed with HTTP status 404: Not Found. (Microsoft.SqlServer.Management.UI.RSClient)
"
More techinal details
"===================================
Cannot connect to xxxxxxxxxxxx.
===================================
The attempt to connect to the report server failed. Check your connection information and that the report server is a compatible version. (Microsoft.SqlServer.Management.UI.RSClient)
Program Location:
at Microsoft.SqlServer.ReportingServices2005.RSConnection.MissingEndpointException.ThrowIfEndpointMissing(WebException e)
at Microsoft.SqlServer.ReportingServices2005.RSConnection.ValidateConnection()
at Microsoft.SqlServer.Management.UI.RSClient.RSClientConnection.CreateConnection(String connectionString)
at Microsoft.SqlServer.Management.UI.RSClient.RSConnectionInfo.CreateConnectionObject()
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()
===================================
The request failed with HTTP status 404: Not Found. (Microsoft.SqlServer.Management.UI.RSClient)
Program Location:
at Microsoft.SqlServer.ReportingServices2005.RSConnection.GetSecureMethods()
at Microsoft.SqlServer.ReportingServices2005.RSConnection.IsSecureMethod(String methodname)
at Microsoft.SqlServer.ReportingServices2005.RSConnection.ValidateConnection()
"
Any help would be greatly appreciated.
Bob
What are you passing in as the server name to Management Studio?
You can connect several ways
http://localhost/reportserver
servername
servername\instance
|||I passed both the servername and the servername\instance to the management studio.
My IIS and uses port 80. I can access Reportserver, report manager and report bilder thru the Internet. I just can not connect to Report server from Management studio.
I will try connecting to RS is Management studo using http://localhost/reportserver.
Regards
Bobba
|||Hi Brad Syputa,
Thank you for the suggestion. I worked. I was not able to try your suggestion immediatly as I was out of town.
Now I have this big question:
Why am I only able to connect to "report server" from "management studio" using
1. http://localhost/reportserver
and not using
2. servername
3. servername\instance.
Your help would save me a lot of time
Regards
Bobba(Bob)
||||||Hi Brad Syputa,
Thank you for the suggestion. I worked. I was not able to try your suggestion immediatly as I was out of town.
Now I have this big question:
Why am I only able to connect to "report server" from "management studio" using
1. http://localhost/reportserver
and not using
2. servername
3. servername\instance.
Your help would save me a lot of time
Regards
Bobba(Bob)
Indeed, I am very interested in disvoering the answer. We had a developer in our organization with the same problem and could only connect by enterting http://localhost/reportserver. The DBA team is fine using servername\instance.
Is this a bug that will be resolved?
thanks in advance,
Jason Wall
|||You should be able to connect using machine\instance. This method uses WMI to get the url for SOAP calls. Will you try opening the report server config tool? Can this tool connect to the machine? Are you specifying the same instance name listed in the config tool connection dialog?|||I have the same problem.
I can connect to the reporting service by using machine\instance in report server config tool.
But I cannot connect to the reporting service through managment studio by providing machine\instance, instead, if I use http://localhost/reportserver, I can connect to the report server through management studio.
I even tried to uninstall the report service, and reinstall it again. This problem still exists.
But the same thing does not happen on my colleague's machine.
I think it is better to look into this issue...
|||I managed to solve this problem...
If you want to use machine\instance to connect Management studio.
You need to make sure in rsreportservice.config, element <UrlRoot>http://localhost/reportserver</UrlRoot> is correctly configured. (You can test this by visit this url)
I guess, the machine\instance will eventurally be translated to the <UrlRoot>. If the <UrlRoot> is not correct, then you will not be able to use machine\instance to connect report service.
|||the attempt to connect to the report server failed. check your connection information and that the report server is a compatible version(.Net 2003 version)|||I am try to solve this problem i give for this error"i have SQL 2205 with SP1 installed on my machine.
and i m not bale to connect to Report Server using SQL management studio as well as from web.
i have installed reporting server and database on same machine. i tried using
"http://localhost/reportserver"
"http://localhost/reports"
"http://localhost/reportmanager"
but i am not bale to connect i am getting "Service Unavailable" page.
and when i try to connect using SQL Management Studio with "servername/instance" as well as "http://localhost/reportserver" i am getting a error saying.
===================================
Cannot connect to http://localhost/reportserver.
The request failed with HTTP status 503: Service Unavailable. (Microsoft.SqlServer.Management.UI.RSClient)
===================================
but if i try and connect to other reporting server on other machine using web http://servername/reportserver i m able to connect it.
but dont know whats the problem on my machine.
do i need to start any services for this...
so anybody knows how to troubleshoot this issue.
Thanks in advance...
|||
Hi,
Any solution for the above mentioned problem?
have SQL 2005 without SP1 installed on my machine.
and i m not bale to connect to Report Server using SQL management studio as well as from web.
i have installed reporting server and database on same machine. i tried using
"http://localhost/reportserver"
"http://localhost/reports"
"http://localhost/reportmanager"
but i am not bale to connect i am getting "Service Unavailable" page.
and when i try to connect using SQL Management Studio with "servername/instance" it says, "No connection could not be made because the target machine actively refused it"
===================================
Cannot connect to http://localhost/reportserver.
The request failed with HTTP status 503: Service Unavailable. (Microsoft.SqlServer.Management.UI.RSClient)
Please post your suggestion, if you resolved it already.
Regards,
Bhuvana
|||i tried visiting this URL. it says 503, service un available error. Please give me the solution.|||Something to try:
I had the same issue, what I did to fix is goto C:\Program Files\Microsoft SQL Server\MSSQL.1\Reporting Services and ensure that the ASPNET user has read,read&Execute and List Folder security permissions applied to all the subdirectories also ensure that you click the 'Advance' button when applying the permissions to ensure the security settings are applied to all child objects. During my installation for some reason it did not assign the proper permissions to the ASPNET user (aspnet_wp account). It couldn't even read the config files.
good luck
can not connect to Report server from SQL SERVER 2005 Management studio
Hi All,
I have a brand new install of sql server 2005 on brand new WINDOWS SERVER2003 with latest versions. Every thing works fine excepting I get a 404 when I connect to report server from management studio..
I am even able to publish reports and all the
url://localhost/reportserver
url://localhost/reports
url://localhost/reportserver/reportbuilder/reportbuilder.application
all work fine on local machine and with in the network behind the fire wall.
But when I try to connect to report server using management studio on the local server or remote server, I get the following error.
"
TITLE: Microsoft SQL Server Management Studio
The attempt to connect to the report server failed. Check your connection information and that the report server is a compatible version. (Microsoft.SqlServer.Management.UI.RSClient)
ADDITIONAL INFORMATION:
The request failed with HTTP status 404: Not Found. (Microsoft.SqlServer.Management.UI.RSClient)
"
More techinal details
"===================================
Cannot connect to xxxxxxxxxxxx.
===================================
The attempt to connect to the report server failed. Check your connection information and that the report server is a compatible version. (Microsoft.SqlServer.Management.UI.RSClient)
Program Location:
at Microsoft.SqlServer.ReportingServices2005.RSConnection.MissingEndpointException.ThrowIfEndpointMissing(WebException e)
at Microsoft.SqlServer.ReportingServices2005.RSConnection.ValidateConnection()
at Microsoft.SqlServer.Management.UI.RSClient.RSClientConnection.CreateConnection(String connectionString)
at Microsoft.SqlServer.Management.UI.RSClient.RSConnectionInfo.CreateConnectionObject()
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()
===================================
The request failed with HTTP status 404: Not Found. (Microsoft.SqlServer.Management.UI.RSClient)
Program Location:
at Microsoft.SqlServer.ReportingServices2005.RSConnection.GetSecureMethods()
at Microsoft.SqlServer.ReportingServices2005.RSConnection.IsSecureMethod(String methodname)
at Microsoft.SqlServer.ReportingServices2005.RSConnection.ValidateConnection()
"
Any help would be greatly appreciated.
Bob
What are you passing in as the server name to Management Studio?
You can connect several ways
http://localhost/reportserver
servername
servername\instance
|||I passed both the servername and the servername\instance to the management studio.
My IIS and uses port 80. I can access Reportserver, report manager and report bilder thru the Internet. I just can not connect to Report server from Management studio.
I will try connecting to RS is Management studo using http://localhost/reportserver.
Regards
Bobba
|||Hi Brad Syputa,
Thank you for the suggestion. I worked. I was not able to try your suggestion immediatly as I was out of town.
Now I have this big question:
Why am I only able to connect to "report server" from "management studio" using
1. http://localhost/reportserver
and not using
2. servername
3. servername\instance.
Your help would save me a lot of time
Regards
Bobba(Bob)
||||||bobba wrote:
Hi Brad Syputa,
Thank you for the suggestion. I worked. I was not able to try your suggestion immediatly as I was out of town.
Now I have this big question:
Why am I only able to connect to "report server" from "management studio" using
1. http://localhost/reportserver
and not using
2. servername
3. servername\instance.
Your help would save me a lot of time
Regards
Bobba(Bob)
Indeed, I am very interested in disvoering the answer. We had a developer in our organization with the same problem and could only connect by enterting http://localhost/reportserver. The DBA team is fine using servername\instance.
Is this a bug that will be resolved?
thanks in advance,
Jason Wall
|||You should be able to connect using machine\instance. This method uses WMI to get the url for SOAP calls. Will you try opening the report server config tool? Can this tool connect to the machine? Are you specifying the same instance name listed in the config tool connection dialog?|||I have the same problem.
I can connect to the reporting service by using machine\instance in report server config tool.
But I cannot connect to the reporting service through managment studio by providing machine\instance, instead, if I use http://localhost/reportserver, I can connect to the report server through management studio.
I even tried to uninstall the report service, and reinstall it again. This problem still exists.
But the same thing does not happen on my colleague's machine.
I think it is better to look into this issue...
|||I managed to solve this problem...
If you want to use machine\instance to connect Management studio.
You need to make sure in rsreportservice.config, element <UrlRoot>http://localhost/reportserver</UrlRoot> is correctly configured. (You can test this by visit this url)
I guess, the machine\instance will eventurally be translated to the <UrlRoot>. If the <UrlRoot> is not correct, then you will not be able to use machine\instance to connect report service.
|||the attempt to connect to the report server failed. check your connection information and that the report server is a compatible version(.Net 2003 version)|||I am try to solve this problem i give for this error"i have SQL 2205 with SP1 installed on my machine.
and i m not bale to connect to Report Server using SQL management studio as well as from web.
i have installed reporting server and database on same machine. i tried using
"http://localhost/reportserver"
"http://localhost/reports"
"http://localhost/reportmanager"
but i am not bale to connect i am getting "Service Unavailable" page.
and when i try to connect using SQL Management Studio with "servername/instance" as well as "http://localhost/reportserver" i am getting a error saying.
===================================
Cannot connect to http://localhost/reportserver.
The request failed with HTTP status 503: Service Unavailable. (Microsoft.SqlServer.Management.UI.RSClient)
===================================
but if i try and connect to other reporting server on other machine using web http://servername/reportserver i m able to connect it.
but dont know whats the problem on my machine.
do i need to start any services for this...
so anybody knows how to troubleshoot this issue.
Thanks in advance...
|||
Hi,
Any solution for the above mentioned problem?
have SQL 2005 without SP1 installed on my machine.
and i m not bale to connect to Report Server using SQL management studio as well as from web.
i have installed reporting server and database on same machine. i tried using
"http://localhost/reportserver"
"http://localhost/reports"
"http://localhost/reportmanager"
but i am not bale to connect i am getting "Service Unavailable" page.
and when i try to connect using SQL Management Studio with "servername/instance" it says, "No connection could not be made because the target machine actively refused it"
===================================
Cannot connect to http://localhost/reportserver.
The request failed with HTTP status 503: Service Unavailable. (Microsoft.SqlServer.Management.UI.RSClient)
Please post your suggestion, if you resolved it already.
Regards,
Bhuvana
|||i tried visiting this URL. it says 503, service un available error. Please give me the solution.|||Something to try:
I had the same issue, what I did to fix is goto C:\Program Files\Microsoft SQL Server\MSSQL.1\Reporting Services and ensure that the ASPNET user has read,read&Execute and List Folder security permissions applied to all the subdirectories also ensure that you click the 'Advance' button when applying the permissions to ensure the security settings are applied to all child objects. During my installation for some reason it did not assign the proper permissions to the ASPNET user (aspnet_wp account). It couldn't even read the config files.
good luck
can not connect to Report server from SQL SERVER 2005 Management studio
Hi All,
I have a brand new install of sql server 2005 on brand new WINDOWS SERVER2003 with latest versions. Every thing works fine excepting I get a 404 when I connect to report server from management studio..
I am even able to publish reports and all the
url://localhost/reportserver
url://localhost/reports
url://localhost/reportserver/reportbuilder/reportbuilder.application
all work fine on local machine and with in the network behind the fire wall.
But when I try to connect to report server using management studio on the local server or remote server, I get the following error.
"
TITLE: Microsoft SQL Server Management Studio
The attempt to connect to the report server failed. Check your connection information and that the report server is a compatible version. (Microsoft.SqlServer.Management.UI.RSClient)
ADDITIONAL INFORMATION:
The request failed with HTTP status 404: Not Found. (Microsoft.SqlServer.Management.UI.RSClient)
"
More techinal details
"===================================
Cannot connect to xxxxxxxxxxxx.
===================================
The attempt to connect to the report server failed. Check your connection information and that the report server is a compatible version. (Microsoft.SqlServer.Management.UI.RSClient)
Program Location:
at Microsoft.SqlServer.ReportingServices2005.RSConnection.MissingEndpointException.ThrowIfEndpointMissing(WebException e)
at Microsoft.SqlServer.ReportingServices2005.RSConnection.ValidateConnection()
at Microsoft.SqlServer.Management.UI.RSClient.RSClientConnection.CreateConnection(String connectionString)
at Microsoft.SqlServer.Management.UI.RSClient.RSConnectionInfo.CreateConnectionObject()
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()
===================================
The request failed with HTTP status 404: Not Found. (Microsoft.SqlServer.Management.UI.RSClient)
Program Location:
at Microsoft.SqlServer.ReportingServices2005.RSConnection.GetSecureMethods()
at Microsoft.SqlServer.ReportingServices2005.RSConnection.IsSecureMethod(String methodname)
at Microsoft.SqlServer.ReportingServices2005.RSConnection.ValidateConnection()
"
Any help would be greatly appreciated.
Bob
What are you passing in as the server name to Management Studio?
You can connect several ways
http://localhost/reportserver
servername
servername\instance
|||I passed both the servername and the servername\instance to the management studio.
My IIS and uses port 80. I can access Reportserver, report manager and report bilder thru the Internet. I just can not connect to Report server from Management studio.
I will try connecting to RS is Management studo using http://localhost/reportserver.
Regards
Bobba
|||Hi Brad Syputa,
Thank you for the suggestion. I worked. I was not able to try your suggestion immediatly as I was out of town.
Now I have this big question:
Why am I only able to connect to "report server" from "management studio" using
1. http://localhost/reportserver
and not using
2. servername
3. servername\instance.
Your help would save me a lot of time
Regards
Bobba(Bob)
||||||Hi Brad Syputa,
Thank you for the suggestion. I worked. I was not able to try your suggestion immediatly as I was out of town.
Now I have this big question:
Why am I only able to connect to "report server" from "management studio" using
1. http://localhost/reportserver
and not using
2. servername
3. servername\instance.
Your help would save me a lot of time
Regards
Bobba(Bob)
Indeed, I am very interested in disvoering the answer. We had a developer in our organization with the same problem and could only connect by enterting http://localhost/reportserver. The DBA team is fine using servername\instance.
Is this a bug that will be resolved?
thanks in advance,
Jason Wall
|||You should be able to connect using machine\instance. This method uses WMI to get the url for SOAP calls. Will you try opening the report server config tool? Can this tool connect to the machine? Are you specifying the same instance name listed in the config tool connection dialog?|||I have the same problem.
I can connect to the reporting service by using machine\instance in report server config tool.
But I cannot connect to the reporting service through managment studio by providing machine\instance, instead, if I use http://localhost/reportserver, I can connect to the report server through management studio.
I even tried to uninstall the report service, and reinstall it again. This problem still exists.
But the same thing does not happen on my colleague's machine.
I think it is better to look into this issue...
|||I managed to solve this problem...
If you want to use machine\instance to connect Management studio.
You need to make sure in rsreportservice.config, element <UrlRoot>http://localhost/reportserver</UrlRoot> is correctly configured. (You can test this by visit this url)
I guess, the machine\instance will eventurally be translated to the <UrlRoot>. If the <UrlRoot> is not correct, then you will not be able to use machine\instance to connect report service.
|||the attempt to connect to the report server failed. check your connection information and that the report server is a compatible version(.Net 2003 version)|||I am try to solve this problem i give for this error"i have SQL 2205 with SP1 installed on my machine.
and i m not bale to connect to Report Server using SQL management studio as well as from web.
i have installed reporting server and database on same machine. i tried using
"http://localhost/reportserver"
"http://localhost/reports"
"http://localhost/reportmanager"
but i am not bale to connect i am getting "Service Unavailable" page.
and when i try to connect using SQL Management Studio with "servername/instance" as well as "http://localhost/reportserver" i am getting a error saying.
===================================
Cannot connect to http://localhost/reportserver.
The request failed with HTTP status 503: Service Unavailable. (Microsoft.SqlServer.Management.UI.RSClient)
===================================
but if i try and connect to other reporting server on other machine using web http://servername/reportserver i m able to connect it.
but dont know whats the problem on my machine.
do i need to start any services for this...
so anybody knows how to troubleshoot this issue.
Thanks in advance...
|||
Hi,
Any solution for the above mentioned problem?
have SQL 2005 without SP1 installed on my machine.
and i m not bale to connect to Report Server using SQL management studio as well as from web.
i have installed reporting server and database on same machine. i tried using
"http://localhost/reportserver"
"http://localhost/reports"
"http://localhost/reportmanager"
but i am not bale to connect i am getting "Service Unavailable" page.
and when i try to connect using SQL Management Studio with "servername/instance" it says, "No connection could not be made because the target machine actively refused it"
===================================
Cannot connect to http://localhost/reportserver.
The request failed with HTTP status 503: Service Unavailable. (Microsoft.SqlServer.Management.UI.RSClient)
Please post your suggestion, if you resolved it already.
Regards,
Bhuvana
|||i tried visiting this URL. it says 503, service un available error. Please give me the solution.|||Something to try:
I had the same issue, what I did to fix is goto C:\Program Files\Microsoft SQL Server\MSSQL.1\Reporting Services and ensure that the ASPNET user has read,read&Execute and List Folder security permissions applied to all the subdirectories also ensure that you click the 'Advance' button when applying the permissions to ensure the security settings are applied to all child objects. During my installation for some reason it did not assign the proper permissions to the ASPNET user (aspnet_wp account). It couldn't even read the config files.
good luck
can not connect to Report server from SQL SERVER 2005 Management studio
Hi All,
I have a brand new install of sql server 2005 on brand new WINDOWS SERVER2003 with latest versions. Every thing works fine excepting I get a 404 when I connect to report server from management studio..
I am even able to publish reports and all the
url://localhost/reportserver
url://localhost/reports
url://localhost/reportserver/reportbuilder/reportbuilder.application
all work fine on local machine and with in the network behind the fire wall.
But when I try to connect to report server using management studio on the local server or remote server, I get the following error.
"
TITLE: Microsoft SQL Server Management Studio
The attempt to connect to the report server failed. Check your connection information and that the report server is a compatible version. (Microsoft.SqlServer.Management.UI.RSClient)
ADDITIONAL INFORMATION:
The request failed with HTTP status 404: Not Found. (Microsoft.SqlServer.Management.UI.RSClient)
"
More techinal details
"===================================
Cannot connect to xxxxxxxxxxxx.
===================================
The attempt to connect to the report server failed. Check your connection information and that the report server is a compatible version. (Microsoft.SqlServer.Management.UI.RSClient)
Program Location:
at Microsoft.SqlServer.ReportingServices2005.RSConnection.MissingEndpointException.ThrowIfEndpointMissing(WebException e)
at Microsoft.SqlServer.ReportingServices2005.RSConnection.ValidateConnection()
at Microsoft.SqlServer.Management.UI.RSClient.RSClientConnection.CreateConnection(String connectionString)
at Microsoft.SqlServer.Management.UI.RSClient.RSConnectionInfo.CreateConnectionObject()
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()
===================================
The request failed with HTTP status 404: Not Found. (Microsoft.SqlServer.Management.UI.RSClient)
Program Location:
at Microsoft.SqlServer.ReportingServices2005.RSConnection.GetSecureMethods()
at Microsoft.SqlServer.ReportingServices2005.RSConnection.IsSecureMethod(String methodname)
at Microsoft.SqlServer.ReportingServices2005.RSConnection.ValidateConnection()
"
Any help would be greatly appreciated.
Bob
What are you passing in as the server name to Management Studio?
You can connect several ways
http://localhost/reportserver
servername
servername\instance
|||I passed both the servername and the servername\instance to the management studio.
My IIS and uses port 80. I can access Reportserver, report manager and report bilder thru the Internet. I just can not connect to Report server from Management studio.
I will try connecting to RS is Management studo using http://localhost/reportserver.
Regards
Bobba
|||Hi Brad Syputa,
Thank you for the suggestion. I worked. I was not able to try your suggestion immediatly as I was out of town.
Now I have this big question:
Why am I only able to connect to "report server" from "management studio" using
1. http://localhost/reportserver
and not using
2. servername
3. servername\instance.
Your help would save me a lot of time
Regards
Bobba(Bob)
||||||Hi Brad Syputa,
Thank you for the suggestion. I worked. I was not able to try your suggestion immediatly as I was out of town.
Now I have this big question:
Why am I only able to connect to "report server" from "management studio" using
1. http://localhost/reportserver
and not using
2. servername
3. servername\instance.
Your help would save me a lot of time
Regards
Bobba(Bob)
Indeed, I am very interested in disvoering the answer. We had a developer in our organization with the same problem and could only connect by enterting http://localhost/reportserver. The DBA team is fine using servername\instance.
Is this a bug that will be resolved?
thanks in advance,
Jason Wall
|||You should be able to connect using machine\instance. This method uses WMI to get the url for SOAP calls. Will you try opening the report server config tool? Can this tool connect to the machine? Are you specifying the same instance name listed in the config tool connection dialog?|||I have the same problem.
I can connect to the reporting service by using machine\instance in report server config tool.
But I cannot connect to the reporting service through managment studio by providing machine\instance, instead, if I use http://localhost/reportserver, I can connect to the report server through management studio.
I even tried to uninstall the report service, and reinstall it again. This problem still exists.
But the same thing does not happen on my colleague's machine.
I think it is better to look into this issue...
|||I managed to solve this problem...
If you want to use machine\instance to connect Management studio.
You need to make sure in rsreportservice.config, element <UrlRoot>http://localhost/reportserver</UrlRoot> is correctly configured. (You can test this by visit this url)
I guess, the machine\instance will eventurally be translated to the <UrlRoot>. If the <UrlRoot> is not correct, then you will not be able to use machine\instance to connect report service.
|||the attempt to connect to the report server failed. check your connection information and that the report server is a compatible version(.Net 2003 version)|||I am try to solve this problem i give for this error"i have SQL 2205 with SP1 installed on my machine.
and i m not bale to connect to Report Server using SQL management studio as well as from web.
i have installed reporting server and database on same machine. i tried using
"http://localhost/reportserver"
"http://localhost/reports"
"http://localhost/reportmanager"
but i am not bale to connect i am getting "Service Unavailable" page.
and when i try to connect using SQL Management Studio with "servername/instance" as well as "http://localhost/reportserver" i am getting a error saying.
===================================
Cannot connect to http://localhost/reportserver.
The request failed with HTTP status 503: Service Unavailable. (Microsoft.SqlServer.Management.UI.RSClient)
===================================
but if i try and connect to other reporting server on other machine using web http://servername/reportserver i m able to connect it.
but dont know whats the problem on my machine.
do i need to start any services for this...
so anybody knows how to troubleshoot this issue.
Thanks in advance...
|||
Hi,
Any solution for the above mentioned problem?
have SQL 2005 without SP1 installed on my machine.
and i m not bale to connect to Report Server using SQL management studio as well as from web.
i have installed reporting server and database on same machine. i tried using
"http://localhost/reportserver"
"http://localhost/reports"
"http://localhost/reportmanager"
but i am not bale to connect i am getting "Service Unavailable" page.
and when i try to connect using SQL Management Studio with "servername/instance" it says, "No connection could not be made because the target machine actively refused it"
===================================
Cannot connect to http://localhost/reportserver.
The request failed with HTTP status 503: Service Unavailable. (Microsoft.SqlServer.Management.UI.RSClient)
Please post your suggestion, if you resolved it already.
Regards,
Bhuvana
|||i tried visiting this URL. it says 503, service un available error. Please give me the solution.|||Something to try:
I had the same issue, what I did to fix is goto C:\Program Files\Microsoft SQL Server\MSSQL.1\Reporting Services and ensure that the ASPNET user has read,read&Execute and List Folder security permissions applied to all the subdirectories also ensure that you click the 'Advance' button when applying the permissions to ensure the security settings are applied to all child objects. During my installation for some reason it did not assign the proper permissions to the ASPNET user (aspnet_wp account). It couldn't even read the config files.
good luck
sqlTuesday, March 20, 2012
Can not change filter on model report - UPDATED 7th June
I have a very simple report based on a test model.
The report is filtered via a date field and runs ok.
If I try to change the filter I get the following error message:
Operation Failed
Short time pattern does not include hours and minutes
Does anyone know how I can correct this?
Regards
John
UPDATE
This only happens if I try to filter between two dates, a single date works correctly!
Can you please save report that fails to file and post it?|||Alexandre
This is the rdl for the failing report.
<?xml version="1.0" encoding="utf-8"?>
<Report xmlns="http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition" xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">
<Language>en-US</Language>
<BottomMargin>0.5in</BottomMargin>
<RightMargin>0.5in</RightMargin>
<DataSets>
<DataSet Name="dataSet">
<Query>
<DataSourceName>dataSource1</DataSourceName>
<CommandText><SemanticQuery xmlns="http://schemas.microsoft.com/sqlserver/2004/10/semanticmodeling" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:rb="http://schemas.microsoft.com/sqlserver/2004/11/reportbuilder" xmlns:qd="http://schemas.microsoft.com/sqlserver/2004/11/semanticquerydesign">
<Hierarchies>
<Hierarchy>
<BaseEntity>
<!--Epex Referral-->
<EntityID>G066c76f8-9856-4acd-8b54-d734971da2c8</EntityID>
</BaseEntity>
<Groupings>
<Grouping Name="Epex Referral">
<Expression Name="Epex Referral">
<EntityRef>
<!--Epex Referral-->
<EntityID>G066c76f8-9856-4acd-8b54-d734971da2c8</EntityID>
</EntityRef>
</Expression>
<Details>
<Expression Name="Created">
<AttributeRef>
<!--Created-->
<AttributeID>G9a9689b0-64a7-49de-abae-58b8d30322e9</AttributeID>
</AttributeRef>
</Expression>
<Expression Name="Close Date">
<AttributeRef>
<!--Close Date-->
<AttributeID>G36ac2614-9e79-4c60-9c3e-fc45de7c67ec</AttributeID>
</AttributeRef>
</Expression>
<Expression Name="Patient">
<Path>
<RolePathItem>
<!--Patient-->
<RoleID>G036974d5-33a0-4096-bc96-166d82853818</RoleID>
</RolePathItem>
</Path>
<AttributeRef>
<!--Name-->
<AttributeID>Gd6622d3c-8a4f-4273-a190-c8834bf90031</AttributeID>
</AttributeRef>
</Expression>
<Expression Name="expr1">
<AttributeRef>
<!--Updated-->
<AttributeID>Gfee3c95d-eb72-48c3-b372-0e2865ac44c8</AttributeID>
</AttributeRef>
</Expression>
</Details>
</Grouping>
</Groupings>
<Filter>
<Expression Name="expr2">
<Function>
<FunctionName>And</FunctionName>
<Arguments>
<Expression>
<Function>
<FunctionName>GreaterThanOrEquals</FunctionName>
<Arguments>
<Expression>
<AttributeRef>
<!--Created-->
<AttributeID>G9a9689b0-64a7-49de-abae-58b8d30322e9</AttributeID>
</AttributeRef>
</Expression>
<Expression>
<Literal>
<DataType>DateTime</DataType>
<Value>2005-01-01T00:00:00</Value>
</Literal>
</Expression>
</Arguments>
</Function>
</Expression>
<Expression>
<Function>
<FunctionName>LessThanOrEquals</FunctionName>
<Arguments>
<Expression>
<AttributeRef>
<!--Created-->
<AttributeID>G9a9689b0-64a7-49de-abae-58b8d30322e9</AttributeID>
</AttributeRef>
</Expression>
<Expression>
<Literal>
<DataType>DateTime</DataType>
<Value>2006-01-01T00:00:00</Value>
</Literal>
</Expression>
</Arguments>
</Function>
</Expression>
</Arguments>
</Function>
<CustomProperties>
<CustomProperty Name="qd:FilterCondition" />
<CustomProperty Name="qd:Filter" />
<CustomProperty Name="qd:ContextEntityID">
<Value xsi:type="xsd:string">G066c76f8-9856-4acd-8b54-d734971da2c8</Value>
</CustomProperty>
<CustomProperty Name="qd:AutoChangeBaseEntity" />
<CustomProperty Name="qd:Design">
<Value xsi:type="xsd:string">expr3</Value>
</CustomProperty>
</CustomProperties>
</Expression>
</Filter>
</Hierarchy>
</Hierarchies>
<CalculatedAttributes>
<Expression Name="expr3">
<Function>
<FunctionName>And</FunctionName>
<Arguments>
<Expression>
<Function>
<FunctionName>And</FunctionName>
<Arguments>
<Expression>
<Function>
<FunctionName>GreaterThanOrEquals</FunctionName>
<Arguments>
<Expression>
<AttributeRef>
<!--Created-->
<AttributeID>G9a9689b0-64a7-49de-abae-58b8d30322e9</AttributeID>
</AttributeRef>
</Expression>
<Expression>
<Literal>
<DataType>DateTime</DataType>
<Value>2005-01-01T00:00:00</Value>
</Literal>
</Expression>
</Arguments>
</Function>
</Expression>
<Expression>
<Function>
<FunctionName>LessThanOrEquals</FunctionName>
<Arguments>
<Expression>
<AttributeRef>
<!--Created-->
<AttributeID>G9a9689b0-64a7-49de-abae-58b8d30322e9</AttributeID>
</AttributeRef>
</Expression>
<Expression>
<Literal>
<DataType>DateTime</DataType>
<Value>2006-01-01T00:00:00</Value>
</Literal>
</Expression>
</Arguments>
</Function>
</Expression>
</Arguments>
</Function>
<CustomProperties>
<CustomProperty Name="qd:FilterCondition" />
</CustomProperties>
</Expression>
<Expression>
<Null />
<CustomPropertes>
<CustomProperty Name="qd:Unspecified" />
</CustomProperties>
</Expression>
</Arguments>
</Function>
<CustomProperties>
<CustomProperty Name="qd:Filter" />
<CustomProperty Name="qd:ContextEntityID">
<Value xsi:type="xsd:string">G066c76f8-9856-4acd-8b54-d734971da2c8</Value>
</CustomProperty>
<CustomProperty Name="qd:AutoChangeBaseEntity" />
</CustomProperties>
</Expression>
</CalculatedAttributes>
</SemanticQuery></CommandText>
</Query>
<Fields>
<Field Name="EpexReferral">
<DataField>Epex Referral</DataField>
</Field>
<Field Name="Created">
<DataField>Created</DataField>
</Field>
<Field Name="CloseDate">
<DataField>Close Date</DataField>
</Field>
<Field Name="Patient">
<DataField>Patient</DataField>
</Field>
<Field Name="expr1">
<DataField>expr1</DataField>
</Field>
</Fields>
</DataSet>
</DataSets>
<DataSources>
<DataSource Name="dataSource1">
<DataSourceReference>/Models/Mars Cutdown</DataSourceReference>
<rd:DataSourceID>4d1edcd6-3c78-4e68-9566-ef952e495be4</rd:DataSourceID>
</DataSource>
</DataSources>
<PageHeight>11in</PageHeight>
<LeftMargin>0.5in</LeftMargin>
<TopMargin>0.5in</TopMargin>
<Width>7.5in</Width>
<Body>
<Height>0in</Height>
<ReportItems>
<Textbox Name="Title">
<Left>0.5in</Left>
<Top>0.5in</Top>
<CanGrow>true</CanGrow>
<Width>6.5in</Width>
<Value />
<Style>
<FontFamily>Tahoma</FontFamily>
<TextAlign>Left</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontWeight>Normal</FontWeight>
<FontSize>18pt</FontSize>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CustomProperties>
<CustomProperty>
<Name>rb:Watermark</Name>
<Value>Click to add title</Value>
</CustomProperty>
</CustomProperties>
<Height>0.375in</Height>
</Textbox>
<Table Name="table">
<Top>1.25in</Top>
<Details>
<TableRows>
<TableRow>
<TableCells>
<TableCell>
<ReportItems>
<Textbox Name="Created_Value">
<DataElementOutput>Output</DataElementOutput>
<CanGrow>true</CanGrow>
<Action>
<Drillthrough>
<ReportName>=DataSources!dataSource1.DataSourceReference</ReportName>
<Parameters>
<Parameter Name="rs:EntityID">
<Value>G066c76f8-9856-4acd-8b54-d734971da2c8</Value>
</Parameter>
<Parameter Name="rs:DrillType">
<Value>Detail</Value>
</Parameter>
<Parameter Name="rs:Command">
<Value>Drillthrough</Value>
</Parameter>
<Parameter Name="DrillthroughSourceQuery">
<Value>=DataSets!dataSet.RewrittenCommandText</Value>
</Parameter>
<Parameter Name="DrillthroughContext">
<Value>=CreateDrillthroughContext()</Value>
</Parameter>
</Parameters>
</Drillthrough>
</Action>
<Value>=Fields!Created.Value</Value>
<Styl>
<Language>en-US</Language>
<BorderColor>
<Default>LightGrey</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<FontFamily>Tahoma</FontFamily>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontWeight>Normal</FontWeight>
<FontSize>8pt</FontSize>
<Format>d</Format>
<BackgroundColor>White</BackgroundColor>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="CloseDate_Value">
<DataElementOutput>Output</DataElementOutput>
<CanGrow>true</CanGrow>
<Value>=Fields!CloseDate.Value</Value>
<Style>
<Language>en-US</Language>
<BorderColor>
<Default>LightGrey</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<FontFamily>Tahoma</FontFamily>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontWeight>Normal</FontWeight>
<FontSize>8pt</FontSize>
<Format>d</Format>
<BackgroundColor>White</BackgroundColor>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="Patient_Value">
<DataElementOutput>Output</DataElementOutput>
<CanGrow>true</CanGrow>
<Action>
<Drillthrough>
<ReportName>=DataSources!dataSource1.DataSourceReference</ReportName>
<Parameters>
<Parameter Name="rs:EntityID">
<Value>G2ceef5ce-4e09-4806-8e8c-9a4e4e8f35fa</Value>
</Parameter>
<Parameter Name="rs:DrillType">
<Value>Detail</Value>
</Parameter>
<Parameter Name="rs:Command">
<Value>Drillthrough</Value>
</Parameter>
<Parameter Name="DrillthroughSourceQuery">
<Value>=DataSets!dataSet.RewrittenCommandText</Value>
</Parameter>
<Parameter Name="DrillthroughContext">
<Value>=CreateDrillthroughContext()</Value>
</Parameter>
</Parameters>
</Drillthrough>
</Action>
<Value>=Fields!Patient.Value</Value>
<Style>
<Language>en-US</Language>
<BorderColor>
<Default>LightGrey</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<FontFamily>Tahoma</FontFamily>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontWeight>Normal</FontWeight>
<FontSize>8pt</FontSize>
<BackgroundColor>White</BackgroundColor>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
</Textbox>
</ReportItems>
</TableCell>
</TableCells>
<Height>0.25in</Height>
</TableRow>
</TableRows>
<Grouping Name="table_EpexReferral">
<GroupExpressions>
<GroupExpression>=Fields!EpexReferral.Value</GroupExpression>
</GroupExpressions>
</Grouping>
<Sorting>
<SortBy>
<SortExpression>=IIf(True, Fields!expr1.Value, Nothing)</SortExpression>
<Direction>Descending</Direction>
</SortBy>
<SortBy>
<SortExpression>=IIf(True, Fields!Created.Value, Nothing)</SortExpression>
<Direction>Descending</Direction>
</SortBy>
</Sorting>
</Details>
<Style />
<Width>0in</Width>
<Height>0in</Height>
<DataSetName>dataSet</DataSetName>
<TableColumns>
<TableColumn>
<Width>0.90092in</Width>
<Visibility>
<Hidden>=Fields!Created.IsMissing</Hidden>
</Visibility>
</TableColumn>
<TableColumn>
<Width>1.06361in</Width>
<Visibility>
<Hidden>=Fields!CloseDate.IsMissing</Hidden>
</Visibility>
</TableColumn>
<TableColumn>
<Width>1.62189in</Width>
<Visibility>
<Hidden>=Fields!Patient.IsMissing</Hidden>
</Visibility>
</TableColumn>
</TableColumns>
<Header>
<TableRows>
<TableRow>
<TableCells>
<TableCell>
<ReportItems>
<Textbox Name="Created_Header">
<CanGrow>true</CanGrow>
<UserSort>
<SortExpression>=Fields!Created.Value</SortExpression>
<SortExpressionScope>table_EpexReferral</SortExpressionScope>
</UserSort>
<Value>Created</Value>
<Style>
<Language>en-US</Language>
<BorderColor>
<Default>LightGrey</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<FontFamily>Tahoma</FontFamily>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontWeight>Bold</FontWeight>
<FontSize>8pt</FontSize>
<BackgroundColor>#518ae5</BackgroundColor>
<Color>White</Color>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="CloseDate_Header">
<CanGrow>true</CanGrow>
<UserSort>
<SortExpression>=Fields!CloseDate.Value</SortExpression>
<SortExpressionScope>table_EpexReferral</SortExpressionScope>
</UserSort>
<Value>Close Date</Value>
<Style
<Language>en-US</Language>
<BorderColor>
<Default>LightGrey</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<FontFamily>Tahoma</FontFamily>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontWeight>Bold</FontWeight>
<FontSize>8pt</FontSize>
<BackgroundColor>#518ae5</BackgroundColor>
<Color>White</Color>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="Patient_Header">
<CanGrow>true</CanGrow>
<UserSort>
<SortExpression>=Fields!Patient.Value</SortExpression>
<SortExpressionScope>table_EpexReferral</SortExpressionScope>
</UserSort>
<Value>Patient</Value>
<Style>
<Language>en-US</Language>
<BorderColor>
<Default>LightGrey</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<FontFamily>Tahoma</FontFamily>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontWeight>Bold</FontWeight>
<FontSize>8pt</FontSize>
<BackgroundColor>#518ae5</BackgroundColor>
<Color>White</Color>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
</Textbox>
</ReportItems>
</TableCell>
</TableCells>
<Height>0.25in</Height>
</TableRow>
</TableRows>
<RepeatOnNewPage>true</RepeatOnNewPage>
<FixedHeader>true</FixedHeader>
</Header>
<Left>0.5in</Left>
</Table>
<Textbox Name="TotalRows">
<Left>0.5in</Left>
<Top>3in</Top>
<CanGrow>true</CanGrow>
<Width>6.5in</Width>
<Value>=String.Format("Total Epex Referrals" & Chr(58) & " {0}", COUNTROWS("dataSet"))</Value>
<Style>
<PaddingLeft>3pt</PaddingLeft>
<PaddingBottom>3pt</PaddingBottom>
<FontWeight>Normal</FontWeight>
<FontSize>8pt</FontSize>
<PaddingRight>3pt</PaddingRight>
<PaddingTop>3pt</PaddingTop>
</Style>
<CustomProperties>
<CustomProperty>
<Name>rb:SpecialContent</Name>
<Value>TotalRows</Value>
</CustomProperty>
</CustomProperties>
<Height>0.25in</Height>
</Textbox>
<Textbox Name="FilterDescription">
<Left>0.5in</Left>
<Top>3.5in</Top>
<CanGrow>true</CanGrow>
<Width>6.5in</Width>
<Value>Filter: Epex Referrals with: Created from 01/01/2005 to 01/01/2006</Value>
<Style>
<PaddingLeft>3pt</PaddingLeft>
<PaddingBottom>3pt</PaddingBottom>
<FontWeight>Normal</FontWeight>
<FontSize>8pt</FontSize>
<PaddingRight>3pt</PaddingRight>
<PaddingTop>3pt</PaddingTop>
</Style>
<CustomProperties>
<CustomProperty>
<Name>rb:SpecialContent</Name>
Value>FilterDescription</Value>
</CustomProperty>
</CustomProperties>
<Height>0.25in</Height>
</Textbox>
</ReportItems>
<Style />
</Body>
<PageWidth>8.5in</PageWidth>
</Report>
|||Is this error happening when you are editing report or when you are running this report? Can you save this report to report server and run it from Report Manager (http://rshost/reports)?
Thanks!
|||The report executes with no problems, I only get the error if I try to change the filter.
What is strange, I can get around the error by apply to separate date filters, one using Greater Than Or Equal and the other Less Than or Equal.
This gets around the problem but I would like to offer my end users the option of From and To as this is what the use in other parts of SSRS.
Regards
John
|||We have the same problem even after installing SP1 and the hotfixes. Has anybody a solution/answer?
Regards
Werner
|||This is a known issue that will be fixed in SP2. Unfortunately the only way to avoid this error for now is to change your Windows regional settings to use a 12-hour clock.|||Bob,
thanks for the immediate answer, when can we approx. expect SP2?
Regards
Werner
|||No committed dates yet, but I believe it's on track for later this year.|||Bob,
i tried to change the format in the regional settings like you said but no changes. We use a german W2003 server... When i select a date field in the report builder filter, select a date from the datetime picker (22.06.2006) and try to save it with the ok button i get a message box saying 'no valid date'...?!?
Can i change anything in the model to solve the problem? Is this filter problem caused by SP1 (in this case we could think about setting up the SQL Server again)?
Regards
Werner
Subscribe to:
Posts (Atom)