especial SUM

I wonderin if I can make this type of sum in SQL Reporting Services.

sum( iif(Fields!ESTADO_TRANSAC_POS.Value = "V",Fields!TOTAL_GENERAL.Value,cdbl("0.00")),"source")

i get an error field : (

i dont want to sum all the rows just the ones that where Estado_Transac = "V"

can you help me : )

i found the answer in this thread Conditional Sum/Runnining Total

sql

Errors: SQL Reporting Services with CRM 3.0

Good Day All ...

I am currently trying to install CRM 3.0 onto one of our test servers.
I have managed with no problem to get everything ready for installation ... but having a problem with reporting services.

On the system requirements results page i have green for everything but reporting services.

ERROR;
Specified Reporting Services Reports Server http://XXXXXX/ReportsServer was not found.

I have reporting services installed, can someone please give me some direction on where to go from here to get this up and working.

Thanks

Do you habe any Sharepoint Server installed on the machine or any other program which tries to bind port 80 to itself ?

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de
|||Yes i do have sharepoint installed.
Would you recommend removing that?|||

Hi,

no defintely not, but you should have a look on my site under the Screencast Section, this will whow you a way to solve your problem.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

|||Thanks for all of your help.
Works fine.

Thanks Again ... Great Advice!!|||If this helped please mark post as answer and (for me) rate the screencast and give additional feedback if you want to :-)

HTH, Jens K. SUessmeyer.

http://www.sqlserver2005.de

Errors with SRS in Sharepoint Integration Mode

Hi Everyone,

Our project has two servers. One server is running WSS 3.0 and the SQL Reporting Services web front-end. We have a second server that operates all the databases involved (WSS Content, SRS, and our application specific DB).

We do not have a domain controller in our architecture. The WSS site is configured to use SQL authentication to connnect and modify the WSS Content database. We installed SRS, SRS service pack 2, and the Sharepoint add-in. We are using forms authentication for our WSS site. We would like to use SRS in Sharepoint Integration mode, but we are unable to create datasources, view reports, etc. SRS is configured to use the "Trusted Account" in WSS Central Admin.

When we attempt to create a new datasource, and we received an error stating the object moved and to check that SRS is in Sharepoint integration mode.

When we attempt to view a report, we get an error stating:

"An unexpected error occurred while connecting to the report server. Verify that the report server is available and configured for SharePoint integrated mode."

I have a feeling this has to do with the Windows Service Account and the Web Service Identity for SRS. What type of account should we use since we do not have a domain?

Thank you,

Michael milazzo

As explained here, in Trusted Account mode, WSS sends the requests to the Report Server under the identity of the SharePoint application. By default, the IIS 6.0 application pool runs under NT AUTHORITY\Network Service. Since you don't have a domain setup, try changing the application domain identity to a local Windows user account which has the same name and password as a privileged account on the Report Server that has access to the report catalog. If you had domain setup, the request could have gone under Domain\WSS machine name$ and you could have granted access to that account.

Errors deploying and running reports

I am developing reports on my PC and deploying them to our server. My
PC only has reporting services client components while our server has
the client and server components installed.
Problem 1 :
when I deploy the solution to the server I get this error message:
"The underlying connection was closed: Could not establish trust
relationship with remote server."
Problem 2:
I have created a ASP.NET application on my PC that runs reports on the
server using the reporting service's web service. When I try and
render a report, I get this error message:
The request failed with HTTP status 404: Not Found.
Any help would really be appreciated
CraigIs your report server configured to use SSL? If so, you will need to use
FQDN (full domain name) of
the server in the report project's TargetServerURL property.
--
Ravi Mumulla (Microsoft)
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Craig HB" <craighb@.bigfoot.com> wrote in message
news:3ba2292b.0407130651.71bf5d0c@.posting.google.com...
> I am developing reports on my PC and deploying them to our server. My
> PC only has reporting services client components while our server has
> the client and server components installed.
> Problem 1 :
> when I deploy the solution to the server I get this error message:
> "The underlying connection was closed: Could not establish trust
> relationship with remote server."
> Problem 2:
> I have created a ASP.NET application on my PC that runs reports on the
> server using the reporting service's web service. When I try and
> render a report, I get this error message:
> The request failed with HTTP status 404: Not Found.
> Any help would really be appreciated
> Craig

Errors Configuring Reporting Services

