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.

 All Forums
 Development Tools
 Reporting Services Development
 Designing reports via a Web interface?

Author  Topic 

urig
Starting Member

3 Posts

Posted - 2005-02-08 : 09:42:39
Hi,

I'm new to MS SQL Reporting Services. Am I correct in understanding that the traditional way to design new reports is via the Visual Studio .net Report Designer?

I would like to have a client design simple reports via a web-based GUI. Can this be done using the "stand-alone" MSSQL Reporting Services software offered by Microsoft?

If not, can anyone point me in the direction of a third-party software product that can let a user design forms via a web-based GUI and integrate them with MSSQL Reporting Services?

Thanks in advance,
Uri Goldstein,
Israel.

jhermiz

3564 Posts

Posted - 2005-02-08 : 22:27:36
create the reports in visual studio .net.




Keeping the web experience alive -- [url]http://www.web-impulse.com[/url]
Imperfection living for perfection --
[url]http://jhermiz.blogspot.com/[/url]
Go to Top of Page

urig
Starting Member

3 Posts

Posted - 2005-02-09 : 03:43:43
I repeat my question - Is there any way for me to create the reports in a web-based GUI?

Visual Studio .net 2003 clearly does not qulaify as a web-based GUI for such purposes.
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2005-02-09 : 12:34:35
There are some 3rd party tools that can do this, but they aren't very cheap. I went to a demo of RS a while back that MS put on and there was a 3rd party vendor that had this functionality. I don't recall the name though. Perhaps googling it would bring up some hits for you.

Also, RS files are just rdl files. You can create your own report via notepad or whatever. It certainly wouldn't be easy though.

Tara
Go to Top of Page

jhermiz

3564 Posts

Posted - 2005-02-09 : 20:36:05
I repeat my answer, use visual studio.net. Some of the tools that are out there (3rd party) do not have a lot of the current functionalities of rs. Why do you need such a "web based tool" anyhow? Whats wrong with creating a report in a client tool. I see no reason why you want a web based gui for such a thing.




Keeping the web experience alive -- [url]http://www.web-impulse.com[/url]
Imperfection living for perfection --
[url]http://jhermiz.blogspot.com/[/url]
Go to Top of Page

jhermiz

3564 Posts

Posted - 2005-02-09 : 20:36:31
I repeat my answer, use visual studio.net. Some of the tools that are out there (3rd party) do not have a lot of the current functionalities of rs. Why do you need such a "web based tool" anyhow? Whats wrong with creating a report in a client tool. I see no reason why you want a web based gui for such a thing.




Keeping the web experience alive -- [url]http://www.web-impulse.com[/url]
Imperfection living for perfection --
[url]http://jhermiz.blogspot.com/[/url]
Go to Top of Page

urig
Starting Member

3 Posts

Posted - 2005-02-10 : 02:29:51
Thanks for the info tduggan and jhermiz.
If I find any third party products worth mentioning I'll list them here.

The reason I need a web-based GUI is that I would like to enable clients to create reports without having to install Visual Studio .net.

Having my clients install VS .net as standalone report designer tool is an overkill. Too expensive, too complex.
Go to Top of Page

jhermiz

3564 Posts

Posted - 2005-02-10 : 16:58:12
You are having clients design reports?

Have fun with that!!!




Keeping the web experience alive -- [url]http://www.web-impulse.com[/url]
Imperfection living for perfection --
[url]http://jhermiz.blogspot.com/[/url]
Go to Top of Page

devKD1
Starting Member

1 Post

Posted - 2005-02-18 : 20:55:22
There is a good sample for ad hoc reporting on the MSDN site. It would require a bit of work in order to include parameters or filtering of data, but it is really quite well done.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/html/AdHocRepSr.asp

Go to Top of Page

GunZ
Starting Member

29 Posts

Posted - 2005-02-20 : 20:47:35
quote:
Originally posted by jhermiz

I repeat my answer, use visual studio.net. Some of the tools that are out there (3rd party) do not have a lot of the current functionalities of rs. Why do you need such a "web based tool" anyhow? Whats wrong with creating a report in a client tool. I see no reason why you want a web based gui for such a thing.

2x



Maybe because RS has not implemented listboxes yet. I have a report that requires list boxes to be passed as part of the parameter for the report which urged me to post this [url]http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=46153[/url].

Australia.NSW.Sydney.GunZ
Go to Top of Page
   

- Advertisement -