Location of Report Files on Server

Does anyone know which directory contains the report (.rdl) files on the SQL
Server Reporting Services server? I'd like to access these files on the
server.
Thank you.There are no rdl files on the server. The process of deploying causes the
rdl to be stored in the database. If you need to retrieve the rdl that was
deployed you can do to report manager, click on the report, properties, edit
and give it a file name to put the rdl into.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Brian P" <BrianP@.discussions.microsoft.com> wrote in message
news:606DD94C-C004-4E30-BD72-DDBB0056C908@.microsoft.com...
> Does anyone know which directory contains the report (.rdl) files on the
> SQL
> Server Reporting Services server? I'd like to access these files on the
> server.
> Thank you.|||Bruce,
Understood. Thanks for the reply.
Brian
"Bruce L-C [MVP]" wrote:
> There are no rdl files on the server. The process of deploying causes the
> rdl to be stored in the database. If you need to retrieve the rdl that was
> deployed you can do to report manager, click on the report, properties, edit
> and give it a file name to put the rdl into.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Brian P" <BrianP@.discussions.microsoft.com> wrote in message
> news:606DD94C-C004-4E30-BD72-DDBB0056C908@.microsoft.com...
> > Does anyone know which directory contains the report (.rdl) files on the
> > SQL
> > Server Reporting Services server? I'd like to access these files on the
> > server.
> >
> > Thank you.
>
>

Location of RDL files?

I'm unable to deploy using Visual Studio and would like to upload my files
manually. I've searched the web server for the existing files and can't find
them. I also searched books online. Any ideas?
ThanksNo rdl files exist on the server. They are all stored in the database.
Deploying a report is more than the report being copied over. To deploy from
outside of VS requires using scripting. Search Books Online for the work
scripting and then open up the samples link.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Leslie" <Leslie@.discussions.microsoft.com> wrote in message
news:58086A07-F1DD-40BE-B0D5-80D3F34891A8@.microsoft.com...
> I'm unable to deploy using Visual Studio and would like to upload my files
> manually. I've searched the web server for the existing files and can't
> find
> them. I also searched books online. Any ideas?
> Thanks|||Thanks for the response. I ftp'd the files over to my server and then
uploaded them using the Report Manager. A little easier than using scripting.
"Bruce L-C [MVP]" wrote:
> No rdl files exist on the server. They are all stored in the database.
> Deploying a report is more than the report being copied over. To deploy from
> outside of VS requires using scripting. Search Books Online for the work
> scripting and then open up the samples link.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Leslie" <Leslie@.discussions.microsoft.com> wrote in message
> news:58086A07-F1DD-40BE-B0D5-80D3F34891A8@.microsoft.com...
> > I'm unable to deploy using Visual Studio and would like to upload my files
> > manually. I've searched the web server for the existing files and can't
> > find
> > them. I also searched books online. Any ideas?
> >
> > Thanks
>
>|||Just an FYI, you can also use the Report Manager to retrieve the rdl if you
ever need to.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Leslie" <Leslie@.discussions.microsoft.com> wrote in message
news:434F327E-9286-47BA-8B6E-6DB079E58461@.microsoft.com...
> Thanks for the response. I ftp'd the files over to my server and then
> uploaded them using the Report Manager. A little easier than using
> scripting.
> "Bruce L-C [MVP]" wrote:
>> No rdl files exist on the server. They are all stored in the database.
>> Deploying a report is more than the report being copied over. To deploy
>> from
>> outside of VS requires using scripting. Search Books Online for the work
>> scripting and then open up the samples link.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Leslie" <Leslie@.discussions.microsoft.com> wrote in message
>> news:58086A07-F1DD-40BE-B0D5-80D3F34891A8@.microsoft.com...
>> > I'm unable to deploy using Visual Studio and would like to upload my
>> > files
>> > manually. I've searched the web server for the existing files and can't
>> > find
>> > them. I also searched books online. Any ideas?
>> >
>> > Thanks
>>

location of rdl files on server

