Beginning SQL Server Reporting Services Part 4

The long-awaited final instalment of Steve Joubert's popular 4-part "from the ground up" guide to SQL Server 2005 Reporting Services. Here, he dissects the Report Definition Language and provides a practical demonstration on the use of Report Builder, an ad-hoc reporting tool that allows end users to build and customize their own reports.

This is the last installment of a four part article on SQL Server Reporting Services:

  • Part 1, provided a step-by-step guide to basic report creation and
  • Part 2 took a tour of some of the core SSRS features and functions that you’ll need to develop dynamic reports
  • Part 3 focused entirely on the built-in SSRS chart control

Here, in part 4, we focus on Report Definition Language (RDL). The definition of RDL provided by MSDN2 is succinct and hard to better, so I’ll use it here:

A report definition contains data retrieval and layout information for a report. Report Definition Language (RDL) is an XML representation of this report definition.”

We’ll examine the component parts of a typical RDL file and discuss how knowledge of RDL will enable you to refine and customize your reports. We’ll then take a look at Report Builder Tool, the new ad-hoc reporting tool that ships with SQL Server Reporting Services 2005. As a report developer, it allows you to create a report-building tool that then allows end-users to build custom reports based on the report definitions you’ve provided. Confused? Fear not, all will become clear.

In order to follow my examples, you will need to have SQL Server 2005, SQL Server 2005 Reporting Services, and Visual Studio 2005 correctly installed and configured. If you need some help with this, please refer back to the links in Part 1 of this series. Next, download the code file for this article (see the Code Download link above). The code file contains a sample Visual Studio project and a SQL Script for creating the ReportDemo database. If you’ve not done so already, go ahead and create the database using the ReportingDemoDatabaseScript.sql script or, alternatively, by restoring the provided ReportingDemo.bak file.

Now start a new Business Intelligence project in Visual Studio 2005 (or using BIDS, which installs with SQL Server 2005). Select Project | Add Existing Item to add to the project the shared datasource (ReportDb.rds) and the sample report definition file, FirstReportMan.rdl

Report Definition Language

Report Definition Language (RDL) is an XML-based schema for defining reports, and the reports that SSRS 2005 generates from the Visual Studio 2005 report designer are basically just XML. Each report has a header, footer and body. The schema defines:

  • Report layout- the body of the RDL file defines all of the objects that will be displayed in the report, including fields, images and tables
  • Each dataset, the data source for each dataset and database connection information (where no data source is used)
  • A set of fields in each dataset that can be populated with data
  • Any parameters that are used in the report

You can read the full specification for RDL at:

http://www.microsoft.com/sql/technologies/reporting/rdlspec.mspx

Dissecting a typical RDL file

The easiest way to get familiar with the basics of RDL is to dive right in and take a look at the component part of a typical RDL file.

Let’s take a look the RDL for the FirstReportMan.rdl included in the download project. Open Visual Studio and open the sample project FirstReportMan.rdl. In the solution explorer, right-click on the FirstReportMan.rdl and select the View Code option. This opens the report in XML mode. The full XML for this file can be found in the code download bundle, but we’ll just step through the major sections here.

Document element

Let’s first take a look at the document element:

The document element is called Report – no surprise there. It references two XML namespaces:

DataSources

The first element of the RDL file, below the namepsace reference is DataSources. In this element you can define a data source, or multiple DataSources, for your reports:

As you can see, this DataSource tag references our shared data source, ReportsDB, and it also references a GUID for the data source. If you weren’t using a shared data source the schema looks like this:

Margins

Oddly enough, the margins for the report are defined next. Remember this is XML; the tag order doesn’t really matter and it will vary from report to report. You will find the other tags, such as the report GUID, scattered around reports:

Report parameters

ReportParameters is the next major section. Each report parameter has a name, a data type and a label, which is used when the user is prompted to enter a value. Each parameter can also have a ValidValues section, which defines the list of valid values that will be used to populate the dropdown parameter list that is displayed to the user when they are prompted for a parameter value:

