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 |
|
gnorro
Starting Member
3 Posts |
 Posted - 2008-06-24 : 05:57:09
|
| Hi everybodyI'm trying to understand the report service in order to use it instead of crystal reportI read the guide to create datasource, report, etc...but now I have some questions.Why is not possible to create a report model from the report web application (http://localhost/reports)?I had to create it from BI dev studio.is it possible to pass a query directly to the report? I need to create something that gives the possibility to select some filters and then view the results. In order to do this now I create a webform with the search results, and then, when I click on a button I populate a temporary table with those results and then I open the report. But I don't think this is the best solution...last question:I create a report (.rdl) and then from my c# web application I added the web reference in order to use report service. I had to specify the virtual url, user, pwd. When I publish this report on a production server, what I'll have to do in order to make it works? I think I have to change the web reference if the server name or ip changes...and to do that do I have to modify my c# solution and recreate the web reference or can I simply change those information in some config files?thanks |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-06-24 : 22:55:53
|
| >> Why is not possible to create a report model from the report web application (http://localhost/reports)?RS web app is for report access, distribution and management, it's not design tool. |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-06-25 : 02:08:53
|
quote:
Originally posted by gnorro
Hi everybodyI'm trying to understand the report service in order to use it instead of crystal reportI read the guide to create datasource, report, etc...but now I have some questions.Why is not possible to create a report model from the report web application (http://localhost/reports)?I had to create it from BI dev studio.is it possible to pass a query directly to the report? I need to create something that gives the possibility to select some filters and then view the results. In order to do this now I create a webform with the search results, and then, when I click on a button I populate a temporary table with those results and then I open the report. But I don't think this is the best solution...last question:I create a report (.rdl) and then from my c# web application I added the web reference in order to use report service. I had to specify the virtual url, user, pwd. When I publish this report on a production server, what I'll have to do in order to make it works? I think I have to change the web reference if the server name or ip changes...and to do that do I have to modify my c# solution and recreate the web reference or can I simply change those information in some config files?thanks
You can give source of your report as a query with parameters and it will automatically generate parameters for you. You can select appropriate values to parameters and rendere the report. |
|
|
|
|
|
|
|
|
Some questions about report service