Reporting Services Add In

Hey all,

still trying to fix my issue of that when i try and install the reportsin services addin, that it is not completeing.

The log file is as follows:

User: SYSTEM

Installing Report Server Feature.

SSRSCustomActionError: Sharepoint is installed, but not configured.

My setup is as follows:

MOSS 2007 installed on a box by itself

Virtual Directories are located in E:\ instead of C:

Sharepoint 07 is up and running all OK. 70 Users connecting

Have checked farm admins and site collection admins. User dsadmin is there (same user that i am installing the client with)

Reporting Server is a SQL server on a different machine. Has been working fine with existing sharepoint 2003 installation.

Does anyone have any ideas at all? Im going nuts trying to work this out..

Thanks in advance

Scotty

for anyone who runs into the same problem ,check that the installing user, and the local system and NT AUTHORITY users have access to your SQL DB. This was my problem.

Scotty

Reporting Services 2005 - CSV - ASCII - ￡(Pound symbol)

Hi

We are having problems getting Reporting Services 2005 to export to an ASCII CSV file and correctly produce a ￡(GBP sign).

I have changed my report server .config file to read:

<Extension Name="CSV1" Type="Microsoft.ReportingServices.Rendering.CsvRenderer.CsvReport,Microsoft.ReportingServices.CsvRendering">
<OverrideNames>
<Name Language="en-UK">CSV - UTF-8</Name>
</OverrideNames>
<Configuration>
<DeviceInfo>
<Encoding>UTF-8</Encoding>
</DeviceInfo>
</Configuration>
</Extension>
<Extension Name="CSV2" Type="Microsoft.ReportingServices.Rendering.CsvRenderer.CsvReport,Microsoft.ReportingServices.CsvRendering">
<OverrideNames>
<Name Language="en-UK">CSV - UTF-7</Name>
</OverrideNames>
<Configuration>
<DeviceInfo>
<Encoding>UTF-7</Encoding>
</DeviceInfo>
</Configuration>
</Extension>
<Extension Name="CSV3" Type="Microsoft.ReportingServices.Rendering.CsvRenderer.CsvReport,Microsoft.ReportingServices.CsvRendering">
<OverrideNames>
<Name Language="en-UK">CSV - ASCII</Name>
</OverrideNames>
<Configuration>
<DeviceInfo>
<Encoding>ASCII</Encoding>
</DeviceInfo>
</Configuration>
</Extension>

And so far so good I get the three options to export to,

If I Export using the ASCII Rendering my pound signs come out as question marks (?) and subsequently loads into Excel as a general data type and is not sum-able.

If I Export using UTF-8 Rendering my pound signs come out as a weird character followed by a pound sign, again opened in excel loads as a General data type and is not summable.

If I export using UNICODE rendering, by file sizes are doublesd as you would expect, and then when you open in excel it is all bunched up in column 1, both un-acceptable.

Interestingly enough If I take the UTF-8 file I have and convert it to ASCII using Ultraedit, notepad or wordpad, everything works fine, the ￡ is correctly encoded, Excel loads it OK and it is summable, result, but I can not use get my end users to perform this "kludge" for an export.

Any help would be appreciated

Thanks

Tim

Hi Tim,

Excel, for some reason, has a problem opening comma separated files with Unicode encoding. This is why you are seeing all of the columns smashed together. In order to get Excel to properly open a Unicode file you should switch to using a tab delimiter. Unfortunately due to a product issue, tab delimiters are not settable in the server configuration file. They are settable when rendering using the URL. Example:

http://server/reportserver/?/myreport&rs:Command=Render&rs:Format=CSV&rc:FieldDelimiter=%09

As for the pound symbol being interpreted as text, I find that if I switch my machine to a en-UK locale this works fine. I can repro your issue when my machine is en-US. Can you verify this?

Thanks,
Chris

|||

Thanks for the pointers here.

Unicode is not ideal for us due the doubling of file size, and we are not using the URL method of rendering so tab delimited is out.

So on to your other comments, I have been trying all morning to make it not produce a ? (question mark)

1. The Local of the machine is definately en-UK, this is the only loaded local
2. The language property of the report in Report designer was set to English (United States), thought I had found it : )

But this changed to English(United Kingdom) re-deployed IIS reset and re-run, exactly the same ? instead of ￡ when exporting to ASCII, and odd character then ￡ in UTF-8

Out of interest the way we have forced the display of the ￡ symbol is using the Format property in report designer setting it to : ￡#,##0.00;(￡#,##0.00)

