24 August 2006

Beginning SQL Server 2005 Reporting Services Part 1

Steve Joubert begins an in-depth tour of SQL Server 2005 Reporting Services with a step-by-step guide to building and deploying basic reports.

Building and deploying basic reports

If ever there was job for “real” developers to shuffle to their juniors, it is building reports. It’s not real development anyway; it’s more like glorified formatting. Besides, the esoteric tools that you use to build reports try to provide an abstraction layer, which often prevents you from having any real control over the report. I’ve heard all these arguments before. If this sounds like a conversation you’ve had by the water cooler, then I invite you to take a closer look at SQL Server 2005 Reporting Services (SSRS).

SSRS 2005 is the latest version of SQL Reporting Services, and ships with all versions of SQL Server 2005. SSRS allows you to quickly and easily create reports from multiple database sources. The finished reports can be presented directly from the reporting services website, or they can be displayed in your web- or Windows-based applications. Reports can be exported to multiple formats, including comma delimited text, XML, portable document format (pdf) and Microsoft Excel.

This article is the first of four parts, which will provide in-depth coverage of SQL Server 2005 Reporting Services:

  • Part 1 covers the basics of the SSRS. It demonstrates how to build quick, simple reports and will familiarize you with the basic Report Designer environment
  • Part 2 will cover use of custom functions, aggregate functions, sub-reporting, the matrix control, drill-downs, and sorting.
  • Part 3 will take an in-depth look at the charting control
  • Part 4 digs into the actual Report Definition Language (RDL) and the new Report Builder tool.

Installing and configuring Reporting Services

After much debate, we decided that full installation and configuration details were outside the scope of an article focused on how to build basic reports using SSRS, especially as there are already several online resources that treat this area in detail. See, for example:

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

and

http://www.awprofessional.com/articles/article.asp?p=357694&seqNum=1&rl=1

Well worth reviewing are the details in the latter on the need to install SSL on any machine hosting SSRS.

Editor’s installation notes
In order to test the reports in this article, I went through a single-machine installation on Windows XP (meaning that SQL Server 2005, Reporting Services, and much more, are all installed on my poor laptop). Since I didn’t install SSRS when I installed SQL Server 2005 (I didn’t have IIS installed at the time), I had to first install IIS 5.1, and then Reporting Services (from the SS2005 disks). I then jumped immediately into Reporting Services Configuration Manager tool (All Programs ¬ SQL Server 2005 ¬ Configuration tools). The left panel acts as a sort of checklist of items to configure:

268-ScreenShot1.gif

All went well until the Database Setup. Because I had not installed SSRS at the same time that I installed SQL Server, the ReportServer and ReportServerTempDB were not created by default. These databases hold all the report definitions and reporting server configuration information. Connecting to SQL Server using Service Credentials, the databases appeared to be created, but I received an error suggesting that I didn’t have permissions to perform the requested task, and a red cross remained next to the Database Setup icon. This had me stumped for a while – eventually I appeared to solve it by hopping to the Server Status section, stopping the Report Server, opening SSMS and deleting both the ReportServer and ReportServerTempDB databases, and then restarting the Report Server and trying again! Even though I swear this didn’t work the first time I tried it, it seemed to do the trick the second time (while I was on the phone moaning to Steve that I couldn’t get it to work!). However, I’m still not clear why I had the problem in the first place – or why it suddenly went away.

This wasn’t quite the end of my problems. Installing SSRS creates two new virtual directories under the default website on IIS. By default, they are named Reports and ReportServer. The ReportServer site hosts a web service for running and managing reports. The Reports site allows you upload reports from a browser and run reports over the web. When I tried to navigate to http://localhost/ReportServer I received the following error: “Failed to access IIS metabase”. Fortunately, the information on the error page is quite useful (for a change) and this, coupled with a quick Google search, led me to grant access to the metabase to the ASPNET user account by executing the following from the directory housing the aspnet_regiis executable (WINDOWS\Microsoft.NET\Framework\v2.0.50727, in my case):

 

This did the trick, and I was up and running. I received some raised eyebrows here when I proposed to install SSRS. It made my long-suffering sys admin team particularly nervous. The 2000 version of SSRS seems to have a very bad reputation among the Red Gate team, both as a performance nightmare, and in one case for “completely annihilating” a developer’s machine. However, the above slight quirks aside, the SSRS 2005 experience seems pretty smooth and I’ve had no real performance, or other, issues. So far.
—–End of Editor’s note—-

Once you’ve completed the installation and configuration process, the first thing to do is download the code file for this article (see the Code Download link at the bottom of the article ). The code file contains a sample Visual Studio project and a SQL Script for creating the ReportDemo database. You will need this database if you want to follow the examples in this series of articles so go ahead and create the database using the ReportingDemoDatabaseScript.sql script or, alternatively, by restoring the provided ReportingDemo.bak file.

If you are using SQL Server Authentication on your SQL Server you will also need to set up a login with permissions to the ReportDemo database (for the examples, I set up a login called DemoUser as a DBO on my ReportDemo database).

Using the Report Wizard

There are two ways to create SSRS Reports. You can build the report manually, or you can use the Report Wizard to give yourself a head start. For this first report, we are going to take advantage of the wizard. Start a new Business Intelligence project in Visual Studio 2005. Then, from the menu, select Project > Add New Item. Select the Report Wizard option and call the file “FirstReportWZ.rdl”. Click Add. Click Next on the Welcome screen and this will bring you to the Select the Data Source screen:

268-ScreenShot2.gif

Select the New data source radio button and give the data source a name. Select Microsoft SQL Server as the type.

Note:
Use of the Shared data source option is actually a better option in most cases but, for the sake of this example, we will just create a new data source. We’re going to set up a shared data source later in this article.

Click the Edit button to bring up the Connection Properties dialog:

268-ScreenShot3.gif

Enter or select a server name. The default is to log on using Windows Authentication. If you are using SQL Server Authentication, choose that setting, and enter the username and password. Finally, select a database, in this case ReportingDemo. Make sure you test the connection before you click OK.

Next up is the Design the Query screen. You can use the Query Builder by clicking the button at the top left, but in this case simply enter “Select * From Customer” into the Query string text box and click Next. On the Select the Report Type simply select the type you prefer (tabular or matrix) and hit Next.

This brings up the Design the Table screen:

268-ScreenShot4.gif

Select State in the Available fields box and click the Group button. This will group the data in the result set by State. Select Next. On the Choose the Table Layout page, select the Stepped option and check the Enable Drilldown checkbox. On the next screen, choose a style for your report (I chose Ocean) and click Next.

This brings up the final screen, Completing the Wizard:

268-ScreenShot5.gif

It shows a summary of your report options, and gives you an opportunity to rename the report and to preview it. Click Finish to end the wizard.

You should be shown the report in the standard Report Designer:

268-ScreenShot6.gif

There are three tabs: Data, Layout and Preview. You should be on the Layout tab. Click on the Preview tab to view the report. Since this report doesn’t take any arguments, it will run as soon as you click on the tab.

268-ScreenShot7.gif

Use the +/- symbols next to the State abbreviations to expand and collapse the grouping of the report.

Manual report creation

The previous section, while perhaps overly simplistic, does show you how to get a report up and running with zero code and zero property setting. Obviously, such reports will not meet most development requirements, but do not discount this option as a starting point for more complicated reports. Once you’ve created a report with the Report Wizard, you are free to make any modifications to it.

In this section, we are going to create a more realistic report from scratch, including how to create and use a shared data source object, stored procedures, and how to format your report, set report properties and use report parameters.