Hi
I am trying to re-install reporting services on a server. In the report
services configuration tool,
The Server staus is Green
The Report Server Virtual Directory is Green
THe Report Manager Virtual Directory is RED
when I click on NEW... to create one I get the following error
ReportServicesConfigUI.WMIProvider.WMIProviderException: The virtual
directory specified already exists. Specify a different name.
at
ReportServicesConfigUI.WMIProvider.RSReportManagerAdmin.CreateVirtualDirectory(String
virtualDirectory, String path)
but IIS Manager does not list any directory called Reports
Any ideas how I should proceed from hereThis is 2005, not Katmai? Both Config Tool and server are at same SP level?
"Bob Miller" <someone@.microsoft.com> wrote in message
news:uZGcMR83HHA.3940@.TK2MSFTNGP05.phx.gbl...
> Hi
> I am trying to re-install reporting services on a server. In the report
> services configuration tool,
> The Server staus is Green
> The Report Server Virtual Directory is Green
> THe Report Manager Virtual Directory is RED
> when I click on NEW... to create one I get the following error
> ReportServicesConfigUI.WMIProvider.WMIProviderException: The virtual
> directory specified already exists. Specify a different name.
> at
> ReportServicesConfigUI.WMIProvider.RSReportManagerAdmin.CreateVirtualDirectory(String
> virtualDirectory, String path)
> but IIS Manager does not list any directory called Reports
> Any ideas how I should proceed from here
>|||Yes,
SQL 2005 and Service Pack 2 has been applied prior to attempting the
configuration
Cheers
"Brian Welcker [MSFT]" <bwelcker@.online.microsoft.com> wrote in message
news:eEOoJgD4HHA.1208@.TK2MSFTNGP05.phx.gbl...
> This is 2005, not Katmai? Both Config Tool and server are at same SP
> level?
> "Bob Miller" <someone@.microsoft.com> wrote in message
> news:uZGcMR83HHA.3940@.TK2MSFTNGP05.phx.gbl...
>> Hi
>> I am trying to re-install reporting services on a server. In the report
>> services configuration tool,
>> The Server staus is Green
>> The Report Server Virtual Directory is Green
>> THe Report Manager Virtual Directory is RED
>> when I click on NEW... to create one I get the following error
>> ReportServicesConfigUI.WMIProvider.WMIProviderException: The virtual
>> directory specified already exists. Specify a different name.
>> at
>> ReportServicesConfigUI.WMIProvider.RSReportManagerAdmin.CreateVirtualDirectory(String
>> virtualDirectory, String path)
>> but IIS Manager does not list any directory called Reports
>> Any ideas how I should proceed from here

Errors accessing VFP data.

