Search results for query: *

This certainly falls under the category of stupid question, but I'm stumped. I apologize in advace. I need to change the dimensions of a label. In Crystal 8.5, this was an option in the Select Expert. I'm now working with Crystal 10 and for the life of me cannot find where to change the...

Sorry for asking a redundant question; I've the solution on the forum before but I can't seem to find the thread I need. I need to combine results of query that returns multiple rows into a single comma delimited row. SELECT name FROM data_tmplt WHERE yada yada yada will give an output of...

In migrating some reports CR8.5 to CR10, I've discovered that the Set Location and Set Alias options are no longer available in CR10. They are replaced with Set Data Source Location and it seems that one can only set the location by browsing to the appropriate procedure/table. Is there a way...

I need to drop on the primary key on a table within a script but keep getting an error. The syntax should be straight-forward: ALTER TABLE accession_2 DROP PRIMARY KEY Yet, I get this error: Server: Msg 156, Level 15, State 1, Line 1 Incorrect syntax near the keyword 'PRIMARY' This is a SQL...

I'm not really sure why, but {a} = "" and {b} = "" worked. The query against the database specifically returns "NULL". Anyway, problem is solved. Thanks for the help!

I've tried that variation and still get the same result. If either {a}, {b}, or both are valued, then I want Option 3 which does indeed work. Option 2 also works when it should. All, my problems are with Option 1.

Yes, I even tried removing the "{c} <> 0" entirely just to see what would happen and I still got the same result. I've run the query directly against the SQL database and I definitely get NULL for both of those fields when I expect to but still I get Option 3 for my output.

How are you placing the barcode on the report? I'm using Crystal 10 to create barcode labels for a Zebra TLP-2844-Z and I'm not having any problems. Have you tried a different barcode font?

How are placing the barcode on the report? I'm using Crystal 10 creating barcode labels for a Zebra TLP-2844-Z and am not having any problems. Have tried a different barcode font?

I'm having trouble getting the formula below to work properly. Fields {a} and {b} are string fields and field {c} is numeric field. When {a} and {b} are null and {c} has a value, I want to see only "{c}". Instead I get "-{c}", which is consistent with OPTION 3. I've verified that {a} and {b}...

I am trying to restore from a backup of a SQL 7(SP4) database onto an instance SQL Server 2000 (SP3) and get the following error message: " MICROSOFT SQL-DMO (ODBC SQL State: 42000) This version cannot redo any index creation or non-logged operation done by SQL Server 7.0 Further roll forward...

I am trying to restore from a backup of SQL 7(SP4) database onto an instance SQL Server 2000 (SP3) and get the following error message: MICROSOFT SQL-DMO (ODBC SQL State: 42000) This version cannot redo any index creation or non-logged operation done by SQL Server 7.0 Further roll forward is...

Thanks, I knew I was missing the obvious!

I am having a problem adding one phrase to an existing formula, but I can't seem to get the syntax right. The solution is bound to be obvious that it's jut not coming to me. Please help! The exist formula is this: IF {stpc_slide_labels.accession_no} LIKE 'EL*'THEN{stpc_slide_labels.last_name}...

I get an an error when running the following formula: IF CURRENTDATE - 30 < DATE({QUERY.AgingDate}) THEN 1 ELSE 0 The AgingDate field is a string field with the following format: 2004/04/15 13:42:00.00 The error I get states the following: Error: Bad date format string...

I need to create a formula that will return all the text in field up to a specific phrase, in this case "Cinincal Summary". Can someone offer some guidance? Thanks,

Thanks Karl, It worked like a charm

I am trying to update some rows of a table with information in the same column from different rows. The statement I'm trying to use is: update delivery_location_2 set courier_route = dl2.courier_route from delivery_location_2 dl1, delivery_location_2 dl2 where dl1.group_id = dl2.id and...

We are using a program that parses several reports through distiller to create individual pdf files. Then I have created a batch sequence to save all these as rtf files in specific directory. They then are sent to a virtual printer from that directory to process into the final system. My...

Thanks for the obvious answer. My must be having a brain fart. I looked at the linking expert and did not see an option to link the parameter fields. After going back and looking again, there it was plain as daylight. Sorry for the amatuer question but I do appreciate the help.