Recent content by knerve1

Esquared, The AncillaryOrderID Table is EXACTLY what I needed! Thank you. Yaanmonkey, This totally worked. Thank you very much!

The filler order id is always 13 characters. The problem is the < lands in different positions for each record. IE: Placer Order ID:<1020517276830> Placer Facility: <RAD> Filler Order ID: <1018863276856> Filler Facility ID: <RAD> I would like it to look like this...

Anyone, What would be the easiest statement to trim this? Filler Order ID: <10190968MMDSCR> Filler Facility ID: <RAD> I only want what is in between the < > to then compare to another column. Thank you,

The database is on a server. Cannot access through Analyzer or EM on the XP machine but can on the 2000. Connecting to sql 2000 sp3. Thanks for the reply.

Anyone, One PC has SQL Server Enterprise Manager MMC 1.2 version 5.0 sp.4 Windows 2000. I can access all databases. The other PC has Enterprise Manager 8.0 and MMC 2.0 v5.1 sp2.0 on a windows XP machine. Cannot access all databases. Has anyone ever encountered a problem like...

Beautiful! Thank you very much, especially for hanging in there with me. Worked like a charm.

I would like it suppressed if both conditions are met... Whenever the details section is suppressed to suppress group footer 1b. So, again only if all the detail records meet the criteria. Thank you for your patience.

Thanks Lbass This is the formula for the detail section: ({BJH_LabTimedUrineColl;1.A}) = "Specimen" and {BJH_LabTimedUrineColl;1.B} = "Urine" On Group 1b format section: New page after is checked and formula not onlastrecord New page before is checked I tried using the same formula for the...

I have an 8.5 report that has two groups. On group is split into 1a and 1b. I would like to suppress 1b if the details section is suppressed. The formulas on Group 1b are New page after "not onlastrecord" , new page before is checked, and Keep together is checked. I have tried using a...

I have been on your site and it is awesome. Thanks. I am trying a Call statement in DOS. I am completely new to this. I created another registry setting so now I have a setting that goes to test and one that goes to production. What I don't understand is how to put the path for the registry...

I have an application that sits on a test as well as a production server. On the win2k client in order to change from test to production, I must go into the registry and modify a Server Profile setting. I go into the setting and remove a few alpha characters to access test and add them back to...

That worked! Thank you very much!

Boni, I can either pull the null values or the populated values but cannot do both, which is what I desire. I also tried your suggestion but it did not pull the null record set. In the view I created ( oracle 8) the records exist, however, when inputting "100" or "200" - as shown in example...

Hello, Using CR 9.0, I have a record selection that looks like this: ({a.COLLECTED} in {?Begin Date} to {?End Date}) and (("ALL" IN {?Test Code})OR ({a.TESTCODE} = {?Test Code})) and {a.PS} in [" ", "210", "91840"] and (("All" in {?Site}) OR {a.LS} = {?Site}) for the a.PS in [" ", "100"...

That totally worked!!! Thank you very much and it was a string parameter but your site covered all scenario's. Thanks again!