I am interested how you have managed to re-create by changing the locale ?

Thanks for your help

Tim

Reporting Services 2000 does not deliver attach documents by e-mail.

Hello,
I'm currently working in some reports(Reporting Services 2000)
that have to be send (e-mail subscription) like XLS or CVS file to
the internal users, but the e-mails have not been received by any user
with the attached documents.
However the other mails subscriptions including Link to the report or
Web archive are delivered by e-mail to the user without any problem.
I'll really appreciate, if somebody can help me.
Regards,
DinaTry the reporting services newsgroup.
"Dina" <Dcardonne@.gmail.com> wrote in message
news:1133975322.524633.318050@.g47g2000cwa.googlegroups.com...
> Hello,
> I'm currently working in some reports(Reporting Services 2000)
> that have to be send (e-mail subscription) like XLS or CVS file to
> the internal users, but the e-mails have not been received by any user
> with the attached documents.
> However the other mails subscriptions including Link to the report or
> Web archive are delivered by e-mail to the user without any problem.
> I'll really appreciate, if somebody can help me.
> Regards,
> Dina
>

Reporting services

Hi
I would like to know how to create a file programatically(VB) in the
reporting services folder, so that it can be accessed from the report
manager.Do you mean create an RDL file? You can find a walk through
on this in books online. An RDL file is just XML so you can
use the XMLTextWriterClass. Check the books online topic:
Generating Report Definition Language Programmatically
and the tutorial:
Tutorial: Generating RDL Using the .NET Framework
-Sue
On 20 Sep 2006 10:44:07 -0700, vishnu.nallamothu@.gmail.com
wrote:

>Hi
> I would like to know how to create a file programatically(VB) in the
>reporting services folder, so that it can be accessed from the report
>manager.

Reporting services

Hi
I would like to know how to create a file programatically(VB) in the
reporting services folder, so that it can be accessed from the report
manager.Do you mean create an RDL file? You can find a walk through
on this in books online. An RDL file is just XML so you can
use the XMLTextWriterClass. Check the books online topic:
Generating Report Definition Language Programmatically
and the tutorial:
Tutorial: Generating RDL Using the .NET Framework
-Sue
On 20 Sep 2006 10:44:07 -0700, vishnu.nallamothu@.gmail.com
wrote:
>Hi
> I would like to know how to create a file programatically(VB) in the
>reporting services folder, so that it can be accessed from the report
>manager.

Reporting services

Hi
I would like to know how to create a file programatically(VB) in the
reporting services folder, so that it can be accessed from the report
manager.
Do you mean create an RDL file? You can find a walk through
on this in books online. An RDL file is just XML so you can
use the XMLTextWriterClass. Check the books online topic:
Generating Report Definition Language Programmatically
and the tutorial:
Tutorial: Generating RDL Using the .NET Framework
-Sue
On 20 Sep 2006 10:44:07 -0700, vishnu.nallamothu@.gmail.com
wrote:

>Hi
> I would like to know how to create a file programatically(VB) in the
>reporting services folder, so that it can be accessed from the report
>manager.

Reporting Service Subscriptions E-mail Configuration

Hello Group,
I am trying to set up a e-mail rendered Standard subscription in Report
Server.
I have edited the RSReportServer.config file according to BOL.
Can anyone give me an example of a working SMTP E-mail enabled config.
Thanks,
Heres the error I recieve in My Subscriptions. I am included in the RS
System Admin role.
"Failure sending mail: The server rejected the sender address. The server
response was: 505 Authentication required"
--
Application Engineer / DBA
UCLA SOMYou will need to grant the report server service account permission to send
e-mail to your SMTP server.
-Lukasz
This posting is provided "AS IS" with no warranties, and confers no rights.
"Marcial" <no_spam@.antispammer.com> wrote in message
news:1257729F-CE95-4F69-9134-F9DB8A5B59C7@.microsoft.com...
> Hello Group,
> I am trying to set up a e-mail rendered Standard subscription in Report
> Server.
> I have edited the RSReportServer.config file according to BOL.
> Can anyone give me an example of a working SMTP E-mail enabled config.
> Thanks,
> Heres the error I recieve in My Subscriptions. I am included in the RS
> System Admin role.
> "Failure sending mail: The server rejected the sender address. The server
> response was: 505 Authentication required"
>
> --
> Application Engineer / DBA
> UCLA SOM

Reporting service install fail

