programmatically set the paper size and and paper layout

how can i set the paper size and paper layout programmatically in RS. im using c#.net as prog. lang. for this. Pls help thanks!

Use the SOAP API SetProperties to modify the PageHeight and PageWidth of the report.

http://msdn2.microsoft.com/en-us/library/microsoft.wssux.reportingserviceswebservice.rsmanagementservice2005.reportingservice2005.setproperties.aspx

|||

In addition, you may want to read these two articles:
* http://blogs.msdn.com/bwelcker/archive/2005/09/28/474898.aspx
* http://blogs.msdn.com/bwelcker/archive/2005/09/07/461758.aspx

-- Robert

|||iam using RS 2000. is this SOAP API SetProperties is available in this version? thanks
|||Yes, the code shown in this article should work for RS 2000: http://blogs.msdn.com/bwelcker/archive/2005/09/07/461758.aspx

-- Robert

|||http://blogs.msdn.com/bryanke/articles/71491.aspx , in this article ive seen Creating a Reference to the Web service, what is the use of the web service? im confused. im doing a window application and in order to view the reporting services reports i used the web browser control to display my reports. i just navigate the said report and pass the needed information in the url (reportserver) example: webbrowser.navigate(URL)
and in my reportserver i dont have web service just reports and the data source. ur help would be much appreciated! thanks..
|||With the Webservice you can communicate with the server and get informaion about reports and could do management jobs such as creating subscriptions. you could also render a report thru the SOAP-Webservice.
Its similar to a database-connection (if you are more familar with db-connections).
With the SOAP-Connection you don't need to call URLs, you could make a web-reference in any type of VS-Project and then use it like a reference to a dll..
Here's some more MS-stuff to read..
http://msdn2.microsoft.com/en-us/library/ms152787(SQL.90).aspx

|||are the link you've given also works in rs 2000?
thank you! :)
|||

So what namespaces must be imported to use this code.

Thank you,

Brian

|||

I cannot get beyond this line:

rs.Credentials = System.Net.CredentialCache.DefaultCredentials

I get a soap exception everytime stating that the user does not have the permissions to perform the task. Any thoughts on where and what I need to edit to get this working?

Thank you.

programmatically set the paper size and and paper layout

how can i set the paper size and paper layout programmatically in RS. im using c#.net as prog. lang. for this. Pls help thanks!

Use the SOAP API SetProperties to modify the PageHeight and PageWidth of the report.

http://msdn2.microsoft.com/en-us/library/microsoft.wssux.reportingserviceswebservice.rsmanagementservice2005.reportingservice2005.setproperties.aspx

|||

In addition, you may want to read these two articles:
* http://blogs.msdn.com/bwelcker/archive/2005/09/28/474898.aspx
* http://blogs.msdn.com/bwelcker/archive/2005/09/07/461758.aspx

-- Robert

|||iam using RS 2000. is this SOAP API SetProperties is available in this version? thanks
|||Yes, the code shown in this article should work for RS 2000: http://blogs.msdn.com/bwelcker/archive/2005/09/07/461758.aspx

-- Robert

|||http://blogs.msdn.com/bryanke/articles/71491.aspx , in this article ive seen Creating a Reference to the Web service, what is the use of the web service? im confused. im doing a window application and in order to view the reporting services reports i used the web browser control to display my reports. i just navigate the said report and pass the needed information in the url (reportserver) example: webbrowser.navigate(URL)
and in my reportserver i dont have web service just reports and the data source. ur help would be much appreciated! thanks..
|||With the Webservice you can communicate with the server and get informaion about reports and could do management jobs such as creating subscriptions. you could also render a report thru the SOAP-Webservice.
Its similar to a database-connection (if you are more familar with db-connections).
With the SOAP-Connection you don't need to call URLs, you could make a web-reference in any type of VS-Project and then use it like a reference to a dll..
Here's some more MS-stuff to read..
http://msdn2.microsoft.com/en-us/library/ms152787(SQL.90).aspx

|||are the link you've given also works in rs 2000?
thank you! :)
|||

So what namespaces must be imported to use this code.

Thank you,

Brian

|||

I cannot get beyond this line:

rs.Credentials = System.Net.CredentialCache.DefaultCredentials

I get a soap exception everytime stating that the user does not have the permissions to perform the task. Any thoughts on where and what I need to edit to get this working?

Thank you.

Programmability of parameter bar(layout/items)?

Hi all,

