Data Reports

[ejanakieff]

I have several reports created with the Data Report of the Visual Basic. I have created a Data Environment, and inside this several procedures that calls a Stored Procedure (SQL Server).

In the data base I have a column that is of the type varchar(8000). It isn't unicode, so it can't save the "€" symbol, or I can't get it.

Do you know how can save the euro symbol in a varchar(8000) in SQL Server 2000?

Because I can't, I save this column doing a replace "€" to "@euro", and every time the end user consults a record I make a replace.

My problem appears in the reports. I don't know how replace every time that appears "@euro" by "€" in one of the records of the report.
Thanks,
Eva Janakieff

 

[Trighosts]

I’ve used something along this line to edit report outputs on the fly from SQL. This may help.


SELECT
OutputColumn1,
(SELECT 'test1' =
CASE
WHEN (Field = ‘@euro’) THEN " € " + OutputField2
END) AS 'OutputColumn2',

OutputColumn3
FROM tblReport

Results should be

Column1 Column2 Column3
Data € Data Data

I tried this from a stored procedure and it works.