Hi Bhavbhuti!

Let's split this into two parts.

Running

EXEC...olumn).

I still think this is far more complicated than doing such conversions using PivotTables in Excel or similar.

HTH,
Set

Hi Set

Thanks for this.  I am more fine with zeros instead of NULL.  And I need to deliver the end result rather than expecting the users to do the same in Excel because this is a report they need to print day in and day out, the report being for eg. Sales Register.  I did try to run your code but I get the following error.  Please advise

Preparing statement: EXECUTE BLOCK returns (Mystatement varchar(4096)) AS
DECLARE VARIABLE S VARCHAR(256)
Error: *** IBPP::SQLException ***
Context: Statement::Prepare( EXECUTE BLOCK returns (Mystatement varchar(4096)) AS
DECLARE VARIABLE S VARCHAR(256) )
Message: isc_dsql_prepare failed

SQL Message : -104
Invalid token

Engine Code    : 335544569
Engine Message :
Dynamic SQL Error
SQL error code = -104
Unexpected end of command - line 2, column 31


Total execution time: 0.016s

Thanks and regards
Bhavbhuti