In this RDL file, we have two parameters, ReportTitle and ReportUserID. The ReportTitle parameter is a string parameter and has two valid values, MyFirstReport and CustomerReport, which correspond to the labels, Title1 and Title2, respectively. If the users selects Title1 from the dropdown, then the report title is displayed as MyFirstReport, and so on. The ReportUserID is also a string, and has no valid values defined for it.

Body

The report Body section is next. It has two main tags under it: Height and ReportItems.

The height property simply defines the height of the body area. It is the ReportItems elements that is the true star here. All of the objects displayed in the report are contained in this section of the RDL file. If you examine this carefully, you will see that there is a table definition and two textbox definitions under ReportItems. Each specifies its height and width, z-order, and top and left positioning. Inside the table you will find separate definitions for:

Let’s start wih the definiton of our table, MyFirstTable. In the Details section of the table definition, we define each detail row of the table, which in this case are populated with values for FirstName, LastName, State, Date of Birth and Status. If the data were grouped or sorted in any way, this would be defined in this section, using the <grouping> and <sorting> elements respectively. Here we show only the FirstName cell: 

We then move on to the Header area of the table. Here we define each cell of this table Header. These correspond to the column headings of our table. For example:

Finally, we have the TableColumn element, which defines the appearance of each column in the table:

Page header

After the body, we come to the PageHeader. This section also has a ReportItems section to contain any display objects just as the body does. It also has tags for whether or not to display the header on the first and last page of the report. This is a useful feature if you have ever tried to have a report with a cover page in a tool that doesn’t support this option.

DataSets

DataSets is the next section, with each DataSet element, predicatbly, describing a dataset that is used in the report. Each Dataset has a query definition with command type, command text, and reference to the datasource. The list of fields follows. Each field has a field name and data type. So, our ReportData dataset is described as folllows:

Last, but not least, is the code section. This section is simply the text of the custom function we embedded in the report.

Writing your own RDL

Okay, so now you have a good idea of the RDL that is written behind the scenes when the SQL Report Designer is doing its thing. This understanding of the report designer gives you the ability to manually tweak a report when necessary. I’ve found that I have had to do this less in SQL Server 2005 than in the 2000 version. However, knowing RDL empowers you in other ways too. You are not restricted to using the Visual Studio Report designer, because SQL Reports are not in some proprietary format. If you wish, you can roll your own report builder tool or RDL generator.

I recently built such a tool for a client. They wanted a reporting tool that could build and publish reports on the fly. Using SQL Report Designer, I created a base report that had the client’s standard header and footer. The body was left blank – as was the report name. I saved the RDL to an XML file. When someone submitted a query on which to base a report, I opened the base XML in an XML Document Object. The tool parsed the SQL statement for the fields and created the ReportItems in the body. Next, the tool created the dataset information and then published the report to their reporting server. The rs.exe utility that ships with SSRS 2005 can be used to publish reports from your application or from the command line.

One important note on using the XML Document Object to build a report: I had to remove the report definition schema from Report tag before it would load into the XML Document object. Just before I saved it added it back in as an attribute.

Using the Report Builder

The Report Builder is a neat addition to the SSRS package. It allows developers to create a tool that is delivered to the user via the web, using one-click deployment. The tool allows the user to select from pre-defined fields and functions as the basis for building their own reports. The user can use the simple drag and drop interface to build custom reports. It’s a great way to give limited control over reporting to your user base, without giving them too much authority on the database.

Defining a report

In this exercise we are going create a report definition that will allow the end-users to customize their own reports. Start by creating a new project type called Report Model Project from the Business Intelligence options in Visual Studio 2005. Look in the Solution Explorer. You should have a project with three folders underneath it.

  1. Data Sources
  2. Data Source Views
  3. Report Models.

Adding a Data Source

