Search results for query: *

Hi guys, Quick question for you, does anyone know if the datasource value is held in any preset variables? Something simple but I can't seem to find it. Thanks.

This was my original formula in the report footer, shared numbervar bloggscount; This returned 2 when it should have returned 1. Even adding the whileprintingrecords, whileprintingrecords; shared numbervar bloggscount; It still seems to be showing 2 as the final amount.

Hi everyone, I have a query with a formula; basically I have a running total e.g. >> shared numbervar aaalcount; >> if {claim.cm_ref} startswith("AAA/L") then aaalcount := >> aaalcount + 1 Now the problem I seem to be having is the formula seems to be adding up ok in the details section, say...

That works a treat, thank you very much. Leafy

Is there a way in Crystal to check a value in real time? What I mean by this is a value I have in the details section will replicate until the new value is displayed, what I want the report to do is to be able o tell when that value has changed? Any help is appreciated. Many thanks.

Hi there PHV, not sure if I know what you mean, the list box has only the one column? I need to extract line 5 from one list box to another. Many thanks.

Hi guys, could someone point me in the right direction please? I have 2 list boxes, the first one (lstFullFileContents) contains all lines within a specific file. I would then like to extract a certain line, in this case always line 5 from that list box to another (lstListBox1)... Getting...

Sorry, yes I use Crystal 10 also. I'll give that a try now and let you know how it goes. Thanks very much.

Morning people, I have a quick question, I have several running totals in a report that reset at the change of a group. This is fine as it is but in the evaluate section I would like it to evaluate on the change of a field and when it finds a particular string. I realise I will have to do...

Thanks again synapsevampire, this works a treat also. Regards

Works a treat, Many thanks Turkbear.

Hi all, I am using the following code to try and extract the second word of a string. global stringvar secondName := {user.us_fullname}; If InStr(secondName, " ") > 0 Then secondName := Right(secondName, InStr(secondName, " ")); Ok, so for example the full name is Joe Bloggs the result of...

Great, thanks very much. I'll give it a try and let you know. Thanks again.

Hi there, Yes the text will always be the same up to the - and the £, just the amounts will vary... there will also be a - after the amount too, e.g. XXXXXX XXXXXXX .... - £1000.00 - XXXXXX XXXXXXX .... - £23.00 - ... ... Thanks

Hi all, is there an easy way in Crystal to extract a number from a string? Basiclly the number within the string will always be set out like this, String line then number amount - £100.00 - thanks.

Sorry Skip, How would I get the SQL code for you? I tried opening the macro recorder but I may have done it at the wrong time. Thanks Skip.

Hi again, Is this the code you mentioned? Provider=Microsoft.Jet.OLEDB.4.0;Password="";User ID=Admin;Data Source=G:\Global\ExcelZipDetails\ZipperInfo.xls;Mode=Share Deny Write;Extended Properties="HDR=YES;";Jet OLEDB:System database="";Jet OLEDB:Registry Path="";Jet OLEDB:Database...

Thanks Skip, I'll give that a go now and let you know what happens... I think I'll have another question if this works ok. Many thanks. UKLeaf

Hi all, I was wondering if it's possible in Excel to create an Access like database? Basically I have list of documents I would like to have displayed in a List Box, DOC1 DOC2 DOC3 etc… What I then would like to accomplish is to once the user clicks or highlights, say DOC2 it would...

Thanks for the reply Chris, the sub report is in the details section and the formula with the shared variable is in the report footer on the main report page. Many thanks