Search results for query: *

hi is there anyway of setting the chart legend to show two decimal places instead of one? any help would be hugely appreciated! Dawnyanne

Hi Is it possible to use instr to pick out words that are capitalised eg if a field has bought 800 BANK OF AMERICA 5.60 ON 27/4/96 I want to be able to pick out the 'BANK OF AMERICA' part. I have a lot of fields all with varying details and so the capitalised detail doesnt always appear in...

Hi forgive me if this is a silly question but I am very new to C#. I am running a stored procedure in Oracle and the last thing the procedure does is run a select statement on a temporary table. I need to put the results of this select statement - or from a query into an xml file that I can then...

hi I am using Crystal v 8.5 the problem I have is with a legend for a pie chart. In this particular case there is a negative number and the totals appear in the legend like this -0.71 - which is correct 100.71 - which is correct ------ 101.42 - which is incorrect and should say...

hi I am using Crystal v 8.5 the problem I have is with a legend for a pie chart. In this particular case there is a negative number and the totals appear in the legend like this -0.71 - which is correct 100.71 - which is correct ------ 101.42 - which is incorrect and should say...

Hi Has anyone used a formula in the Can Grow option in format field? What I need to do is limit a box to 54 lines - and if the text goes over the 54 lines - go to the next page. If I just say Can grow to 54 lines - if there is more text than this it just cuts it off! Oh for a 'linecount'...

Hi - Is there a way of edge to edge printig in Crystal? I am using Crystal v8.5 - and have set the margins to 0 but it still doesnt print edge to edge? Is there a way of forcing this - or is it printer specific? many thanks for any help

Hi I wonder if anyone can help - I have searched through all the posts and cant find my specific answer. I need numbers to display decimal places if there are any and if there isnt - to not show zeros but pad the spacing out so that the decimals line up. e.g 1000.00 = 1000...

Hi I have created a pie chart with a legend - which has a total at the bottom of 100% - but because the legend is forcing to 1 decimal place the totals do not add up to 100% correctly. If I show the labels on the chart it shows 31.25 and 68.75 correctly - but in the legend it shows 31.3 and...

Hi Is there a way to set up a pattern on a colour? eg I know you can use the color(145,145,145) etc - but I need to set the colour up as a pattern aswell. I think I can do it by putting the foreground and background colours in - but I am not sure what syntax to use if it is possible. thank you...

hi there I think I am having a very bad blonde moment! I have a subreport in my group header - but I want the subreports footer to be different to the main report footer. If I put in the different footer in the sub report - then both footers show - is there a ways of surpressing the footer if...

hi I know there has been alot on the forum about this - but I am still stuck. I have 2005, 2006 and 2007 and for each year i want to show 2 sets of data in a line chart. I have all of the figures I need in the database so I dont need to use any calculation. The problem is when I go to put it...

hi I am using Crystal version 8.5 - is there a way of running a report automatically. I am looking to run a batch file overnight and need the crystal report to run? any ideas? many thanks as always!! dawnyanne

hi I am using Crystal v 8.5 and missing the helvetica font - does anyone know where I can retrieve it from? many thanks! Dawnyanne

Hi I am using Crystal v 8.5. I have problem with a Crystal report in that it has many fields all beatifully laid out, but when I go to add in another field - anywhere - the whole thing completely squashes up. To realign everything would take an absolute age. Does anyone know of any easy way to...

Hi - I have been asked to place some boxes on a report in a specific colour and the client has given me the cmyk colour codes. Is there anyway of using the cmyk codes as opposed to RGB codes in Crystal? Websites with conversion codes doesnt quite get there and occasionally throws out a weird...

Hi Is there a way of specifying which colour to use for a particular group when using a pie chart. I have seen that it is possible with a bar chart but not a pie. When I run the chart for four pie slices the colours are fine - but when say there are only 2 or 3 the colours are incorrect. I need...

hi I have Crystal version 8.5 - I have tried to open a report which I think has been opened in a later version and cannot open the file - is there a way around this? many thanks for your help Dawnyanne

Hi I am using Crystal v 8.5. I am creating a horizontal bar chart with labels to the left (and no legend). I need to line all the labels up - which I can do in Analyser - but they show up all over the place in Preview mode. I have tried saving in whilst in Analyser and closed the file and...

Hi - very obscure problem so I am not sure if anyone can help. I am using Crystal v 8.5 for reporting through bespoke software. When I print the Crystal report to the screen it works fine - but when I print it to a spool file -- it just comes up with an error . The report has a subreport within...