does anybody of you know how to code and customize the parameter bar of the
SSRS reports? I know about putting code behind expressions but how is it with
parameters?

How is it possible to...
1. define the layout of the parameter bar and the positions of the parameter
items?
2. make the parameter items user-specific?

Is it possible to define a report with the report designer and hand over
data (parameters) by code-behind or a referenced assembly?

Thanks a lot for any help

Best Regards
Marc

Unfortunately, you can't do either of these things. (#1, #2, or the "hand-over" of parameter selection via Report Designer).

If the parameter selection needs to be as dynamic as you describe, the best solution is to actually build your own custom UI in which you display the appropriate parameter UI in the appropriate places to the appropriate users...Then take the values that get selected and pass them to the report via URL Access, or plug them into the ReportViewer with code, andrender the report in the viewer. www.gotreportviewer.com has samples of the latter.

Hope this helps!

|||

Hey Russell,

that's not really good news...but thanks a lot for your help anyway..i'm going to try the solution with passing parameters by code into the ReportViewer control.

Cheers
Marc

|||

Hi Marc,

I have a similar problem. Could you please explain how you were able to solve this problem.

Thanks a lot for your help.

Regards,

Simranjeev

|||You need to query the web service to find out which parameters a report has, their data types and values etc. then programatically populate dropdowns etc. and arrange them how you like in your custom UI. You can use either a web or a windows UI for this.|||

Thanks ... Can i find some article / sample code somewhere on how to build custom UI and use it as the Parameter Area in Reporting Services

Programmability of parameter bar(layout/items)?

Hi all,

does anybody of you know how to code and customize the parameter bar of the
SSRS reports? I know about putting code behind expressions but how is it with
parameters?

How is it possible to...
1. define the layout of the parameter bar and the positions of the parameter
items?
2. make the parameter items user-specific?

Is it possible to define a report with the report designer and hand over
data (parameters) by code-behind or a referenced assembly?

Thanks a lot for any help

Best Regards
Marc

Unfortunately, you can't do either of these things. (#1, #2, or the "hand-over" of parameter selection via Report Designer).

If the parameter selection needs to be as dynamic as you describe, the best solution is to actually build your own custom UI in which you display the appropriate parameter UI in the appropriate places to the appropriate users...Then take the values that get selected and pass them to the report via URL Access, or plug them into the ReportViewer with code, andrender the report in the viewer. www.gotreportviewer.com has samples of the latter.

Hope this helps!

|||

Hey Russell,

that's not really good news...but thanks a lot for your help anyway..i'm going to try the solution with passing parameters by code into the ReportViewer control.

Cheers
Marc

|||

Hi Marc,

I have a similar problem. Could you please explain how you were able to solve this problem.

Thanks a lot for your help.

Regards,

Simranjeev

|||You need to query the web service to find out which parameters a report has, their data types and values etc. then programatically populate dropdowns etc. and arrange them how you like in your custom UI. You can use either a web or a windows UI for this.|||

Thanks ... Can i find some article / sample code somewhere on how to build custom UI and use it as the Parameter Area in Reporting Services

Programmability of parameter bar(layout/items)?

Hi all,
does anybody of you know how to code and customize the parameter bar of the
SSRS reports? I know about putting code behind expressions but how is it with
parameters?
How is it possible to...
1. define the layout of the parameter bar and the positions of the parameter
items?
2. make the parameter items user-specific?
Is it possible to define a report with the report designer and hand over
data (parameters) by code-behind or a referenced assembly?
Thanks a lot for any help
Best Regards
MarcI don't know if this is the right way but I turned off the parameter bar and
added the following code
Dim parm As New
Microsoft.Reporting.WebForms.ReportParameter("week",
DrpWeeks.SelectedValue.ToString)
Dim p() As Microsoft.Reporting.WebForms.ReportParameter = {parm}
ReportViewer1.ServerReport.SetParameters(p)
DrpWeeks is a drop down box populated just as I would have if I had
populated it in the report designer.
User specific is by grabbing user!userid
"MarcBey" wrote:
> Hi all,
> does anybody of you know how to code and customize the parameter bar of the
> SSRS reports? I know about putting code behind expressions but how is it with
> parameters?
> How is it possible to...
> 1. define the layout of the parameter bar and the positions of the parameter
> items?
> 2. make the parameter items user-specific?
> Is it possible to define a report with the report designer and hand over
> data (parameters) by code-behind or a referenced assembly?
> Thanks a lot for any help
> Best Regards
> Marc
>
>