Hi there ,
I am working on SSRS and I just wanted to know where
are the .rdl file stored on the server.I came along this problem as i
was searching a way to make the report content dynamic rather make the
report content customizable .I just wanted to know is there a way to
change rdl files to make them customizable.
thanks.AFAIK, the files are not stored anywhere. When you upload a report, the definition (contents of the
RDL file) is inserted into one or more tables in the report database. I'm not RS expert, though, so
you might want to verify this in an RS forum.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"unixbf" <bondfranco@.gmail.com> wrote in message
news:d2323315-9f7f-44a1-9d32-49795ad3efc2@.v46g2000hsv.googlegroups.com...
> Hi there ,
> I am working on SSRS and I just wanted to know where
> are the .rdl file stored on the server.I came along this problem as i
> was searching a way to make the report content dynamic rather make the
> report content customizable .I just wanted to know is there a way to
> change rdl files to make them customizable.
> thanks.|||Tibor Karaszi wrote:
> AFAIK, the files are not stored anywhere. When you upload a report, the definition (contents of the
> RDL file) is inserted into one or more tables in the report database. I'm not RS expert, though, so
> you might want to verify this in an RS forum.
>
true!

location of rdl files on report server

Hi there ,
I am working on SSRS and I just wanted to know where
are the .rdl file stored on the server.I came along this problem as i
was searching a way to make the report content dynamic rather make the
report content customizable .I just wanted to know is there a way to
change rdl files to make them customizable.
thanks.RDL files are not stored as files on the server. They are stored in the
database. Essentially you have to redeploy the rdl file which you can do by
using webservices. However, you cannot do this for a specific user.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"unixbf" <bondfranco@.gmail.com> wrote in message
news:448b5c16-8146-48b0-a412-8e38d873955d@.v67g2000hse.googlegroups.com...
> Hi there ,
> I am working on SSRS and I just wanted to know where
> are the .rdl file stored on the server.I came along this problem as i
> was searching a way to make the report content dynamic rather make the
> report content customizable .I just wanted to know is there a way to
> change rdl files to make them customizable.
> thanks.

Location of deployed rdl file on the ReportingServer