Hello I get the following in the a log file when I install RS, any ideas wha
t the problem is.
<Header><Product>Microsoft SQL Server Reporting Services Version 8.00.743.00
</Product><Locale>en-US</Locale><TimeZone>GMT Daylight Time</TimeZone><Path>
C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\LogFiles\Repo
rtServerService__main_05_07
_2004_16_00_31.log</Path><SystemName>PSLDEV-UT01</SystemName><OSName>Microso
ft Windows NT 5.0.2195.0</OSName><OSVersion>5.0.2195.0</OSVersion></Header>
ReportingServicesService!library!ad0!07/05/2004-16:00:32:: i INFO: Initializ
ing ConnectionType to '0' as specified in Configuration file.
ReportingServicesService!library!ad0!07/05/2004-16:00:32:: i INFO: Initializ
ing IsSchedulingService to 'True' as specified in Configuration file.
ReportingServicesService!library!ad0!07/05/2004-16:00:32:: i INFO: Initializ
ing IsNotificationService to 'True' as specified in Configuration file.
ReportingServicesService!library!ad0!07/05/2004-16:00:32:: i INFO: Initializ
ing IsEventService to 'True' as specified in Configuration file.
ReportingServicesService!library!ad0!07/05/2004-16:00:32:: i INFO: Initializ
ing PollingInterval to '10' second(s) as specified in Configuration file.
ReportingServicesService!library!ad0!07/05/2004-16:00:32:: i INFO: Initializ
ing MemoryLimit to '60' percent as specified in Configuration file.
ReportingServicesService!library!ad0!07/05/2004-16:00:32:: i INFO: Initializ
ing RecycleTime to '720' minute(s) as specified in Configuration file.
ReportingServicesService!library!ad0!07/05/2004-16:00:32:: i INFO: Initializ
ing MaximumMemoryLimit to '80' percent as specified in Configuration file.
ReportingServicesService!library!ad0!07/05/2004-16:00:32:: i INFO: Initializ
ing MaxAppDomainUnloadTime to '30' minute(s) as specified in Configuration f
ile.
ReportingServicesService!library!ad0!07/05/2004-16:00:32:: i INFO: Initializ
ing MaxQueueThreads to '0' thread(s) as specified in Configuration file.
ReportingServicesService!library!ad0!07/05/2004-16:00:32:: i INFO: Initializ
ing MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration
file.
ReportingServicesService!library!ad0!07/05/2004-16:00:32:: i INFO: Initializ
ing MaxScheduleWait to '5' second(s) as specified in Configuration file.
ReportingServicesService!library!ad0!07/05/2004-16:00:32:: i INFO: Initializ
ing DatabaseQueryTimeout to '120' second(s) as specified in Configuration fi
le.
ReportingServicesService!library!ad0!07/05/2004-16:00:32:: i INFO: Initializ
ing InstanceName to 'MSSQLSERVER' as specified in Configuration file.
ReportingServicesService!library!ad0!07/05/2004-16:00:32:: i INFO: Initializ
ing ProcessRecycleOptions to '0' as specified in Configuration file.
ReportingServicesService!library!ad0!07/05/2004-16:00:32:: i INFO: Initializ
ing RunningRequestsScavengerCycle to '60' second(s) as specified in Configur
ation file.
ReportingServicesService!library!ad0!07/05/2004-16:00:32:: i INFO: Initializ
ing RunningRequestsDbCycle to '60' second(s) as specified in Configuration f
ile.
ReportingServicesService!library!ad0!07/05/2004-16:00:32:: i INFO: Initializ
ing RunningRequestsAge to '30' second(s) as specified in Configuration file.
ReportingServicesService!library!ad0!07/05/2004-16:00:32:: i INFO: Initializ
ing CleanupCycleMinutes to '10' minute(s) as specified in Configuration file
.
ReportingServicesService!library!ad0!07/05/2004-16:00:32:: i INFO: Initializ
ing SecureConnectionLevel to '0' as specified in Configuration file.
ReportingServicesService!library!ad0!07/05/2004-16:00:32:: i INFO: Initializ
ing DisplayErrorLink to 'True' as specified in Configuration file.
ReportingServicesService!resourceutiliti
es!ad0!07/05/2004-16:00:34:: i INFO:
Reporting Services starting SKU: Developer
ReportingServicesService!servicecontroll
er!ae4!07/05/2004-16:00:34:: Total P
hysical memory: 402112512
ReportingServicesService!servicecontroll
er!ad0!07/05/2004-16:00:35:: i INFO:
RPC Server started
ReportingServicesService!servicecontroll
er!a5c!07/05/2004-16:00:36:: i INFO:
RPC Server stopped
ReportingServicesService!servicecontroll
er!ae4!07/05/2004-16:00:37:: Service
Maintenance thread caught an exception, restarting Service Maintenance thre
ad. Error Message System.AppDomainUnloadedException: The target application
domain has been unloaded.
Server stack trace:
at System.Threading.Thread.EnterContextInternal(Context ctx, Int32 id, Int32
appDomainID, ContextTransitionFrame& frame)
at System.Runtime.Remoting.Channels.CrossAppDomainSink.DoTransitionDispatch(
Byte[] reqStmBuff, SmuggledMethodCallMessage smuggledMcm, SmuggledMethod
ReturnMessage& smuggledMrm)
at System.Runtime.Remoting.Channels.CrossAppDomainSink.SyncProcessMessage(IM
essage reqMsg)
Exception rethrown at [0]:
at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage re
qMsg, IMessage retMsg)
at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgD
ata, Int32 type)
at Microsoft.ReportingServices.Library.AppDomainProxy.get_IsPollingWorking()
at Microsoft.ReportingServices.Library.ServiceAppDomainController.ServiceMai
ntenance().
ReportingServicesService!servicecontroll
er!a5c!07/05/2004-16:00:41:: Service
shutting down.Hello,
If I understand your problem correctly this is a reporting service issue.
This is beyond the scope of the datawarehouse and would be best handled by
the reportingsvcs group. If you would, please post this question in the
reportingsvcs newsgroup microsoft.public.sqlserver.reportingsvcs. The
reportingsvcs newsgroup is primarily for issues involving reporting
services. The reason why we recommend posting appropriately is you will get
the most qualified pool of respondents, and other partners who read the
newsgroups regularly can either share their knowledge or learn from your
interaction with us.
Regards,
Michael Shao
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.

