Problem in exporting Report with multiline textbox to Excel

Hi,

I am facing a problem while exporting reports to Excel.
My report contains a multilined textbox - which is displayed correctly in Report Design.

Following is code of report Statistics contents to be displayed in a textbox: ="Report Statistics " & vbcrlf & "Date : " & Format(Globals!ExecutionTime, "MMM dd yyyy tt”) & vbcrlf & "By : " & User!UserID

Problem Description: In Excel - one extra line is added between each line

Sample output of report exported in Ms Excel 2003:

Report Statistics

Date : Jun 12 2006

Time : 6:53:23 PM

By : COMPANY\EMP ID

Correct Output Required:

Report Statistics

Date : Jun 12 2006

Time : 6:53:23 PM

By : SERWIZSOL\P97006

Configuration:
Microsoft SQL Server 2000 SP3
Microsoft SQL Reporting Services 2000 SP2

If some one is facing similar problem or knows the solution, please let me know.

Thanks in Advance.
Regards,
Abhijeet

Hi Abhijeet,

I tried your expression ="Report Statistics " & vbcrlf & "Date : " & Format(Globals!ExecutionTime,"MMM dd yyyy tt") & vbcrlf & "By : " & User!UserID

Everything worked fine for me. I added a text box and set the expression to above text and it works perfectly. Was there anything else you were doing?

Problem in Exporting Crystal Reports

Hi All,
I have been using Crystal Reports 8.5 with VB6.0.
I want to set the Export options through VB code.
But when I call the Export method ,the settings whatever I made is not active,it is displaying the default settings only.
How to resolve this?

Thanks in Advance for all helps!

Regards,
Muthukumar.CThere are plenty of articles in Business Objects knowledge base about how to export reports using various interfaces:
http://support.businessobjects.com/library/kbase/articles/c2010117.asp
http://support.businessobjects.com/communityCS/FilesAndUpdates/autexprt.zip.asp

Be sure to always check the knowledge base before posting to forum. In most cases, you will find the solution much faster than you expect.

Problem in deployment of Crystal 10 with VB6

I've facing problem in creating the package for the application using VB6 and Crystal reports 10. What are the support files needed to be included in the package. I've already included Crviewer.dll,CRAXDRT.dll. But there is no response in the client machine.Whether Crystal Reports 10 need to be installed in client machine?

Please respond!

Thanking you,

Regards,
Rajarajan RI found solution to my deployment problems in the next link -->

http://support.businessobjects.com/communityCS/TechnicalPapers/rdc10_deployment.pdf

problem in crystal reports design

hi,
I want to know if its possible to design crystal reports with checkbox. Iam working in vb.net and using crystal reports.What do you want to to that?

See if you find solution here
http://support.businessobjects.com/

Problem in creating reports using BI fields

Hi,

I have created a cube using 3 Dimensions and 1 measure. One of the dimensions is a time dimension. I have also used the ADD BI command to get the Year to Date and Year over year % . This works perfectly with the cube. But when I try and create a report I am unable to display the figures for the above mentioned columns. I get Null data there.

Does anybody have any suggestions as to why this is happening and what the way to overcome this.

Thanks in advance
MNJ

Could you provide more information on how you are creating the report and which columns are returning nulls?

Problem in creating reports using BI fields

Hi,

I have created a cube using 3 Dimensions and 1 measure. One of the dimensions is a time dimension. I have also used the ADD BI command to get the Year to Date and Year over year % . This works perfectly with the cube. But when I try and create a report I am unable to display the figures for the above mentioned columns. I get Null data there.

Does anybody have any suggestions as to why this is happening and what the way to overcome this.

Thanks in advance
MNJ

Could you provide more information on how you are creating the report and which columns are returning nulls?

Problem in creating reports using BI fields

Hi,

I have created a cube using 3 Dimensions and 1 measure. One of the dimensions is a time dimension. I have also used the ADD BI command to get the Year to Date and Year over year % . This works perfectly with the cube. But when I try and create a report I am unable to display the figures for the above mentioned columns. I get Null data there.

Does anybody have any suggestions as to why this is happening and what the way to overcome this.

Thanks in advance
MNJ

Could you provide more information on how you are creating the report and which columns are returning nulls?sql

Problem in creating Crystal reports

Hello friends,

I am creating crystal reports, I have used a crystal report viewer, but when i run it , i am asked the database login, I have set the windows NT Integrated security,so what userID and Password i should supply?

Kindly help me outIt should be no UID or PWD.
It should be windows authentication.

Good Luck.

Problem in creating Crystal reports

Hello friends,

I m stuck up with crystal reports. I have used crystal report viewer , but when I run it , i am asked database login , I have used Windows Integrated security what userid and password should I supply

Kindly help me outWhat are you using? Crystal Reports? The Crystal Report viewer in .Net? I'm assuming you are using SQL Server 2000? Need more info.

Erik Roessing

Problem in connecting to SSAS

I'm facing some security when deploying SSAS and reports using Reporting Services. In my environment, I don't understand why I can access the SSAS via the management studio if I don't have the domain administrator right. The support team have granted this right to me for development purpose.
In the connection dialog of Management Studio, I can only choose Server name after I click Connect --> Analysis Services. The authentication type is dimmed out by default. Please gives me some more relevant links to setup properly.
After deployed my cubes and reports, the other user cannot view the reports as they can't access the SSAS database. What should I do? There're so many security setting and I don't know which one I should tune. Thanks in advance.

Hello! You do not need to be an domain adminstrator in order to access Reporting Services and Analysis Services. It is sufficient to be a local administrator on the server running these two applications.

In Reporting Services you have the option to run a report with windows authentication or an assigned account for Reporting Services access to Analysis Services.

If you run with the first option each user need to mapped to a role in Analysis Services which can be done with individual accounts or windows groups. For the second option it is only the Reporting Services(AS2005) account that needs to mapped to a role in Analysis Services.

You can do this both in BIDS, Report Manager or Management Studio.

This is true for a server where both these applications are running. If Reporting Services is on a separate server things are a little bit more complicated. In this case you will have to set up account delegation in Active Directory. The key word for this setup is 'Kerberos' .

HTH

Thomas Ivarsson

|||Can you give me some more detail on the configuration please? Are there any guides available on the web? Thanks!|||

Hello! I have not found any best official practices regarding SSRS2005 and SSAS2005 integration.

My advice is based on customer cases/practises that I have used and some good writing in a reporting services book.

Regards

Thomas Ivarsson

|||http://technet.microsoft.com/en-us/library/ms175386(SQL.90).aspx

This website provides what I needed.

Problem in connecting to SSAS

I'm facing some security when deploying SSAS and reports using Reporting Services. In my environment, I don't understand why I can access the SSAS via the management studio if I don't have the domain administrator right. The support team have granted this right to me for development purpose.
In the connection dialog of Management Studio, I can only choose Server name after I click Connect --> Analysis Services. The authentication type is dimmed out by default. Please gives me some more relevant links to setup properly.
After deployed my cubes and reports, the other user cannot view the reports as they can't access the SSAS database. What should I do? There're so many security setting and I don't know which one I should tune. Thanks in advance.

Hello! You do not need to be an domain adminstrator in order to access Reporting Services and Analysis Services. It is sufficient to be a local administrator on the server running these two applications.

In Reporting Services you have the option to run a report with windows authentication or an assigned account for Reporting Services access to Analysis Services.

If you run with the first option each user need to mapped to a role in Analysis Services which can be done with individual accounts or windows groups. For the second option it is only the Reporting Services(AS2005) account that needs to mapped to a role in Analysis Services.

You can do this both in BIDS, Report Manager or Management Studio.

This is true for a server where both these applications are running. If Reporting Services is on a separate server things are a little bit more complicated. In this case you will have to set up account delegation in Active Directory. The key word for this setup is 'Kerberos' .

HTH

Thomas Ivarsson

|||Can you give me some more detail on the configuration please? Are there any guides available on the web? Thanks!|||

Hello! I have not found any best official practices regarding SSRS2005 and SSAS2005 integration.

My advice is based on customer cases/practises that I have used and some good writing in a reporting services book.

Regards

Thomas Ivarsson

|||http://technet.microsoft.com/en-us/library/ms175386(SQL.90).aspx

This website provides what I needed.sql

Problem getting some users to be able to run reports (probably security of some sort)

I am able to deploy and run reports from my screen at work, but some non-developers cannot run them. They can see the reports, but get the following error message when they click on the report:

An error has occurred during report processing. (rsProcessingAborted)

Cannot create a connection to data source 'DataSource1'. (rsErrorOpeningConnection)

For more information about this error navigate to the report server on the local server machine, or enable remote errors

--

--

- I assume the preceding error has something to do with credentials. I am using Windows security authentication for this. One user has worked through this and is now getting cannot run report query (one of the report queries in the report). Help would be appreciated.

Can you make sure that the users who are having issues can actually connect to the SQL Server & database?

Have you tried running Profiler to see what credentials are actually passed to the SQL Server when the user runs the report?

Jarret

|||What was found was a security issue. I got some DBA help in setting up permissions to login to the database and to grant run permissions on the queries. First access was granted to the database itself, the we had to go into security on the database and setup the user and grant permissions. This resolved the problem.

Problem Exporting to PDF - TRIED EVERYTHING (almost)

OK.. The newest member so go slow with me (normally do male modelling.. ;) )

