Search results for query: *

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

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:=...

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

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

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

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

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

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?

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

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

Thanks much...that worked!

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

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