all groups > sql server reporting services > february 2005 >
You're in the

sql server reporting services

group:

problems with ReportViewer Control: Not accepting parameters


problems with ReportViewer Control: Not accepting parameters RemoteDeploy
2/15/2005 5:13:16 PM
sql server reporting services:
Hello all,

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
Re: problems with ReportViewer Control: Not accepting parameters TechnoSpyke
2/17/2005 8:55:03 AM
I'm also trying to use the ReportViewer control, to some success.

Assuming you are passing parameters through code, you can use the
SetQueryParameter(), which is the same as the Ode To Code example.
Remember, if it is not a report parameter, always include the prefix (i.e.
rc, rs). Without these prefixes, the parameters are treated as report
parameters and you get the rsUnknownReportParameter error.

SetParameter("rc:Parameters","false");
SetParameter("rc:DocMap","false");
SetParameter("rc:LinkTarget","_top");

The rsInvalidItemPath error is usually due to some invalid characters on the
URL string. Try removing the "amp;" on your url.

Hope this helps.

Marlon

[quoted text, click to view]

Re: problems with ReportViewer Control: Not accepting parameters RemoteDeploy
2/18/2005 10:11:54 AM
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
Re: problems with ReportViewer Control: Not accepting parameters TechnoSpyke
2/19/2005 10:06:51 AM
You might find these examples helpful.

http://msdn.microsoft.com/msdnmag/issues/04/08/SQLServerReportingServices/default.aspx
http://odetocode.com/Articles/95.aspx

Marlon

[quoted text, click to view]

Re: problems with ReportViewer Control: Not accepting parameters RemoteDeploy
2/21/2005 2:37:46 PM
hey TechnoSpyke,

thanks for the links. They helped me a lot.

Ravi
AddThis Social Bookmark Button