Reporting service install fail

Hello I get the following in the a log file when I install RS, any ideas what the problem is.
<Header><Product>Microsoft SQL Server Reporting Services Version 8.00.743.00</Product><Locale>en-US</Locale><TimeZone>GMT Daylight Time</TimeZone><Path>C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\LogFiles\ReportServerService__main_05_07
_2004_16_00_31.log</Path><SystemName>PSLDEV-UT01</SystemName><OSName>Microsoft Windows NT 5.0.2195.0</OSName><OSVersion>5.0.2195.0</OSVersion></Header>
ReportingServicesService!library!ad0!07/05/2004-16:00:32:: i INFO: Initializing ConnectionType to '0' as specified in Configuration file.
ReportingServicesService!library!ad0!07/05/2004-16:00:32:: i INFO: Initializing IsSchedulingService to 'True' as specified in Configuration file.
ReportingServicesService!library!ad0!07/05/2004-16:00:32:: i INFO: Initializing IsNotificationService to 'True' as specified in Configuration file.
ReportingServicesService!library!ad0!07/05/2004-16:00:32:: i INFO: Initializing IsEventService to 'True' as specified in Configuration file.
ReportingServicesService!library!ad0!07/05/2004-16:00:32:: i INFO: Initializing PollingInterval to '10' second(s) as specified in Configuration file.
ReportingServicesService!library!ad0!07/05/2004-16:00:32:: i INFO: Initializing MemoryLimit to '60' percent as specified in Configuration file.
ReportingServicesService!library!ad0!07/05/2004-16:00:32:: i INFO: Initializing RecycleTime to '720' minute(s) as specified in Configuration file.
ReportingServicesService!library!ad0!07/05/2004-16:00:32:: i INFO: Initializing MaximumMemoryLimit to '80' percent as specified in Configuration file.
ReportingServicesService!library!ad0!07/05/2004-16:00:32:: i INFO: Initializing MaxAppDomainUnloadTime to '30' minute(s) as specified in Configuration file.
ReportingServicesService!library!ad0!07/05/2004-16:00:32:: i INFO: Initializing MaxQueueThreads to '0' thread(s) as specified in Configuration file.
ReportingServicesService!library!ad0!07/05/2004-16:00:32:: i INFO: Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration file.
ReportingServicesService!library!ad0!07/05/2004-16:00:32:: i INFO: Initializing MaxScheduleWait to '5' second(s) as specified in Configuration file.
ReportingServicesService!library!ad0!07/05/2004-16:00:32:: i INFO: Initializing DatabaseQueryTimeout to '120' second(s) as specified in Configuration file.
ReportingServicesService!library!ad0!07/05/2004-16:00:32:: i INFO: Initializing InstanceName to 'MSSQLSERVER' as specified in Configuration file.
ReportingServicesService!library!ad0!07/05/2004-16:00:32:: i INFO: Initializing ProcessRecycleOptions to '0' as specified in Configuration file.
ReportingServicesService!library!ad0!07/05/2004-16:00:32:: i INFO: Initializing RunningRequestsScavengerCycle to '60' second(s) as specified in Configuration file.
ReportingServicesService!library!ad0!07/05/2004-16:00:32:: i INFO: Initializing RunningRequestsDbCycle to '60' second(s) as specified in Configuration file.
ReportingServicesService!library!ad0!07/05/2004-16:00:32:: i INFO: Initializing RunningRequestsAge to '30' second(s) as specified in Configuration file.
ReportingServicesService!library!ad0!07/05/2004-16:00:32:: i INFO: Initializing CleanupCycleMinutes to '10' minute(s) as specified in Configuration file.
ReportingServicesService!library!ad0!07/05/2004-16:00:32:: i INFO: Initializing SecureConnectionLevel to '0' as specified in Configuration file.
ReportingServicesService!library!ad0!07/05/2004-16:00:32:: i INFO: Initializing DisplayErrorLink to 'True' as specified in Configuration file.
ReportingServicesService!resourceutilities!ad0!07/05/2004-16:00:34:: i INFO: Reporting Services starting SKU: Developer
ReportingServicesService!servicecontroller!ae4!07/05/2004-16:00:34:: Total Physical memory: 402112512
ReportingServicesService!servicecontroller!ad0!07/05/2004-16:00:35:: i INFO: RPC Server started
ReportingServicesService!servicecontroller!a5c!07/05/2004-16:00:36:: i INFO: RPC Server stopped
ReportingServicesService!servicecontroller!ae4!07/05/2004-16:00:37:: Service Maintenance thread caught an exception, restarting Service Maintenance thread. Error Message System.AppDomainUnloadedException: The target application domain has been unloaded.
Server stack trace:
at System.Threading.Thread.EnterContextInternal(Conte xt ctx, Int32 id, Int32 appDomainID, ContextTransitionFrame& frame)
at System.Runtime.Remoting.Channels.CrossAppDomainSin k.DoTransitionDispatch(Byte[] reqStmBuff, SmuggledMethodCallMessage smuggledMcm, SmuggledMethodReturnMessage& smuggledMrm)
at System.Runtime.Remoting.Channels.CrossAppDomainSin k.SyncProcessMessage(IMessage reqMsg)
Exception rethrown at [0]:
at System.Runtime.Remoting.Proxies.RealProxy.HandleRe turnMessage(IMessage reqMsg, IMessage retMsg)
at System.Runtime.Remoting.Proxies.RealProxy.PrivateI nvoke(MessageData& msgData, Int32 type)
at Microsoft.ReportingServices.Library.AppDomainProxy .get_IsPollingWorking()
at Microsoft.ReportingServices.Library.ServiceAppDoma inController.ServiceMaintenance().
ReportingServicesService!servicecontroller!a5c!07/05/2004-16:00:41:: Service shutting down.
Hello,
If I understand your problem correctly this is a reporting service issue.
This is beyond the scope of the datawarehouse and would be best handled by
the reportingsvcs group. If you would, please post this question in the
reportingsvcs newsgroup microsoft.public.sqlserver.reportingsvcs. The
reportingsvcs newsgroup is primarily for issues involving reporting
services. The reason why we recommend posting appropriately is you will get
the most qualified pool of respondents, and other partners who read the
newsgroups regularly can either share their knowledge or learn from your
interaction with us.
Regards,
Michael Shao
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.

