Message-ID: <025601c3eb1f$55d371e0$0a52dcc1@CATSMGMT> From: "Volven D'souza" <volven@cats-net.com> Subject: [Emerald] Emerald Ver 4.5.6 - Custom Reports Error Date: Wed, 4 Feb 2004 16:03:51 +0300
Hi,
In our attempt to upgarde to the Latest Version of Emerald i.e 4.5.6, we did
the following;
1. Backed up the Exisiting Database.
2. Built a New Server.
3. Installed 4.5.6
4. Restored the Database.
Everything else seems to be working fine, except the reports.
When you click the custom reports menu, the following error is reported ;
Error during query operation:
[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name
'ReportType'.
----------------------------------------------------------------------------
----
Select Report, FileName, CASE WHEN ISNULL(Parameters, 0) = 0 THEN
'print.ews' ELSE 'print_parm.ews' END As Dest From Reports Where (ReportType
= 1 OR ReportType IS NULL) and (OperatorGroupID IS NULL OR OperatorGroupID=1
or 1=1) Order By Report
----------------------------------------------------------------------------
----
S0022
Please assist !
Regards
Volven