Search results for query: *

Awesome - Thanks!

Here is my data: A1 A A2 B A3 C A4 D B1 1 B2 2 B3 3 B4 4 E1 A E2 C E3 E E4 B I need a formula that will: If cell E1 is within range A:A then cell F1 should result B# My results in F should be: F1 1 F2 3 F3 "blank" F4 2 Thanks Catherine

I need to find a way to edit a currency field with a formula to remove "," and decimal points and to have the result 10 digits long. For example, 12,866.90 would need to be 0001286690. I cannot simply do this with the "format field" option on the report as that does not actually chance the...

Yep - did that - no good. My workaround (because nothing else seemed to work) - was I added another column (hidden) in excel and put in a formula to add a period (.) to the original column - I redirected my crystal to read that column less the last character - that worked. Thanks for all the...

Defined? Not sure what you are asking - it's formatted as General

Yep, that worked perfectly - Thanks!!

I have a field that is a string and the data reads like: 123A 56785A 12-5A The first part of it varies on how many characters that it has but it will always end in the letter "A" I want a formula that I can eliminate the A - I only want characters prior to A to display Thanks for all your...

I should add a disclaimer that I am not an Tech person (so layman's terms will be used) Yet, I actually tried the totext before submitting this post. There are no nulls I ran NumericText on this field and for the data that has numbers & text (12-18m) I get FALSE for the data that has just...

Still nothing When I originally set-up this report, this field was set-up as a Number - Now, I have an excel report that has both, numbers & numbers & letters - so when I set the database - it is asking me to map this field - I can uncheck the "match type" and then map it, so it then changes...

I have a Crystal report that has a field type of STRING - it is linked and pulling data from an excel spreadsheet The data in this field varies, some of the results have numbers & letters (12M, 2T), some are just numbers (4, 5) This field is not displaying results that are just numbers (it is...

How do I underlay multiple sections on a Crystal Report? I have a report designed with GH1 GH2 - suppressed GF2a GF2b GF2c I want all four groups (GH1, GF2a, GF2b, GF2c) to be on the same line - I have all the sections above checked "Underlay Following Sections" It's lining up GH1 &...

Perfect that works!!! Thanks so much, I was getting ready to pay a consult to fix the report for me!! Catherine

I'm confused about what you are asking. In the main report my shared variable formula is: whileprintingrecords; shared numbervar cust := {p21_view_invoice_hdr.customer_id_number}; This formula is located in GH1a In the subreport my shared variable formula is the same formula and it is located...

I have a Two Year Customer Sales History Report. It is grouped by 1) Salesrep 2) Customer I have ranked the sales dollar for the most recent year in the report. I want to show the customer's rank from the previous year on this report. This is what I've done: 1. Create your customer sales...