Search results for query: *

Hello, Environment: Windows XP Pro, 3 Gigs Ram, 2 Intel Xeon 3.4 Processors, MSFT SQL Server 2005, Crystal Reports v11 Professional. Is it possible to make a crystal report, report off of a table that will change each time the report is run? For example today my table has these columns...

Hello, I am running a report using SQL Server 2000 and and inquiry has been created which is running from Crystall Reports 11. To be honest I am not so good at this. Is there anyway to improve the query below? The purpose is to get the cumulative cash flows of a deal from the very beginning to...

Environment: Windows 2000 Server with Crystal 9 installed. The situation is that I have a client which have requested for approximately 150 reports by entity and they currently have 200 plus entities in the system. The reports usually need to be distributed to the subsidiary on entity or...

Hello, I have the following formula in Crystal v8.5: if {glsaprpt.base_amt}< 0 then 0 else ToNumber(right(ToText({glsaprpt.base_amt},0,""),len(ToText({glsaprpt.base_amt}))-1)) The field {glsaprpt.base_amt} has the following value $23,837,877,855.00 I am trying to remove the "," & ".00"...

I have the following formula in Crystal v8.5: " Face Value : "+ ToText ({acrlrpt.face_value})+" " + " Interest Rate : " + ToText ({acrlrpt.rate},6)+"%" The problem is I have multiple currencies and the first character of the acrlrpt.face_value is always "$". I would like to remove the...