Recent content by crystalkiwibruce

A Stored Procedure is a oommand inside the database. It performs some SQL and returns some data. If a similar Stored Procedure is in the other database you can use "Set Location" to select the other procedure. The name inside the report will stay as the original name, but you can rename the...

My Export UFL lets you define and build a grid inside the report, and you can then save the data to a CSV file. Worth a look at. Trial version available for download from my web site. Bruce Ferguson www.crystalkiwi.com/nlog.htm

Do a verify database and see if the field is still there. It could be generated in the SQL as part of a SQL command or a stored procedure in the database. Use Show SQL Query to see if that is happening. Bruce Ferguson www.crystalkiwi.com/nlog.htm

Why not just put the shared variables into the one formula: @Project1 Whileprintingrecords; Shared NumberVar myTotal; Shared NumberVar myTotal2; Shared NumberVar myTotal2a; {Current_Inventory} + myTotal - myTotal2a If you wnat to total that formula you need another variable. Global...

First thing to check is if your app is 32 or 64 bit, and is the Windows 7 version 32 bit or 64 bit. A 32 bit app needs the 32 bit odbc connection on a 64 bit version of windows. Don't use the control panel ODBC connector. There is a 32 bit ODBC setting under the...

Sorry - typed that wrong... Should be Replace({Table.field}, "XXX", "ABC") Bruce Ferguson www.crystalkiwi.com/nlog.htm

Use the replace function: Replace({Table.field}, "XXX', "ABC") should work fine. Bruce Ferguson www.crystalkiwi.com/nlog.htm

My Export Function Library includes a FileExists function. You could use that with your path name to display a message or exclude some records without the image. Bruce Ferguson www.crystalkiwi.com/nlog.htm

Duplicate records are usually a table join problem. Are the amount fields from the JnlRow table? Or should you be ignoring the payments and only select the invoices? Bruce Ferguson www.crystalkiwi.com/nlog.htm

It depends on what crystal version you have. With Crystal 2008/11 you can use an embedded summary to pick up the summary in this cell and then one in the previous row. and then subtract them. Examples of how to use this is in the training database and report files on my web site. That's a...

Your idea of having the data in details a and the horizontal line in details should work. then conditionally suppress details b if you don't want it. Bruce Ferguson www.crystalkiwi.com/nlog.htm

If you already have the number then use Totext as follows.. ToText({Table,Number},"00000") Bruce Ferguson www.crystalkiwi.com/nlog.htm

Create a Formula of Date({?Year},{?Period},1) and format it as MMM-yyyy For the previous month if {?Period}=1 then Date({?Year}-1,12,1) else Date({?Year},{?Period}-1,1) A Date Heading could then be ToText({@This Period},"MMM") + "-" + ToText({@Previous},"MMM") Bruce Ferguson...

Local numbervar i; local stringvar array AllPoints := split({table.field},"."); local stringvar results :=""; for i=1 to count(AllPoints) Results := Results & char(13) + char(10) + ToText(i,0,"","") + ". " + AllPoints [ i]; Mid(Results,3) //Need to remove first CR/LF Bruce...

Are you sure it's not a sorting issue? Sort by a field so the NULL values appear first. Bruce Ferguson www.crystalkiwi.com/nlog.htm