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

Reporting Server Project 2005 - xml datasource - Querying the data

The way I create the report is I use VS2005 to create the RDL programmatically on the fly. The problem is querying the data when I use XML as a data source (changing the data source is not an option).

I can connect to the XML data source, I enter a basic query in the data tab in VS 2005 and what happens is for some reason or another the above element in XML gets concatenated onto the column name in the result set.

So what I have to do is manually modify the RDL file to accept the new names and then the report works. There has to be a way to not have this happens. Any advice on where I can find information on how to do this would be greatly appreciated. Examples are always welcome.

See below for an example of what I did and an example of the XML data.

XML File Example:
<data>
<Table>
<iss_id>Test Data1</issu_id>
<issue_nm>Test Data1</issue_nm>
</Table>
<Table>
<iss_id>Test Data2</issu_id>
<issue_nm>Test Data2</issue_nm>
</Table>
<data>

XML Query: (I enter this in the data tab in VS 2005)
data/Table

Result:

Table_iss_id Table_issue_nm <--Column Headers
Test Data1 Test Data1
Test Data2 Test Data2

I think it has to do with the webservice web method, and how it needs to be set-up for serializing the parameters correctly to work with the XML data Source. I am having a similar problem which I am documenting here

http://forums.microsoft.com/MSDN/User/MyForums.aspx?SiteID=1

J. C.