Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Adam West
Constraint Violating Yak Guru
261 Posts |
 Posted - 2009-09-03 : 10:09:23
|
| I have a situation where the report in Report Manager is working correctly but somehow the version in my Visual Studio project is not. So I am interested in knowing if the Report Manager, keeps the original source member or at the least what the name of the source was when it was uploaded to Report Manager. |
|
|
JCirocco
Constraint Violating Yak Guru
392 Posts |
Posted - 2009-09-03 : 11:55:14
|
| AW, By source are you erfering to the SQL of the data set? Report Manager contains a folder (or folders) where reports are deployed. There are datasources (which describe how to get at the data) and Report definitions (.RDL files with the layout AND the SQL for all data sets embedded within the RDL file) When the user views the repotr, Report Viewer renders the RDL and retrieves the data. Theoretically, the user cannot get at the SQL source unless they have rights to the folders on the server.I hope I answered your question...JonhJohn"The smoke monster is just the Others doing barbecue" |
 |
|
|
Adam West
Constraint Violating Yak Guru
261 Posts |
Posted - 2009-09-03 : 12:01:25
|
| I am referring to the name of the original Report name that got uploaded, the SEU name in AS/400 terms. It's ok now but I would still like to know for the future. |
|
|
|
JCirocco
Constraint Violating Yak Guru
392 Posts |
Posted - 2009-09-03 : 12:17:11
|
There is a log somewhere on the report server side that tracks the deployments. Unfortunately I am contractor here and they did not give me rights to that. (And how did you know I speak /400?  John"The smoke monster is just the Others doing barbecue" |
|
|
|
JCirocco
Constraint Violating Yak Guru
392 Posts |
Posted - 2009-09-03 : 12:29:34
|
| AW, I asked my DB guy here and he said ours are in:C:\Program Files\Microsoft SQL Server\MSSQL.1\Reporting Services\LogFiles and the files are in the format of:ReportServer__mm_dd_yyyy_hh_mm_ss.logI just did a deploy of a single report:In the log it should look similar to:w3wp!library!1!09/03/2009-12:24:51:: Call to CreateReportAction(Feedback - Incident Creation Report, /RepotsFolder, True).My report name was Feedback - Incident Creation ReportDeployed to folder /ReportsFolderJohn"The smoke monster is just the Others doing barbecue" |
|
|
|
Adam West
Constraint Violating Yak Guru
261 Posts |
Posted - 2009-09-03 : 16:37:54
|
| Good to know, thanks John. You mentioned 400 in one of your posts. |
|
|
|
shah429
Yak Posting Veteran
52 Posts |
Posted - 2009-09-04 : 11:19:12
|
| Adam West, if the report in Report Manager is working, then why don't you get that report from Report Manager itself? Am I missing something? |
|
|
|
|
|
|
|
|
Report Manager - does it keep the source