Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. jfokas

    Resizing Mailing Label

    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...
  2. jfokas

    Combining multiple rows in one

    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...
  3. jfokas

    Setting Location and Alias in CR10

    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...
  4. jfokas

    Dropping Primary Key

    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...
  5. jfokas

    Problem with conditional formula

    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!
  6. jfokas

    Problem with conditional formula

    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.
  7. jfokas

    Problem with conditional formula

    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.
  8. jfokas

    Report on a Thermal Barcode Label Printer

    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?
  9. jfokas

    Report on a Thermal Barcode Label Printer

    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?
  10. jfokas

    Problem with conditional formula

    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}...
  11. jfokas

    Error Attempting to Restore Database

    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...
  12. jfokas

    Error Restoring Database

    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...
  13. jfokas

    NOT LIKE Syntax

    Thanks, I knew I was missing the obvious!
  14. jfokas

    NOT LIKE Syntax

    ...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} ELSE{@full_name} I'm trying to add a clause as such: IF {stpc_slide_labels.accession_no} LIKE 'EL*' AND...
  15. jfokas

    Error in Formula regarding data formats

    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...
  16. jfokas

    Formula to truncate text in a field

    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,
  17. jfokas

    Update problem

    Thanks Karl, It worked like a charm
  18. jfokas

    Update problem

    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...
  19. jfokas

    Scheduling a batch process

    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...
  20. jfokas

    Subrfeport parameters

    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.

Part and Inventory Search

Back
Top