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 |
|
CoachGBT
Starting Member
6 Posts |
 Posted - 2014-10-09 : 12:24:45
|
| My knowledge is limited with SSRS, but my question is rather simple. I'm trying to locate a report that's generated from the following url; http://mpdnetdw1/ReportServer/Pages/ReportViewer.aspx?%2fBudget_Entry_2015%2fBudgeted_BudgetEntryFull.When I open url http://mpdnetdw1/ReportServer, it provides a directory list resembling <dir> Budget_Entry_2015 but I'm unable to get to that directory physically. How can I get to the directory to open report name Budgeted_BudgetEntryFull?Your assistance is greatly appreciated if you understand my question.Thanks! |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2014-10-09 : 12:31:17
|
| It's not an actual directory. It is stored inside the RS database. The rdl file gets sucked into the database. You should be able to export the report to an rdl file and then open that file in your report writer.Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
 |
|
|
CoachGBT
Starting Member
6 Posts |
Posted - 2014-10-09 : 13:04:58
|
| I understand what you're saying up to ReportViewer.aspx. Now the ?%2f following report viewer(I don't understand). I do kknow Budget_Entry_2015%2fBudgeted_BudgetEntryFull (is the path) Budget_Entry_2015/Budgeted_BudgetEntryFull, but to what is where my confusion starts and end.You stated the .rdl gets sucked into the database, but where? That's what I need to know is the where? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2014-10-09 : 13:08:00
|
| Let's start over. What are you trying to do? Are you just trying to run the report or make modifications to it?Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
|
|
|
CoachGBT
Starting Member
6 Posts |
Posted - 2014-10-09 : 13:12:36
|
| Make modifications to the report |
|
|
|
CoachGBT
Starting Member
6 Posts |
Posted - 2014-10-09 : 13:14:35
|
| But I'm unable to find the report to make changes |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2014-10-09 : 13:47:07
|
| There is no file as it's inside the database. You can use Report Manager to export the report to a file so that you can work on it. Connect to this to get to Report Manager: http://mpdnetdw1/ReportsExport it to an rdl file. Then work on the report by loading the rdl file into your report writer, which I think would be Business Intelligence Studio or Visual Studio. It's been a while since I've worked on RS reports.Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
|
|
|
CoachGBT
Starting Member
6 Posts |
Posted - 2014-10-09 : 13:59:19
|
| Thank You So Much! Changes made, report format data corrected. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
Reporting Services Directory
Tara Kizer