Search results for query: *

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!

I am using CR9.0. I have a parameter field that has multiple locations set as default values. In the report header I want to display the parameter values input at runtime. I have put the parameter field into the report header but it only lists the First value input. How do I see multiple...

How do you modify the Sql in the CR9.0 "Show Sql Query" text box. In earlier versions, you could modify the query directly in this box. How do you do it in 9.0. From Database>Show Sql Query. Thanks for any help.

Thanks you guys soooo much! I got it to work. I put a cross tab in the group header that totalled the "employee" count by region- suppressed fields as needed. It displayed a line item total of the count of employees. Then I did a standard running total in the group footer ( moved everything...

Thanks campsys, this did work for my absolute last record. I have my running total resetting at the group level (failed to mention that earlier) so how can I use this not onlastrecord function when grouping? For example, I have a count of employees grouped by region, I only want to see the...

Anyone, I think this is simple but I cannot figure it out. I have a running total that I only want the last record to display. How can suppress an unknown amount of records before the last record is displayed? Any help is appreciated.