Formatting a Report (Reporting Services)

Based on the above example ( how to create a report ), I show how we can "format" that report for a more professional presentation using visual basic reporting services from. net.

Open the report on which will work, will be more or less like this:

formatoreporte001

The first thing to do is see if we have seen the two toolbars you need to format the report, they are: "Borders of the report" and "Format of the report." If they are not visible can enable from View / Toolbars.

formatoreporte002

To change the color of a table cell, select the cell and deploy the window background color from the Format toolbar of the report. Here we atodos web colors we use normally in windows forms.

formatoreporte003

We can also apply formatting to any cell edge of the table from the Borders toolbar of the report.

formatoreporte004

We can apply the font to multiple cells at once by selecting multiple cells and apply the formatting.

formatoreporte005

It is very useful option to merge cells. Select more than one cell in the same row and from the contextual menu (the one that opens when you press click the right mouse button) select the Merge Cells option.

formatoreporte006

For any text we want to appear on the report used a text box.

formatoreporte007

By default, when placed on the table a number field, this is aligned to the right. If you wish this can be changed using the Format Bar. In our case we use the Format function to format the number to the price. Price Botónderecho the cell and select Expression ...

formatoreporte008

The Edit Expression box is full, I recommend you give it a look, we use the Format function to format "Fixed" we monstrará numbers with two decimal places.

formatoreporte009

So you should see the finished report:

Hope this helps and do not forget that this is a base, is up to you to enhance these tools put much dedication and talent.

8 Responses to "Formatting a Report (Reporting Services)"

  1. Information Bitacoras.com ...

    Rate in Bitacoras.com: Based on the above example (how to create a report), I can show you how? Format? that report for a more professional presentation using visual basic reporting services from. net. Open ...

  2. Aldo says:

    hello friend I need to make a filter that meejor not display all data from my database only the user to enter in the textbox

    • Elisha says:

      To not display all records in a table you must modify the SQL command you use to query and add the where clause. More info here .

  3. cancuneitor says:

    And to place images in a report, the images are stored in the database as System.Byte () and I find as put in the report.
    How do you ago?

  4. Marialex says:

    Great! thanks!

  5. Tomas says:

    Great.
    If you have time you should do the same
    but for a WebsForm.

    Regards

  6. Carlos says:

    You can make an invoice for this purpose?? as I pass the parameters of the header and detail.
    Regards

    • Leonardo said:

      If possible there is the option to pass parameters pr code or by the visual environment such Report / Report Parameters, or from the properties of the type of graphics you will generate!

Comment