Creating a shared data source

Before we start the report, we are going to build a shared data source i.e. a data source that is common to, and can be used by, all of the reports on a reporting server. While each report can contain its own connection information, it is good practice to use shared data sources, as it will save you a lot time and headaches. This way, you only have to set the connection information once. For example, let’s say your company has Development, Test and Production environments. If you put the connection information into each report, you will have to change it each time when you publish to Development, Test and Production. If you use a shared data source, you still have to set up a data source object for each of three environments, but you can simply publish the report to each environment, and they will automatically use the connection information associated with that environment.

From the menu select Project > Add New Item > Select Data Source. On the General tab, call the data source “ReportsDB”. Leave the Type as Microsoft SQL Server. Click the Edit button on the right, and enter the connection information for Reporting Demo, as before. Click OK on the Shared Data Source screen and the data source is done.

Add a new report

From the menu select Project > Add New Item. Select Report and name it “FirstReportMan.rdl”. A new report will be added to the project, and the Report Designer will open at the Data tab. At this point, let’s take a closer look at the Report Designer tool. At the top of the Report Designer window are three tabs: Data, Layout and Preview. The Data tab is used to build data sources for your report. The Layout tab is the physical report designer where you set up the header, the footer and the data presentation of the report. The Preview tab allows you to actually run the report from Visual Studio 2005, without having to publish it to a report server first. If your report takes parameters, the Preview tab will ask you to fill them out before it runs the report.

The first thing we need to do is get data into our report. At the top of the Data tab choose <New Dataset…> from the dropdown list:

268-ScreenShot8.gif

The Dataset dialog opens:

268-ScreenShot9.gif

Name the dataset “ReportData”, and select the ReportsDB data source from the dropdown. Select StoredProcedure as the command type, and enter “spr_CustomerSelectAll” in the query string box. Click OK to close the dialog.

Note:

spr_CustomerSelectAll is a very simple, parameter-less stored procedure that selects all of the columns from the Customer table. The source code is included in the ReportingDemoDatabaseScript.sql script with the code download.

Test the dataset by clicking on the big red exclamation point at the top of the report designer. This executes the query and displays the results. You can repeat these steps if you wish to add multiple datasets to your report.

Setting up the report display

Next, switch to the Layout tab. This is where you actually build the report display. Start by dragging a table from the Toolbox, onto the Body section of the report. By default, the table shows a header row at the top, a detail row in the middle and a footer row at the bottom. You can add additional columns to the table by right-clicking on one of the columns and selecting one of the two Insert Column options.

Click on the Datasets tab under Toolbox on the left-hand side of the Visual Studio environment. You should see the ReportData dataset. Expand it, select FirstName and drag it to the first cell of the body row of the table. This will display the First Name field in the first column. Now put the LastName in the second column, and the CustomerStatus in the third:

268-ScreenShot10.gif

Note that, when you drag the column FirstName into the body row of the table, SSRS make a guess as to what to call the row. It calls it “First Name”. You can click on the Preview tab to view the report.

Adding formatting

OK, so we have a basic, very plain, report. Let’s add some formatting to make it look good. Let’s add the DateOfBirth column to the table. You can expand and shrink the size of the columns by highlighting and dragging:

268-ScreenShot11.gif

If you wish to get rid of the footer row of the table and then click on any field in the table. You will see a grey box surround the table. Right-click on the icon at the beginning of the body row and then click the Table Footer option to deselect it.

The table header is next. To format all the cells in the header in the same way, click and drag over all the cells to select them. Open the Properties window and set background color, font, and so on.

268-ScreenShot12.gif

Note, however, that if you wish to change the justification of the text or the size, then you do so using the main menu at the top, not via the properties window. Again, you can click on the Preview tab to view the report.

Add a report header

The table already has a header, but the report can also have a header and footer. Report headers and footers appear on every page of the report. Put the Report Designer in Layout mode and select Report > Page Header from the menu. A new band labeled Page Header appears on the report above the body. Drag a text box onto the header and click directly on it. Type “My First Report”, not in the Properties window, but right on the control.

268-Screenshot13.gif

To adjust the text style and size of your heading, highlight the text box and use the option from the top menu.

Formatting

Each field can have formatting. Let’s deal with that ugly Date of Birth field. The time information is superfluous, so let’s format the date properly. Right-click on the cell that contains the date of birth, and choose Properties. Next, select the Format tab.

268-ScreenShot14.gif

Click on the second button (labeled “…”) to the right of the Format code field. When the dialog opens, use the standard options. Select Date in the list on the left, then choose the sample date format you want on the right. Click OK to close the dialog.

268-ScreenShot15.gif

Click OK to close the Properties window and then click on the Preview tab to view the report.

Setting report properties

To access the report properties, you need to be on the Layout tab of the Report Designer. When you click on this tab, a new menu item, Report, activates. This menu gives you options for turning on and off the report header and footer sections (as we have seen), adding embedded images, setting report properties, and setting report parameters.

Setting up the report print settings is not intuitive, compared to other products. In the report Layout tab you see your report with a ruler across the top. That ruler is set up in inches. A standard sheet of paper is 8.5 x 11 inches. The default setting in SSRS is to have a 1-inch margin all the way around the content area. So, at 8.5 inches wide with a 1-inch margin on the left and another on the right, you have 6.5 inches for content. Any more, and the content beyond the 6.5 inches will spill over onto a second sheet of paper when printed. It will not automatically shift to Landscape.

To get Landscape reports, you have to make the proper report settings. Navigate to the Layout tab of the Report Designer. From the Report menu select Report Properties. Switch to the Layout tab of the dialog box. To switch to Landscape printing, you need to change Page width to 11in and the Page height to 8.5in.

268-ScreenShot16.gif

On the same Layout tab, you can also get up your report to display the data in multiple columns, and you can control the margins. By default, all the margins are set at 1 inch. Remember, if your report width, plus the right and left margins, is greater than the width of the printer, you will get spill-over when you print out your report.

Using parameters

There are two ways to add parameters to your reports. The first is to use parameters in the queries in your data sources. The second is to set up parameters through the Report Parameters dialog box. We will do both.

Query parameters

First, we will set up parameters using a data source query. Navigate to the Data tab, and click the “…” button right next the Dataset dropdown box. The Dataset dialog box opens and allows you to edit the query for the dataset. Change the Query string from “spr_CustomerSelectAll” to “spr_CustomerSelectByState”.

Note:
spr_CustomerSelectByState accepts a parameter called StateCD that allows us to filter the data from the Customer table by State. Again, the source code is included in the ReportingDemoDatabaseScript.sql script with the code download.

Click OK and then run the query by clicking the red exclamation point (!) on the Data tab toolbar. You will be prompted to enter a parameter value for StateCD (the State code). Enter “CA” and click OK. The query should return all the customers that live in California.

Switch to the Preview tab. Instead of the report just running, there should be a place for you to enter a value for the “StateCD” and run the report. Enter “CA” and click the View Report button. You should see your report filtered by state.

To edit the parameters, or to add new ones, switch to the Layout tab of the Report Designer and open the Report Parameters dialog from the Report menu. First, we are going to make the “State code” prompt a little more friendly. Select StateCD in the Parameters list box then, in the Parameters Properties box, change the prompt to read “State”. In the Available values section enter “California” and “CA” on the first line. Enter “Louisiana” and “LA” on the second line.

268-ScreenShot17.gif

