Archive for category: Blog

Many of you probably know that one of the Microsoft RS partners, Cizer, offers an ad-hoc reporting tool called Cizer Query (mentioned in my book).

Now, Cizer has released a report designer tool – Cizer Report Builder, as an alternative for authoring reports if you don’t have or want to purchase VS.NET. According to the vendor:

“Cizer Report Builder (CRB) 2004 v1.00 is now available.  Bringing full-featured production report design into the browser, CRB makes the rapid deployment of reporting with Microsoft Reporting Services a reality.  Cizer .NET Reporting now provides both ad hoc and production report design in a single web interface with zero client installation or download required.   Charts, graphs, parameters, images, calculations and formatting are now easy to develop and manage.  Other highlights include:

• Guided Report Development Wizards

• Links to Cizer Quick Query

• Access to Multiple Data Sources

• Drag and Drop Placement of Report Objects

• Local and Global Libraries for Report Templates, Queries and Parameter Panels

• Private and Public Report Sharing

• Saves as RDL Format Which Easily  Exports to Multiple Formats Including Excel and PDF

• Deploys to Microsoft Reporting Services to Support Enterprise-Wide Distribution

Cizer Report Builder is available for purchase on the Cizer website (www.cizer.com). “

Please let me know if you like Cizer Report Builder. Do you think that it provides a viable alternative to the RS Report Designer?

For those of you who would like to know what new RS features have made it to SQL Server 2005 Beta 2, here is the list:

• Ability to load report projects in the new SQL Server 2005 Intelligence Development Studio IDE. The consequence of this is important. You don’t have to purchase VS.NET anymore just to get the Report Designer because the Intelligence Studio IDE comes bundled with the Report Designer.
• Integration with the SQL Server Management Studio. The third toolbar button on the Registered Servers toolbox brings to the RS configuration. Now you have a single console to connect and manage the RS configuration properties, security, jobs and shared schedules.
• The Analysis Services MDX and DMX Query Designers that allow you to craft MDX and data mining queries in a graphical way. Those of you targeting Microsoft Analysis Services will probably appreciate these two designers. Both designers operate in design and query modes similar to the Graphical and Generic Query Designers included in version 1.0. When used in Graphical mode, the designers allow you to drag and drop dimensions and measures to the query pane to make the tedious task of authoring MDX queries much easier. In addition, Analysis Services 2005 supports parameterized MDX queries and you can declare any dimension member as parameterized. If you have time to play with SQL Server Beta 2, check the new query designers. They really rock!

The rest of the RS new features will be included in SQL Server Beta 3 scheduled to be released around Q2 2005.

I highly recommend you start evaluating SQL Server 2005 as soon as you can. There are so many new and cool features that it may take you months to go over them. On the downside, you need a beefed up testing machine. Based on my experience, the Beta 2 performance is far from being optimized. Loading the Books Online, Management and Intelligence Studio pretty much take up all of the 700 MB of RAM allocated to my Virtual PC. Ouch!

If you need community support, check out the SQL Server 2005 newsgroups at http://communities.microsoft.com/newsgroups/default.asp?icp=sqlserver2005 .

Happy yukoning!