Add a field to a Visual Studio 2005 Report Services Report

In the Datasets area right-click on a DataSource and select Add.

Add Field

Enter in the Name of the new field and the Database field or Calculated field.

Add Field Dialog

Then we need to update the tie between the Dataset and SQL Server by clicking on the Data tab and selecting our Dataset in the dropdown and updating the query.

Comments

Post a Comment

Popular posts from this blog

ToMethodObject Refactoring

Image
I love refactoring code. To refactor code safely you need automated tests. Some code, especially code not written using Test Driven Development(TDD), make it difficult to write tests for the part of the code you are looking to change. Usually what you face are a class that has many dependencies, so in your test setup, you have to create all these dependencies to inject into the constructor even though many or perhaps all of these dependencies don't even have anything to do with the part of the code you are looking to change. Or the method that you want to write a change for is private and the calling public method has a bunch of dependencies which again many will not have anything to do with the part of the code you are looking to change. You are thinking: "If only this code was in a public method it would be so much easier to test". But you may have heard somewhere that changing the code just to make it easier to test is bad.  This is a terrible line of thought that has
Read more

How to unlock a file in Team Foundation Server(TFS)

To unlock a file in Team Foundation Server you have to issue the following command at the Visual Studio Command Prompt: TF UNDO filename /WORKSPACE:workspace;checkout_user /SERVER:servername Where you change the lower case words with your particular case.  For more information go here: http://weblogs.asp.net/dmckinstry/archive/2006/07/09/Undo-_2F00_-Unlock-for-Others-with-Team-Foundation-Version-Control.aspx
Read more

Show/Hide formatting text in MS Word 2010

Image
Was updating a MS Word 2010 document and coming from a WordPerfect background I like to see the formatting text when I'm editing. A quick search found this: http://answers.microsoft.com/en-us/office/forum/office_2010-word/view-hidden-text/0db765e8-0f42-476e-88dc-267eccdbf45b  That pointed me in the right direction. You click on the File  tab then click Options .  On the Word Options  dialog click on the Display  option on the left menu bar.  Then check the "Show all formatting marks" checkbox. Like this: Or if you only want to see specific formatting marks you can pick and choose between "Tab characters", "Spaces", "Paragraph marks", "Hidden text", "Optional hyphens", and "Object anchors".
Read more