Hola Brian. I'm sorry I didn't give you my opinion about your free chapters before, I was very busy at work solving some misteries of CR XI, that's why I came to your site and found some very valuable information and I want to give you THANKS for that. "Writing Functions Manually" was very useful for all of us who don't have too much time to read technical manuals.
I want to share something I learned these days working with SQL2005 and CRXI ReportDocument object (VS C#). I have the next table (just an extract for this example):
CREATE TABLE [dbo].[Invoice](
[PK] [int] IDENTITY(1,1) NOT NULL,
[GrandTotal] [money] NOT NULL
) ON [PRIMARY]
GrandTotal is declared of money type, when I change the currency symbol with a formula in desing time it works fine (in preview mode it shows the symbol the formula returns), but in run time it doesn't (still shows the same currency delcared via Customize Formula Editor dialog box). The solution was to cast GrandTotal to decimal :
CAST(Inv.GrandTotal AS decimal(19, 4)) AS GrandTotal)
Do you know why this happens?
Have a GREAT time & thanks again.
Edited by htorrescr - 23 Feb 2007 at 7:02am
IP Logged
