Search results for query: *

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

Sounds similar to a problem I have with a local client. Their Delphi App uses a SQL database and Crystal 7. One user got a new Windows 7 Pc and found they couldn't run the application or Crystal Run time. Had to set up a VM with XP and install everything on that. All works fine now, just...

replace the formula with {data.MonthYear} <> Date(1900,1,1)// y,m,d Quotes indicate a string value, not a date. Need to use the function above. Bruce Ferguson www.crystalkiwi.com/nlog.htm

You could modify Brians suggestion as follows... Local stringvar array ProdTypes := split({HardwareType}," -> "); if count(ProdTypes)>= 3 then ProdTypes [3] else "" Bruce Ferguson www.crystalkiwi.com/nlog.htm

As the months columns are pretty fixed, replace the crosstab with a report that has a formula for each month, and is grouped by year. You can then use the "Previous" function to compare this year with the previous year. If there are lots of records per year you might have to save each groups...

My Export UFL will build a tab delimited file while the report processes. You have total control over field delimiters and separators. You can download a trial version from my web site. Bruce Ferguson www.crystalkiwi.com/nlog.htm