Reporting Service for Oracle

From where can i find latest reporting service installation file for Oracle?? Did it is compulsory to install SQL Server for reporting though I am using Oracle.

Hi, milindsaraswala:

As for as i know, there is a Report module in the ORACLE database. As you are using oracle to store your information, why not using the oracle reports.

If you want to use the SSRS and use the oracle database as one datssource, i suppose you have to install the instance of the SQL SERVER.

How to use Reporting Services to configure and to access an Oracle data source

http://support.microsoft.com/kb/834305

Tap into Oracle Databases with SQL Server Reporting Services

http://www.developer.com/db/article.php/3524781

Reporting service 400 bad request error

I have my reporting services installed on a Windows 2003 server. I have my Http://localhost/RepsortServer file directory opens fine.

However, I get this error when I try to access http://localhost/Reports.

Error

The request failed with HTTP status 400: Bad Request. Home

HELP

Any red X shows up when you open the configuration tool? Do you reportserver and reports vdirs live in the same application pool?

Try to recreate the report manager virtual directory using the configuration tool.

Reporting Service 2005, Custom Security Extension failed.

Hi,

I am trying the get the custom security extension samples to work on my machine. I have installed everything according the sameple help file. However, i am getting a "Authentication Ticket is not issued by LogonUser." error after I attempted to log on to the report manager thru UILogon.aspx page. I already created an admin user. Upon a closer inspection, I realized that the authentication went thru okay, however, the authentication Ticket Name contained in the "RSAuthenticationHeader" has a duplicate value of "sqlauthticket, sqlauthticket". So apparently, the report server added this value twice to the response header. Has anyone seen this error before? How would you fix it? Also to bypass this error, I parsed out the header and take the correct auth ticket name, now report manager just redisplays the logon page and not letting me thru. Has anyone have seen that before? I am running in Win 2003 server, IIS 6, .NET 2.0 and SQL server 2005 enterprise version.

