How to simulate Nothing from a deep link

Hello-

I'm working on an app that will create an HTTP connection to the SSRS server to gather a PDF generated by SSRS and place it on the LAN. looks something like this :

http://server/ReportServer?%2fDEV%2frpt_Sheet&rs%3aCommand=Render&rc:Toolbar=false&userID=NULL&StoreID=23&rs:Format=PDF

We have a few reports where 1 or more parameters can be null, but I'm having one heck of a time trying get this to work with a null value. Does anyone know what value is actually passed to SSRS when a parameter is NULL?

I have tried Nothing, but to no avail.

Thanks in adavance,

Tristan

Do not include that parameter in the link and set its default value as null or send something like this:

parameter name = "param1"

&param1%3aisnull=True

http://reportserver/?%2fReport1Test&param1%3aisnull=True&rs%3aParameterLanguage=&rc%3aParameters=Collapsed

Maciej

How to Setup Schedule On SSRS on Time Basis?

Hi All,

I am new to SSRS. I subscribe my report through report subscription. I want to schedule my report from 9 AM to 17:30 PM. I setup start time but I am not able to schedule to stop at 17:30 on daily basis.

Please help me ....

Thank you in advance....

Regards,

Balwant Patel.

I don't think this level of flexibility is supported. I'd use the FireEvent API to kick off the schedule programatically.|||

Hi Teo,

I have no idea about FireEvent...I will look on FireEvent but the time being..i schedule the same report twice.

sql

How to set up security to SQL 2005 Reporting Service?

I have Sql 2005 server (SSAS, SSRS, Database)installed on my workstation running on Windows XP Pro. SP2 for development only. However I need to migrate the reports to a "Production" enviroment next month which is set up with two servers running on Windows 2003 Server, one will serve as Data Server with Sql 2005 server and SSAS installed on it and the other will serve as Report Server with Sql 2005 Reporting Service. My question is how to set up the IIS on the Report Server to allow users from the domain to access the Report Manager (the reporting Service is intend to set up as an "Intranet" tool for the users ie No Internet access to the reports). A "dumpy" user will be set up at the Report Server for the data connection to the remote Sql 2005 Server. Also how to implement the security on the individual folder in the Report Manager. Currently I have folders set up for the department and I want to set up security only allow people from those depts to access their folder/subfolders. How to set up security on folder and subfolders in Report Manager? Can I set the security on my Windows XP machine to test it before I roll it out to the Production servers? Thanks.

here is a microsoft link that talks about role based security in reporting services...

http://msdn2.microsoft.com/en-us/library/ms156014.aspx

hope this helps...good luck!

How to set PDF margins when rendering via WS

I'm rendering reports in PDF format in aspx pages by calling the ssrs
webservice. Is there a way to adjust the side margins in the PDF?
Currently the margins are a default of 1 inch on each side and I want to
reduce it to 1/2 inch on each side.
Thanks.
--
moondaddy@.nospam.nospamHello,
I suggest that you refer to the following topics in Reporting Services
Books Online:
PDF Device Information Settings
Device Information Settings
Render Method
I hope the information is helpful.
Sophie Guo
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
=====================================================When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================This posting is provided "AS IS" with no warranties, and confers no rights.

How to set No of rows per page in ssrs

Hi All,

By default in ssrs there are some fixed records..per page.......i mean each page contains (n) no of records.........per page..........?I want to display 100 records per page...for this what can i do ..please suggest .......

Thank's in Advance....

Hi
Add group with the following expression = Ceiling(RonNumber(Nothing)/N). Here N is the No of records in per page. And Select the Check box "Page Break either after/before"

Thanks

how to send the reports as an exe file

Hi,

can any one tell me how to send the reports as an exe file. Is there any possibility in ssrs. I have to send all my reports to my client along with the .net application. can any one help me out in this.

Thanks in advanceI doubt this is possible. Why not just deploy the reports on the client's PC?|||

You will probably have to look at building a .net app to run the RDL file, and distributing both the .exe for the .net app and the rdl file.

You may want to check out Project RDL.

http://www.codeproject.com/csharp/rdlproject.asp

The RDL Project is an open source (GPL) C# implementation of the Report Definition Language (RDL) for the .NET environment, by fyiReporting Software.

RDL is an XML based language created by Microsoft with the goal of promoting interoperability of reporting products. Microsoft implemented RDL as part of the Microsoft SQL Server Reporting Services

cheers,

Andrew

|||I have created all my reports in one application. I have to send this as an exe along with my .net project. so that they can install that in their machines. can u tell me What are the possible solutions for this?|||

Hi Andrew,

Thanks for u r reply, my requirement is how to send this as an exe along with .net project. So that my client will install in his machines. is there any possibility for this.

Thanks

Rahul

|||

So, your problem is how to deploy your reports to a client?

Your reports need to be published (deployed) to your client's reporting server. Sending the rdl files in an exe (i.e. as an install exe or a zip exe) will not achieve this. I suggest you either make an msi with a custom action to deploy the reports, or you use the report manager on your client's site to upload the reports to the server (the reports can be uploaded from your machine to your customer's reporting server in this way).

Did that make sense?

|||

Thanks for the reply.

I created MSI setup for deplying the reports. can any one tell me how to change the target server. Here I added a webreference of that. but in my client place target server name may be different. how can I make it dynamic. will there be any possiblity?

Thanks

Rahul