Anyway. Using Crystal Reports 8.0 and VB6. It "exports" from VB6 to The Crystal Report Viewer 8.5. I then try to use the export button and it will export to RTF and Text BUT not to PDF. It will not export from the Viewer OR the actual program.

I have copied all relevant DLL's into Windows\crystal on the PC. These were u2fpdf.dll, u2ddisk.dll. There is no need to Regsvr32 them as they will not go in anyway.

I have also put them in windows\system32 just for good measure as well as program files/common files/crystal decisions/1.0/bin/*. I have tryed downloading different versions of these DLL's but it has made no difference.

I even installed Adobe Acrobat Writer as I thought this might make a difference but it has not.

ANY HELP would be appreciated as firstly I can't spell... and secondly I don't really know what I am doing.. I'm finishing off someone elses project...

Cheers

KirbanWhich OS are you using? CrViewer requires different dll's to Windows98 and earlier OS's. With XP you must use crxf_pdf.dll instead u2fpdf.dll and be sure to register your exportmodeller.dll after you insert the dll.

In one rare occasion I had to rename crxf_pdf.dll to u2fpdf.dll in order to get the client machine working.

Problem displaying report services in client browsers

Hi all

I'm working on a project where we've developed a number of reports using SQL Reporting Services. Everything works fine on the developer PCs and when they cannect to the reporting services URL they can see all the reports listed and everything works fine. When the testers connect, they can see the basic reporting services homepage with the contents and properties tabs. But when they click on the contents tab nothing is displayed.

The tester pcs are locked down and the user profiles wouldnt have the same access rights as the developers who are all local admins on their PCs.

My question is what would prevent the reports from being listed? Is there an activex control that is possibly being blocked by the local security policy for the tester profiles? If this is the case is there anything that can be pre installed on the client pcs to get around this problem?

Any thoughts or assistance that anyone could provide would be grately approeciated

Thanks

Mark
Make sure that these users have the proper roles assigned for the report server. There is Browser, Content Manager (that can pretty much do everything), Report Builder, My Reports and Publisher. There is also a way to define custom roles if needed. The Report server manager can set up users, groups and role assignments.

Problem Deploying Reports when using SSL

Here is my current setup. I have Report Services sp1 installed on a Windows
2000 machine with SQL Server 2000. We have successfully configured RS to
produce reports over the internet via SSL. The actual viewing of the report
over the internet works great. However, in Visual Studio I receive the
following error when trying to deploy the reports...
"The underlying connection was closed. Could not establish trust
relationship with remote server"
The only work around I have found so far is to modify the
rsreportserver.config file and change secureconnectionlevel= from 2 to 0.
Then I am able to deploy the reports and do not receive this message.
Because SSL is a must, I then have to change the secureconnectionlevel= back
to 2.
Users externally are accessing the report server via
http://FQDN/reportserver. I had gone into the rswebapplication.config file
and changed <ReportServerUrl>http://server/reportserver<ReportServerUrl> to
<ReportServerUrl>http://FQDN/reportserver<ReportServerUrl> but no luck. My
certificate name uses the FQDN as the site name.
My question is why I am not able to deploy my reports when the SSL is turned
on?
I hope this makes sense and I am sure I left something out. Please let me
know your thoughts. Thanks!Sounds like you're hitting the issue in this KB article
http://support.microsoft.com/default.aspx?scid=kb;en-us;823177. Are you
specifying the FQDN in VS when deploying the reports?
--
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Tom" <Tom@.discussions.microsoft.com> wrote in message
news:B42B3849-C5FA-45AB-AEDA-D769D49ED57D@.microsoft.com...
> Here is my current setup. I have Report Services sp1 installed on a
> Windows
> 2000 machine with SQL Server 2000. We have successfully configured RS to
> produce reports over the internet via SSL. The actual viewing of the
> report
> over the internet works great. However, in Visual Studio I receive the
> following error when trying to deploy the reports...
> "The underlying connection was closed. Could not establish trust
> relationship with remote server"
> The only work around I have found so far is to modify the
> rsreportserver.config file and change secureconnectionlevel= from 2 to 0.
> Then I am able to deploy the reports and do not receive this message.
> Because SSL is a must, I then have to change the secureconnectionlevel=> back
> to 2.
> Users externally are accessing the report server via
> http://FQDN/reportserver. I had gone into the rswebapplication.config
> file
> and changed <ReportServerUrl>http://server/reportserver<ReportServerUrl>
> to
> <ReportServerUrl>http://FQDN/reportserver<ReportServerUrl> but no luck.
> My
> certificate name uses the FQDN as the site name.
> My question is why I am not able to deploy my reports when the SSL is
> turned
> on?
> I hope this makes sense and I am sure I left something out. Please let me
> know your thoughts. Thanks!
>

Problem deploying reports from VS.NET with SSL

Hi.
I'm using Reporting services for my company's web site and it worked fine
until I tried to activate SSL : now when I try to deploy new reports from
VS.NET I'm asked to login to https://www.mysite.com/reportserver and no
credentials are accepted.
Debugging from VS.NET I can see a call without SSL (http instead of https),
although I changed http in https everywhere.
Can somebody give me some help ?
ThanksNot sure if this solves your problem, but have you tried running rsconfig?
It would be something like:
rsconfig -c -s https://www.mysite.com -d ReportServer -a Windows -u
domain\username -p password
Pieter van Maasdam
Macaw B.V.
"Moreno" <movendra@.yahoo.com> wrote in message
news:eMXvt6ThEHA.536@.TK2MSFTNGP11.phx.gbl...
> Hi.
> I'm using Reporting services for my company's web site and it worked fine
> until I tried to activate SSL : now when I try to deploy new reports from
> VS.NET I'm asked to login to https://www.mysite.com/reportserver and no
> credentials are accepted.
> Debugging from VS.NET I can see a call without SSL (http instead of
https),
> although I changed http in https everywhere.
> Can somebody give me some help ?
> Thanks
>

Problem deploying reports

Hi,

I have an application that involves 3 components one of which is
Reports.
My system's configuration:
SQL 2000 - Default instance
SQL 2005 - Named instance (Instance1).

I provide the user with an option of selecting the SQL Server instance.
If the user chooses Instance1, then I need to deply the reports in SQL
2005.
The exceptions encountered during installation are logged in the Event
log.
When I do the installation for the in a machine, I always
get the following error in the event log:
Could not connect to the Report Server Database
http://<MachineName>/ReportingServices.asmx.
I tried giving the rs.exe options from commandline. I got an error like:

Error in DetermineReportUrlSecurity().

I don't have the exact error with me now.

Note that I do not get this error when I do the installation in a
machine where both default and named instances are SQL 2005.

Can anyone tell me why this happens?

Thanks,

Sandhya

Are you installing RS2005 on the same machine as RS 2000? If so you should be prompted to do a files only install, is that the case? If it is then I am not sure when you are seeing this error. During configuration? If you could provide the error message and a better description of exactly what you are doing, perhaps I can offer some help.|||

Hi,

I am deploying my reports during the time of installation of my application i.e., throwugh an msi. I deploy the reports using rs.exe command and any error encountered would be logged in event log.

While installing SQL 2005. I selected the option 'Install and configure' for Reporting Services component. I also verified that I am able to browse to the Reports page. So there is no problem with the configuration. Someone had a similar problem which I saw in another forum. There a solution was given as to disable the firewall/create exceptions for report server. But in my system the firewall is already disabled.

I am deploying my reports from the installer by giving the rs.exe command wherein I get the following error:
Could not connect to the Report Server Database
http://<MachineName>/ReportingServices.asmx.

I tried giving the rs.exe from the command line with -t parameter to trace the error.
Folowing is the exact error that I am getting:
Microsoft.ReportingServices.ScriptHost.ScriptHost.DetermineServerUrlSecuri
ty()
at Microsoft.ReportingServices.ScriptHost.ScriptHost.InstanceMain()
at Microsoft.ReportingServices.BaseCmdLine.CommandLineMain(String[] args,
BaseCmdLine instance)

Why do I get this error?

Thanks,
Sandhya

|||

You need to connect to http://machinename/ReportServer/ReportingServices.asmx.

I hope this help.s

|||Hi,
I am connecting to http://machinename/ReportServer/ReportingServices.asmx.
Still I get the error. Any clues as to why I face this problem?
Thanks,
Sandhya|||According to the error the report server does not exist. Does the report server come up if you browse to http://machinename/reportserver? Does http://machinename/reports work?|||

Hi,

For Yukon, the default configuration for the Report page would be:

Default instance - http://<machinename>/reports

Named Instance - http://<machinename>/reports$<InstanceName>

In my case, I have Yukon in the named instance(Instance1). Hence I need to connect to http://<machinename>/reports$Instance1 and I verified that I am able to browse to this page. I get the Reports homepage.

When I browse to http://machinename/reportserver$Instance1, I get the following displayed in the page:

chnshl13423/ReportServer$Instance1 - /

---

---

Microsoft SQL Server Reporting Services Version 9.00.1399.00

So what might be the problem?

Thanks,

Sandhya

|||you should pass in -s http://machinename/reportserver$Instance1 to rs.exe.|||

Hi,

I am already giving the following:

rs.exe -i "C:\Pr\DCMReports For Yukon\DeploymentScript\PublishDCMReports.rss" -s "http://chnshl13423/reportserver$Instance1" -v parentFolder="DCM Reports For Yukon" -v reportLocation="C:\Pr\DCMReports For Yukon\DeploymentScript\PublishDCMReports.rss" -v serverName="chnshl13423\Instance1" -v databaseName="DCMSolution"

Thanks,

Sandhya

|||Any suggestions?|||

Hmm, It looks like you are doing everything that you should be. All the script host does at this point is call the soap method ListSecureMethods, using the ReportService2005.asmx endpoint. Your command looks correct and the server is up and running. I really don't know what would be causing this error.

The only thing I can think of is if the user you are running rs.exe as can not be authenticated with RS or RS is setup to use forms or basic auth. You could try using a different user, or if you are using basic auth, pass in the username and password options.

Problem deploying reports

Hi,

I have an application that involves 3 components one of which is
Reports.
My system's configuration:
SQL 2000 - Default instance
SQL 2005 - Named instance (Instance1).

I provide the user with an option of selecting the SQL Server instance.
If the user chooses Instance1, then I need to deply the reports in SQL
2005.
The exceptions encountered during installation are logged in the Event
log.
When I do the installation for the in a machine, I always
get the following error in the event log:
Could not connect to the Report Server Database
http://<MachineName>/ReportingServices.asmx.
I tried giving the rs.exe options from commandline. I got an error like:

Error in DetermineReportUrlSecurity().

I don't have the exact error with me now.

Note that I do not get this error when I do the installation in a
machine where both default and named instances are SQL 2005.

Can anyone tell me why this happens?

Thanks,

Sandhya

Are you installing RS2005 on the same machine as RS 2000? If so you should be prompted to do a files only install, is that the case? If it is then I am not sure when you are seeing this error. During configuration? If you could provide the error message and a better description of exactly what you are doing, perhaps I can offer some help.|||

Hi,

I am deploying my reports during the time of installation of my application i.e., throwugh an msi. I deploy the reports using rs.exe command and any error encountered would be logged in event log.

While installing SQL 2005. I selected the option 'Install and configure' for Reporting Services component. I also verified that I am able to browse to the Reports page. So there is no problem with the configuration. Someone had a similar problem which I saw in another forum. There a solution was given as to disable the firewall/create exceptions for report server. But in my system the firewall is already disabled.

I am deploying my reports from the installer by giving the rs.exe command wherein I get the following error:
Could not connect to the Report Server Database
http://<MachineName>/ReportingServices.asmx.

I tried giving the rs.exe from the command line with -t parameter to trace the error.
Folowing is the exact error that I am getting:
Microsoft.ReportingServices.ScriptHost.ScriptHost.DetermineServerUrlSecuri
ty()
at Microsoft.ReportingServices.ScriptHost.ScriptHost.InstanceMain()
at Microsoft.ReportingServices.BaseCmdLine.CommandLineMain(String[] args,
BaseCmdLine instance)

Why do I get this error?

Thanks,
Sandhya

|||

You need to connect to http://machinename/ReportServer/ReportingServices.asmx.

I hope this help.s

|||Hi,
I am connecting to http://machinename/ReportServer/ReportingServices.asmx.
Still I get the error. Any clues as to why I face this problem?
Thanks,
Sandhya|||According to the error the report server does not exist. Does the report server come up if you browse to http://machinename/reportserver? Does http://machinename/reports work?|||

Hi,

For Yukon, the default configuration for the Report page would be:

Default instance - http://<machinename>/reports

Named Instance - http://<machinename>/reports$<InstanceName>

In my case, I have Yukon in the named instance(Instance1). Hence I need to connect to http://<machinename>/reports$Instance1 and I verified that I am able to browse to this page. I get the Reports homepage.

When I browse to http://machinename/reportserver$Instance1, I get the following displayed in the page:

chnshl13423/ReportServer$Instance1 - /

---

---

Microsoft SQL Server Reporting Services Version 9.00.1399.00

So what might be the problem?

Thanks,

Sandhya

|||you should pass in -s http://machinename/reportserver$Instance1 to rs.exe.|||

Hi,

I am already giving the following:

rs.exe -i "C:\Pr\DCMReports For Yukon\DeploymentScript\PublishDCMReports.rss" -s "http://chnshl13423/reportserver$Instance1" -v parentFolder="DCM Reports For Yukon" -v reportLocation="C:\Pr\DCMReports For Yukon\DeploymentScript\PublishDCMReports.rss" -v serverName="chnshl13423\Instance1" -v databaseName="DCMSolution"

Thanks,

Sandhya

|||Any suggestions?|||

Hmm, It looks like you are doing everything that you should be. All the script host does at this point is call the soap method ListSecureMethods, using the ReportService2005.asmx endpoint. Your command looks correct and the server is up and running. I really don't know what would be causing this error.

The only thing I can think of is if the user you are running rs.exe as can not be authenticated with RS or RS is setup to use forms or basic auth. You could try using a different user, or if you are using basic auth, pass in the username and password options.

Problem deploying reports

Apologies in advance, newbee to SQL Server and Reporting Services...
Installed Reporting Services in TEST environment (without SSL). I can author
a report, view the data from the data source and preview successfully.
However, I receive the following error message when trying to Deploy a
Solution from within Visual Studio Report Designer..."The underlying
connection was closed: Unable to connect to the remote server."
I can navigate to both the Report Manager and Report Server pages
successfuly using IE. Following the deployment failure the Report Manager
contains the new folder to which I was attempting to deploy the report but
it's empty (no report).
Any help would be appreciated.
Thanks,
Chris.In Report Manager, can you simply click on Upload File? Then you can upload
an RDL file manually.
--
Cheers,
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"Chris W, AgriBank" <ChrisWAgriBank@.discussions.microsoft.com> wrote in
message news:96862E2B-8F7C-422F-8A6E-71C86897BB60@.microsoft.com...
> Apologies in advance, newbee to SQL Server and Reporting Services...
> Installed Reporting Services in TEST environment (without SSL). I can
> author
> a report, view the data from the data source and preview successfully.
> However, I receive the following error message when trying to Deploy a
> Solution from within Visual Studio Report Designer..."The underlying
> connection was closed: Unable to connect to the remote server."
> I can navigate to both the Report Manager and Report Server pages
> successfuly using IE. Following the deployment failure the Report Manager
> contains the new folder to which I was attempting to deploy the report but
> it's empty (no report).
> Any help would be appreciated.
> Thanks,
> Chris.|||hey chris,
i m having the same issue .. are u able to resolve it ..
Please post ur comments if u know the solutions..
Thanks
SR
"Chris W, AgriBank" wrote:
> Apologies in advance, newbee to SQL Server and Reporting Services...
> Installed Reporting Services in TEST environment (without SSL). I can author
> a report, view the data from the data source and preview successfully.
> However, I receive the following error message when trying to Deploy a
> Solution from within Visual Studio Report Designer..."The underlying
> connection was closed: Unable to connect to the remote server."
> I can navigate to both the Report Manager and Report Server pages
> successfuly using IE. Following the deployment failure the Report Manager
> contains the new folder to which I was attempting to deploy the report but
> it's empty (no report).
> Any help would be appreciated.
> Thanks,
> Chris.

problem deploying report - can't connect to server?

Hello,
I am relatively new to reporting services. I was experimenting with some
already developed reports on a workstation and trying to figure out how
things work. The reports run fine, and I can deploy them from the solution
folder where the reports exist.
Then I tried creating my own report in my own solution folder. I was able
to create a basic report with a paramenter and run it in the IDE. But when I
tried to deploy it, I got an error message that the service could not connect
to the server. Is this like asp/aspx where you need a virtual directory or
something like that in IIS? What do I need to do to deploy my test report
from my new solution folder?
Thanks,
RichOK. I figured out how to deploy my report. I had to go to the solution
explorer, right-clicked on the ReportProject name, selected properties and
entered the name of the server machine where ReportServer resides. My report
successfully deployed.
But how can I access my report on the company intranet? Any suggestions
appreciated.
"Rich" wrote:
> Hello,
> I am relatively new to reporting services. I was experimenting with some
> already developed reports on a workstation and trying to figure out how
> things work. The reports run fine, and I can deploy them from the solution
> folder where the reports exist.
> Then I tried creating my own report in my own solution folder. I was able
> to create a basic report with a paramenter and run it in the IDE. But when I
> tried to deploy it, I got an error message that the service could not connect
> to the server. Is this like asp/aspx where you need a virtual directory or
> something like that in IIS? What do I need to do to deploy my test report
> from my new solution folder?
> Thanks,
> Rich|||OK. Figured this one out also. For posterity I share what I did. I went
back to the solution explorer and right-clicked on the Project Name, selected
properties. In the same dialog where I had to change the server name from
localhost to my server's name, apparently, by default, the startItem is set
to Report1.rdl. My report's name was RptTest1.rdl. The startItem has a
dropdown box where RptTest1.rdl was listed, so I selected it. Then I
re-deployed my report and viola! It showed up on IE along with the parameter
box. It ran fine. Yay!
"Rich" wrote:
> OK. I figured out how to deploy my report. I had to go to the solution
> explorer, right-clicked on the ReportProject name, selected properties and
> entered the name of the server machine where ReportServer resides. My report
> successfully deployed.
> But how can I access my report on the company intranet? Any suggestions
> appreciated.
>
> "Rich" wrote:
> > Hello,
> >
> > I am relatively new to reporting services. I was experimenting with some
> > already developed reports on a workstation and trying to figure out how
> > things work. The reports run fine, and I can deploy them from the solution
> > folder where the reports exist.
> >
> > Then I tried creating my own report in my own solution folder. I was able
> > to create a basic report with a paramenter and run it in the IDE. But when I
> > tried to deploy it, I got an error message that the service could not connect
> > to the server. Is this like asp/aspx where you need a virtual directory or
> > something like that in IIS? What do I need to do to deploy my test report
> > from my new solution folder?
> >
> > Thanks,
> > Rich