This works almost the same as it does in regular reporting services. When you add a new data source (Project -> Add New Item) you get a wizard. The wizard will automatically look for the data source on your local report server or which ever report server you configure the project to use. If you have not defined the correct data source, you can create a new data source object like we did previously.

345-ScreenShot26.gif

Adding a Data Source View

Data Source Views allow you to define which tables the user has to select from when they are creating a report. It also allows you to define the relationships between those tables so that the report knows how to join them. Table relationships can be based on foreign keys or a name matching schema. If you choose some type of name matching option the report will attempt to join tables based on columns with the same name or based on primary keys.

Select Project -> Add New Item from the menu and choose Data Source View. Click next to get past the first page of wizard. The first screen asks you to select a data source to use for this view.

345-ScreenShot27.gif

As you can see, there is also the option of Create a new data source here as well. Select the data source you set up in the previous step.

345-ScreenShot28.gif

On this screen you tell the report builder how you want ‘name matching’ to take place when it constructs the SQL statement. As you select the radio buttons the sample code changes in the bottom pane. For now let’s go with the default option (same name as primary key). Click Next.

345-ScreenShot29.gif

On this screen, you select which tables and/or views you want to include in the view. Select the Customer table and move it to the list box on the right-hand pane. Click Next.

345-ScreenShot30.gif

The last screen of the wizard gives you a chance to name the Data Source View. Click Finish and you’ve created a data source view.

Adding a Report Model

The Report Model takes a Data Source View and wraps so that the end user can use the tables it contains. The Report Model also allows you to select which individual fields from those tables are available to the report.

From the menu, select Project -> Add New Item. When the dialog opens, select Report Model Wizard and name it ReportingDemo.smdl. Alternatively, you can right-click on the Report Model folder and select Add New Data Model. Either way, click past the wizard start screen.

345-ScreenShot31.gif

Select the Data Source View we just created and click Next. Note that you could create a data source view from this screen as well. Click Next.

345-ScreenShot32.gif

In addition to simply providing you with fields you select, the report builder also gives you the option-adding aggregate functions. You can determine which functions you want to be added on this page: Report Model Generation Rules. For this particular demo, use the defaults and click Next.

345-ScreenShot33.gif

The model statistics screen allows you to determine whether you want the database to update its statistics before the report builder is generated. This is generally a good idea. For now leave the defaults and click Next. On this last page you can give the report model a name. If you choose not to, one is supplied based on the data source view you chose for the report.

345-ScreenShot34.gif

The only thing left to do is click the Run button. This generated the basis for the report. Once Run has completed, you can examine the options created. The Run button will change to the Finish button. Click the Finish button to complete the wizard.

Build and publish

Lastly, right-click on the project icon and build and publish this project to your report server. This may take a couple minutes the first time you do it. The report builder is actually compiling a windows application and setting it up for one-click deployment over the web.

Using the Report Builder to make a report

When we run the report builder is launches a windows application that allows the user to drag and drop field on a canvas in order to create a report. The user gets to determine which fields are on the report in which order. They can format the report as they wish and run it.

Let’s run the report builder. Remember that everything from now on is meant to be experienced by the users. You must have the .NET Framework 2.0 redistributable installed on your machine before you can run this.

Navigate to your Reports website: http://localhost/Reports/.

345-ScreenShot35.gif

Notice that in the tan bar there is a new option called Report Builder. Click on it to launch Report Builder. The first time you do this it has to download the code base, so it may take a few seconds to activate.

345-ScreenShot36.gif

Once the Report Builder has opened, you will see a Getting Started panel on the right. Just under that there should be a list box showing the report models. If you have only defined a single report model you may not see this dialog. The report model you created will be used by default. The one you just created and deployed should be listed. Select it. Choose the Table Layout and click OK.

345-ScreenShot37.gif

Now let’s get our bearings. On the left you have the Entities list box which lists each table from the report model you selected. When a table or view is selected, all of the field options for that entity are listed beneath it.

