Reports with custom interface

Hello all,
I have been looking at various models and ways to implement a custom
interface for the Reporting Services.
My client wants some kind of a
default website (should be available only in the Intranet)
where he can get
1. an interface with a list of reports.
2. The fields required for the parameters of each report.
3. A submit there should send the params to the RS and the results
should be printed, probably in a frame. I would like to get back the
exact output including all the taskbar items of RS interface.
I have been trying building an ASP.NET webapp or use the reportviewer
control etc. but getting confused.
I am sure someone has done this before. Would like some suggestions on
which is the better option for me and some hints on where to start.
Help will be appreciated very much
Thanks
RaviCheck this site, it should get you started...
http://www.odetocode.com/Articles/128.aspx
--
bs
kingofthegreens.com
"RemoteDeploy" wrote:
> Hello all,
> I have been looking at various models and ways to implement a custom
> interface for the Reporting Services.
> My client wants some kind of a
> default website (should be available only in the Intranet)
> where he can get
> 1. an interface with a list of reports.
> 2. The fields required for the parameters of each report.
> 3. A submit there should send the params to the RS and the results
> should be printed, probably in a frame. I would like to get back the
> exact output including all the taskbar items of RS interface.
> I have been trying building an ASP.NET webapp or use the reportviewer
> control etc. but getting confused.
> I am sure someone has done this before. Would like some suggestions on
> which is the better option for me and some hints on where to start.
> Help will be appreciated very much
> Thanks
> Ravi
>|||Ben,
Thanks for the reply. I have checked that site and created an example
and show that to the client. But they wanted more custom look and feel.
So I am looking at using RS web services interface and I am getting
lost there.
Ravi|||The ReportViewer control is a good place to start. You may need to modify
it a bit to support changing parameters and report links (search this
newsgroup for ReplacementRoot for more info).
You can use the web service interface on a starting page that obtains a list
of reports to put on a web page, and -- it sounds like the way your customer
wants it -- obtains a list of parameters as well. That page can then post
the report and parameters to a report display page with the ReportViewer
control on it, and set the ReportViewer values accordingly there.
--
Cheers,
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"RemoteDeploy" <bofobofo@.yahoo.com> wrote in message
news:1108490439.909791.62940@.g14g2000cwa.googlegroups.com...
> Ben,
> Thanks for the reply. I have checked that site and created an example
> and show that to the client. But they wanted more custom look and feel.
> So I am looking at using RS web services interface and I am getting
> lost there.
> Ravi
>|||hello jeff,
thanks for the advice.
I am trying to use the reportviewer control to publish reports in
another website to provide customised interface.
I am using the example at
http://www.odetocode.com/Articles/128.aspx to try to make it work.
It works fine normal. I get a frame of params and after Submitting i
get the report in another frame.
When I try to hide the paramters frame and send parameters through the
Reportpath property I get the following errors.
When I set a param a value this is the error I get:
An attempt was made to set a report parameter 'param_IdServer' that is
not defined in this report. (rsUnknownReportParameter) Get Online Help
When I dont pass any params but still have the command
rc:Parameters=false& in the URL i get the follow error.
The path of the item '/projectname/reportname,' is not valid. The full
path must be less than 260 characters long, must start with slash;
other restrictions apply. Check the documentation for complete set of
restrictions. (rsInvalidItemPath) Get Online Help
I would like to know where is the problem.
Thanks
Ravi|||Can you provide the full URL that is being passed to the ReportServer? That
might give a clue as to the error. You can munge the server name if you're
concerned about privacy.
--
Cheers,
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"RemoteDeploy" <bofobofo@.yahoo.com> wrote in message
news:1108516594.197188.258640@.g14g2000cwa.googlegroups.com...
> hello jeff,
> thanks for the advice.
> I am trying to use the reportviewer control to publish reports in
> another website to provide customised interface.
> I am using the example at
> http://www.odetocode.com/Articles/128.aspx to try to make it work.
> It works fine normal. I get a frame of params and after Submitting i
> get the report in another frame.
>
> When I try to hide the paramters frame and send parameters through the
> Reportpath property I get the following errors.
>
> When I set a param a value this is the error I get:
>
> An attempt was made to set a report parameter 'param_IdServer' that is
> not defined in this report. (rsUnknownReportParameter) Get Online Help
>
> When I dont pass any params but still have the command
> rc:Parameters=false& in the URL i get the follow error.
>
> The path of the item '/projectname/reportname,' is not valid. The full
> path must be less than 260 characters long, must start with slash;
> other restrictions apply. Check the documentation for complete set of
> restrictions. (rsInvalidItemPath) Get Online Help
>
> I would like to know where is the problem.
>
> Thanks
> Ravi
>|||Hello Jeff,
Thankx for the help. I got it going, but my client doesnt want that
interface.
they dont want any part of the RS interface.
I am figuring out how to implement using the Web Service API.
I am able to print reports with parameters but having issues when there
are images in the reports.
I need to use the RenderStream method to render different streams. But
having a host of issues there.
Thankx
Ravi|||I am back to square one. The customer doesnt want the web service
interface as well. After comparing the pros and cons he wants the
Reportviewer Control.
Here is how its supposed to look.
A frame based page.
Left Frame --> a treeview or a menu like listing of all the reports
Right Frame --> when the user clicks a report I should render the
Reportviewer object for that report.
Now I have some questions of the Reportviewer as well.
1. Can I seperate the params part and the report part into 2 diff
frames ?
Thx
Ravi|||Hello Jeff,
I am using a treeview control from IE web control to provide a
navigation of all reports on the server. My intent is to achieve
scenario where I have the list of reports on the left and click on a
report will open the reportviewer control on the right (i placed inside
a html table).
The problem is i am not able to tie the Url of the treenode to
reportviewer control.
Any ideas on how to achieve this ?
Also any other better way to implement a navigator instead of this
treeview. I have already implemented using the dropdown menu but i want
something that shows all the reports at a time.
Thx
ravi