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 derfloh 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. McNasti

    Text to Currency???

    Hell all: I'm using Crystal Report XI. I have the following formula @Barcode: "*" &TOTEXT(00000000000014082) &"*" It currently outputs...no idea why *14,082.00* I need it to output: *00000000000014082* Thanks Pat
  2. McNasti

    Maximum Value in an Array

    Hi Again, Thanks Synapse, I've tried using the following. It doesn't seem to recognize @shared_Sub1 evaluateafter({@shared_Sub1});//formula in my subreport Shared NumberVar Sub1; Shared NumberVar Sub2; Shared NumberVar Sub3; Shared NumberVar Sub4; numbervar array MyValues:=...
  3. McNasti

    Maximum Value in an Array

    This doesn't quite work. Oddly, it returns the max value for the current row on the next row. It also maintains the max value for multiple rows until a row of greater value is reached. If i use the example from above it returns something like the following. ID SUB1 SUB2 SUB3 SUB4...
  4. McNasti

    Maximum Value in an Array

    I have 4 subreports containing one shared numbervar field each. And a formula that I'd like return the maximum values of each sub value. I'd like it to return data as follows. ID SUB1 SUB2 SUB3 SUB4 MAX -- ---- ---- ---- ---- ---- 01 4.50 1.00 2.39 6.90 6.90 04...
  5. McNasti

    Suppress Rows Conditionally

    Hello All: I'm Runnung Crystal 8.5 against Oracle 8i. I've created a report that displays the following fields in Details section: Id, Name, Class, Begin_date, End_date So My data looks something like this: 001, Josh, A, 12/01/99, 02/04/03 001, Josh, B, 03/05/04, 02/06/05 001, Josh, C...
  6. McNasti

    Automatically Run Macro on the event of a New Email

    Hi All: I'm running Outlook 2000. I've created a Macro that inserts select emails into an Access 2000 Table. I'd like to have this Macro run every time a new email is recieved by my inbox. I know that in Outlook 2002 I would be able to use the rules wizard; But what are my options in 2000...
  7. McNasti

    Outlook/Access?

    Hello All: I've been asked to create module that would on the event of every new email received by a specified folder, create a record in an Access table containing the Subject, Sender and Timestamp relating to that New email. What would be the best approach? and would I create this module...
  8. McNasti

    Edit Mask

    I'm Running CR10. How would I use the Edit Mask option to ensure that all parameter values passed to my SQL are within Single Qoutes?
  9. McNasti

    Help!! XML Data

    Hi, How would I accomplish a left outer join from an XML datasource. It won't allow it fro within the Database Expert. I'm you using the SELECT EXPERT to establish my relationships. So using the example above in the select expert i have. B.LocationID = A.LocationID I need some outer join...
  10. McNasti

    Reconumber

    Hi, How do I get the recordnumber function in the details section to begin a new count after every new group header. The following is what i'm experiencing now. GH1| Carol D | 1 Location G D | 2 Location J GH1| Ann D | 3 Location Z GH1| Kate D | 4 Location C I'd like this: GH1| Carol D...
  11. McNasti

    Help!! XML Data

    Thanks much...that worked!
  12. McNasti

    Help!! XML Data

    I have two "tables" i need to report from. I'm reporting from a XML Datasource so they're not actually tables, im using CR Version 10. Table A Contains Location_Id (PK) Location Name Table B Contains: A person has 2 locations. Person_Id(PK) Location_id_1(FK)--References Location_id in Table...
  13. McNasti

    XML records

    Hi All, I'm Running CR10, XML Datasourse. My sample XML is as follows: <LocationList oid="1"> <Location id="Location_2" oid="2"> <Name>Lansking</Name> <Description>Headquaters<Description/> <Type>PHYSICAL</Type> </Location> <Location id="Location_3" oid="3"> <Name>Hamberg</Name>...

Part and Inventory Search

Back
Top