The report designer takes up the rest of the screen. Click on the text box labeled Click to Add Title and give your report a title. Next, drag some fields into the table. I added the customers’ First Name, Last Name, City, State and Birth Year. The birth year is available under functions if you expand Date of Birth Just drop each field to the right (or left) of the previous one. The tool will automatically add columns for you.

345-ScreenShot38.gif

Click the Run Report button at the top of the page.

345-ScreenShot39.gif

This is the result. Notice that by clicking on the column headers you can sort the report. You can toggle back to Design View with the button next to Run Report, but let’s stay here for now. Now click on the Filter button. The Filter dialog appears.

345-ScreenShot40.gif

Double click on State. State equals appears in the right pane. A dropdown menu provides you with a unique set of values from the result set. Select CA. and Click OK. The report regenerates, and only your California customers are displayed on the report.

345-ScreenShot41.gif

So there you have it. Report Builder allows you to deliver an Ad-hoc reporting tool to you clients. If you find yourself constantly having to produce custom reports for various clients, all off the same data, then this is the tool for you. It allows you to transfer that control to your customer’s hands. That frees you up to do more important work and your customers may even enjoy designing their own reports. For your part you free up your time and look like a hero to your customers and your boss.

Conclusion

I hope this tutorial article has given you some insight into the capabilities of SQL Server Reporting Services 2005. There are many more features for you to discover. Just to name a few, I suggest you look into sub-reports, the charting control, report caching and report subscriptions. Happy reporting…

Downloads

