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.

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

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

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

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

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.

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

Hi all, I have posted about this before, however only got one reply and that was to look in the help section in Crystal. After doing this I am none the wiser! basically I have a sub report with a total, the formula for this is, WHILEPRINTINGRECORDS; SHARED NUMBERVAR LEEDSTOTAL :=...

Hi all, I was wondering if it was possible to display a summary of sub reports on the upper most report front page. For example, I have a report that is a front sheet basiclly to 3 sub reports. Each sub report has it's own stats, number totals and such like. I tried doing a formula on the...

Hi all, hope you can help... basically I would like to use a formula to pluck out amounts from a line of text, the problem is we have 1000's of these lines and after the number there is a dash! Crystal is looking at this as if the numbers were negative amounts but they aren't. is there a way...

I know it's possible but for some reason I can't get this to work! basically I have several fields on our system, allot of them are set to zero, Crystal wont include these in the addition formula... if I change the formula to add those fields with an amount in it works fine, if I then change it...