Some observations on the New Table or Matrix Wizard in Report Builder 2.0

It is an excellent tool that makes it easy to rapidly develop cross-tab like reports. However there are a few problems using it.

#1. It is not like what the Report Builder 2.0 documents says it is.

Copied from documentation

Copied from the Report Builder's Wizard

#2. You can only make a cross-tab report using this (of course you can edit the report later to make a Table report).

#3. Once you move a field into the three others (ROW GROUPS, COLUMN GROUPS, VALUES) you cannot remove it. You can however move it around the three.

#4. If you cancel this step you have to start the wizard all over again

#5. Even if you start with Insert | Table Wizard you end up with the same Arrange Fields page of the wizard.

This was my experience, What is yours?

What can Report Builder 1.0 do?

Let me first of all say what it cannot do.

The scenario:

Report Builder 1.0 and Models created with Visual Studio 2.0/Report Manager [Enterprise Evaluation Copy] or Reports created with Visual Studio 2.0 based on the Models created in VS2008 and hosted on Report Server [SQL Server 2008 Enterprise EE].

#1. The Models created by VS2008/BIDS/Report Manager[Enterprise Evaluation Edition] can be accessed by Report Builder 1.0. Reports created in RB1.0 using the entities in the model accessed, cannot be processed. You get the following error:
---------
MemoryStream length must be non-negative and less than 2^31 - 1 - origin.
Parameter name: offset
Remote GDI stream version: ?. Expected version: 11.0.1.

#2. Trying to open a report created in Visual Studio 2008 based on a Model created in Visual Studio 2008 cannot be opened in Report Builder 1.0 in the SQL Server 2008 Enterprise Evaluation Edition.
The error message for this is:

System.IO.StreamReader: The Report element was not found.

Note: The Open Report window in Report Builder 1.0 locates the report bt cannot open it. The above error is displayed.

I have not tested by trying to upload a Model/Report built using SQL Server 2005. May be it can.

From Baghavad Gita - the divine book of songs

From the artist (Lakshmi Candade) who contributed to the Sugama Sangita disc "Naraynamruta" recently released with support from Niviqure a original medical equipment maker from Bangalore.



Watch this on You Tube:

This is no winning notification

Another scam from London. Must be quite desperate.

Info lottery

show details 3:58 PM (14 hours ago)

Reply

Microsoft Promotion Award Team
20 Craven Park, Harlesden
London NW10
United Kingdom
FILE REF: HL/5564/06/08/MICS
BATCH: MC11/834/5PDH /EU

MICROSOFT WINNING NOTIFICATION.

Query Designer Tool in Report Builder 2.0 : Problem with an ODBC Connection

Query Designer Tool in Report Builder 2.0 does not allow you to use the Graphical designer for an ODBC Connection.

Here is a screen shot of what should have been a graphical interface to create a dataset.

The workaround is to type in a query which you have created, tested and verified earlier. The import can only import *.sql or *.rdl files from a saved location.

Updated information:

It appears that the Graphic interface in the Query Designer Tool works only with SQL Server according to one of MSDN Moderators.
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=3890536&SiteID=1