I have a test system setup in Reading.
SQL Server is on machine EUK01314
IIS 5 also is on machine EUK01314
Reporting services are installed on machine EUK01314
Visual Studo is on machine EUK01314
I can create reports that access SQL server data, or via ODBC, or via OLEDB
to SQL server on EUK01314.
I can use those reports from our Terminal Server, no problem.
I can create reports that access Oracle data, via ODBC, or via OLEDB to
Oracle on a server in Belgim..
I can use those reports from our Terminal Server, no problem.
I draw a total blank accessing Visual FoxPro data.
I can create reports that access VFP data, via ODBC or OLEDB.
Those reports work on EUK01314 in Visual Studio.
Those reports work on EUK01314 in IE via Report Manager.
So why on earth (or any other planet) don't they work on any other machine
?
Connection string: Driver={Microsoft Visual FoxPro
Driver};SourceType=DBC;SourceDB=\\ecengds001\connections\data\connrdp.dbc;Exclusive=No;NULL=NO;Collate=Machine;BACKGROUNDFETCH=NO;DELETED=NO
a.. An error has occurred during report processing. (rsProcessingAborted)
Get Online Help
a.. Cannot create a connection to data source 'DataSource1'.
(rsErrorOpeningConnection) Get Online Help
a.. ERROR [S1000] [Microsoft][ODBC Visual FoxPro Driver]Cannot open
file \\ecengds001\connections\data\connrdp.dbc. ERROR [IM006]
[Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed ERROR
[01000] [Microsoft][ODBC Driver Manager] The driver doesn't support the
version of ODBC behavior that the application requested (see SQLSetEnvAttr).
Connection string: Driver={Microsoft Visual FoxPro
Driver};SourceType=DBC;SourceDB=\\ecengds001\connections\data\connrdp.dbc
a.. An error has occurred during report processing. (rsProcessingAborted)
Get Online Help
a.. Query execution failed for data set 'DataSet1'.
(rsErrorExecutingCommand) Get Online Help
a.. ERROR [S1000] [Microsoft][ODBC Visual FoxPro Driver]Cannot open
file \\ecengds001\connections\data\service.dbf.
Connection String: Provider=VFPOLEDB.1;Data
Source=\\eukfs01\mis_deve\andersonanalysis\data\;Collating Sequence=MACHINE
a.. An error has occurred during report processing. (rsProcessingAborted)
Get Online Help
a.. Cannot create a connection to data source 'DataSource1'.
(rsErrorOpeningConnection) Get Online Help
a.. Invalid path or file name.
Change to use credentials when connecting to datasource. (my user ID and
password)
a.. An error has occurred during report processing. (rsProcessingAborted)
Get Online Help
a.. Cannot create a connection to data source 'DataSource1'.
(rsErrorOpeningConnection) Get Online Help
a.. Multiple-step OLE DB operation generated errors. Check each OLE DB
status value, if available. No work was done.
Change to also impersonate user in Windows after connection.
a.. An error has occurred during report processing. (rsProcessingAborted)
Get Online Help
a.. Cannot impersonate user for data source 'DataSource1'.
(rsErrorImpersonatingUser) Get Online Help
a.. Specified method is not supported.
Remember, these work just fine when Report Manager is accessed from
EUK01314.
They do not work if Report Manager is accessed from another machine.
--
PAulHi PAul :-)
I think checking the Deleted box corresponds to SET DELETED ON which
evaluates to DELETED=YES in the connection string so be sure to verify that
you're getting what you want. Sorry I can't help on the ReportingSvcs stuff.
--
Cindy Winegarden MCSD, Microsoft Visual FoxPro MVP
cindy_winegarden@.msn.com www.cindywinegarden.com
"PAul Maskens" <pmaskens@.mvps.org> wrote in message
news:efE5woQwEHA.3872@.TK2MSFTNGP11.phx.gbl...
> Connection string: Driver={Microsoft Visual FoxPro
> Driver};SourceType=DBC;SourceDB=\\ecengds001\connections\data\connrdp.dbc;Exclusive=No;NULL=NO;Collate=Machine;BACKGROUNDFETCH=NO;DELETED=NO|||You are using SP1, right? This looks similar to an issue that we had with
Access databases (MDBs) on remote shares. Is the FoxPro database on the same
machine as the Report Server? At one point, we were incorrectly adding an
Integrated Security property to the connection string but this should have
been fixed.
--
Brian Welcker
Group Program Manager
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"PAul Maskens" <pmaskens@.mvps.org> wrote in message
news:efE5woQwEHA.3872@.TK2MSFTNGP11.phx.gbl...
>I have a test system setup in Reading.
> SQL Server is on machine EUK01314
> IIS 5 also is on machine EUK01314
> Reporting services are installed on machine EUK01314
> Visual Studo is on machine EUK01314
> I can create reports that access SQL server data, or via ODBC, or via
> OLEDB to SQL server on EUK01314.
> I can use those reports from our Terminal Server, no problem.
> I can create reports that access Oracle data, via ODBC, or via OLEDB to
> Oracle on a server in Belgim..
> I can use those reports from our Terminal Server, no problem.
> I draw a total blank accessing Visual FoxPro data.
> I can create reports that access VFP data, via ODBC or OLEDB.
> Those reports work on EUK01314 in Visual Studio.
> Those reports work on EUK01314 in IE via Report Manager.
> So why on earth (or any other planet) don't they work on any other machine
> ?
> Connection string: Driver={Microsoft Visual FoxPro
> Driver};SourceType=DBC;SourceDB=\\ecengds001\connections\data\connrdp.dbc;Exclusive=No;NULL=NO;Collate=Machine;BACKGROUNDFETCH=NO;DELETED=NO
> a.. An error has occurred during report processing. (rsProcessingAborted)
> Get Online Help
> a.. Cannot create a connection to data source 'DataSource1'.
> (rsErrorOpeningConnection) Get Online Help
> a.. ERROR [S1000] [Microsoft][ODBC Visual FoxPro Driver]Cannot open
> file \\ecengds001\connections\data\connrdp.dbc. ERROR [IM006]
> [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed ERROR
> [01000] [Microsoft][ODBC Driver Manager] The driver doesn't support the
> version of ODBC behavior that the application requested (see
> SQLSetEnvAttr).
> Connection string: Driver={Microsoft Visual FoxPro
> Driver};SourceType=DBC;SourceDB=\\ecengds001\connections\data\connrdp.dbc
> a.. An error has occurred during report processing. (rsProcessingAborted)
> Get Online Help
> a.. Query execution failed for data set 'DataSet1'.
> (rsErrorExecutingCommand) Get Online Help
> a.. ERROR [S1000] [Microsoft][ODBC Visual FoxPro Driver]Cannot open
> file \\ecengds001\connections\data\service.dbf.
> Connection String: Provider=VFPOLEDB.1;Data
> Source=\\eukfs01\mis_deve\andersonanalysis\data\;Collating
> Sequence=MACHINE
> a.. An error has occurred during report processing. (rsProcessingAborted)
> Get Online Help
> a.. Cannot create a connection to data source 'DataSource1'.
> (rsErrorOpeningConnection) Get Online Help
> a.. Invalid path or file name.
> Change to use credentials when connecting to datasource. (my user ID and
> password)
> a.. An error has occurred during report processing. (rsProcessingAborted)
> Get Online Help
> a.. Cannot create a connection to data source 'DataSource1'.
> (rsErrorOpeningConnection) Get Online Help
> a.. Multiple-step OLE DB operation generated errors. Check each OLE
> DB status value, if available. No work was done.
> Change to also impersonate user in Windows after connection.
> a.. An error has occurred during report processing. (rsProcessingAborted)
> Get Online Help
> a.. Cannot impersonate user for data source 'DataSource1'.
> (rsErrorImpersonatingUser) Get Online Help
> a.. Specified method is not supported.
> Remember, these work just fine when Report Manager is accessed from
> EUK01314.
> They do not work if Report Manager is accessed from another machine.
> --
> PAul
>|||Thanks Brian.
Sorry for the delay, I've been away in Utrecht.
I started out with the evaluation edition, then installed the SP1 download
onto that.
I had no errors reported during the installation of SP1, so I assume it
really completed OK.
How can I find out what the connection string being used is?
I know what I typed into the Report Manager, but you're implying that
something else is actually sent.
If there's a way to debug this, I'd like to get to the bottom of it.|||Hmm. I'm not sure there is a trace for VFP. Is it OLE DB or ODBC? For SP1,
the string should be the same (we don't add the Integrated Security flag for
other providers). You can make sure SP1 was successful by looking at the
version under http://server/reportserver.
--
Brian Welcker
Group Program Manager
Microsoft SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
"PAul Maskens" <pmaskens@.mvps.org> wrote in message
news:OZUD5Xx0EHA.1296@.TK2MSFTNGP10.phx.gbl...
> Thanks Brian.
> Sorry for the delay, I've been away in Utrecht.
> I started out with the evaluation edition, then installed the SP1 download
> onto that.
> I had no errors reported during the installation of SP1, so I assume it
> really completed OK.
> How can I find out what the connection string being used is?
> I know what I typed into the Report Manager, but you're implying that
> something else is actually sent.
> If there's a way to debug this, I'd like to get to the bottom of it.
>|||Sorry for the delay, I've been dragged onto a BizTalk project for a while.
Microsoft SQL Server Reporting Services Version 8.00.878.00

error:no report server found on the specified machine while setting up reporting services config

Hello,

I have installed sql server 2005 along with reporting services... though i am able to design report using business intelligence studio... i am unable to access the report server.... while trying to start the reporting services configuration manager it says no report server found on the specified machine...Invalid Namespace... the installation is local ...

Due to this problem inspite of designing the entire report i am unable to deploy it on the web..since it is asking for a report server...

Can somebody please help me on this...

Thanks in advance...

Nirupa

Hello Nirupa,

Can you make sure you have IIS installed and running? If so, make sure you have /Reports and /ReportServer showing in IIS management.

Then, check to see if you have the following three folders in the C:\Program Files\Microsoft SQL Server\MSSQL.x\Reporting Services directory (where x is the component number for RS). LogFiles, ReportManager, & ReportServer

Hope this helps.

Jarret

|||

Hi Jarret,

Thanks for your suggestions first,

yes I installed IIS and it is running,

and

I couldn't find any folder C:\Program Files\Microsoft SQL Server\MSSQL.1\ Reporting Services directory

...LogFiles, ReportManager, & ReportServer

I could see only path C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\ Backup

'' \Bin

'' \Install

'' \LOG

'' \repldata

'' \TemplateData

can you suggest me what might had happen.... or what shall be done

Thanks

Nirupa

|||

Do you have a MSSQL.2, MSSQL.3, or MSSQL.4 folder? If so, look in each for the 3 folders I listed in my last post. If you don't have these folders, you probably should reinstall Reporting Services.

Jarret

|||

Hello Jarret

I do not have the folders that you have mentioned....As you have mentioned will probably need reinstallation

Thank you

Nirupa

|||

That is correct, if you don't have these folders, you don't have RS installed. Try to re-install and see if that fixes your problem.

Jarret

|||

Hi Jarret,

Thanks for your suggestions.As you mentioned, I reinstalled SQL reporting services and got the above mention folders(MSSQL.1,MSSQL.2,MSSQL.3) and also I successfully configured reporting services.While trying to deploy my reporting services application in to localhost , I got the below mentioned error : " The attempt to connect to the report server failed. Check your connection information and that the report server is a compatible version. (Microsoft.ReportingServices.Designer) "

can you please sugguest me work around for this issue.

Error: The underlying connection was closed....

I have been getting the following error since re-installing Reporting
Services (I had to set up my Virtual PC again from scratch): "The underlying
connection was closed: The remote name could not be resolved" when I try to
gain access via http://localhost/reports (and when trying to run a report
using a BI product called TARGIT). I have read one other post relating to
this error - the author re-installed Reporting Services and the problem went
away - I have tried the same thing and still get the error. I also get the
error on Reporting Services with and without SP2 installed.
Can anybody help?Run the rsconfig.exe utility specifying the new server name along with the
security information.
You need to update the server URL in the file rswebapplication.config
In your Report Manager directory, look for a RSWebApplication.config file.
Open it and look for something like:
<ReportServerUrl>http://Youroldservername/ReportServer</ReportServerUrl>
Good luck!
Rajesh
MCSD.NET
http://meenrajan.blogspot.com
"Neil Wright" wrote:
> I have been getting the following error since re-installing Reporting
> Services (I had to set up my Virtual PC again from scratch): "The underlying
> connection was closed: The remote name could not be resolved" when I try to
> gain access via http://localhost/reports (and when trying to run a report
> using a BI product called TARGIT). I have read one other post relating to
> this error - the author re-installed Reporting Services and the problem went
> away - I have tried the same thing and still get the error. I also get the
> error on Reporting Services with and without SP2 installed.
> Can anybody help?|||Hi ,
I figured out the solution to this problem. Follwoing 3 things should be
made sure of:
1. Never reinstall reporting services without first uninstalling it
completely... i.e first remove the registry entiries manually then only
reporting services uninstallation is complete.
2. In the RSWebApplication.Config file in Reports Manager , the
ReportServerURL key should have a value as https:/IP(of the report manager
virtual directory)/ReportServer . If in other Report Server and Report
manager .Config files, you find localhost... replace it with the IP of the
virtual directory where reports manager and report server are installed.
3. When you deploy the report, in the configuration properties for the
project .. in the deployment path, again specify the IP instaed of
localhost...
If all these 3 things are taken care of.. then this error will not occur...
When i fixed all these, it worked for me.
pmud
"Rajesh" wrote:
> Run the rsconfig.exe utility specifying the new server name along with the
> security information.
> You need to update the server URL in the file rswebapplication.config
> In your Report Manager directory, look for a RSWebApplication.config file.
> Open it and look for something like:
> <ReportServerUrl>http://Youroldservername/ReportServer</ReportServerUrl>
> Good luck!
> Rajesh
> MCSD.NET
> http://meenrajan.blogspot.com
>
>
> "Neil Wright" wrote:
> > I have been getting the following error since re-installing Reporting
> > Services (I had to set up my Virtual PC again from scratch): "The underlying
> > connection was closed: The remote name could not be resolved" when I try to
> > gain access via http://localhost/reports (and when trying to run a report
> > using a BI product called TARGIT). I have read one other post relating to
> > this error - the author re-installed Reporting Services and the problem went
> > away - I have tried the same thing and still get the error. I also get the
> > error on Reporting Services with and without SP2 installed.
> >
> > Can anybody help?