Hiding and shrinking the width of the Column in SSRS 2008


Hi,

 We recently had a requirement wherein we were hiding few columns of our SSRS report dynamically based on value of a parameter.

The problem was that the hidden column although not visible was still consuming the space.

To solve this issue

  • Select Advanced Mode in the report Column Groups


  • Select the static column referring to the column we want to hide and set its Hidden property


The helpful post

http://blogs.msdn.com/b/robertbruckner/archive/2010/05/02/report-design-shrinking-hidden-static-columns.aspx

Bye.

Showing SSRS report in a single page


Hi,

We had a requirement to show one of our SSRS report (in CRM 2011) in a single page so that users don’t have to click on Previous Page and Next Page buttons.

.

Setting InteractiveSize’s Height property of the report to 0 solved the issue.

The helpful posts

http://social.msdn.microsoft.com/forums/en-US/sqlreportingservices/thread/5733e039-7031-454a-b9ad-981a93d97f1f/

Bye.

Using Web Service as a Data Source in Sql Server Reporting Services


Suppose this is a simple web method inside a web service in ASP.NET.

[WebMethod]

public string HelloWorld(String FirstName, String LastName) {

return “Hello “ + FirstName+ ” “ + LastName ;

}

Now we would to add the above as a xml data source in out Report.

For this we need to do the following

  • Create a new Report
  • Select <New DataSet..>
  • For Type (inside General Tab) select XML as DataSource type.
  • Inside connection string give the path to the web service.
  • i.e. http://localhost:2584/WebSites/Service.asmx
  • Define query for the data source in the following manner

<Query>

<Method Namespace=http://tempuri.org/ Name=HelloWorld>

</Method>

<SoapAction>http://tempuri.org/HelloWorld</SoapAction>

</Query>

 

We can create report parameters for FirstName and LastName parameters of the method.

Or we want to define default values for these parameters define the query as following

 

<Query>

<Method Namespace=http://tempuri.org/ Name=HelloWorld>

<Parameters>

<Parameter Name=FirstName>

<DefaultValue>Nishant</DefaultValue>

</Parameter>

<Parameter Name=LastName>

<DefaultValue>Rana</DefaultValue>

</Parameter>

</Parameters>

</Method>

<SoapAction>http://tempuri.org/HelloWorld</SoapAction>

</Query>

 

Bye..

%d bloggers like this: