Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by dawnyanne

  1. dawnyanne

    Crystal v8.5 Chart Legend Decimal places

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

    Crystal v8.5 Chart Legend Decimal places

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

    Using Instr to pick out words in Uppercase in a string

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

    Using Instr to pick out words in Uppercase in a string

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

    Using Instr to pick out words in Uppercase in a string

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

    running stored procedure - need to convert to XML

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

    incorrect totals on legend when using negative numbers

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

    chart legend totals incorrect when a negative number involved

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

    formula in the 'Can Grow' option in Format field

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

    formula in the 'Can Grow' option in Format field

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

    formula in the 'Can Grow' option in Format field

    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'...
  12. dawnyanne

    Edge to Edge printing

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

    alignment of decimals, remove trailing zeros but keep padding

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

    decimal places in a chart legend?

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

    setting color patterns

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

Part and Inventory Search

Back
Top