Saturday, 12 May 2012

Tips

  •        CDate(“mm/day/year”).

CDate("may/02/2011")—result is 5/2/2011

Table Grouping: Problem 2

Situation:
      If you want to keep particular group alone in single page.


d    Solution:

    Step 1:  Select the group cell. Do  write click. Select Row Group--> Grop Properties


Step 2: Check the box like below,


Note:

That particular group alone will display in every single page.






Table Grouping: Problem 1

Situation:

 If you using two tables in same page. If you wish to display the 2nd table data content in new page. Do the following steps:

           Solution:
Select table1's properties. Then click the sorting. Select page breaks.




Expantion for .rdl and .rdlc file


Note :

Rdl stands for- Report Definition Language
Rdlc stands for-Report Definition Language Client-Side


Difference between .rdl and .rdlc file


Difference between rdl and rdlc:
·         The <Query> element of RDL contains query or command information and is used by the report server to connect to the data sources of the report.
·         The <Query> element is optional in an RDLC file. This element is ignored by the ReportViewer control because the ReportViewer control does not perform any data processing in local processing mode, but uses data that the host application supplies.
·         Report Viewer’s dataset is different from rdl’s dataset.
  • Dataset and data source terminology has different meanings in Visual Studio 2005 and SQL Server 2005. In Visual Studio, a dataset is a collection of data tables and is logically equivalent to a query or command that retrieves data. In Reporting Services, a dataset includes the following parts:
    • Data source information, including the data source type and connection string. The data source type specifies a data processing extension that is deployed on the report server.
    • Credential information that specifies how to obtain credentials for the data source connection.
    • Query or command information used to retrieve data.
Visually, an .rdlc file that is configured to run in a ReportViewer control has the dataset object, binding source object, and table object displayed at the bottom of the designer view. The following diagram provides an illustration of how these objects appear in a Windows form (the same data binding objects appear differently in a Web page):

Data objects in a project workspace

If you select an .rdlc file for use in a ReportViewer control and the data objects do not appear in the project, you are most likely looking at a renamed .rdl file that requires additional conversion steps to make it a fully functional .rdlc file.

The dataset name might be misleading; by default, Reporting Services uses the name of the data source for the first dataset that is created (for example, a dataset might be called "Northwind" even if it only retrieves data from one of the tables).


Convert rdl(2008) to rdlc(2008) file Problem


Cant use  ssrs SQL R2 in visual studio 2008,(if u try to convert rdl to rdlc, result is error with unknown html code)

Reason is,
Visual Studio 2008 was released much earlier than SQL Server 2008, so ReportViewer 2008 is based on the 2005 version of RDL.
A SQL Server Reporting Services 2008 server report is based on the 2008 version of RDL, so, it can't be degrade to 2005 RDLC.

In this case, we need to redesign the local report with Visual Studio.

In order to convert a RDL 2008 to RDLC 2008, we can follow the steps in the original article you have post.
However, this RDLC can't be used in Report Viewer 2008 as Report Viewer 2008 need RDLC 2005. To use RDLC 2008, please use Report Viewer 2008 R2(10.0.0.0). Report Viewer 2008 R2 is coming with Visual Studio 2010.

How to retrieve the table's particular cell value or Textbox

Note:

        Step 1:  Select anyone of table cell or Textbox in your SSRS report.



        Step 2:  Note that cell name or textbox name in properties.

        Step 3:  Then you can retrieve and use that value in anywhere, Like ReportItems!Textbox1.Value
                       Ex: ReportItems!TextboxName.Value