WiseOwl Training - Established 1992 Wise Owl Training

Established May 1992
30 years in business
Wise Owl Training
30 years in business
See 479 reviews for our classroom and online training
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