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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. jesperengel

    Numbers show as strings

    Just an update, I updated CRXI to SR2 and now the fields show up in Details as numbers as well. Do not know what caused the problem. Thank you.
  2. jesperengel

    Numbers show as strings

    Ok I will try and explain further. In the field explorer the field shows as a "number". I then insert it into my report in details, and when I point the mouse on the field it says "string". When I try and format the field to 2 decimals, I do not have the "Numbers" tab in the Format Editor. If...
  3. jesperengel

    Numbers show as strings

    I am using CRxi with a xsd schema file and xml file in Visual Studio DOT.NET. In the Field Explorer window the fields show as numbers, but when I insert them in my report they show and act like strings. I cannot just use the ToNumber formula because that will ruin some of my other formulas, so...
  4. jesperengel

    File Size Issues

    Arrian, You might already know, but if you are using any image CR converts them to BMP format, which explain the enourmous file size.
  5. jesperengel

    File Size Issues

    Arrian, did you ever find a solution to your problem. I am experiencing the same, and have not been able to solve the problem.
  6. jesperengel

    Sorting and grouping problem

    Thank you all for your suggestions. Rrgkanth, the three fields have been grouped and for clarification I will try and give you a better idea of the report setup below. BobSuruncle, I tried your solution with a unique combo, but ended up in the same place, without being able to sort the data in...
  7. jesperengel

    Sorting and grouping problem

    Using CRvXI, I have a report with three data fields, which are all grouped. Then I have a forth "row", which counts the number of shots made with each combination. Each group is sorted in its original order. Player Club Ball Shots John Titleist Srixon 4 Peter...
  8. jesperengel

    Gap between two values

    Hello again, jleboef, thank you for your suggestion, but I ended up using the suggestion from lbass, which suited my report better. Lbass, you are my star. A pure genius! Thank you!
  9. jesperengel

    Gap between two values

    Using CRvXI I have a report that contains a field "Club" and a field Average Carry (average of a database field named Carry). For every Club it lists the average carry for each Club. So far so good. Now I would like a way to list the difference or gap between two Clubs. Is there any way I can...
  10. jesperengel

    Maximum of Running Totals

    Lbass, I got it!! Thank you. I do not know why making a simple summary on Ball gives me the right number but never mind. To put the summary for ball in the Details section I just made a ToNumber (Count ({Stroke.IdentifierData.BallType}, {Stroke.IdentifierData.BallType})); which worked fine...
  11. jesperengel

    Maximum of Running Totals

    Lbass thank you for your reply. I will try and explain in detail. I have three data fields. 1) Player 2) Club 3) Ball I have grouped each field Group 1 (Player), Group 2 (Club), and Group 3 (Ball), and put them in the Details section. Each group I have Suppressed if Duplicated. This gives me...
  12. jesperengel

    Maximum of Running Totals

    Thank you lbass, The last solution your suggested worked fine for counting two groups using Count({Stroke.IdentifierData.PlayerName},{Stroke.IdentifierData.ClubName});. Is there any way I can include the third group ({Stroke.IdentifierData.BallType})?? As for your first suggestion, I do not...
  13. jesperengel

    Maximum of Running Totals

    Using CrvXI I have a report with 3 groups. I have made a running total (Total shots), which evaluates every record and resets after change of Group 3. It gives me something like this: Player Club Ball Total Shots Jack Titleist Titleist 1...
  14. jesperengel

    Schema file elements not recognised as numbers

    Hello Turkbear, Thank you for your reply. Unfortunately it did not do the job. Somehow it seems as if CR still interprets the number data type from the schema file as a string. Allthough I can add as many decimals to the number as I like, but not format it in any other way. Can I use another...
  15. jesperengel

    Schema file elements not recognised as numbers

    Using CRvXI I am using a xsd scema file as my data source, where some of the datatypes are strings and some are numbers. In CR I can see in the Database field that the datatypes are Numbers but I cannot format them as numbers, i.e. no matter what I do to the number it is only displayed as in...
  16. jesperengel

    Box will not stretch to the end of the page.

    I am using CR XI. I have a main report containing a subreport. The subreport has a box stretching from Group Header 1 to the Report footer. I have done this to make the box go to the end of the page instead of just surrounding the dataset. When viewing the report, I am using as subreport, as a...
  17. jesperengel

    Running Total which resets when either of three groups changes

    Using Crystal Reports ver XI. I have a report with three different groups: "Player", "Ball" and "Club". The report changes page for every combination of the three groups. So far so good. Now, I want to do a Running Total which resets if either of the three groups changes. I have tried it with...

Part and Inventory Search

Back
Top