This will make the prompt for “State value” into a dropdown. You can also build additional datasets into your report, and use the values in those datasets as criteria for dropdowns.

Report parameters

Now let’s add a parameter that is not used in a query. Click the Add button in the Report Parameters dialog from the Report menu. Give the new parameter the name “ReportTitle”. Its Data type should be String. Set the Prompt to “Report Title”. Click OK and close the dialog box.

Drag a new text box onto the report header area. Right-click on it and choose the Expression option. In the Edit Expression dialog select Parameters. Double-click on the ReportTitle parameter. This text box will now display the value you pass to the Report Title parameter.

268-ScreenShot18.gif

Switch to the Preview tab and try it out.

Publishing your reports

Up to now, you have been running your reports in the Visual Studio 2005 environment but, to make them useful, you must publish them to a report server. The easiest way to do this is to have Visual Studio publish your reports.

Start by right-clicking on Project in the Project Explorer and choose Properties.

268-ScreenShot19.gif

Set TargetServerURL to the URL of your report server. Use the TargetReportFolder property to set up a folder for your reports. If the folder does not exist, the Publisher will create it for you. The other key thing to pay attention to here is the OverwriteDataSources property. When this property is set to “True”, it will automatically copy over all your data source objects when you publish. When set to “False”, it will copy any new data source objects, but it will not overwrite existing ones. This is important when dealing with development, test and production servers. You can publish a set of data source objects to each server, pointed at the correct database, and never have to worry about what database your reports are hitting in each environment.

From the Build menu select Deploy Solution. This will publish the project to the selected folder on your report server. You can also deploy individual reports by right-clicking on the file in the Solution explorer and selecting Deploy.

Once your report has been published, you can access and run it on your server through the browser at http://<servername>/<reportservername>. From the Home page, you should be able to find the folder you published to, with the reports in it. Select a report to run. At the top of the page you can enter any values for report parameters, and then run the report. From here, you can also print or export the report.

Wrap up

That’s everything you need, to build a very basic report. In the next articles we’ll get into adding some more advanced options such as drill-downs, sorting and custom functions. Stay tuned.

Keep up to date with Simple-Talk

For more articles like this delivered fortnightly, sign up to the Simple-Talk newsletter

Downloads

This post has been viewed 941496 times – thanks for reading.

Tags: , , , ,

  • Rate
    [Total: 1351    Average: 4.1/5]
  • Share

Steve Joubert

