Report authoring articles

Here are links to some of the older report authoring articles excluding the articles on data access pages

Generating and Hosting a SQL Server Reporting 

Creating an MS Access 2003 Front End for an 

Creating a Crosstab Report in Visual Studio 2005 Using Crystal Reports 

ASP.NET and SQL 2000 Reporting Services

On Importing an Access Parametric Report into SQL 2000 Reporting Services

SQL Server 2000 Reporting Services: Creating a report from scratch

Building a Multi-table Report with SQL 2005 Reporting Services

Creating a Chart with SQL 2000 Reporting Services

Crystal Report from OLAP Data  

Generating a Simple Crystal Report using VS 2005

Generating a Multiple Table Crystal Report using VS 2005


Developing Applications on Oracle 10g XE: Generating a Report

Creating a Simple Report with Visual Studio 2008

Links to SQL Server 2008 and SSRS 2008 can be found on this blog by searching with the keyword 'Report'

Crystal Reports 2008's Cool Features

Mini Review

With a few clicks I created a report with some grouping. Embedded the report in an ASP.NET page (VS 208) and displayed it in a browser. It is already on my intranet.

The Group Tree and Parameters featues were automatically present.

With Parameters icon clicked you can pick and choose items from the group list and keep them all as tabbed pages. I have four tabbed groups, Main Report, ALFIKI, CACTU  and FAMIA(showing).
Click on the Group tree and you have the 'document' map with drilldown features.

You can export any of these to several formats.

You can also set the number of pages you can send.

Don't you think these are cool features.

Can you use Cubes created using SQL Server Analysis Services 2008 in Crystal Reports 2008?

Yes and No.

There are three options for using the cube in Crystal Reports 2008:

• Using Olap Server

• Using Local Cube file(.CUB)

• Using HTTP Cube

Using OLAP Server: Yes

Using Local Cube file (.CUB): NO

When I tried to use a Local Cube file created in VS 2008, I could not. SSAS 2008 creates CUBEs with the extension .cube
Crystal Reports 2008 will look for a CUBE with the extension .cub. This is the only choice while browsing for a cube in Crystal Reports 2008.

Using HTTP Cube: Not tested yet