| Author |
Topic |
|
Adam West
Constraint Violating Yak Guru
261 Posts |
 Posted - 2009-08-24 : 16:40:34
|
| We currently do not have ASp.net templates or any other web templated or tools to develop an important interface for our SSRS reports that I have developed using Visual Studio.My question is, what can we use instead to develop such an interface, and how easy would it be for this, to interact with Reporting Manager where I have the reports? |
|
|
savior faire
Posting Yak Master
194 Posts |
Posted - 2009-08-24 : 17:15:54
|
| Any reason why you are not using http://localhost/Reports ?Talk sense to a fool and he calls you foolish. |
 |
|
|
Adam West
Constraint Violating Yak Guru
261 Posts |
Posted - 2009-08-25 : 09:07:05
|
| SF, we do use Local host but we feel this is not suitable for the end user. We have many customers and want them to run their own reports from a simple web interface. This interface will then interact with the Report manager.Report Manager at least in VS 2005, is not a good choice for the type of users and customers we have, we need something a little flashier and also with a more upfront parameters.I was wondering what other people do. Should we go ahead and purchase the Standard or Professional VS product, just for this interface need, or is there an alternative? |
|
|
|
JCirocco
Constraint Violating Yak Guru
392 Posts |
Posted - 2009-08-25 : 09:32:29
|
| You can try issuing the following HTML code:http://servername/ReportServer?/FolderPathToReports/SubFolders/ReportName |
|
|
|
Adam West
Constraint Violating Yak Guru
261 Posts |
Posted - 2009-08-25 : 09:43:10
|
| Thanks JCirocco, what you are proposing, is that I would write a type of 'user menu' and behind each item it would invoke the http://servername. etc that you posted?In what type of language would this be written taking into account the security needs, that one customer does not see the other customers private and confidential data? |
|
|
|
JCirocco
Constraint Violating Yak Guru
392 Posts |
Posted - 2009-08-25 : 09:57:23
|
| Exactly, We have a canned software app that has a user task bar that changes based upon the context of what the user is doing. It has hyperlinks to the various reports I have written. It should launch the report viewer directly into the report that the HTML pointed to.In our case the our server name is an environment variable based upon if the user is in test or prod. All our reports are currently in a single folder so our path is simple:http:/%svrenv%/ReportServer?/LocalReports/reportname |
|
|
|
Adam West
Constraint Violating Yak Guru
261 Posts |
Posted - 2009-08-25 : 10:52:41
|
| Now you say Report Viewer but I thought I can't have Report Viewer in the VS that we have, i.e. the 'what comes with SQL brand' |
|
|
|
JCirocco
Constraint Violating Yak Guru
392 Posts |
Posted - 2009-08-25 : 11:14:58
|
| Report Viewer is a piece of MS Reporting Services, not Visual StudioJohn"Just don't tell me what I can't do!" |
|
|
|
Adam West
Constraint Violating Yak Guru
261 Posts |
Posted - 2009-08-25 : 11:24:31
|
| I see. Where does this Report viewer piece sit? Can you access it without using Visual Studio? It sounds like yes but how?Our need, is to create a user interface that will take some parameters, and call the appropriate report that sits in REport manager. |
|
|
|
JCirocco
Constraint Violating Yak Guru
392 Posts |
Posted - 2009-08-25 : 14:52:40
|
| Report Viewer is the mechanism that Reporting Services natively delivers reports.Use the http link I posted earlier. Make sure whoever manages reportmanager that you have sufficient authority to browse reports.If your URL that you create has spaces in it and you have issues, try substituting "+" in place of the " "John"The smoke monster is just the Others doing barbecue" |
|
|
|
JCirocco
Constraint Violating Yak Guru
392 Posts |
Posted - 2009-08-25 : 14:57:02
|
| If your server name is:MyReportsAnd you only have one folder level to navigate called:ReportsFolderAnd your report is named:Daily_Sales.rdlThe URL to use is:http://MyReports/ReportServer?/ReportsFolder/DailySalesWhat you get when you do that IS the report viewerJohn"The smoke monster is just the Others doing barbecue" |
|
|
|
|
Creating an interface to Report Manager