Search results for query: *

Thanks I will give this a go, it will be really useful...

You said that you could alter data in a database with Crystal, I'd be very interested to find out how. Could you post up the procedure for doing this please.... Thanks

Thanks Jim will give that a go......

Hi everyone, thanks for the suggestions. M8tt I gave yours a go and it gave me all the records for the date parameter but returned all stock numbers and vendors regardless of what I passed to these 2 parameters.. Jim the date formula is there because in the database the date is a string, I...

Can anyone help. I have the following if statement: {@DateOriginal} = {?DateOriginal} and (if{?StockNumber}=&quot;&quot; then {IPPOITM.STOCK_NUMBER}like&quot;*&quot; and {IPPOITM.VENDOR_NUMBER}like{?Vendor} else if {?StockNumber}<>&quot;&quot;then{IPPOITM.STOCK_NUMBER}like{?StockNumber}and...

It's ok, I fixed it by putting the shared variable into the GF on the subreport.... Thanks everyone :-)

Thanks LB but the @partscost is the formula which declares the shared variable. I did however try what you said anyway and it didn't work. The formula to add the labour and parts cost still appears to be ignoring the parts cost element and just gives me the labour cost. I know the shared...

Sorry, didn't realise I hadn't said. Ok here goes: Group1 grouped on job category Group2 grouped on job number Subreport is PartsCost Shared Variable is @PartsCost Formula to get the total job cost is: {@PartsCost}+Sum ({@LabourCost}, {IPJOBM.JOB_NUMBER}) the subreport (ie PartsCost) and...

Hi there, I have cr9 connecting to sql 2000. I have a shared variable in my mainreport from a sub report which calculates parts costs. This has been placed in the group footer of the main report which summarises the labour cost so I have job costs for labour and parts. I need to get the total...

thanks everyone, got it working but still don't know what the problem was cos in the end I recreated my report and the {table.col}like{?para} worked. Corrupt report perhaps. I will make a note of all the solutions offered for future reference... thanks again :-)

Both the column and the parameter are strings so I'm at a loss as what is going wrong here.

thanks for all the replies... I tried to use {table.column}like{?para} but it generated an error saying a string is required here???? :-(

Please help before I lose my sanity!!! I am trying to use wildcards with parameters so that when end users are prompted for a part no for example, they can put in C69-* where * represents the missing part of the number. I have tried using the following syntax in my record selection formula...

I've had the same problem, I opened a report, changed the size of a line then had to abandon the changes because it wouldn't let me save giving the same message you guys have had.

thanks everyone, I don't have variables in my formula so I should be ok, it certainly appears to be reasonably efficient from what I can see... Blue

Hey guys you are both angels!! This works so no more headaches for me, I can get on with producing the enormous pile of reports I have to do for our new system.... Thanks again. Blue [smile2]

Thanks Ido, I understand the logic but am unsure of where to do this. Should I be using the record selection formula editor and if so do you think you could send me a sample of the syntax. I am working with 3 or 4 products and they all use differing sql syntax so I'm getting confused. Thanks Blue

Help! I need to set a date range parameter in my report (Crystal v8) but the date field in the database is actually a text string. I have a formula which converts the string to a date but of course can't use this in a parameter. Anyone out there know how to get round this??? :-)