Hi all,
I have a reporting server on which My rdl files are deployed from my
development machine.
Can any one tell me where is the physical location of those rdl files on
the reporting server where the files get deployed.
I did a search for rdl files on the Reportingserver but I could not found any.
Also is it possible to add a .rdl file from the ReportServer machine to my
VS.NET project IDE on a remote development machine
Any suggestions will be highly appreciated.
Thanks in advance,
siajThe RDL files are stored in the report server database. They are not stored
on disk.
-Lukasz
This posting is provided "AS IS" with no warranties, and confers no rights.
"siaj" <siaj@.discussions.microsoft.com> wrote in message
news:DABA9613-D421-4F10-AE66-5BB0D46BFBCD@.microsoft.com...
> Hi all,
> I have a reporting server on which My rdl files are deployed from my
> development machine.
> Can any one tell me where is the physical location of those rdl files on
> the reporting server where the files get deployed.
> I did a search for rdl files on the Reportingserver but I could not found
> any.
> Also is it possible to add a .rdl file from the ReportServer machine to my
> VS.NET project IDE on a remote development machine
> Any suggestions will be highly appreciated.
> Thanks in advance,
> siaj|||On Mon, 24 Jan 2005 15:13:02 -0800, "siaj"
<siaj@.discussions.microsoft.com> wrote:
>Hi all,
>I have a reporting server on which My rdl files are deployed from my
>development machine.
>Can any one tell me where is the physical location of those rdl files on
>the reporting server where the files get deployed.
>I did a search for rdl files on the Reportingserver but I could not found any.
>Also is it possible to add a .rdl file from the ReportServer machine to my
>VS.NET project IDE on a remote development machine
>Any suggestions will be highly appreciated.
>Thanks in advance,
>siaj
The deployed reports are stored in the RS database (default name -
ReportServer), not in physical files. The table name is "Catalog".
If you need to change a deployed report, you can download it from the
Report Server web page and use it in your VS project. Open the list of
reports (http://<servername>/Reports/Pages/Folder.aspx), click "Show
Details" on the toolbar. Now click the Edit icon preceeding the report
you need, this will open the properties page for the report. There are
2 links under "Report Definition": Edit and Update. "Edit" downloads
the RDL file for you, and "Update" allows you to upload the file back.|||Thanks Lukasz/Usenet
siaj
"Usenet User" wrote:
> On Mon, 24 Jan 2005 15:13:02 -0800, "siaj"
> <siaj@.discussions.microsoft.com> wrote:
> >Hi all,
> >I have a reporting server on which My rdl files are deployed from my
> >development machine.
> >Can any one tell me where is the physical location of those rdl files on
> >the reporting server where the files get deployed.
> >I did a search for rdl files on the Reportingserver but I could not found any.
> >
> >Also is it possible to add a .rdl file from the ReportServer machine to my
> >VS.NET project IDE on a remote development machine
> >
> >Any suggestions will be highly appreciated.
> >
> >Thanks in advance,
> >siaj
>
> The deployed reports are stored in the RS database (default name -
> ReportServer), not in physical files. The table name is "Catalog".
> If you need to change a deployed report, you can download it from the
> Report Server web page and use it in your VS project. Open the list of
> reports (http://<servername>/Reports/Pages/Folder.aspx), click "Show
> Details" on the toolbar. Now click the Edit icon preceeding the report
> you need, this will open the properties page for the report. There are
> 2 links under "Report Definition": Edit and Update. "Edit" downloads
> the RDL file for you, and "Update" allows you to upload the file back.
>

LocalReportService2005.ReportingService2005 class?

Last month, on 8/15, in the "Using RDL as a data source for documenting
reports?" thread, Wei Lu posted some sample C# code. I am trying to use it
as a basis for a small app I'm writing, but I can't seem to find the right
library or DLL to use the LocalReportService2005.ReportingService2005 class.
Can someone point me in the right direction?
Thx,
RipleyNever mind. As usual, as soon as I post the question, I find the answer
myself. ;-)
Rip
"Ripley" <ripley@.ihatespam.com> wrote in message
news:%23a2QGBr0GHA.4476@.TK2MSFTNGP05.phx.gbl...
> Last month, on 8/15, in the "Using RDL as a data source for documenting
> reports?" thread, Wei Lu posted some sample C# code. I am trying to use it
> as a basis for a small app I'm writing, but I can't seem to find the right
> library or DLL to use the LocalReportService2005.ReportingService2005
> class.
> Can someone point me in the right direction?
> Thx,
> Ripley
>

Localization of Reports

Are there any plans to improve the process of localizing reports? for example, it would be nice to extend the RDL schema to include a section for resource strings and localization information.

Thanks

This is very high on our wish list. Unfortunately, it will most likely not make it in Katmai.

|||

Hi Brian,

Sorry to hear that we won't see this functionality in Katmai. Should we start a campaign and try to get it into Katmai J?

Given we have to deal with this reality for a while, what is the best approach to localize reports. We know about the recommendation in http://msdn2.microsoft.com/en-us/library/ms156493.aspx and http://technet.microsoft.com/en-us/library/aa964130.aspx.

We have 100’s of reports and we don’t want to make sacrifice performance, if possible.

Thanks

Local Report Processing mode

Hi,
We have a scenario where we want to test the <a href> url generated
by parsing the <Hyperlink> element present in the rdl file
This check needs to be done without deploying the rdl file on the
report server. So we are planning to use Local processing mode of the
report view control.
I wanted to ask on whether there are any differences between the
conversion of <Hyperlink> element to <a href> when checked in local
processing mode and when checked in remote processing mode (i.e when
the conversion is done by report server by using reporting server web
services).
Thanks in advancewhat do you mean by "test the <a href>?
do you want to validate that the URL works fine before deploying the report?
the local processing mode of the report viewer can't use an RDL file. you
have to convert it to RDLC. but you also have to execute the query in your
code.
the report viewer just render the report and can't execute the query
statements.
but...
you can validate the hyperlink objects in the RDL file
directly, if the hyperlink is hardcoded. (you can simply use the XML
Document object model to do this)
another option is to publish the report in report server, then execute the
report by code and retrieve the URLS generated in the HTML content to
validate them.
hope this will help you.
"Amit" <amits.84@.gmail.com> wrote in message
news:1182624675.249537.176170@.x35g2000prf.googlegroups.com...
> Hi,
> We have a scenario where we want to test the <a href> url generated
> by parsing the <Hyperlink> element present in the rdl file
> This check needs to be done without deploying the rdl file on the
> report server. So we are planning to use Local processing mode of the
> report view control.
> I wanted to ask on whether there are any differences between the
> conversion of <Hyperlink> element to <a href> when checked in local
> processing mode and when checked in remote processing mode (i.e when
> the conversion is done by report server by using reporting server web
> services).
> Thanks in advance
>|||Thanks for the reply.
I want to validate 2 things with the Hyperlink element which would
contain complex expressions and calls to custom assemblies.
1. Whether the rdl file deploys correctly
2. Whether the url generated is right
This needs to be done without any interaction with the report server.
Hence we wanted to try out local report processing mode. Can you
please guide whether I will be able to validate the above mentioned
scenarios using local processing mode ?
For validating the second scenario I would need to generate an event
of clicking the hyperlink. Is that possible in local report processing
mode ?
I will convert the rdl file to rdlc file. As only <Hyperlink>
scenarios needs to be test I would create a rdl file which contains
only <Hyperlink> element. Renaming this rdl file to rdlc would work as
the schema for both are same. right ?
On Jun 24, 2:33 am, "Jeje" <willg...@.hotmail.com> wrote:
> what do you mean by "test the <a href>?
> do you want to validate that the URL works fine before deploying thereport?
> thelocalprocessingmodeof thereportviewer can't use an RDL file. you
> have to convert it to RDLC. but you also have to execute the query in your
> code.
> thereportviewer just render thereportand can't execute the query
> statements.
> but...
> you can validate the hyperlink objects in the RDL file
> directly, if the hyperlink is hardcoded. (you can simply use the XML
> Document object model to do this)
> another option is to publish thereportinreportserver, then execute thereportby code and retrieve the URLS generated in the HTML content to
> validate them.
> hope this will help you.
> "Amit" <amits...@.gmail.com> wrote in message
> news:1182624675.249537.176170@.x35g2000prf.googlegroups.com...
> > Hi,
> > We have a scenario where we want to test the <a href> url generated
> > by parsing the <Hyperlink> element present in the rdl file
> > This check needs to be done without deploying the rdl file on the
> >reportserver. So we are planning to useLocalprocessingmodeof the
> >reportview control.
> > I wanted to ask on whether there are any differences between the
> > conversion of <Hyperlink> element to <a href> when checked inlocal
> >processingmodeand when checked in remoteprocessingmode(i.e when
> > the conversion is done byreportserver by using reporting server web
> > services).
> > Thanks in advance|||All the above testing scenarios should be done programmatically.
On Jun 24, 6:47 pm, Amit <amits...@.gmail.com> wrote:
> Thanks for the reply.
> I want to validate 2 things with the Hyperlink element which would
> contain complex expressions and calls to custom assemblies.
> 1. Whether the rdl file deploys correctly
> 2. Whether the url generated is right
> This needs to be done without any interaction with thereportserver.
> Hence we wanted to try outlocalreportprocessingmode. Can you
> please guide whether I will be able to validate the above mentioned
> scenarios usinglocalprocessingmode?
> For validating the second scenario I would need to generate an event
> of clicking the hyperlink. Is that possible inlocalreportprocessingmode?
> I will convert the rdl file to rdlc file. As only <Hyperlink>
> scenarios needs to be test I would create a rdl file which contains
> only <Hyperlink> element. Renaming this rdl file to rdlc would work as
> the schema for both are same. right ?
> On Jun 24, 2:33 am, "Jeje" <willg...@.hotmail.com> wrote:
> > what do you mean by "test the <a href>?
> > do you want to validate that the URL works fine before deploying thereport?
> > thelocalprocessingmodeof thereportviewer can't use an RDL file. you
> > have to convert it to RDLC. but you also have to execute the query in your
> > code.
> > thereportviewer just render thereportand can't execute the query
> > statements.
> > but...
> > you can validate the hyperlink objects in the RDL file
> > directly, if the hyperlink is hardcoded. (you can simply use the XML
> > Document object model to do this)
> > another option is to publish thereportinreportserver, then execute thereportby code and retrieve the URLS generated in the HTML content to
> > validate them.
> > hope this will help you.
> > "Amit" <amits...@.gmail.com> wrote in message
> >news:1182624675.249537.176170@.x35g2000prf.googlegroups.com...
> > > Hi,
> > > We have a scenario where we want to test the <a href> url generated
> > > by parsing the <Hyperlink> element present in the rdl file
> > > This check needs to be done without deploying the rdl file on the
> > >reportserver. So we are planning to useLocalprocessingmodeof the
> > >reportview control.
> > > I wanted to ask on whether there are any differences between the
> > > conversion of <Hyperlink> element to <a href> when checked inlocal
> > >processingmodeand when checked in remoteprocessingmode(i.e when
> > > the conversion is done byreportserver by using reporting server web
> > > services).
> > > Thanks in advance|||converting an RDL file to RDLC + code based dataset execution could be
possible, but complicated regarding your development constraints.
also, testing a report should be done 1 time only, after this you can't test
all the cases (I mean you can't test all the possible resultsets coming from
the database)
So, I recommend to spread your code in 2:
1. predeploy testing
2. deploy
the step 1 can be done by deploying the report in a test report server or an
hidden folder in RS. when you publish a report the publish process returns
the warnings and other errors found in the report. (so you can stop the
process here if there is warning, and if there is errors the report is not
deployed)
When this step pass the deployment, you can now execute the report a first
time and scan the resulting HTML content by code.
so you can retrieve all the <a href statements and verify by code if these
links works fine (using the webrequest object in .NET)
and finally, remove the tested report from report server.
now the report is approved for deployment and can be added in your
deployment process.
converting an RDL report to RDLC can be complex because you have to extract
the SQL queries and connections from the report, create and populate a
dataset on the fly and execute the report on the fly. what's appends if
there is parameters?
you can't simulate a direct "click" event on an hyperlink in any scenario.
you can just extract and test the generated HTML content.
but can you explain who creates the reports and how?
because Visual Studio can validate the deployment himself and can "compile"
the report to identify warnings and errors.
also, can you explain how the hyperlinks are created in the reports?
does it's hardcoded (fixed) links? or does the links come from a database?
or does the links is a formula result? (a concatenation of something like:
"http://myserver/myfolder/mypage.aspx?id=" & Datasetfield.Value)
Jerome.
"Amit" <amits.84@.gmail.com> wrote in message
news:1182692843.900480.295280@.e16g2000pri.googlegroups.com...
> Thanks for the reply.
> I want to validate 2 things with the Hyperlink element which would
> contain complex expressions and calls to custom assemblies.
> 1. Whether the rdl file deploys correctly
> 2. Whether the url generated is right
> This needs to be done without any interaction with the report server.
> Hence we wanted to try out local report processing mode. Can you
> please guide whether I will be able to validate the above mentioned
> scenarios using local processing mode ?
> For validating the second scenario I would need to generate an event
> of clicking the hyperlink. Is that possible in local report processing
> mode ?
> I will convert the rdl file to rdlc file. As only <Hyperlink>
> scenarios needs to be test I would create a rdl file which contains
> only <Hyperlink> element. Renaming this rdl file to rdlc would work as
> the schema for both are same. right ?
> On Jun 24, 2:33 am, "Jeje" <willg...@.hotmail.com> wrote:
>> what do you mean by "test the <a href>?
>> do you want to validate that the URL works fine before deploying
>> thereport?
>> thelocalprocessingmodeof thereportviewer can't use an RDL file. you
>> have to convert it to RDLC. but you also have to execute the query in
>> your
>> code.
>> thereportviewer just render thereportand can't execute the query
>> statements.
>> but...
>> you can validate the hyperlink objects in the RDL file
>> directly, if the hyperlink is hardcoded. (you can simply use the XML
>> Document object model to do this)
>> another option is to publish thereportinreportserver, then execute
>> thereportby code and retrieve the URLS generated in the HTML content to
>> validate them.
>> hope this will help you.
>> "Amit" <amits...@.gmail.com> wrote in message
>> news:1182624675.249537.176170@.x35g2000prf.googlegroups.com...
>> > Hi,
>> > We have a scenario where we want to test the <a href> url generated
>> > by parsing the <Hyperlink> element present in the rdl file
>> > This check needs to be done without deploying the rdl file on the
>> >reportserver. So we are planning to useLocalprocessingmodeof the
>> >reportview control.
>> > I wanted to ask on whether there are any differences between the
>> > conversion of <Hyperlink> element to <a href> when checked inlocal
>> >processingmodeand when checked in remoteprocessingmode(i.e when
>> > the conversion is done byreportserver by using reporting server web
>> > services).
>> > Thanks in advance
>