Tags: , , , , , ,

  • 162744 views

  • Rate
    [Total: 156    Average: 4.2/5]
  • Anonymous

    report builder
    That’s nice article Steve and unfortunately there is not much abt report builder! it covers very basic and new user using Report builder can be scared that way entities hierarchy changes! I wish there was more info on usage on report builder.

  • Anonymous

    Dynamically creating Datasources
    Hi, I noticed in article 1 that a few people asked if there was any way to dynamically create a Datasource or at least a way to Dynamically point to a Datasource that has been created on the Report server itself.

    I am wondering if you had an answer for this?

    If any of the other posters knows how to do this I would be very greatfull if you would send me an e-mail explaining how to do this

    thank you.
    I can be reached at
    rick@liralin.com

  • Anonymous

    Regardin Automatic running of Report
    Sir,

    Facing problem of automatioc running of report.

    Suppose we are taking two parameter and passing default values for both. It is automatically run when we take preview without clicking View Report commend button.

    So I want my report should not run whenever we dont click on view report button.

    If any solution.Please give.

    thank you.
    I can be reached at
    acmishra83@gmail.com

  • Anonymous

    SSRS XML Mapping to Word 2007 Template
    What is the optimal approach for integrating some SSRS-reported tables and charts, perhaps through XML mapping, to set locations in a Word template? Thanks for your advice.

  • Patrick Index

    Brilliant
    These 4 tutorials have been brilliant. I was thinking of buying yet another book on Reporting Services but I certainly won’t bother now. Thanks again.

  • Anonymous

    Conditioning Reporting Parameter selection
    Great tutorials. I have several reports I need to create. The end layout is the same on all reports. The only difference between the reports is the selection. Does reporting services have the capability to prompt the user for how they want the report selected by and then provide a drop down for the selected criteria?
    For example: The first report is selected by sku, next the user may want the same report selected by general ledger type.
    I am trying to avoid 5 different reports and want to use reporting services for the entire process.
    Please reply to krkiser@yahoo.com
    Thanks

  • Anonymous

    hi
    Having problem in deploying the reports.
    While trying to run with http:\localhostreportserver

    Its giving

    Reporting Services Error

    The report server has encountered a configuration error. See the report server log files for more information. (rsServerConfigurationError)
    Access to the path ‘C:Program FilesMicrosoft SQL ServerMSSQL.3Reporting ServicesReportServerRSReportServer.config’ is denied.

    Please reply to

    j.selvakumar2gmail.com

    Thanks

  • Anonymous

    Having problem in deploying the reports
    Having problem in deploying the reports.
    While trying to run with http:\localhostreportserver

    Its giving

    Reporting Services Error

    The report server has encountered a configuration error. See the report server log files for more information. (rsServerConfigurationError)
    Access to the path ‘C:Program FilesMicrosoft SQL ServerMSSQL.3Reporting ServicesReportServerRSReportServer.config’ is denied.

    Please reply to

    j.selvakumar@gmail.com

    Thanks

  • Anonymous

    http:\localhostReports – get the error message below
    The encrypted value for the “LogonCred” configuration setting cannot be decrypted. (rsFailedToDecryptConfigInformation) Get Online Help The report server has encountered a configuration error. See the report server log files for more information. (rsServerConfigurationError) Get Online Help

    Any help would be appreciated – thanks

  • Anonymous

    Hi I am getting below error any help is apprecitated
    The encrypted value for the “LogonCred” configuration setting cannot be decrypted. (rsFailedToDecryptConfigInformation) Get Online Help The report server has encountered a configuration error. See the report server log files for more information. (rsServerConfigurationError) Get Online Help

  • Giridhar

    multiple tables and multiple stored procedures
    Hi,
    I want to use Multiple tables and Multiple storedprocedure in one dataset to retrive the data using RDL,
    Is it possible

  • Giridhar

    multiple tables and multiple stored procedures
    Hi,
    I want to use Multiple tables and Multiple storedprocedure in one dataset to retrive the data using RDL,
    Is it possible

  • Anonymous

    How to make report parameters as read only??
    How to make report parameters as read only??
    I want the date parameter as read only. can any one help on this?

  • Anonymous

    How to make report parameters as read only??
    How to make report parameters as read only??
    I want the date parameter as read only. can any one help on this?

  • Anonymous

    help me
    hai all,

    my requirement is:
    i want to pass multiple perameters from one web page to other one.the other one containts reportviewer contol.by using that perameters report will be generated…is it possible?
    i need c#.net code with some example…
    plase help me …
    multiple perameters means:
    example…

    let id is one perameter..it accepts the multiplevalues id=1,2,3 like that

    in aspx form: id=1,2,3.. if i enter like this
    report will genarate .all the details of ids 1,2,3
    query:select * from table1 where id=@id;
    reportpreview:

    idno name
    ………….
    1 v
    2 g
    3 t
    like that
    ……….
    please help me………

  • Anonymous

    plz helpme
    hai all,

    my requirement is:
    i want to pass multiple perameters from one web page to other one.the other one containts reportviewer contol.by using that perameters report will be generated…is it possible?
    i need c#.net code with some example…
    plase help me …
    multiple perameters means:
    example…

    let id is one perameter..it accepts the multiplevalues id=1,2,3 like that

    in aspx form: id=1,2,3.. if i enter like this
    report will genarate .all the details of ids 1,2,3
    query:select * from table1 where id=@id;
    reportpreview:

    idno name
    ………….
    1 v
    2 g
    3 t
    like that
    ……….
    please help me………

    reply me at :veeru.karusala@gmail.com

  • Himanshu

    Multiple Datasets in aTable
    Hi,

    I want to use values from multiple datasets in a single table…… but it is only able to take an aggregate from the 2nd dataset which is not associated with the table. I there any way out?

  • Himanshu

    Multiple Datasets in aTable
    Hi,

    I want to use values from multiple datasets in a single table…… but it is only able to take an aggregate from the 2nd dataset which is not associated with the table. I there any way out?

  • vinny

    hi
    I created a report with cascading parameters and every thing is fine but I want to view the report with out clicking the view report button I want to genarate the values as soon as I selec the values in the parameter. Is ther any such option in SSRS 2005? Please if you know the solution please let me know.

    I can be contacted at
    vinnu_e@hotmail.com

  • Anonymous

    stylesheets to control layout
    Hi Can we use stylesheets to control SQL Reporting Services reports?

  • Anonymous

    Logon failed

    Hi,

    We just have new reporting services server up. When I try to test out a report (which was working fine from VS), I keep getting below message:

    “Logon failed.

        For more information about this error navigate to the report server on the local server machine, or enable remote errors”

    I have my data source set up as:

    Connection type: Microsoft SQL Server

    Connection string: data source=<myserver>;initial catalog=<mydatabase>

    Connect using:

    Credentials stored securely in the report server

    User name: mydomainmyRptSvcsAcct ( I also tried window authenticated option I got the same error)

    Password: mypw

    Checked on Impersonate the authenticated user after a connection has been made to the data source

    Please advise.

    Thank you

    Mydieu

    mnugyen@foundation.fsu.edu

     

  • Anonymous

    Report Builder
    I get this message when I launch the Report Builder
    “No report builder models are available. To use report builder atleast one model must be published to the report server”

    Please help

  • Potomov

    Re: How to make report parameters as read only??
    maybe making it an internal parameter makes it read-only parameter

  • Anonymous

    report parameters
    hi,
    in preview option the report parameters are displayed only in two columns what ever may be their number can we display some of the parameters in third column

  • Andreou

    good! support!
    good! support!
    <a href=http://jeniffer.velocityblog.com/ > best blog </a>
    [url=http://jeniffer.velocityblog.com/] best blog [/url]

  • Anonymous

    Footer in Matrix
    Hi, great articles.

    But still no help on a footer for the matrix.

  • Susantha

    Need to parse loginId from web application to report.
    Hi,
    My requirement is to, based on login details(loginId) the report should be generated.
    The dataset which create the report will have ,
    WHERE clause for check the loginId. But how I parse the loginId from asp.net application. I have loginId in my web application, but im wondering how it parse as parameter to report. This can not be done using dropdown list, becasue for security purpose, dont give user to select his loginId.. It should get from web application and once user click to view report it should generate as dynamically based on loginId. Can anyone help me.

    susanthaucsc@gmail.com

  • Anonymous

    Re.Need to parse loginId from web application to report.
    In the Expression option select Globals –> UserID which will give you =User!UserID. You can make use of this.

    Hope this works,
    Ganesh

  • Clement

    Matrix and blank pages in Report
    Hi,

    I have never been able to get a correct width with SSRS and a matrix in the report.
    I always get some blank space after my matrix in the preview tab.
    I know SSRS is not able to get a dynamic width for matrix or table columns (and it’s odd) but I still do not understand where these blanks are from ?

    a+, =)
    -=Clément=-

  • clement

    Solution for matrix width in SSRS
    Hi,

    I have just found the solution :
    SSRS report items push them each others

    In the following picture you can see
    -in red the push effect and the always blank zone.
    -in green the rectangle you should add and the new zone where the matrix width will expanse
    http://nsa02.casimages.com/img/2008/05/27/0805270213313444060.png

    a+, =)
    -=Clément=-

  • Cyndy

    Deploy of Report Models throws exceptions
    These tutorials have been great!!! Thanks so much for posting them. Everything has worked fine for me through #3. I was sailing along and found that when I went to publish the above to be able to build a report on the model in Report Builder, it produced errors. Build runs fine, but deploy throws an exception error on the smdl and the ds. Errors are as follows:
    Build complete — 0 errors, 0 warnings
    —— Deploy started: Project: Report Model Project Tutorial, Configuration: Production ——
    Deploying to http://servername/ReportCenter?%2f
    Exception of type ‘System.NotSupportedException’ was thrown.
    Deploying model ‘Reporting Demo.smdl’.
    Exception of type ‘System.NotSupportedException’ was thrown.
    Deploy complete — 2 errors, 0 warnings
    ========== Build: 1 succeeded, 0 failed, 0 up-to-date, 0 skipped ==========
    ========== Deploy: 0 succeeded, 1 failed, 0 skipped ==========
    Not sure what is up and nothing in search helps pinpoint the why. Deploy to production and using same target paths as I have been in the SQL BID. Research finds posting that says “Report Models cannot be sourced from any other RDBMS besides SQL & Oracle. In our case we were sourcing from PostgreSQL”. Not sure correct when you tutorials have worked fine up to this point, but I can not find what setting or switch I need to change
    Any help – please! Thanks

  • Anonymous

    Sql Server Reporting Make some fields while download ReadOnly
    Hi want to download a report.rdl and make some of the report fields readonly amd some editable.

  • Anonymous

    nice stuff
    Good article…

  • Kalelur Rahman

    Nice Article
    Well done Mr. Steve Joubert. I have read all the four parts of this article. SQL2k5 beginners…. should be thankful to you…..we would like to join them too…

  • Anonymous

    can we use stylesheets with SSRS 2005 reports?
    seems to be an obvious connection here…

  • klauspin

    Automatic execution of reports
    Hello,
    very nice paper, very helpful,
    I have the same problem as an Anonymous user asked on March 08, 2007.
    If I specify Default values for all Parameters (or there are no parameters at all) the report will start executing without me pressing the “View Report” button.
    Can you suggest a solution or work-around if I want to prevent this. I have already played around with a hidden parameter but did not succeed.
    Thanks a lot,
    Regards,
    Klaus.

  • klauspin

    Automatic execution of reports
    Hello,
    very nice paper, very helpful,
    I have the same problem as an Anonymous user asked on March 08, 2007.
    If I specify Default values for all Parameters (or there are no parameters at all) the report will start executing without me pressing the “View Report” button.
    Can you suggest a solution or work-around if I want to prevent this. I have already played around with a hidden parameter but did not succeed.
    Thanks a lot,
    Regards,
    Klaus.

  • M|S

    Specified method is not supported.
    When I hit Run on the Report Model Wizard, I get this error:

    “Specified method is not supported.”

    That’s all it says, doesn’t say what method.

    I found this: https://forums.microsoft.com/TechNet/ShowPost.aspx?PostID=2715573&SiteID=17 but that wasn’t the problem.

    If anyone has a solution to this, please post.

  • ST John

    RE. How to make report parameters as read only
    to make a report parameter ‘read only’ use the available values feature (in the paramertes properties dialogue’) to provide just one value for the available values and the same value for the default value.

    this effectivly limits the user to just one choice, though one has to wonder why you are not simply generating the value that you want and passing it to your dataset directly.

    J

  • rintu_mitra

    Sort in Report Model
    i want to sort column in my report model. i have given sort information in report builder ,but its not happenig.i’m unable to find the solution. please tell me if anybody know the solution.

    thanks in advance

  • qumrudden

    About Sql reporting services
    Hello
    i am .net developer. & we are using crystal report for reporting purpose.but i want to learn SSRS . i am a new for sql server reporting services. first i want to know what is the basic difference between Crystal reporting & sql server reporting services. Is SSRS have any advantage over crystal reporting.can you please explain.
    what can’t i do in crystal report & can do in SSRS.
    Thank in advance.

  • kumarchpramod

    Part 3 link is not working…
    Hi ,
    I am a newbie to SSRS . But unfortunately i have to work on it . I am following this website and slowly learning SSRS parallelly working on it. Here part 3 link is not opening. Did any one noticed?

    Please let me know if there is any new link…
    Also please let me know how many parts are there in total.

    Also i am looking for SSIS articles also…are they available…

    Thank You…

  • lazario

    Question about Report Server
    I am new to this forum. I am having strange issue with a production Report Server instalation. I am not an expert with RS, but I analyse everthing I could even Profiler to see query and querys are ok.
    But the report hangs ( from IE 8 explorer ) when I run with specific parameter.
    Can you help me with this ?
    Thank you