Search results for query: *

Try this...

Are you using Basic or Crystal Syntax? Amber [peace]

I tried this: whileprintingrecords; stringvar names; if instr(names,{psmresindstaff.res_abbr}) = 0 then names := names + {psmresindstaff.res_abbr} + ", " else names := names; left(names,len(names)-2); I'm only getting the first practitioner. Amber [peace]

OK, now that I've got that working - One more question: How do I link that parameter to a data field? For example, my parameter is pulling all practitioner IDs, but I want to list the practitioner name in the footer. I have the two tables linked, but when I try to pull the paractname into...

OK, I think I figured out what my problem is. My parameter was formatted to allow discrete AND range values. Once I took the 'Range' option off, I quit getting errors! [2thumbsup] Amber [peace]

This is my coding: whileprintingrecords; stringvar parm; numbervar counter; numbervar i := ubound({?practid}); for counter := 1 to i do( parm := parm + totext({?practid}[counter],0,"") + ", "); left(parm, len(parm)-2); ---------------------------------------------------- I get the error "A...

I have tried using both Crystal and Basic Syntax, but I get errors with both. Amber [peace]

After WhilePrintingRecords, I get the error "A statement is expected here". Amber [peace]

When I put the semicolon after WhilePrintingRecords, I get the error "The remaining text does not appear to be part of the formula" at the semicolon. Amber [peace]

Try This: From the Crystal menu, go to Database/Set Location. In the “Databases” box, highlight each table and remove the ODBC name and “dbo” (or other user name) from the table name found in the “Table:” text box (i.e. hsmprod.dbo.casemain becomes casemain) Amber [peace]

I should have been more clear - the error is pointing to the end of line 1. Amber [peace]

I tried that coding (my parameter is a number), but I get the error "The remaining text does not appear to be part of the formula". ???????????????????????????????????????? Amber [peace]

OK, I tried this: WhilePrintingRecords: shared x as string: dim i as number: i = 1: for i = 1 to count({?practid}) x = x + {?practid}(i) + ", ": Next I get the error "A string is required here" for my parameter in line 6. I tried to change it to text: WhilePrintingRecords: shared x...

I have a report in Crystal 8.5 that shows Anesthesia Types selected by Anesthesiologist, OR Suite, Patient Type, etc. I would like to show in the footer of the report the criteria that the user selects to print the report. The only parameter that I can get to print on the report is the...

Try going into Query Analyzer and running: BACKUP LOG <database> WITH TRUNCATE_ONLY Then go into enterprise manager, look at your database in TaskPad view. At the bottom, there is a section titled "Space Allocated". Hover over the arrow beside the title and a menu will appear. Click on...

I have been assigned to migrate an old btrieve database to SQL 2000 and I have no idea where to start. I do know that there are programs on the market that will do this for me, but they are not cheap. Does anyone have any experience in this? Would I be better off purchasing a package product or...

There is no order to the UOM. The values in this field occur randomly. I just want to pull the value of the UOM for the first occurrence in the database of each item number. Amber [peace]

I am sorting ascending by item number. Amber [peace]

Crystal 8.5 from an SQL2000 database I want to select the first UOM in the database for each item number. Amber [peace]

I have a field entitled "UOM" that I am pulling into Crystal 8.5 from an SQL2000 database. This UOM could be Box, Each, Case, etc. How do I tell Crystal to only choose the first instance for each item number? For example, if the first UOM for Item 37495 is Box, select only that instance. Any...