View all articles by Steve Joubert

  • Anonymous

    Reporting services
    Great article. A must read for anyone hinking of starting SSRS.
    Munir Syed

  • Anonymous

    Reporting services
    When is Part 2 published?

  • Anonymous

    ReportingDemoDatabaseScript
    Hi

    Just a note to let you know that when I tried to run the script SQL said the database needed to be at least 3MB in size.

    I changed the size in the create database command to 3072KB and all went well.

    Alan Browne

  • Anonymous

    Parameters
    Is there a way to pass parameters via querystring?

    I want to call the report froma web page that has parameters that user will select to run the report?

    Thanks,
    anabhra

  • Anonymous

    Parameters
    Never mind I figured it out. Now I need to find out how to hide the top header row in the viewer ..the section that displays the parameters…
    thanks,
    anabhra

  • Anonymous

    parameters
    Sorry for so many posts but I figured that out that one too!

    This article has been a great start for me.

    Thanks,
    anabhra

  • Anonymous

    Next Installment
    Brilliant tutorial, is making a lot of sence and i am learning a lot.

    Thank you

    When is the next part due to be available??

  • Tony Davis

    re: next installment
    Apologies for the delay in publishing part 2 — it will be up on the site early next week (Monday or Tuesday).

    Cheers,

    Tony (Simple-Talk Ed.)

  • Anonymous

    Reporting Service 2005 and headers
    Hi all,

    Header and Footers do not take fields related to a dataset. I have to make them refer to databound fields that are located within the body.

    When my databind control does not arise, my Header connected to this control is not posted.

    It is normal, but it is my problems

    Let’s take for example of invoice:
    – an invoice of 30 lines with a pagination of 10 lines per pageµ
    – a table of Totals which follows my first table containing the lines of my invoice.
    – The header contains the address of the customer to be invoiced (the posted infos are connected on the first table)

    If I arrive on the page 4 which posts the totals, I do not have any more the address of the customer who posts himself.
    On the 4th page, the header of the table of details is not repeated as there is no more row to display; therefore the header of the report doesn’t hold any info anymore.

    Do you have an idea ?

    Thanks

  • Anonymous

    Thanks
    Foi de grande valia, parabéns pela iniciativa.

  • Anonymous

    SSRS – good tutorial
    An easy to follow tutorial. Thanks Steve
    Zavier

  • Anonymous

    Excellent Job
    You have done a fantastic job for newbie like me to start off. Thank you very much.

  • Anonymous

    important steps missing
    I really appreciate this article,
    However very important step missing from part one
    when setting up a shared data source . You do not mention the initial catalog which is required

  • Anonymous

    Selecting Report DataSet
    Hi, Great Article!!!
    Could you help-me to find a solution to my problem?

    I need to make a report where I can switch among more or less 15 DataSet with diferents servers and Sql Server Database name.
    The report will always be the same, just the DataSet will change.

    Thank you a lot!
    Lucas Almeida
    lucas.almeida@conductor.com.br

  • Anonymous

    Very Helpful
    Thanks!

  • Anonymous

    Reporting Service
    very help full article.

  • Anonymous

    Reporting Services
    It’s just great article. Thanks for keeping streamlined all things.

  • Anonymous

    Reporting Services
    Good Job Steve. Keep up the good work.

  • Anonymous

    Reporting Services
    This is a great article, everyone must read it to learn SSRS.

    Best Regards,
    Rami Zaitoun

  • Anonymous

    Reporting services Table Prob
    hi,

    i have used a single tablw with number of headers which used to return values. But loading of design took much time at last its saying file corrupted. Pls do help me.
    Thanking u.

  • Anonymous

    report header
    The page header and report header cannot be the same. I want to know, how we will design the report header (Which will display only in begining of the report)

    If somebody knows Plz let me know.
    Venkateshwar Rao Gunlapally

  • Dayashankar

    Reporting services
    Best way of step by step learning Reporting services. Easy and Friendly tutorial.Thanks a lot

  • Anonymous

    passing parameters
    hi all can any body help me to pass parameters(more then one) in the report with the querystring
    i have a form in wic i am selecting the fields…and i want the parameters to be passed in the query string and report be generated with those parameters on the click of mouse.
    Mail me 2 vijaymann1@gmail.com
    thanks

  • jasoncsunde

    Reporting Services
    I think that this is a great article for anyone starting out with Reporting Services.

  • Anonymous

    Setting Margins
    how to set the header and footer margins?
    i set it in the sql report 2005 and when i export it to the excel the parameters dont hold thier margin values, passed through the report.

    please advice.

  • Anonymous

    hi
    hi very good and nice article

  • Anonymous

    hi
    can you please post some advanced articles on reporting services like grouping and filtering

  • Anonymous

    Report header v.s. Page header
    You are using report header/footer and page header/footer interchangeably and there is a big difference. a report header/footer doesn’t repeat on every page.

  • Arul

    Is there a way to pass parameters via querystring?
    Is there a way to pass parameters via querystring?

    I want to call the report from a web page that has parameters that user will select to run the report?

  • Anonymous

    Hi anabhra..can you help me on this?
    Hi anabhra,
    can you help me on this?

    Is there a way to pass parameters via querystring?

    I want to call the report from a web page that has parameters that user will select to run the report?

    Thanks,
    Arul

  • Anonymous

    thanks
    Hi anabhra,
    thanks for your explaining.
    it’s very helpfull for me .

    Thanks,
    Ayşegül

  • JChalouhi

    Thanks
    very helpful thank you,easy to apply and easy to learn.thank you very much,keep it up

  • charbel

    Thanks
    a very good way to learn and start deploying SSRS projects.
    good explanation and deep details
    thanks

  • Akbar Ali

    Good starting point to learning SSRS
    hi

    A good start of learing SSRS and also the deployment, a nice article for starters, looking forward with next version with new aspects and deeper details.

  • Anonymous

    One request
    I will be happy if the article contains coding part, rather than connecting to DB manually and creating reports. Please substantiate with code examples.Looking forward for the best

  • Ruja

    Need One Solution
    Hi,
    Good article but can anyone tell me how to pass parameters to query from visual studio web form?

  • Anonymous

    Beginning SSRS 2005 Part 1
    Under deadline pressure, and after 2 months of hairpulling, I still couldn’t get the sample DB/DW (from MS Online Books Help), nor the sample DBs from the Microsoft Press book (“SS 2005 RS Step by Step”)configured so I could follow along with the examples. (Nor was any tech support available from Microsoft.) Your article truly does make it simple: in 2 days I had a prototype report to show my boss! I cannot thank you enough.

  • R Suresh

    A Gift to those worried about implementing RS
    This came as a candle light when i was groping in the dark for a solution for implementing RS for our project(Tango- Taxcut2007).

    Thanks Steve. Hats off to you.
    R Suresh

  • Anonymous

    Dataset using .net Application
    Hi Steve,

    Could u pls help me in this? I am trying to create dataset using .net application and it will automatically connects to the source database and creates a dataset for the report. User’s need not to create a dataset for the report.

    Is it possible? If Yes, what are the steps and procedures to achive this?

    Thanks

  • Anonymous

    Formatting a Matrix Report
    Hi Steve,
    Thanks for your wonderful articles that have helped us a lot. But, I am still looking for something to format my Matrix Report with two row groups in it. could you please help us to know how we can format (bold/ underline, background color etc) the Sub Total columns in a Matrix Report. Also how can we present the second row groups under first after a tab space? This will be a great help.

    Thanks
    Steve P

  • Anonymous

    3 rd and 4 th articles
    Hi Steve,
    I am not able to find your 3 rd and 4 th articles in this reporting series
    Thanks for your help

  • Anonymous

    3 rd and 4 th articles
    Hi Steve,
    I am not able to find your 3 rd and 4 th articles in this reporting series
    Thanks for your help

  • Anonymous

    summation of column
    hi steve,

    can you help me about reporting services on how to sum the coloumn and put it on a textbox… but the case is like this,

    Stud Name Fee Name Fee Amt. Amt Paid
    John Doe Registration 1000 1000
    Tuition Fee 5000 3500
    1500
    Jane Bake Tuition Fee 5000 5000

    when i aggregate the Fee Amt. using Sum function i get the result of 16000 because john doe break his payment in to two. any help would be appreciated. tnx

  • Anonymous

    Hi anabhra/Arul..can you help me on this?
    Hi anabhra/Arul,
    can you help me on this?

    Is there a way to pass parameters via querystring?

    I want to call the report from a web page that has parameters that user will select to run the report?
    Mail me on swatiban@gmail.com
    Thanks,
    Swati

  • Anonymous

    How to get data repeated in the body
    I have placed required fields in the Report body for repeating data, but I am getting only one reocrd in the entire report. When I check with query, it has around 1400 records, but I am getting only one record in the report.

    Please help me out.
    Thanks,
    RaviPola.

  • Anonymous

    How to get data repeated in the body
    When I use Table in the body then I able to see all the data.

    But here I want to display without table. As I have placed database feilds in the design form only.
    Thanks,
    RaviPola.

  • Anonymous

    How to call Functions from SQL-2005 Database.
    I have created Database in SQL-2005 with Tables, StoredProcedures and Functions.

    By the time of Generating Report, I could able to call StoredProcedure but I did not able to call Functions in the same report.

    Please help me out on how to call functions and StoredProcedures in the same report.

    Mail me On ravi_pola2001@yahoo.com, ravipola2001@gmail.com

    Thanks
    RaviPola.

  • Anonymous

    Great article to begin with
    Great article to start off with… would recommend freshers to this article

  • Anonymous

    Nice one
    clear step through, simple, basic but that what you need if you are a beginner.

  • Anonymous

    chart sizes
    how can we make the chart sizes interactive?
    I mean, how to change chart size based on the parameter selected by the user?
    The page size is good since I can give interactive size 0;0 which does the job, but not the chart size?
    Can you help me with this?
    Thanks a lot.

  • Anonymous

    Formatting subtotals in matrix report is simple
    For all those who want to some extra formatting Matrix Report – the trick is the InScope() function. I have a matrix report with 2 column groupings and one row grouping and I wanted to show a different color in subtotals and even make them bold, all this can be done using this inscope function.
    For background color – select the text box properties and then select background color property and click expression and write this -> =iif(inscope(“matrix_columngroup2″,”white”,”yellow”)

    This will put the background color yellow for the text box in the subtotal and the regular information will have white color.

    You can do the same thing for the Font Weight property too.

    Hope this is helpful.
    Cheers.

  • Anonymous

    How to load a parameter value depending upon user rights ?
    In my reports i want to load the list of countries as a parameter depending on the user logged in my asp.net application. For this i need to pass UserId as parameter from my .aspx page. How will i achieve this?

    mail me ratheeshn@gmail.com
    Thanks in advance

  • Anonymous

    Reporting Services
    hi all
    My probelm is i ve generated the report but i ve to pass parameters from a browser to reporting services

    main idea it should not b using url parameter passing or any source code
    I want the procedure for passing parameters directly from a browser to a reporting services

    If Any body knows kindly reply me or mail me

    chandusripathi@gmail.com
    or contact me 9885331312 at any time thank u bye

  • Anonymous

    Formatting subtotals in matrix report is simple
    Hi all,

    I have a matrix report.
    I am trying to make my subtotals bold, as well as add an extra line under my first row.
    I tried the Inscope function but it gives me an error “Wrong number of arguments.”

    mail me
    zaraivanova@gmail.com
    Thanks

  • Anonymous

    About passing parameters to Sub-Report
    How do u bind a main report to subreport
    and how do u pass parameters for the same

    mail me
    gauri.avarsekar@gmail.com
    Thanks

  • Anonymous

    Great Overview – But how about a specific issue…
    How can you lock the summary lines, so that when you are using the drilldown capablilities of the reporting tool you don’t loose the column headings?

  • Anonymous

    Great!
    I’ve been asked to work with Reporting Services for the first time… Your explanation above is absolutely great in terms of the basics that you need to know to get started.

    Thanks a lot!

  • Patrick Index

    Superb
    Superb article. Very helpful. Thanks

  • Anonymous

    Report Server won’t start
    Why did my SSRS Server won’t start ? I’ve already try it many times from configuration manager, but it still not work. Can anyone help me ? Thanks

  • Anonymous

    Passing Parameters
    Can anyone explain how to pass parameters from a asp webpage to the report server please.I see ther are a few similar posts here maybe you guys could help

  • Anonymous

    very good!!!
    very good!!!

  • Steve Joubert

    Passing Parameters Answer
    Hello all. When you installed SSRS it created two websites Reports and ReportServer by Default. Navigate to the ReportServer website. You will see a list of folders. Open the folder with your report in it. Find the report you want and open it. The screen will come up and prompt you for parameters. Let’s say that your report needs a CustomerID. Simply ad this as a querystring value to the URL “&CustomerID=1516” and refresh the page. If you pass all of the required parameters to the report it will run automatically.

    Alternatively if you are using the ReportViewer Control in VS2005 you:

    1. Reference the Microsoft.Reporting.WebForms namespace
    2. Create a collection of ReportParameters
    3. Create the individual paramenters
    4. Pass the parameters to the SetParameters() function of the ReportViewer.

    using Microsoft.Reporting.WebForms;

    List<ReportParameter> parms = new List<ReportParameter>();

    parms.Add(new ReportParameter(“CustomerID”, 1516));

    ReportViewer1.ServerReport.SetParameters(parms);

    I hope this helps.

  • Anonymous

    report Services
    it is excellent for the beginers.
    i tis very nice.

  • 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.

    I have given the full control to the folder itself, still it is giving the same error.

    Please reply to

    j.selvakumar@gmail.com

    Thanks

  • Anonymous

    report header/footer
    Hej
    any one can explain me how to make a report header/footer? i do not mean the page header/footer, but i mean somthing that appear just in the start og the report and the end of the report.
    kindly mail me at aborouaa@gmail.com if you know the answer or a link to a good article aboute that.
    thanks

  • Anonymous

    Problems in connecting to Reporting Services
    I still had problems connecting to reporting services. Although I selected Service Credentials as per this article, when it was trying to connect from SQL Server Management Studio, it was trying to logon using Windows Authentication – my user name. I had already tried the aspnet_regiis bit with my user id. I read this article and tried it with ASPNET as the user. I thought that this might have been it since in the SQL Server Configuration Manager the Web Service Identity is ASPNET. However, it still did not work. What finally solved it was going in to the SQL Server Configuation Manager and changing the Windows Service Identity from the default of Built in Account localhost to Windows Account and entering my User Name. I think that there was some extra bit during that which I forget.

    Are there any implications for what I did? Is there another way around this?

    By the way I am running on XP Professional with IIS 5.1. I installed SQL Server, SSAS, and SSIS before I installed IIS and SSRS. I am using .Net v2. My PC is a 32 bit.

  • Anonymous

    Great Article
    It is a great article for any beginner as it gives you the basic knowledge of generating the report and rest can be done by doing a more research

  • Anonymous

    Thanks a Ton !
    Gr888888888888 Work !

  • Manju

    SSRS
    Articel is really nice thank you for your information on SSRS

  • shullz

    Thanks
    it helped me alot.

  • Anonymous

    Nice Article
    You got me excited to start learning SSRS. I’ve been using Crystal Reports for many years but am very involved now with SQL Server 2005. Loading SSRS over the weekend to play.

  • Ash

    Thanks
    This article was of great help for me. Thanks. I am quite comfortable with creating reports now

  • Bharat

    How to use three or more datasets with a single table.
    I have to use three datasets with the same table and also use fix header proprty of the table. I am having difficulty in achieving this. Can you please help me.
    My e-mail addrees is bpgadhia@yahoo.com
    Thank you in advance.
    Bharat Gadhia.

  • Anonymous

    Passing Multi-Valued to SetReportParameters
    Can anybody help me with some code example how to pass multiple values to a Multi-Value parameter with SetReportParameters.

    johans@synaxon.co.za

  • Venkateswarlu.Ch

    Reporting Services
    It is most useful for beginners .This article was of great help for me. Thanks.When is Part 2 published?

  • Anonymous

    Bandwidht wastage
    Hi

    Nice article,I had a doubt when i pass the dataset to reports via coding in local mode,it hits the reporting service or not,if it will hit means,the net connection is needed or not, if needs bandwidth is reduced or not.

    Murali
    murali@ibpm.net

  • Anonymous

    Passing parameters to reports
    I am trying to pass a parameter to a Reporting Services report written in Visual Studio 2005 from an application also written in Visual Studio 2005 and it just isn’t working. The report is called from an xml page like so:

    openWindow(‘http://path?itempath=%2freport+name%26parm=value’)

    where %2f and %26 are the hexadecimal representations of “/” and “&”, respectively. But when I click the link, although the report appears, my parameters are not populated. Has anyone had this problem? I would appreciate any advice. Thanks.

  • Yazan

    Q
    How to do grouping in the table as the matrix … is it possible or not ??!!!

  • Chandan Koushik

    deploying a report(through vs2005)
    Hi Steve,
    i want to programatically deploy the report in VS2005 environment,ie.from an asp.net page if i click deploy report Button ,the report should be deployed into the report server automatically.So that i can view the report in report server.
    the input to the asp page would be the.rdl file…
    If anyone could help then it would be good.
    thankyou.
    you can reply back at chandan_koshik@yahoo.com

  • Abhijit Ramani

    Matrix Average Column/Sort/Formating
    Have a matrix report with 2 column SaleAmount and ProfitAmounts by Month like

    Sale Profit
    Dealer May June July May June July
    A 100 200 300 20 25 15
    B 200 250 50 30 45 19

    how can i do following 3 things

    1)Add Total column for Sale and Average column for Profit

    2)Always Sort report by lastMonth of Sale (here 7/1/2007) High to low

    3)if last month of sale(here 7/1/2007) is less than second last month here (6/1/2007) whole row should be red

    thanks
    you can reply back at it@mobileistic.com

  • kiran kharat

    Error of running report server
    when i run report server project it gives following errors.
    rsServerConfigurationError,login failed,& a connection could not be made to report server.

  • kiran kharat

    Error when running report server
    when i run report server project it gives following errors.
    rsServerConfigurationError,login failed,& a connection could not be made to report server.
    i tried more options but still gives errors so please help me. you can reply back to me at
    kharatkiran1@gmail.com , kkharat@mtuberall.com

  • Sumitra

    Passing parameters using querystring from a C# ASP.NET Web Page
    I am using the reporting Serive and want to use the ASP.NET page on my website to display the report. I want to pass a startdate and enddate through a querystring to the report so it displays the report when the page rendered. I do not want the page to wait for the users to enter a value. Please email me at a-ssheth@microsoft.com

  • Sumitra

    Passing parameters using querystring from a C# ASP.NET Web Page
    I am using the reporting Serive and want to use the ASP.NET page on my website to display the report. I want to pass a startdate and enddate through a querystring to the report so it displays the report when the page rendered. I do not want the page to wait for the users to enter a value. Please email me at a-ssheth@microsoft.com

  • Anonymous

    creating dynamic c
    i have created a report to display a table and its chart. The problem is how do i create the chart based on the users requirement? (have given a drop down for line, column and pie chart). So the question is how do i create a dynamic chart?
    please mail me at shaunaqsingh@hotmail.com

    ps: a great read for newbies.

  • Anonymous

    Matrix Average Column/Sort/Formating
    I have the same question as Abhijit Ramani. Does anyone know how to add an Average column in a Matrix report.

  • Daniel Ranger

    General Comment
    I’m just starting to look at SSRS and your article is *very* helpful.

    Much appreciated.

  • Anonymous

    Question
    Hi Steve

    I was not able to highlight single column in report viewer in Preview mode. Is there any property that sets as read only. Thank you for your time.

  • Anonymous

    Question
    Hi Steve

    I was not able to highlight single column in report viewer in Preview mode. Is there any property that sets as read only. Thank you for your time.

  • Anonymous

    drill down
    It would be great if you would demonstrate how to do a drill down from a summary screen to a detail screen.

  • Bennyboy

    Re: Formatting subtotals in matrix report is simple
    The InScope code that was mentioned is missing a bracket – it should be =iif(inscope(“matrix_columngroup2″),”white”,”yellow”) – note bracket after _columngroup2″.

    However that expression didn’t work for me.

    But I figured out that if you right-click on the little green triangle on the Subtotal title cell and select Properties, these properties affect the actual Subtotal value cells, as opposed to the Subtotal title cell itself. You can change things like background colour and font to your heart’s content 🙂

    Hope this helps – it took me a while to figure this out. Maybe I should read a manual one day :/

  • dola.mangaraju@gmail.com

    I want to know that How we call the SSRS in Web Applucation in easiest way?
    Greetings to Authour from Dola India. Sir, really it’s very helpful to beginners like me. I am very happy to give a big compliments to you. Thank You so much
    Sir, I want to know that How we call the SSRS in Web Applucation in easiest way? Can U please send me the article on this issue

  • Kaushal Patel.

    Wrap Text in Excel Sheet.
    How to wrap text in particular Column of Excel sheet. I have set ‘CanGrow’ property to True.
    but its not working properly.
    Any1 have soln?

  • Kaushal Patel.(patelkaushalk@gmail.com)

    Repeat Table Header on Next Page.
    How to repeat Table Header on Next Page.?

  • Geoff

    thanks
    I was looking all over for information about tables displaying data set info. Your article was an oasis.

  • N Talwar

    Got me started!
    Very nice for us newcomers to RS. Thank you, and I’m looking forward to reading the sequels.

  • Anonymous

    What abt with windows authentication
    I did same steps using windows authentication. report generated successfully in preview but it was not deploying. i.e., while deploying report it is asking for username and password..how to rectify this problem. mail me to prasanna.ank@gmail.com

  • Ronak A. Shah

    Explained very nicely
    Explained very nicely

  • Sena M.

    Excellent Article for Starters
    I was looking for a no nonsense tutorial to get started on SSRS and this article is just that.

    Please continue your excellent work.
    I eagerly await the next part of the series.

  • Anonymous

    drop down list in rdl report
    Plz help me out how to display a drop down list in rdl report which is filled by stored procedure & again we are fetching data from database based on the value selected in the drop down list.again with the use of stored procedure.

  • Anonymous

    Report Parameters and the Dataset Query String
    I have a Dataset in my report which requires calculations based on the Report Parameters, before running the result query.
    Is this possible?
    Or are the Report Parameters only available through expressions?
    I do not want to use an expression for a number of reasons, including (but not limited to) the query being complex.
    If anyone has an info on this, it would be most appreciated.
    Thanks.

  • Anonymous

    Report Parameters and the Dataset Query String
    I have a Dataset in my report which requires calculations based on the Report Parameters, before running the result query.
    Is this possible?
    Or are the Report Parameters only available through expressions?
    I do not want to use an expression for a number of reasons, including (but not limited to) the query being complex.
    If anyone has an info on this, it would be most appreciated.
    Thanks.

  • AnvieK

    Thanks a lot
    your article is really helpful. Thanks a lot…

  • appalaraju@satyam

    Even beginers can do Reporting Services configuration
    This is good article on Reporting Service

  • kamal101

    multiple columns
    how to get multiple columns in a srs report.
    i set 2 columns to Report Properties in Layout and i set also the body width, then when i preview, or run the report, it doesn t display 2 columns but only 1.
    thanks for help

  • Domingo Asuncion

    Very Good Idea!!!
    Thank you very much, i learn it so much and god bless..

  • N.R.SENDAS KESAVAN

    BEST FOR BEGINNERS!
    Really the Article posted is best for beginners. Thanks for posting the Article.

  • Sudha

    Code Download Link
    I am not able to download the code. The link downloads a html page.
    Can you please provide me link to download the code?
    Thanks!

  • Anonymous

    part -2 where
    good

  • Leong

    It a best tutorial for the beginner.
    The article is ease to understand and a clear way to start a simple report.
    Thanks.

  • Anonymous

    How to pass a sql query string to sql reporting services
    please help me on this that how to pass a sql query string to sql reporting services

  • techbabu303

    Nice Article
    Got me working !!

  • Anonymous

    Formatting & Target server url
    Basic formatting chosen does not seem to work. For example if there is a datetimestamp and we just want the date format, chosing a sample 1/8/2000 does not seem to work.

    Can you also help me find the target server url
    and its association with iis please

  • Bistesh Jois

    BEST Tutorial
    This is one of the best tutorial to lears SSRS with example. This helped a lot. I’m having one more question . Can this report be conected with sharepoint list items??? If so please help me. I want to get report from SharePoint List.
    bistesh_jois@yahoo.com
    Thanks
    Bistesh

  • JT

    regarding multiple datasets and parameters
    I have a query with a parameter being passed in. Something like:

    select myvalue from mytable where myparam = @param

    This query needs to be used multiple times in the report, and the only difference is the value of @param. I have researched extensively, but have not found a way to pass in the parameter from the report (not from the url). I.e., I would like to be able to do something like:

    = SUM(Field!myvalue.value, “mydataset?param=1”) (or something analogous) for the equation, where I am passing in a value for @param. There are multiple situations (dozens) where, if I can’t do this, then I literally have to have datasets where the only difference is the value of @param. So I would end up with something like:

    dataset1: select myvalue from mytable where myparam = 1

    dataset2: select myvalue from mytable where myparam = 2

    etc, etc.

    This is, to say the least, immensely cumbersome.

    Any ideas? Does this make sense?

    Can anyone answer my question

  • Newbie

    Matrix subtotal
    I have a matrix with some data in Row group.
    i want to do something like Total+A-B in the Subtotal of the Row group.

    And, i also want to highlight the subtotal row.

    hope you help me out.
    thanks in advane!!
    please mail me @hsnuguri@gmail.com

  • Newbie

    Matrix subtotal
    I have a matrix with some data in Row group.
    i want to do something like Total+A-B in the Subtotal of the Row group.

    And, i also want to highlight the subtotal row.

    hope you help me out.
    thanks in advane!!
    please mail me @hsnuguri@gmail.com

  • Kasi Viswanadham.

    Very Helpfull to Beginers
    Hi Steve Joubert,

    I am very thankful to you.. it is very helpfull to beginers.

    Thanks
    P.Kasi Viswanadham.

  • Anonymous

    Abt aggregate function
    I have a porblem while using aggregate function.why cant we use aggregate functions in the SSRS report which contains Filters

  • Anonymous

    Abt aggregate function
    I have a problem while using aggregate function.why cant we use aggregate functions in the SSRS report which contains Filters

  • Sandeep

    How to Format multiple rows for Currency type
    How to Format multiple rows for Currency type

  • frikouflios

    Good tutorial
    Nice job Steve. I’m going for part 2 and i am very happy because many How-To was answered via your part 1…….

    I hope to complete all parts today!!!

    Keep writing partZ!!!

  • Justin

    Thanks
    Great article!!

  • Anonymous

    SSRS
    A great article, informative and accurate. It was a deeeeep breath of fresh air.

  • Pradeep D

    Reporting Services
    A Nice article. Good Work Steve

  • Anonymous

    Re: BEST Tutorial
    [quote user=”Anonymous”]This is one of the best tutorial to lears SSRS with example. This helped a lot. I’m having one more question .
    bistesh_jois@yahoo.com
    Thanks
    Bistesh[/quote]

  • Anonymous

    SSRS
    Thanx Steave, You have given a very easy way for beginners.

  • Anonymous

    SSRS
    Thanx Steave, You have given a very easy way for beginners.

  • Anonymous

    Error
    Dear sir,
    Please explain, how to validate start date and end date

  • Buddika

    Thanks
    I’m new comer for SQL Server 2005 Reporting Services.this article valuble for me.
    Nice article. Thanks a lot.

  • Anonymous

    DrillDown in my report
    I want to drill down in the report. can u plese explain me how I can do that

  • Anonymous

    Good……..
    hi all ,
    iam new for ssrs reporting services…this article is very useful for begginers who are working on reporting services.

  • Debraj

    Do not want Report Header to apear when exported to excell ?
    Hi,

    I do not want my report header to apear whenn taking export to excell. Header is causing merged cell in the excell. These merged cell is preventing me to use sort option in excell.
    Does ay one have any sugestion for this problem..

  • srikant

    Good…………….
    Hi,

    It’s nice to see such articals. It gives lots of infromation about SSRS what i am look for.

    Thanks

  • Roopesh Babu V

    Good Job
    Hi..

    Really useful one…can u add more things here in next part….

    Thx a lot man…

  • Anonymous

    good job
    kudos!
    A very educative piece of information.

  • Anonymous

    Good job
    I learned so much thing from this article. Thank you for you done. Really useful for me.

  • Anonymous

    Parameter issue
    Has anybody been able to solve the “passing parameters before the report is rendered issue”? Please email me @ kunminik@gmail.com

  • shravan kumar

    good job
    It is very good article and really useful for me .
    thanks a lot.

  • Pavan

    When part 2 cuming up
    When is part 2 cuming up …

  • Arjun

    Very informative and waiting for part-3
    Hi,
    I have more clear after reading this article.
    Regards,
    Arjun

  • Rajesh

    parameter prompt
    hi,
    i have a report paramter and while displaying the parameter i want to show a long message to the use (warning: eg; ‘Do not use the select All option. Select only a few values’). Can i make this appear in two lines while displaying.
    Any suggestions.
    Regards
    Rajesh

  • Anonymous

    tq
    its great artical for Beginner.

  • Shas77

    It so much hepful!!
    Thanks a lot.
    Only one problem not at all worth mentioning is I was not able to run the ReportSampleDBDemo

  • Anonymous

    Excellent Tutorial
    I tried two expensive books, including Microsoft’s own, without success. This tutorial makes it really simple to understand the fundamentals and provides a foundation on which to build. The author has put himself in the shoes of the beginner and has done a truly outstanding job. The sign of a good instructor is not how much he knows, but how well he imparts that knowledge to others. Congratulations on an excellent tutorial. And my heartfelt thanks as well.

  • Anonymous

    Custom report run from SQL server 2005 which has a parameter
    Can anybody help me out to run a custom report (.RDL) build in Vb.net 2005 from SQL server 2005 custome report option? .RDL has a parameter which is in the query of a store procedure and the store procedure called by the .RDL. For your information the repot is running absutely fine from the vb.net 2005 and also passing the parameter correctly.

  • Anonymous

    Custom report run from SQL server 2005 which has a parameter
    Can anybody help me out to run a custom report (.RDL) build in Vb.net 2005 from SQL server 2005 custome report option? .RDL has a parameter which is in the query of a store procedure and the store procedure called by the .RDL. For your information the repot is running absutely fine from the vb.net 2005 and also passing the parameter correctly.

  • Anonymous

    Custom report run from SQL server 2005 which has a parameter
    Can anybody help me out to run a custom report (.RDL) build in Vb.net 2005 from SQL server 2005 custome report option? .RDL has a parameter which is in the query of a store procedure and the store procedure called by the .RDL. For your information the repot is running absutely fine from the vb.net 2005 and also passing the parameter correctly.

  • Anonymous

    Custom report run from SQL server 2005 which has a parameter
    Can anybody help me out to run a custom report (.RDL) build in Vb.net 2005 from SQL server 2005 custome report option? .RDL has a parameter which is in the query of a store procedure and the store procedure called by the .RDL. For your information the repot is running absutely fine from the vb.net 2005 and also passing the parameter correctly.

  • Amit Kumar Dhuper

    Reporting link with password connectivity
    Hi

    I like to go one report to another report however I click on link so it is possible any pop up window will come and I will enter the password then another report will show.

  • Amit Kumar Dhuper

    Reporting link with password connectivity
    Hi

    I like to go one report to another report however I click on link so it is possible any pop up window will come and I will enter the password then another report will show.

    Please mail me amitadmin@gmail.com

  • Anonymous

    Great article
    Best article for beginning SSRS I’ve read, very helpful, thanks a lot!

  • Anonymous

    Great Article.
    I was able to create my first report with so much ease. Thanks a bunch!!

  • Anonymous

    Thanks!
    Excellent, to-the-point article for beginners.
    Thanks!

  • Anonymous

    Second part
    when is the second part coming???

  • Anonymous

    Thanks
    Wonderful Article !!

  • srikanth Ravipati

    Matrix
    How we can create reports using matrix instead of tables,Could u please help me.

  • Hiren Dave

    Thanks
    Can we use it in situation where data is dynamic.Means in datasource number of tables are differrent each time.

  • santhosh

    thanks
    it was really helpul creating reports in sqlserver 2005.

  • DotNetGuts

    Good work
    It was nicely explained. Thanks.

    DotNetGuts
    http://dotnetguts.blogspot.com

  • Anonymous

    Explanation very much clear
    Thanks, I was looking a starting point in reporting
    services. This is great starting point.

    Anupam Gupta

  • Anonymous

    Explanation very much clear
    Thanks, I was looking a starting point in reporting
    services. This is great starting point.

    Anupam Gupta

  • pazzo

    Good
    It was nicely explained. Thanks…

  • Anonymous

    Sajith
    Really a gud article on SSRS..thanks dude..

  • vishal s.surana

    display purticular records on per page
    Nice tutorial for sql server report.

    I want to display purticular records on per page.
    How to display please tell me.

  • Nishith Mohan

    Excellent
    Excellent article on SQL Reporting services to start with

  • Sera White

    Awesome Article
    I am so happy I found this article. I was starting to get really frustrated. I kept thinking “this has to be possible”…
    Thanks so much for spending the time to write this!

  • Anonymous

    Adding header in matrix
    How to add a header name in matrix.I have 3 rows there

    please mail me @ majuleo@gmail.com

  • Anonymous

    Charts Report
    When working with Chart reports which is using multiple datasets to generate different charts, there is a problem with refreshing. If we click on View Report button report is not generating, it is generating when we click on Refresh Button. When I checked it is updating all the datasets, how to fix this. Please mail me to
    bvsssrao@dhanushinfotech.com

  • Rupesh Mondal

    ssrs
    Great Article. we will wait for the release of such great articles again and again.It is graphical and step by step which is the plus point
    thanx

  • Raj

    SSRS
    Superb article for biggeners

  • Anonymous

    Good
    Good.

    Where to find the Part 3 & Part 4

  • Anonymous

    good
    good

  • Anonymous

    Can pass parameters with a popup window?
    Thanks for the article. I have a question for all:
    Is it possible to pass a parameter with a popup window? i.e. when the user double click the input textbox, a popup window show up and let the user do some searching, then when the user select the option, the selected paramter automatically entered in the input textbox. Is this possible? any comment is appreciated.

  • Rohit Vankamamidi


    Its a very good tutorial…it has helped me a lot in understanding SSRS…keep up the good work

  • Anonymous

    hi
    Graet Tuts …Add some more to this like passing parameters to report

  • Abdul Qaium

    SQL RS Part 1 is Excellent
    It is simple and written like a Simple Talk.
    I came to know lot of things on Shared Data Source. I will use this article in my first session of “Introduction to SQL RS”

  • suman the sexy guy

    good one
    really a good article

  • Amit

    Awesome article for SSRS beginners
    Thanks man..for this knowledgable article for SSRS beginners like me.

  • Srinivas

    Configuring Reporting Services
    Hi Friends,

    I’m a java techie. I’m new to SQL Server. Now we are starting a new project with SQL Server 2005 (Linked server, Reporting Services) with Java (Standalone Application).

    Can any body reply me your great answers to move forward in dealing with Reporting Services.

    I’ve stucked from the last one week to find out exact answers on these:
    –> Is it possible to interact Reporting Services with Java Standalone application (I know how send a http request to a RS Server from Standalone application)?

    –> What are the pre installation softwares(like IIS, ASP.NET, etc…) to install MS SQL Server 2005 and Reporting services.

    –> Can anybody give me a brief PRIOR and POST configuration steps for Reporting Services. (yes, I tried with many more links from google. but not succeeded in the configuration of Reporting Services)

    GREAT THANKS IN ADVANCE EVERY BODY!

    Best Regards,
    Srinivas.

  • girish

    hi
    hi

    can any one provide links for part 3 and part4
    i have git links for part 1 and part 2

  • thrustuponsql
  • DamianS

    Can anyone explain what I’ve done wrong?
    This series of articles looks exactly what I’m looking for. I’ve got all the necessary applications running on my laptop but the ‘Report Wizard’ does not appear as an option when coming to ‘Add new item’.
    There must be a connection or link I missed.
    Report Manager appears to be running fine

  • brendans

    Advanced reporting from SQL in .net environment
    Initially, we integrated with reporting services, but as things have gone towards SaaS applications at the end user level, we recently integrated this designed for OEM product with great success, if you are looking at extending reporting services, take a look at these guys too…

    http://www.izenda.com

    Cheers!

  • chandru.pal

    Simply Superb!!!
    First of all, thank you for posting a simple and neat article. It saved me much time. Thanks a lot. I still have to go through the other parts of this article. Definitely they will be useful to all.

  • vani_r14

    Having Two Table Headers
    Hi

    I am trying to design a report where the SQL bit has two case statements.. The first case statement has been put into a table with a header and details. However for the second statement I would like to do the same have another header and detail section in the same report but seperated. Can you please tell me if this possible at all and if so how we could do this

    Thanks

  • meks

    Two or more reports combined in one report different headers
    I have a task to compare two data sources and generate reports based on the difference if any.

    The 2 databases are from different servers.

    I intend to do the following:

    1. Load data from source A into SQL database
    2. Create a view of source B data in the SQL database.
    3. Either create stored procedures to generate the difference results OR create views based on compare results using SQL queries.

    4 Use SQl reporting services to generate the reports from either the stored procedures or the views.

    Please can someone tell me if my above plan is workable? I am new to SSRS. After reading this article, i feel I can learn SSRS very quickly.

    Also, another problem is that I will have many views or stored procedures which will then generate different reports. Can SSRS allow me to combine the different reports in one report, possibly each report will have its own header in the same report.

    Please, someone should help.

  • meks

    Two or more reports combined in one report different headers
    I have a task to compare two data sources and generate reports based on the difference if any.

    The 2 databases are from different servers.

    I intend to do the following:

    1. Load data from source A into SQL database
    2. Create a view of source B data in the SQL database.
    3. Either create stored procedures to generate the difference results OR create views based on compare results using SQL queries.

    4 Use SQl reporting services to generate the reports from either the stored procedures or the views.

    Please can someone tell me if my above plan is workable? I am new to SSRS. After reading this article, i feel I can learn SSRS very quickly.

    Also, another problem is that I will have many views or stored procedures which will then generate different reports. Can SSRS allow me to combine the different reports in one report, possibly each report will have its own header in the same report.

    Please, someone should help.

  • meks

    my contact
    Please, responses to my request: Two or more reports combined in one report different headers should be to: meks@myself.com

    Thank you.

  • gtsenthil

    To Create Data source in report builder
    Hi

    I dont know how to create a data sources for a report builder.In report builder the data sources area is showing empty.
    Even i have tried to create a data source in report manager and sql server management studio.
    It is not creating. Is there any option to create Data source for report builder . Thanks in adavance.

  • faalli

    Group by Position
    Hi Steve,

    How can I move the Group by to show up below the rows it grouped vs. above the rows? My report has an amount column and I would rather see that total at the bottom of the grouped rows. I can do a Grand total in the Footer, but I cannot figure out how to move the group.

    Thank you
    Aliesha

  • faalli

    Re: Group By position
    HI Steve,

    I want to let you know that I found the solution on how to move the group by below the rows. It was pretty much a manual process. I recreated the detail and then add the Group now i’m going enable drilling..

    Thanks
    Aliesha

  • pravinshah

    Hi Steve, Great Article
    Excelent article to start learning of SSRS. Topics covered in a very simple language with example, great.

  • avinash.parate

    Hi Steve
    Good Article, easy to understand and much more easy to configure and implement .

    Thanks good help.

  • Vaibhav S

    Data Retrival from a SP having parameters.
    Hi Steve,
    Can u post some articles for viewing reports with parameters.

    Thanks
    Vaibhav

  • hieuhotrung

    Excellent
    Excellent

  • navkrishg

    Query on SSRS
    Folks,

    I ‘ve a question related to creating excel reports in SSRS 2005. We ‘ve scenarios to generate reports and export them in excel format, in which condition will be supplied to iterate a collection and each excel file needs to be created.

    For eg., if we ‘ve a table with store number s1 to s10, it should create each excel file for each stores like s1.xls, s2.xls…. in a particular path. We are doing this using .NET code. Just wanted to automate with SSRS.

    Is this possible in SSRS, can you please help me out?

  • Bala2010

    Brilliant
    Tutorial was Brilliant…Thanx.

  • braveali

    Reporting Service not working
    i am unable to Browse Reporting server ? Below is the Error

    http://localhost/Reports/Home.aspx

    An error occurred while parsing the configuration file. The ReportServerVirtualDirectory element is missing.
    Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

    Exception Details: System.Exception: An error occurred while parsing the configuration file. The ReportServerVirtualDirectory element is missing.

    Source Error:

    An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

  • cloudynet

    Excellent
    Hello Steve,

    Excellent blog, it was really very useful for me.

    Guess you too are “LOST” fan like me, the customer names in the db makes me say this.

  • DarwinPhuong

    Greate Article
    I’m new to Reporting Service. This is a great place to start. It took only minutes to learn. Thanks, Steve!

  • Ripu

    URGENT REQUIREMENT: SQL Server DBA |Jacksonville FL |3 months contract to PERM
    Best Regards:

    Ripu
    RipudamanSingh | Maccadin Inc. | Santa Clara, CA
    Phone (408) 372-0916 Office: (408)372- 6280 | Fax (408) 657-4692 |
    ripu@maccadin.com | http://www.maccadin.com

  • pradeep_a

    Very useful for begineers
    Good article Steve !

    can you explain the same with some real time scenarios like

    saving the PDF directly to the local drive