Search results for query: *

Hi I am using Crystal v8.5 and dont have that option - I can get the data labels to appear with two decimal places but not the actual legend. Many thanks for your help

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

Thank you so much!!! Works perfectly! You are an absolute star! thanks again Dawnyanne

Hi Lbass! sorry the ON wouldnt be capitalised it would just be the name of the bank for example - so I just need everything in the field that is in uppercase to be selected. There wont be any other text in the field that has the first letter capitalized so its just a case of picking out all of...

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 Thank you so much for coming back to me. The field I am looking at is a MEMO field - so I cant seem to use this field in a formula - Is there any way around this? Thank you so, so much for your help - it is very much appreciated. take care dawnyanne

to add this problem the field that I am using is of 'Memo' type - so I cant use a variable to work out the number of lines in the field! grr! Many thanks for any help dawnyanne

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

Thanks LB I have a pie chart where the sections have different patterns and colours eg squares and lines etc - I forgot to say that I am using Crystal v8.5 Normally in a formula I would put say color red or use the rgb values - but i need to specify thats it is a pattern aswell and I am not...

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 - thank you for coming back to me! The way the report runs at the moment is a lette with a footer and then the subreport creates one or more contracts after the letter - I think I need to put the surpress in the main report as if it is the letter I want one footer and if its the...

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