Thanks for the help,

Eric

Hi EriC!

Did you ever get an answer to your question? I have exactly the same isse.

Best,

Dmitri

Reporting Service 2005, Custom Security Extension failed.

Hi,

I am trying the get the custom security extension samples to work on my machine. I have installed everything according the sameple help file. However, i am getting a "Authentication Ticket is not issued by LogonUser." error after I attempted to log on to the report manager thru UILogon.aspx page. I already created an admin user. Upon a closer inspection, I realized that the authentication went thru okay, however, the authentication Ticket Name contained in the "RSAuthenticationHeader" has a duplicate value of "sqlauthticket, sqlauthticket". So apparently, the report server added this value twice to the response header. Has anyone seen this error before? How would you fix it? Also to bypass this error, I parsed out the header and take the correct auth ticket name, now report manager just redisplays the logon page and not letting me thru. Has anyone have seen that before? I am running in Win 2003 server, IIS 6, .NET 2.0 and SQL server 2005 enterprise version.

Thanks for the help,

Eric

Hi EriC!

Did you ever get an answer to your question? I have exactly the same isse.

Best,

Dmitri

Reporting Service 2005

Hi All,
I create rdlc Reports VS 2005. Now I can convert into rdl format for
Reporting Server 2005 same file How ?
thanks,
Harshad
Hi
All you need to do is rename the file see http://tinyurl.com/3ae7kl for more
John
"harshad" wrote:

> Hi All,
> I create rdlc Reports VS 2005. Now I can convert into rdl format for
> Reporting Server 2005 same file How ?
> thanks,
> Harshad
>

Reporting Service 2005

Hi All,
I create rdlc Reports VS 2005. Now I can convert into rdl format for
Reporting Server 2005 same file How ?
thanks,
HarshadHi
All you need to do is rename the file see http://tinyurl.com/3ae7kl for more
John
"harshad" wrote:
> Hi All,
> I create rdlc Reports VS 2005. Now I can convert into rdl format for
> Reporting Server 2005 same file How ?
> thanks,
> Harshad
>

Reporting Server Rendering

Hi Everyone,

Let me first tell u guys/gals what i hve done till now. I've created a Report Server and created a TestReport.rdl file in it. This report is bound to a DataSet. Now i want to ask few qusetions:

First, Is it possible to call this report from another Project (Web) so that it could be rendered directly to ReportViewer without having to specify a DataSource ? I mean, i wouldn't have to specify the ReportDataSource again since it's already specified when i created that report.

Second, can the same functionality be specified for .rdlc (client file) ?

Till now i've worked out this code:

<code>

rptView.ProcessingMode =ProcessingMode.Remote;

rptView.ServerReport.ReportServerUrl =newUri("http://localhost/Tutorial/");

rptView.ServerReport.ReportPath ="Report2";

</code>

but this doesn't seem to work and keeps on giving me this error:

The attempt to connect to the report server failed. Check your connection information and that the report server is a compatible version.The request failed with HTTP status 404: Not Found.

Any points in the right direction will be greatly appreciated. TIA

ok i figured out part of the problem, it was happening because Report Server wasn't configured properly. But now it says "Report requires an Active Database Connection" but when i try to configure the database through Reporting Service Manager i get the error:

Using Other editions of SQL Server for report Data Source and/or the reprot Server Database is not supported.

not sure wat that means but i'm lookng into it.

Any help will b appreciated. TIA