Differences between Report Builder and Reporting Services
Part five of a seven-part series of blogs

Report Builder and BIDS (the Visual Studio add-in for creating Reporting Services reports) are essentially the same underneath their very different looking skins. This blog lists the small number of differences.

  1. Report Builder vs. Reporting Services - Differences
  2. Report Builder Difference 1 - Look and Feel
  3. Difference 2 - Report Builder 3.0 has more wizards
  4. Difference 3 - Creating Datasets in Report Builder
  5. Difference 4 - Expression Intellisense in Report Builder (this blog)
  6. Difference 5 - Using Report Parts in Report Builder
  7. Other Differences for Report Builder

Posted by Andy Brown on 07 November 2011

You need a minimum screen resolution of about 700 pixels width to see our blogs. This is because they contain diagrams and tables which would not be viewable easily on a mobile phone or small laptop. Please use a larger tablet, notebook or desktop computer, or change your screen resolution settings.

Difference 4 - Expression Intellisense in Report Builder

Weirdly, Report Builder 3.0 doesn't have intellisense built into the expression builder.  So here's an example of an expression in BIDS:

BIDS expression builder

Starting to create an expression in Visual Studio

Here's exactly the same expression in Report Builder 3.0:

Expression builder in Report Builder

Creating an expression in Report Builder

Given that everything else is the same, this seems odd - if anyone knows the reason, please let me know!  The net - and surely undesired - effect is that you need to know how to create formulae much better if you're using Report Builder.

This blog has 0 threads Add post